Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Power BI - The Complete Masterclass
Getting started
Welcome! (0:22)
What is Power BI? (3:01)
Download & Installing (4:06)
The interface (Quick Tour) (2:43)
Mini Project - Transform Data (6:52)
Mini Project - Visualizing Data (5:07)
Mini Project - Data Model (7:21)
What will you learn in this course? (5:02)
All source files & course slides
Preparing the course project
Working with the attached project files (3:51)
Data Transformation - Beginner to Intermediate
Exploring the Query Editor (6:11)
Connecting to our data source (6:48)
Editing and removing rows (8:10)
Changing data types (8:24)
Replace Values (3:27)
Close & Apply (3:29)
Connecting Power BI to a csv file (3:21)
Connecting to a Web Page (5:04)
Extract Characters (6:18)
Splitting & Merging Columns (9:22)
Create a conditional column (5:52)
A little note on the next lecture!
Columns from examples (8:38)
Merging Queries (17:23)
Pivoting & Unpivoting (5:43)
Appending Tables (8:20)
Practise & Solution: PopulationTable (14:30)
Fact Dimension Model (9:19)
Practise: Load Dimension Table (3:48)
Organizing our Queries in Groups (2:59)
Text used in the next lecture
Entering data manually (4:43)
Creating an index column (3:04)
Workflow & more transformations (4:38)
Module Summary (5:05)
Excersice: Instructions (1:41)
Exercise: Solution (11:09)
Data Transformation - Advanced
Advanced Editor - Best practise (8:43)
References vs. Duplicates (9:50)
Enable Disable Load & Report Refresh (4:31)
Group by (4:47)
Mathematical Operations (4:54)
Run R Script (14:36)
Using Parameters to dynamically transform data (6:28)
M-language Basics (6:40)
M-Language Values, Lists & Tables (13:57)
M-Language Functions (13:13)
M-Language More functions & steps (5:02)
Exercise: Instructions (0:55)
Exercise: Solution (4:31)
Creating the Data Model
Understanding relationships (5:07)
Create & Edit relationships (6:16)
One-to-Many and One-to-One Relationship (5:49)
Many-to-Many relationship & Crossfilter direction (8:15)
Cross filter direction (5:56)
Activate & Deactivate relationships (5:52)
Section Summary (3:04)
Exercise 3 - Create Model (2:27)
Exersice 3 - Solution (1:37)
Data Visualization
Our first visual (7:57)
The format tab (11:52)
Tables (9:53)
Conditional Formatting (8:48)
The pie chart (5:32)
All about the Filter visual (12:32)
Filter pane for developers (8:52)
Cross filtering & Edit interactions (3:56)
Exercise 4 - Instructions (1:00)
Exercise 4 - Solution (6:10)
Syncing slicers across pages (7:06)
Drill down (8:29)
Drill through (6:50)
Tree map visual (7:06)
Decomposition tree (5:23)
Matrix visual (5:17)
Edit pages (7:15)
Buttons & Actions (9:28)
Bookmarks to customize your report (9:31)
Analytics and Forecast with Line Charts (10:12)
Working with Custom Visuals (7:17)
R scripts for the next lecture
Get data using R & R Script Visual (8:26)
Asking Questions - Q & A Visual (3:45)
Wrap up Data Visualization (8:09)
Power BI & Python
Python in Power BI: Plan of attack (2:57)
Setting up Python for Power BI (3:03)
Transforming data using Python scripts (11:24)
Python script I (for the next lecture)
Creating visualizations using Python (7:55)
Python script II (for the next lecture)
Violine plots, ridge plots & correlation analysis plots (7:13)
Python script III (for the next lecture)
Machine Learning & Text Analysis using Python (9:53)
Performance & Troubleshooting (3:27)
DAX - The Essentials
Welcome to DAX (2:32)
Let's look at our data (4:09)
DAX Cheat Sheet
All files for the DAX sections
Measures vs. Calculated columns (14:37)
Automatically create a date table (8:17)
CALENDAR (5:08)
Complete date table with additional features (3:43)
Script to be used in your future projects
Key Measures Table (3:19)
Aggregation functions (6:07)
COUNT and its variations (14:05)
SUMX - How does it work (8:32)
DAX Exercise 1
DAX Solutions 1
DAX - CALCULATE function
CALCULATE Basics (10:53)
FILTER (6:31)
ALL (7:53)
ALLSELECTED (3:13)
ALLEXCEPT (7:24)
DAX Exercise 2
DAX Solution 2
DAX - Time Intelligence
TimeIntelligence & DATEADD (11:18)
Year-to-Date & Month-to-Date (5:19)
TOTALYTD VS DATESYTD (8:54)
DATESBEETWEEN (5:15)
DAX - Operators, Variables & Quickmeasures
Logical Operators (9:27)
Commenting and Formatting (5:48)
Variables (9:47)
Quickmeasures - How to use them in a smart way (4:46)
Visualize effectively & Tell a story with your data
Intro - Best Practises (1:01)
Best practise #1 - Show Empathy & Identify the requirements (2:37)
Best practise #2 - Finding the most suitable KPIs (2:18)
Best Practise #3 - Choose an effective visualization (3:39)
Best Practise #4 Make use of natural reading pattern (2:58)
Best practise # 5 - Tell a story using visual cues (5:21)
Best practise # 6 - Avoid Chaos & Group information (2:17)
Wrap up - Stroytelling with data (1:41)
Power BI Cloud - Power BI Service
How to go from here? (3:13)
Power BI Pro vs. Premium & Registration (3:48)
An alternative if you don't have a business email
Exploring the Workspaces (4:10)
Discovering the workspaces (2:31)
Note on the next lecture
Connecting Power BI Desktop & Cloud (4:00)
Understanding Datasets & Reports (3:24)
Working with the reports (3:53)
Updating the reports from Power BI Desktop (4:29)
Creating and working with Workspaces (7:13)
Installing & Using a Data Gateway (12:53)
Get Quick Insights (2:33)
Creating Dashboards (4:05)
Sharing our results through Apps (10:09)
Power BI Mobile App (5:26)
Creating the layout for the Mobile App (3:46)
Cloud Wrap up (7:13)
Row-Level Security
Intro (3:20)
Creating a Row-Level Security (4:51)
Row-Level Security in the Cloud (3:31)
Row-Level Security & Data Model (4:38)
Dynamic Row-Level Security (7:28)
Dynamic Many-to-Many RLS (4:04)
Hierarchical Row-Level Security (12:55)
Additional data sources
JSON & REST API (9:57)
Setting up a local MySQL database (14:01)
Connecting to a SQL database (4:59)
Power BI & SQL database (PostgreSQL) (5:01)
Congratulations & how to stay up to date
Congratulations & Next steps (6:24)
More data to practise
Mini Project - Transform Data
Download
gdp_data.xlsx
Download
life_expectancy_years.xlsx
Complete and Continue