Course curriculum

  1. 1

    • Google Subtitles Instructions

    • Data Preparation written materials

    • 1.1 Clean Data in Query Editor

    • 1.2 Power BI Data Types and Formatting

    • 1.3 Transform Your Data with Custom Columns

    • 1.4 Duplicate and Merge Queries

    • 1.5 Date Correction

    • 1.6 Erroneous Data
  2. 2

    • DAX written materials

    • 2.1 Intro to Time Intelligence

    • 2.2 Year Over Year Analysis and Day Analysis

    • 2.3 Last 30 Days Analysis

    • 2.4 Running Sum

    • 2.5 Variables and Measures within Variables

    • 2.6 DAX Development Best Practices

    • 2.7 Pareto Chart

    • 2.8 Moving Average

    • 2.9 Switch Function
  3. 3

    • Formatting and Design written materials

    • 3.1 Basic Report Formatting Tips

    • 3.2 Custom Themes

    • 3.3 Conditional Formatting

    • 3.4 Drillthrough (Same Report)

    • 3.5 Drillthrough (Cross Report)

    • 3.6 Sync Slicers

    • 3.7 Edit Interactions