Power BI: Advanced Data Modeling and Shaping (One-Day Course)

Course 8646

  • Duration:
  • Labs: Yes
  • Language: English
  • Level:
Get This Course 5.900 kr
  • 1-day instructor-led training course
  • Microsoft Official Courseware

  • Hands-on learning labs included
  • After-course coaching available

  • Guaranteed to Run - you can rest assured that the class will not be cancelled.
    jun 15 15:00 - 22:30 CEST
    Ottawa or Online (AnyWare)
  • jun 27 9:00 - 16:30 CEST
    Stockholm or Online (AnyWare)
  • jul 4 10:00 - 17:30 CEST
    Online (AnyWare)
  • jul 11 15:00 - 22:30 CEST
    Herndon, VA or Online (AnyWare)
  • aug 8 15:00 - 22:30 CEST
    New York or Online (AnyWare)
  • sep 8 15:00 - 22:30 CEST
    Ottawa or Online (AnyWare)
  • okt 6 15:00 - 22:30 CEST
    Herndon, VA or Online (AnyWare)
  • nov 16 15:00 - 22:30 CET
    New York or Online (AnyWare)
  • dec 12 10:00 - 17:30 CET
    Online (AnyWare)
  • feb 27 15:00 - 22:30 CET
    Ottawa or Online (AnyWare)
  • mar 13 10:00 - 17:30 CET
    Online (AnyWare)

Scroll to view additional course dates

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, Optimisation Techniques)
Module 7: Summary, Wrap-up, and Questions

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

Advanced Data Modelling in Power BI FAQs

You should have a foundational knowledge of Power BI before signing up for this course. We recommend the following courses: 

No, this class is not an exam prep class.