Example Curriculum
Introduction
Available in
days
days
after you enroll
Section 1: Power Query for Extract, Transform and Load (ETL) operations
Available in
days
days
after you enroll
- Section Resources
- Introducing Power Query (10:55)
- Applying Basic Transformations (12:13)
- Editing Transformations (8:46)
- Numerical Transformations (8:43)
- Text Transformations (7:45)
- Date Transformations - Building a Calendar Table (8:53)
- Conditional Transformations (7:09)
- Merging Datasets (11:34)
- Appending Datasets (8:56)
- Exercises
- Let's Have Some Fun (+ Free Resources)
Section 2: The Excel Data Model
Available in
days
days
after you enroll
- Section Resources
- Introducing Excel's Data Model (8:56)
- Putting the Data Model to Work (13:08)
- Relationships (10:29)
- Relationships in The Excel Data Model (15:14)
- Power Pivot Tables (13:05)
- Calendar Tables (6:47)
- Exercise: Imposter Syndrome (2:55)
- Power Pivot Pitfalls (8:05)
- Multiple Data Tables (11:22)
- Exercises
- Unlimited Updates
Section 3: Analyzing the Data Model With DAX
Available in
days
days
after you enroll
- Calculated Columns With DAX (10:22)
- Project Exercise - Calculated Columns with DAX
- The IF Function in DAX (11:35)
- Project Exercise - The IF Function in DAX
- The SWITCH Function (15:10)
- Project Exercise - The SWITCH Function
- The RELATED Function (9:44)
- Project Exercise - The RELATED Functions
- Introducing Measures (12:07)
- Project Exercise - Introducing Measures
- Using DAX Functions in Measures (10:39)
- Project Exercise - Using DAX Functions in Measures
- The CALCULATE Function (13:33)
- Project Exercise - The CALCULATE Function
- The ALL Function (10:48)
- Project Exercise - The ALL Function
- Course Check-In
Section 4: Advanced DAX
Available in
days
days
after you enroll
- Introducing Time Intelligence Functions (17:32)
- The ISBLANK Function (4:42)
- Project Exercise - The ISBLANK Function
- The DATEADD Function (10:40)
- Project Exercise - The DATEADD Function
- The DATESINPERIOD Function (13:01)
- Project Exercise - The DATEINPERIOD Function
- Variables in DAX (10:33)
- Project Exercise - Variables in DAX
- The X Functions (8:42)
- Project Exercise - The X Functions
- The RANKX Function (9:25)
- Project Exercise - The RANKX Function
- The TOPN Function (9:45)
- Project Exercise - The TOPN Function
- Implement a New Life System
Section 5: Data Visualization Techniques
Available in
days
days
after you enroll
- Pivot Table Formatting Tips (8:52)
- Conditional Formating: Data Bars, Color Scales, and Icon Sets (15:02)
- Custom Conditional Formats (10:11)
- Introducing Pivot Charts (14:58)
- Column Charts (6:06)
- Line Charts, Area Charts, and Timelines (11:43)
- Combo Charts (5:49)
- Changing Measures With Slicers (13:28)
- Using Pivot Tables as Formulas (17:18)
- Project Exercise - Data Visualization Techniques
Where To Go From Here?
Available in
days
days
after you enroll