Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Power Pivot, Power Query & DAX in Excel
Section 1: Introduction
Welcome and Overview (3:02)
What is Power Query? (5:24)
What is Power Pivot? (3:43)
Course Exercise Files
Course Demo Files
Section 2: Getting Started with Power Query
Exploring the Power Query Editor (6:29)
Common Power Query Transformations (8:59)
Editing an Existing Query (9:55)
Import Multiple Files from a Folder (11:06)
Connect to Data in Another Excel Workbook (9:37)
IMPORTANT: Checking the Location of your Query's Source (3:34)
Get Data From the Web (5:39)
Practise Exercise (1:05)
Section 3: Useful Power Query Features
Unpivoting Columns (5:32)
Combine Data from Multiple Tables with Merge Queries (6:11)
Use Merge Queries to Compare Two Tables (5:03)
Stack Data into One Table with Append Queries (6:02)
Duplicating and Referencing Queries (9:10)
Grouping and Aggregating Data (7:53)
Conditional Columns in Power Query (7:13)
Practise Exercise (1:14)
Section 4: Creating the Data Model
Enable the Power Pivot Add-In (1:54)
Understanding the Power Pivot Window (4:42)
Creating Relationships Between tables (5:03)
Managing the Relationships of the Model (3:01)
Creating a PivotTable from the Data Model (4:42)
Hide Fields from Client Tools (3:19)
Grouping Queries (4:33)
Practise Exercise (0:49)
Section 5: Introduction to DAX
Why use DAX? (3:14)
Creating Calculated Columns with DAX (5:09)
Creating your First DAX Measure (6:17)
The COUNTROWS Function (5:09)
SUMX and RELATED Functions (4:45)
Practise Exercise (0:49)
Section 6: More DAX Measures
Create a Date Table in Power Pivot (8:46)
The CALCULATE Function (3:31)
The DIVIDE Function (3:09)
Using the DATESYTD Function (2:20)
Calculate the Percentage of a Total (6:17)
Practise Exercise (1:05)
Section 7: Using PivotTables and Slicers
Create PivotTables and PivotCharts (11:57)
Using Slicers with your PivotTables (6:21)
Create a Top 10 PivotTable (8:25)
Practise Exercise (0:47)
Section 8: Closing
Wrap Up (1:26)
Course Quiz and Certificate of Completion
Hide Fields from Client Tools
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock