Cart 0

Power BI: Advanced Data Modeling and Shaping (One-Day Course)
Course 8646
1 DAY COURSE

Price:
Course Outline

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 and Shaping (One-Day 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

Course Dates
Attendance Method

How will you be attending the class?

Selecting 'Live Virtual' allows you to attend remotely from work or home. You will receive email communication well before the class starts with detailed instructions on how to validate your equipment and connect to the classroom for a quality learning experience.

Additional Details (optional)

Private Team Training

Interested in this course for your team? Please complete and submit the form below and we will contact you to discuss your needs and budget.