Power BI Advanced Data Shaping: 1-Day Workshop

Advaiya Solutions Inc.

A 1-day training session, helping business users to learn how to import data from multiple data sources into Power BI and understand Power Query M language for doing complex transformations.

This training will help business users to import and shape data from a variety of sources. By the end of the training, attendees will be able to:

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


  • Understanding basic Data Modeling
  • Getting Started with Power Query M Language
  • Importing data and Basic Transformations
  • Advanced M Transformations
  • Understanding Variable, Parameters and Functions
  • Best practices for optimization of queries and data model

Rychlý přehled