NEED HELP? TALK TO AN EXPERT (904) 638-5743

Advanced Data Shaping with Power BI

Part Of The On-Demand Courses

WHAT YOU'LL LEARN

  • 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

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.

Outline

 

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


Instructor

MANUEL QUINTANA

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.

REVIEWS
Instructor was great, engaging, very good communication skills.

Anonymous

Great course.

Anonymous

Instructor was great, engaging, very good communication skills.

Anonymous

Start With The Free Community Plan

Pragmatic Works free community plan gives you lifetime access to 7 Microsoft “in a day” courses on Power BI, Excel, Power Apps, Azure Synapse, Power Automate, Paginated Reports and Chatbots.

 

Bonus:

• Get preview access to all 70+ courses & custom Learning Paths for 7 days

• Labs and files included

• Access courses from our mobile app or desktop

• Access quizzes to practice while you learn

Get Instant Access Now!