Home
Courses
Power BI: Advanced Data Modeling and Shaping

Power BI: Advanced Data Modeling and Shaping

Course 8646

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

Get This Course $2,050 GOV $2,050

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

Get the Advantage $3,895

Take this course and gain unlimited access to more than 300 virtual instructor-led courses
Future-proof your career with more than 100 sought-after certifications in the market
Build real skills through hands-on learning in more than 180 virtual labs
Grow your skills and capabilities with more than one course at a time and save

Thank you for choosing subscriptions!

#8646

Guaranteed to Run - you can rest assured that the class will not be cancelled.
May 21 - 22 9:00 AM - 4:30 PM EDT

Virtual
Jun 16 - 17 9:00 AM - 4:30 PM EDT

Herndon, VA or Virtual
Jul 14 - 15 9:00 AM - 4:30 PM EDT

Ottawa or Virtual
Aug 18 - 19 9:00 AM - 4:30 PM EDT

Herndon, VA or Virtual
Sep 8 - 9 9:00 AM - 4:30 PM EDT

Ottawa or Virtual
Nov 12 - 13 9:00 AM - 4:30 PM EST

Virtual
Dec 15 - 16 9:00 AM - 4:30 PM EST

Virtual
Feb 24 - 25 9:00 AM - 4:30 PM EST

Virtual
Mar 25 - 26 9:00 AM - 4:30 PM EDT

Virtual

Scroll to view additional course dates

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

Get the Advantage $3,895

Take this course and gain unlimited access to more than 300 virtual instructor-led courses
Future-proof your career with more than 100 sought-after certifications in the market
Build real skills through hands-on learning in more than 180 virtual labs
Grow your skills and capabilities with more than one course at a time and save

Thank you for choosing subscriptions!

#8646

Guaranteed to Run - you can rest assured that the class will not be cancelled.
May 21 - 22 9:00 AM - 4:30 PM EDT

Virtual
Jun 16 - 17 9:00 AM - 4:30 PM EDT

Herndon, VA or Virtual
Jul 14 - 15 9:00 AM - 4:30 PM EDT

Ottawa or Virtual
Aug 18 - 19 9:00 AM - 4:30 PM EDT

Herndon, VA or Virtual
Sep 8 - 9 9:00 AM - 4:30 PM EDT

Ottawa or Virtual
Nov 12 - 13 9:00 AM - 4:30 PM EST

Virtual
Dec 15 - 16 9:00 AM - 4:30 PM EST

Virtual
Feb 24 - 25 9:00 AM - 4:30 PM EST

Virtual
Mar 25 - 26 9:00 AM - 4:30 PM EDT

Virtual

Scroll to view additional course dates

Bring this or any training to your organization
Full-scale program development
Delivered when, where, and how you want it
Blended learning models
Tailored content
Expert team coaching

Get the Advantage $3,895

Take this course and gain unlimited access to more than 300 virtual instructor-led courses
Future-proof your career with more than 100 sought-after certifications in the market
Build real skills through hands-on learning in more than 180 virtual labs
Grow your skills and capabilities with more than one course at a time and save

Thank you for choosing subscriptions!

#8646

Questions about this course?

Customize Your Team Training Experience

Fill out the form below or call 888-843-8733

* Required Fields

Preferred method of contact:

Phone

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, Power BI Data Analyst Training Course (PL-300) prior to going into this Advanced Data Modeling and Shaping course.

No, this class is not an exam prep class.

Power BI: Advanced Data Modeling and Shaping

Power BI: Advanced Data Modeling Training Delivery Methods

Power BI: Advanced Data Modeling Course Benefits

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

Upgrade your course experience with: Subscriptions

Get the Advantage $3,895

Thank you for choosing subscriptions!

Upgrade your course experience with: Subscriptions

Get the Advantage $3,895

Thank you for choosing subscriptions!

Upgrade your course experience with: Subscriptions

Get the Advantage $3,895

Thank you for choosing subscriptions!

Advanced Data Modelling in Power BI FAQs

What are the prerequisites for Power BI: Advanced Data Modeling?

Does this class prepare an attendee for a Microsoft Exam?

Related Courses