<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=612681139262614&amp;ev=PageView&amp;noscript=1">
Skip to content

Need help? Talk to an expert: phone(904) 638-5743

Advanced Data Shaping With Power BI

Learn to use Power BI Desktop for data import and shaping from various sources. Understand data models, effective schemas, Power Query M language, query creation, parameters, and query organization.

  • Course Info
  • Instructor
  • System Requirements
  • What to know beforehand

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.

Course Outline ( Free Preview)

Advanced Data Shaping with Power BI - What you need to get started

Module 00 - Introduction 6 min.

Module 01A - Basic Data Modeling (Overview) 26 min.

Module 01B - Basic Data Modeling (Lab) 10 min.

Module 02A - Getting Started with M (Overview) 13 min.

Module 02B - Getting Started with M (Import and Basic Transform Lab) 38 min.

Module 03A - Advanced M Transformations (Overview) 10 min.

Module 03B - Advanced M Transformations (Complex Transformations Lab) 29 min.

Module 04A - Variables and Parameters (Overview) 5 min.

Module 04B - Variables and Parameters (Creating Parameters and Paths Lab) 26 min.

Module 05 - Optimization Techniques 10 min.

Module 06 - Class Wrap-Up 1 min.

This course includes:

  • 2+ hours of training
  • 12 Modules
  • * Access on mobile and browser
  • Certificate of Completion