Home | Excel | Power BI | Copilot | Visualising Data
This is a one day two day course.
This course assumes that people have attended the Power BI Foundation Course.
You will learn how to build a data model in Power BI - this is fundamental to accurate reporting and good dashboards
Build a dimensional data model - arrange several fact and dimension tables in a star schema pattern.
Understand how and why to use Date tables in a dimensional model.
Introduction to the DAX query view.
Build DAX measures and calculated columns to improve the data model.
Shape data so that it is suitable for data modelling; pivot and unpivot data, merge and append datasets.