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.

What you'll learn
Course Description
Course Outline
Instructor
System Requirements
What to know beforehand

What you'll learn

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.

This course includes:

2+ hours hours of training
Access on mobile and browser
Certificate of Completion

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.

This course includes:

2+ hours hours of training
Access on mobile and browser
Certificate of Completion

Course Outline

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 hours of training
Access on mobile and browser
Certificate of Completion

Instructor

Greg Trzeciak

Power BI Trainer

Gregory Trzeciak has his master’s degree in Education from the University of Florida. He has 9 years of teaching experience in high school, college level, and summer programs where he was recognized as a top educator and leader in interactive education. As a trainer at Pragmatic Works, his primary goal is to help individuals gain confidence in using Power BI and the Power Platform. While not in the office, he enjoys fantasy football, walking his dog, and running half-marathons!

Learn More

This course includes:

2+ hours hours of training
Access on mobile and browser
Certificate of Completion

System Requirements

Microsoft Power BI Desktop requires Internet Explorer 9 or greater.

This course includes:

2+ hours hours of training
Access on mobile and browser
Certificate of Completion

What to know before class

It is recommended that students first watch the Introduction to Power BI course before starting this course.

This course includes:

2+ hours hours of training
Access on mobile and browser
Certificate of Completion