Course Overview
Hello & Welcome to this Microsoft Power BI course. If you're trying to quickly master the most suitable tool for connecting, transforming, visualising, and analysing your Data, you are in the right place. We will take you from zero to hero, through our practical learning approach, and will quickly get you up running & building analytical solutions for your organisation.
My name is Abdelkarim M. MAHMOUD, and I am a Power BI certified Consultant. I have spent the last years empowering different type of organizations by helping them gain performance and competitivity through their Data. I had the chance and the pleasure to train dozens of teams from simple Power BI users to Chief Data Officers. I am here today to put all my expertise at your disposal in a simple and practical way.
This in-depth training strikes the perfect balance between theory and practice, several PowerBI use cases are covered to allow you to get the most value from your data. Here's what we're gonna dive into :
Introduction - What is Power BI ?
More reasons to use Power BI ESPECIALLY if you use excel
Resources & Course Structure
Quick tour & Interface overview
Chapter 1 - Extract, Load, and Transform Data in Power Query
Power Query, Connecting to a Database and Data Types
Filtering
Removing & Ordering Columns
Conditional Columns
Connecting to a folder as a Data Source
Combining Data
Dealing with less structured data
Fixing Errors
Chapter 2 - Data Modeling ?
Tables and Relationships
BEST PRACTICE : Dimensional Modeling & Star Schemas
BEST PRACTICE : Optimising The model for Development Time
Chapter 3 - DAX for Data Analysis Expressions
DAX, the “POWER” in POWER BI
Using Measures to create Calculations and KPIs
Comparing this year’s Value to last year’s value
Year over Year Varience, and Waterfall Charts
Year to Date with DAX
Chapter 4 - Data Vizualisation
Why Data Visualisation Really Matters
Pie Chart and Treemap
Hierarchies
Filtering and TopN
Dual-Axis (Combo) Chart
Advances Visual Analytics Pane - Trends, Targets, Forecasts and more
Artificial Intelligence: Decomposition Tree, Q&A and Key Influencers
Slicers
MAPS and Dynamic Coloring !
Fancy Tables
Chapter 5 - Power BI Service
Sharing and Collaboration in Power BI
How to Publish a report to the Power BI service
Deep Dive into the Power BI service
FAQ
FAQ area empty
Course curriculum
Chương 1 Chapter 0 (Introduction) 5 bài · 12 phút
- Welcome, Hero ! Học thử 0:57
- What is Power BI ? Học thử 2:17
- More reasons to use Power BI ESPECIALLY if you use excel Học thử 1:49
-
Resources & Course Structure 2:45
-
Quick tour & Interface overview 3:53
Chương 2 Chapter 01 - Extract, Load and Transform Data in Power Query 13 bài · 28 phút
-
Power Query, Connecting to a Database and Data Types 4:54
- Filtering Học thử 4:07
- Removing & Ordering Columns Học thử 1:54
-
Conditional Columns 1:45
-
Connecting to a folder as a Data Source 2:53
-
Combining Data 4:52
-
Dealing with less structured data 5:48
- Fixing Errors Học thử 1:28
-
Exercises Scenario & Resources
- Exercise 01 - Import Data from Access Data Base Học thử
-
Exercise 02 - Import Data from a folder containing CSV files
-
Exercise 03 - Import a less structured Data from an Excel file
-
Exercises Solutions
Chương 3 Chapter 02 - Data Modeling 6 bài · 18 phút
-
Data Modeling ? 1:49
-
Tables and Relationships 7:49
-
BEST PRACTICE : Dimensional Modeling & Star Schemas 4:52
-
BEST PRACTICE : Optimising The model for Development Time 3:31
-
Exercise
-
Exercise Solution
Chương 4 Chapter 03 - DAX for Data Analysis eXpressions 11 bài · 19 phút
-
DAX, the “POWER” in POWER BI 1:26
-
Using Measures to create Calculations and KPIs 2:06
-
Comparing this year’s Value to last year’s value 4:01
-
Year over Year Varience, and Waterfall Charts 5:11
-
Year to Date with DAX 5:48
-
Exercises Scenario & Resources
-
Exercise 1 - Last year comparison
-
Exercise 2 - Year to Date
-
Exercise 3 - Market Share
-
Exercise 4 - Best Practices : Optimize the Data Model
-
Exercises Solution
Chương 5 Chapter 04 - Data Vizualisation 20 bài · 52 phút
-
Why Data Visualisation Really Matters 1:19
-
Pie Chart and Treemap 2:57
-
Hierarchies 4:28
-
Filtering and TopN 2:22
-
Dual-Axis (Combo) Chart 1:29
-
Advances Visual Analytics Pane - Trends, Targets, Forecasts and more 2:54
-
Artificial Intelligence: Decomposition Tree, Q&A and Key Influencers 6:05
-
Slicers 3:53
-
MAPS and Dynamic Coloring ! 5:51
-
Fancy Tables 5:10
-
Custom Formatting & Design tips 7:41
-
App Like User Experience & Navigation 8:15
-
Exercises Scenario & Resources
-
Exercice 1 - Cross Tabular Report
-
Exercise 2- Part-to-Whole Report
-
Exercise 3- Relationship Report
-
Exercise 4- Trend Report
-
Exercise 5- Rank Report
-
Exercise 6- Customise your report & Navigation
-
Exercices Solutions
Chương 6 Chapter 05 - Power BI Service 3 bài · 6 phút
-
Sharing and Collaboration in Power BI 0:51
-
How to Publish a report to the Power BI service 0:48
-
Deep Dive into the Power BI service 4:15
Chương 7 Congratulations Hero! 1 bài · 2 phút
-
Why Power BI is going to be huge 2:27
Requirment
-
Familiarity with Microsoft Excel or Google Sheets
Outcomes
-
Power bi
-
Business Intelligence
-
Data Visualisation
-
Dashboarding
-
Powerbi
-
DAX
-
Power Query
-
Data Modeling
-
BI
-
Data vizualisation
0 Student
1 Course
0 review