Power BI: Advanced Data Modeling and Shaping

Duration: 2 days
Labs: Yes
Language: English
Level: Advanced

In this Power BI Advanced Data Modeling and Shaping course, you will learn the techniques of data modeling and shaping in Power BI, including the Data Analysis Expressions (DAX) formulas and the Power Query M language.

Power BI: Advanced Data Modeling Training Delivery Methods

In-Person
Online

Power BI: Advanced Data Modeling Course Benefits

Learn how to import data into Power BI from various sources, including XLS and CSV files
Create data queries using Power BI’s toolbar navigations and Advanced Editor
Apply your knowledge in hands-on learning labs
Follow a curriculum based on Microsoft Official Courseware
Continue learning and face new challenges with after-course one-on-one instructor coaching

Power BI: Advanced Data Modeling Course Outline

Module 1: Data Modeling Basics – Getting the Data

Module 2: Getting Started with M (Power Query Language) and Relationship Between Tables

Module 3: Fact Table, Introduction to DAX Calculated Columns and Measures

Module 4: Working with Parameters and Introduction to DAX

Module 5: Working with Functions - DAX CALCULATE Function, Custom Functions and Time Intelligence Functions

Module 6: Modeling with Power BI and DAX Best Practices (Data Modeling, Optimization Techniques)

Module 7: Summary, Wrap-up, and Questions

Select Commercial or Government Pricing

$2,340

2-day instructor-led training course
Microsoft Official Courseware
Hands-on learning labs included
After-course coaching available

Would you like to take this course as a team?

Nov. 9 - 10 10:00 a.m. - 5:30 p.m. EST

Austin or Virtual
Dec. 7 - 8 9:00 a.m. - 4:30 p.m. EST

New York or Virtual
Feb. 16 - 17 9:00 a.m. - 4:30 p.m. EST

Ottawa or Virtual
Mar. 22 - 23 9:00 a.m. - 4:30 p.m. EDT

Herndon, VA or Virtual
May 5 - 6 9:00 a.m. - 4:30 p.m. EDT

New York or Virtual
Jun. 21 - 22 9:00 a.m. - 4:30 p.m. EDT

Herndon, VA or Virtual
Aug. 16 - 17 9:00 a.m. - 4:30 p.m. EDT

Ottawa or Virtual
Sep. 20 - 21 9:00 a.m. - 4:30 p.m. EDT

Herndon, VA or Virtual

Scroll to view additional course dates

$2,060

2-day instructor-led training course
Microsoft Official Courseware
Hands-on learning labs included
After-course coaching available

Would you like to take this course as a team?

Nov. 9 - 10 10:00 a.m. - 5:30 p.m. EST

Austin or Virtual
Dec. 7 - 8 9:00 a.m. - 4:30 p.m. EST

New York or Virtual
Feb. 16 - 17 9:00 a.m. - 4:30 p.m. EST

Ottawa or Virtual
Mar. 22 - 23 9:00 a.m. - 4:30 p.m. EDT

Herndon, VA or Virtual
May 5 - 6 9:00 a.m. - 4:30 p.m. EDT

New York or Virtual
Jun. 21 - 22 9:00 a.m. - 4:30 p.m. EDT

Herndon, VA or Virtual
Aug. 16 - 17 9:00 a.m. - 4:30 p.m. EDT

Ottawa or Virtual
Sep. 20 - 21 9:00 a.m. - 4:30 p.m. EDT

Herndon, VA or Virtual

Scroll to view additional course dates

Speak with a Learning Consultant

Inquiring For

Myself

Team/Group

First Name*

Last Name*

Email*

Phone Number*

Company*

Job Title

I'm interested In

* Required Fields

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

Advanced Data Modelling in Power BI FAQs

Attendees of this course would benefit from Learning Tree course 1360, Introduction to Power BI Training or course 8574, Design and Manage Analytics Solutions Using Power BI (PL-300) prior to going into this Advanced Data Modeling and Shaping course.

No, this class is not an exam prep class.