Data Model Design using Power BI Desktop - Level 2

This Level 2 course in the custom Power BI Desktop training series focuses on designing robust data models using Power Query and Power BI.

You will learn to connect to multiple data sources, shape and transform data, and build clean, reliable models for reporting. Emphasis is placed on creating queries, optimizing model performance, and preparing datasets that other Power BI report users can leverage. The course bridges Excel-centric workflows with Power BI capabilities, helping report builders move beyond basic spreadsheets to scalable, shareable models. Participants gain practical skills in model design and transformation to support consistent, accurate reporting.

Skills and knowledge equivalent to those learned in:

1. Data Analysis using Power BI Desktop - Level 1 - Report Builder

Report builders and analysts who create Power BI reports and need to design or refine custom data models. Ideal for Excel users transitioning to Power BI, BI developers supporting business teams, and professionals responsible for preparing datasets for others. Those aiming to master Power Query, improve data shaping and transformation, and optimize models for reliable reporting will benefit. It suits users who collaborate on shared datasets and want to deliver scalable, consistent reports.