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
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