Excel to Power BI Series – Ep 3: Power Query
In episode 3 of our EXCEL TO POWER BI series, we'll learn how to use Power Query to automate the process of cleaning, combining, and transforming data used in our analysis.
Example files: https://1drv.ms/u/s!Ag7ykXTYqW3UgTC81...
Episode 1 (Pivot tables): • Excel to Power BI Series – Ep 1: Pivot Tables
Episode 2 (Power Pivot): • Excel to Power BI Series – Ep 2: Power Pivot
Power Query add-in: https://www.microsoft.com/en-US/downl...
0:00 - Intro
1:28 - Setup
2:11 - Step 1: Get Data
3:04 - Step 2: Combine/transform data
11:16 - Step 3: Load data (pivot table)
13:38 - Recap