SE flag SE
SE +46 (0) 8 50666800 UK +44 (0) 207 874 5000
  • Home
  • Courses
  • Power BI: Advanced Data Modeling and Shaping (One-Day Course)

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

Course 8646

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

  • Microsoft Official Courseware

  • Hands-on learning labs included

  • After-course coaching available

#8646
  • Guaranteed to Run - you can rest assured that the class will not be cancelled.
    nov 16 15:00 - 22:30 CET
    Virtual
  • dec 12 10:00 - 17:30 CET
    London or Virtual
  • dec 12 15:00 - 22:30 CET
    Virtual
  • jan 10 15:00 - 22:30 CET
    Virtual
  • mar 3 15:00 - 22:30 CET
    Virtual
  • mar 13 10:00 - 17:30 CET
    London or Virtual
  • mar 28 15:00 - 22:30 CEST
    Virtual
  • maj 16 15:00 - 22:30 CEST
    Virtual
  • jun 12 10:00 - 17:30 CEST
    London or Virtual
  • jun 27 15:00 - 22:30 CEST
    Virtual
  • aug 10 15:00 - 22:30 CEST
    Virtual
  • aug 30 15:00 - 22:30 CEST
    Virtual
  • sep 26 15:00 - 22:30 CEST
    Virtual

Scroll to view additional course dates

Questions about this course?
* Required Fields

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.

Contact Us

Advanced Data Modelling in Power BI FAQs

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

No, this class is not an exam prep class.

Related Courses

  • Learning Tree
    Introduction to Microsoft Power BI Training

    In this course, you will gain the basic skills and knowledge to manage and analyse data in Power BI.

    Foundation
    3 days
    Online or In-class
    Starts from 21 900 kr
  • Microsoft
    Power BI: Advanced Data Modeling and Shaping (One-Day Course)

    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.

    Advanced
    1 day
    Online or In-class
    Starts from 5 900 kr
  • Microsoft
    Microsoft Power BI Data Analyst (PL-300)

    Attend this 3-day Microsoft Power BI Data Analyst (PL-300) course to discuss the various methods and best practices that are in line with business and technical requirements for modelling, visualising, and analysing data with Power BI.

    Intermediate
    3 days
    Online or In-class
    Starts from 27 000 kr