- Business Intelligence
- Data Analysis
- Microsoft Power BI for data analysis
- Introduction to the Course 00:09:28
- Power BI Installation 00:04:58
- Get Data to bring in the practice data files 00:07:44
- Connecting to Databases, web sources and cloud apps. 00:06:49
- Data Transformation - Part 1 00:10:00
- Data Transformation - Part 2 00:10:09
- Data Modeling - Part 1 00:10:00
- Data Modeling - Part 2 00:10:00
- Data Modeling - Part 3 00:10:00
- Data Modeling - Part 4 00:00:40
- Report Creation - Part 1 00:10:00
- Report Creation - Part 2 00:10:00
- Report Creation - Part 3 00:10:00
- Report Creation - Part 4 00:10:00
- Report Creation - Part 5 00:10:00
- Report Creation - Part 6 00:10:00
- Report Creation - Part 7 00:10:00
- Report Creation - Part 8 00:05:56
- Power BI Service - Part 1 00:10:00
- Power BI Service - Part 2 00:10:00
- Power BI Service - Part 3 00:10:00
- Power BI Service - Part 4 00:10:00
- Power BI Service - Part 5 00:10:00
- Power BI Service - Part 6 00:10:00
- Power BI Service - Part 7 00:09:35
- Report Refresh and Scheduling Refresh - Part 1 00:10:00
- Report Refresh and Scheduling Refresh - Part 2 00:11:26
- Importing Data from Google Sheets 00:04:36
- Installing SQL Server for Practice with Adventure Works Company Database 00:05:52
- Setting up Adventure Works Database on your local SQL Server 00:03:05
- Some basic data analysis exposure
- Familiarity with Microsoft Excel
This course is a fully hands-on one to take you from just having an idea of what Power BI does to be 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 center, 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 the 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 weblink
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 a 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.
- Data Analysts
- MIS Analysts
- Financial Analysts
- Project Managers
- Supply Chain Analysts
- 3 Reviews
- 7 Students
- 2 Courses
Michael is a 6x Microsoft MVP (Most Valuable Professional), certified Advanced Financial Modeler (AFM), Chartered Stockbroker (NG), UK CISI member, Microsoft Certified Trainer and founder of UrBizEdge, a business data analysis solutions firm. He began his professional career as a Radio Access (RA) Engineer for Nokia Siemens Networks, then as a Business Analyst and MIS Analyst for Comviva -- Airtel Africa CRBT operations in 10 countries, and finally as a Service Delivery Lead and Performance Analyst for 21st Century Technologies before resigning to build his own company.
He has done several financial modeling, business intelligence and data analysis projects/training for Telecommunications companies, FMCG companies, FinTech companies and other industries across the globe.
He is addicted to Microsoft Excel, Power BI, business intelligence and Financial Modeling.
-
Tue, 08-Sep-2020Tobiloba Williams
Write a public review