- Introduction Free
- Meet Power Query (aka Get & Transform) Free
- The Query Editor Free
- Data Loading Options Pro
- IMPORTANT: Updating Locale Settings Pro
- Basic Table Transformations Pro
- Text-Specific Tools Pro
- Number-Specific Tools Pro
- Date-Specific Tools Pro
- PRO TIP: Creating a Rolling Calendar Pro
- Adding Index & Conditional Columns Pro
- Grouping & Aggregating Data Pro
- Pivoting & Unpivoting Pro
- Modifying Workbook Queries Pro
- Merging Queries Pro
- Appending Queries Pro
- Connecting to a Folder of Files Pro
- PRO TIP: Additional Data Connectors (Excel, MySQL, PDF, Web) Pro
- Power Query Best Practices Pro
- HOMEWORK: Power Query Pro
- QUIZ: Power Query Pro
- Introduction Pro
- Meet Excel's Data Model Pro
- Data vs. Diagram View Pro
- Database Normalization Pro
- Data Tables vs. Lookup Tables Pro
- Relationships vs. Merged Tables Pro
- Creating Table Relationships Pro
- Modifying Table Relationships Pro
- Active vs. Inactive Relationships Pro
- Relationship Cardinality Pro
- Connecting Multiple Data Tables Pro
- Filter Direction Pro
- Hiding Fields from Client Tools Pro
- Defining Hierarchies Pro
- Data Model Best Practices Pro
- HOMEWORK: Data Modeling 101 Pro
- QUIZ: Data Modeling 101 Pro
- Introduction Pro
- Creating a Power PivotTable Pro
- Power Pivots vs. Normal Pivots Pro
- Intro to Data Analysis Expressions (DAX) Pro
- Calculated Columns Pro
- Intro to DAX Measures Pro
- Creating Implicit Measures Pro
- Creating Explicit Measures (AutoSum) Pro
- Creating Explicit Measures (Power Pivot) Pro
- Understanding Filter Context Pro
- Step-by-Step Measure Calculation Pro
- RECAP: Calculated Columns vs. Measures Pro
- Power Pivot Best Practices Pro
- HOMEWORK: Power Pivot & DAX 101 Pro
- QUIZ: Power Pivot & DAX 101 Pro
- Introduction Pro
- DAX Formula Syntax & Operators Pro
- Common DAX Function Categories Pro
- Basic Math & Stats Functions Pro
- COUNT, COUNTA, DISTINCTCOUNT & COUNTROWS Pro
- HOMEWORK: Math & Stats Functions Pro
- Logical Functions (IF/AND/OR) Pro
- SWITCH & SWITCH(TRUE) Pro
- Text Functions Pro
- HOMEWORK: Logical & Text Functions Pro
- Basic Date & Time Functions Pro
- The CALCULATE Function Pro
- Adding Filter Context with Filter (Part 1) Pro
- Adding Filter Context with Filter (Part 2) Pro
- Removing Filter Context with ALL Pro
- HOMEWORK: CALCULATE, FILTER & ALL Pro
- Joining Data with RELATED Pro
- Iterator (X) Functions: SUMX Pro
- Iterator (X) Functions: RANKX Pro
- HOMEWORK: Iterator Functions Pro
- Time Intelligence Formulas Pro
- HOMEWORK: Time Intelligence Pro
- Speed & Performance Considerations Pro
- DAX Best Practices Pro
- QUIZ: Common DAX Functions Pro