Objectives

  • Understand the Power BI Desktop data model components and most effective schemas
  • Gain an understanding of the Power Query M language
  • Import data from a variety of sources (including XLS and CSV files)
  • Create queries using the toolbar navigations and Advanced Editor
  • Understand parameters
  • Organize queries using folders

Agenda

  • Introductions and Overview
  • Module 1: Getting Started with M Power Query Language
    • Module 1 Lab: Import and Basic Transform
  • Module 2: Advanced M Transformations
    • Module 2 Lab: Complex Transformation
  • Module 3: Variable, Parameters and Functions
    • Module 3 Lab: Creating Parameters and Paths
  • Module 4: Optimization Techniques
  • Module 5: Introduction to Data Flows
  • Wrap Up and Questions