Course curriculum

  1. 1
  2. 2

    • Lesson 2.1 Loading Data with PowerQuery

    • Lesson 2.2 Loading Data From Excel Tables

    • Lesson 2.3 Introduction to using with Pivot Tables

    • Lesson 2.4 Other Data Load Options

    • Lesson 2.5 Loading Data From an External Database
  3. 3

    • Lesson 3.1 More on Pivot Tables

    • Lesson 3.2 Pivot Tables and Relationships

    • Lesson 3.3 Introduction to Refreshing Data

    • Lesson 3.4 Refreshing Data via Connections

    • Lesson 3.5 Refreshing Data from an External Database
  4. 4

    • Lesson 4.1 Calculated Columns

    • Lesson 4.2 Introduction to Measures

    • Lesson 4.2 Introduction to Measures

    • Lesson 4.3 Adding Explicit Measures with Autosum

    • Lesson 4.4 Adding Implicit Measures

    • Lesson 4.5 Adding Explicit Measures in Power Pivot Menu
  5. 5

    • Lesson 5.1 Introduction

    • Lesson 5.2 Adding a Hierarchy

    • Lesson 5.3 Using Hierarchies in a Pivot Table

    • Lesson 5.4 Drill Paths

    • Lesson 5.5 Introduction to Related Columns

    • Lesson 5.6 Related Columns in a Hierarchy

    • Lesson 5.7 Best Practices with Hierarchies

    • Lesson 5.8 Editing Hierarchies
  6. 6

    • Lesson 6.1 DAX Syntax and Operators

    • Lesson 6.2 Some Useful DAX Functions Part 1

    • Lesson 6.3 Some Useful DAX Functions Part 2

    • Lesson 6.4 Some Useful DAX Functions Part 3

    • Lesson 6.5 Introduction to Iterator Functions

    • Lesson 6.6 Expressions in Iterator Functions

    • Lesson 6.7 Table functions in Iterator Functions (RELATEDTABLE)

    • Lesson 6.8 Table functions in Iterator Functions (TOPN)

    • Lesson 6.9 Other Iterator Functions

    • Lesson 6.10 Introduction to Context

    • Lesson 6.11 Examples of Context

    • Lesson 6.12 Filter Context in Pivot Tables

    • Lesson 6.13 Introduction to Filter Functions

    • Lesson 6.14 Example of a Filter Function

    • Lesson 6.15 Using Filters in a Filter Function

    • Lesson 6.16 Using the ALL Filter Function

    • Lesson 6.17 Using the ALLSELECTED Filter Function

    • Lesson 6.18 Introduction to Parent-Child Functions

    • Lesson 6.19 Using Parent-Child Functions

    • Lesson 6.20 Using Parent-Child Functions for a Hierarchy

    • Lesson 6.21 Time Intelligence Functions Part 1

    • Lesson 6.22 Time Intelligence Functions Part 2

    • Lesson 6.23 Time Intelligence Functions Part 3

    • Lesson 6.24 Time Intelligence Functions Part 4

    • Lesson 6.25 Key Performance Indicators

    • Completed files