Introduction
  • Introduction to the Course
  • About the Course
  • Please download the Training Data Files
Overview of the Query Editor
  • Overview and Introduction to Query Editor
Perform Transformations
  • Introduction to Transformations
  • Transformations Part 1
  • Transformations Part 2
  • Transformations Part 3
  • Practical Activity - Transformations
  • Practical Activity Completed
  • Conditional IF
Advanced Transformations
  • Introduction to Advanced Transformations
  • Merge Function
  • Practical Activity - Merge Function
  • Practical Activity Completed - Merge
  • Append Data
  • Custom Calculations
  • Group By Function
Cleanse Data and Parameters
  • Introduction to Cleanse Data
  • Download the Training Data Files
  • Query Editor Diagnostics
  • Cleansing Data Files
  • Parameters Part 1
  • Parameters Part 2
Connect to Power BI Connections and Data Sources
  • Introduction to Power BI Data Connections and Sources
  • Loading Data from SQL Server
  • Loading Data from CSV and TXT
  • Practical Activity - Load Data from a CSV file
  • Loading Data from the Web
  • Practical Activity - Connect to Data on the Web
  • Loading Excel Data from One Drive for Business
  • Loading Data from XML files
  • Loading Data from JSON
  • Loading Data from the Power BI Service
  • Loading Data from Google Sheets
  • Loading Data from Google Analytics
Case Studies
  • Introduction to Case Studies
  • Case Study Data Flows
  • Case Study - One Drive for Business
Conclusion
  • Conclusion to the Course