Michael Olafusi – Business Intelligence and Automated Reports using Power BI

Michael Olafusi – Business Intelligence and Automated Reports using Power BI

Description:

We give participants access to a shared Power BI pro account so they can practice all the full aspects of Power BI. We also do regular live support sessions to give a more enriching experience and help you align what you are learning with career growth. Enroll now to get this benefit for life!**
This course is a fully hands-on one to take you from just having an idea of what Power BI does to being able to create insights-rich and interactive reports/dashboards in Power BI that can drive business process and report automation and take you from just data analysis level to Business Intelligence (BI).
We cover the following aspects:
Get Data (bringing in your data for analysis)
Data Sources in Power BI Desktop
Connect to web data and web apps
Import Excel Workbooks
Connect to enterprise Database
Data Transformation, Power Query and DAX
Get Data
Model section of the report builder (Power BI Desktop)
Creating Relationships
Cardinality
Direction
Data section of the report builder (Power BI Desktop)
Data Type
Data Format
DAX
New Column
New Measure
New Table
Must know DAX formulas
DAX formula reference guide
Row level Security to control report access using roles (dept, function, branch, cost centre etc)
Report section of the report builder (Power BI Desktop)
Report creation
Native Visuals
Custom Visuals
Menu Tools for professional looking reports
Edit Interactions
Report creation from scratch
Power Query
Transforming and Combining Data before loading to Model
Common Power Query tasks
Unpivot
Pivot
Split Column
Append Tables
Merge Tables
Remove rows
Use first row as header
Merge Columns
Add Columns
Group By
Extract
Fill
Transpose
M Code reference resource
Report Publishing, Dashboards and Power BI Service
Understanding the concept of Workspaces
Publishing report (from Power BI desktop to Power BI service for consumption)
Controlling access to aspects of the report by role (region, department or level)
Published Report options
Exporting to PowerPoint or PDF
Embedding in SharePoint
Embedding in a website
Making it available via a web link
Sharing with specific users
Editing the report – adding new visuals, changing visuals used and creating new report pages
Adding comments and tagging users
Scheduling the report to send our daily or weekly to specific people
Creating a Dashboard
Can be created from one or more reports to show management useful analysis
Can incorporate data and visuals from other people’s dashboards or reports shared with you
Set Alerts to be instantly notified when a KPI is reached or an SLA is breached
Add actionable comments
Schedule the dashboard to be sent out daily or weekly to specific people
Share the dashboard with final users
Best practices
Setting automatic/scheduled refresh so new data is ingested automatically
Data Gateway configuration
The type of data sources that require data gateway
AI in Power BI and Settings
Q&A for autogenerating charts and tables in answer to questions
Organization wide settings
Account wide settings
Workspace settings
Dashboard settings
Report settings
Datasets settings
This is the course to solidify your Power BI proficiency.

Business online course

Information about business:

Business is the activity of making one’s living or making money by producing or buying and selling products (such as goods and services).
[need quotation to verify] Simply put, it is “any activity or enterprise entered into for profit.
It does not mean it is a company, a corporation, partnership, or have any such formal organization, but it can range from a street peddler to General Motors.”

Having a business name does not separate the business entity from the owner, which means that the owner of the business is responsible and liable for debts incurred by the business.
If the business acquires debts, the creditors can go after the owner’s personal possessions.
A business structure does not allow for corporate tax rates. The proprietor is personally taxed on all income from the business.