Advanced Data Shaping with Power BI

Part Of The On-Demand Courses


  • The Power BI Desktop data model
  • Components of effective schemas
  • Power Query M language
  • How to import data from a variety of sources (including XLS and CSV files)
  • How to create queries using toolbar navigations and Advanced Editor
This course includes:
  • Course Description
  • Outline
  • Instructor
  • System Requirements
  • What to Know Before Class

Course Description

At a high level, this session will cover using Power BI Desktop to import and shape data from a variety of different sources. Specifically, you will be able to: Understand the Power BI Desktop data model, the components of 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 toolbar navigations and Advanced Editor, understand parameters and finally, organize queries using folders.



Module 00 | Course Introduction
08m 10s total


Module 00A | Course Introduction
08m 10s


Module 01 | Basic Data Modeling
32m 35s total


Module 01A | Basic Data Modeling
32m 35s


Module 02 | Getting Started with M
63m 20s total


Module 02A | Getting Started with M Overview
17m 33s


Module 02B | Import and Basic Transform Lab
45m 47s


Module 03 | Advanced M Transformations
50m 34s total


Module 03A | Advanced M Transformations Overview
10m 31s


Module 03B | Complex Transformations Lab
40m 03s


Module 04 | Variables & Parameters
41m 51s total


Module 04A | Variables & Parameters Overview
06m 50s


Module 04B | Creating Parameters and Path Labels
35m 01s


Module 05 | Class Wrap Up
7m 39s total


Module 05A | Class Wrap Up
7m 39s



Training Content Manager
As a Training Content Manager with Pragmatic Works, Manuel uses his knowledge with the BI Stack (SSRS, SSIS, SSAS) to deliver exciting and engaging content. He also has experience with T-SQL, DAX and Power Pivot and is always looking to expand his knowledge. A native of Puerto Rico, Manuel graduated from the University of Central Florida and loves being involved in the world of Business Intelligence.


System Requirements

Microsoft Power BI Desktop requires Internet Explorer 9 or greater​

What to Know Before Class

We recommend first taking our Introduction to Power BI course prior to taking this one.


Instructor was great, engaging, very good communication skills.


Great course.


Enjoyed it, thanks!


Start your 7 day free trial

Pragmatic Works On-Demand Learning Platform gives you access to 60+ courses such as Power BI, Azure, SQL Server, Data Science, Business Intelligence Power Apps and more.

Instant Download | No Credit Card Required