Advanced Data Modelling and Shaping (MSIAD)

OVERVIEW

Prerequisites—DIAD training or equivalent working experience

This one-day course will cover using Power BI Desktop to import and shape data from a variety of sources. It will also walk through Power BI capabilities you can use to enhance the data model for your business users. The course covers key aspects of how to create a great data model to meet your business needs, various features in Power BI used to enhance data models so you can build great reports, and an introduction to DAX to create calculations.

After completing this training, the attendees should be able to import data from a variety of data sources into Power BI, shape the data, create the data model, and write DAX functions to the Power BI model.

COURSE BENEFITS:

• Understand the Power BI Desktop data model, its components and most effective schemas
• Describe concepts of calculated columns and measures
• Create queries using M
• Create calculations with DAX
• Understand the use of functions
• Create and optimize a data model
• Understand the consequences of data model design decisions

WHO IS THE COURSE FOR?

• Power BI report developers who wish to improve the structure of their data models
• Power BI report developers who wish to use advanced features like parameters and M coding in Power Query
• Power BI practitioners who wish to optimise their models more effectively
• Attendees wishing to prepare thoroughly for the DAX In A Day course

COURSE OUTLINE