Data and AI Training

Home | Prices | Contact Us | Courses: Power BI - Excel - Python - SQL - Generative AI - Visualising Data - Analysing Data

Power BI Advanced (Data Modelling) Course

Who should attend

Data Modelling is the fundamental skill needed to produce sophisticated analyses and powerful reports. Data Modelling is about the arrangement and relationships of several data tables. This course is aimed at people who have some experience of using Power BI and who want to build or review a data model.

Course Length

2 days

Learning Objectives

Attendees will be able to use Power BI’s data modelling features to design and arrange their data into well-known dimensional modelling patterns resulting in better reports and dashboards. They will be able to review and critique data models.

Pre-requisites

A basic familiarity with Power BI, for example gained on the foundation and intermediate courses.

Course Content

This is a practical hands-on course. Attendees will build Power BI data models and visualisations to check they are working as expected. The course covers:

• The basics: tables, columns and data types
• The grain of a table, and why this is important
• Primary and foreign keys
• Unique and distinct values
• Discrete and continuous variables
• Relationships between tables
• Fact and dimension tables
• Star schemas (and their advantages)
• Snowflake schemas
• Just enough DAX for data modelling
• Data shaping with the Query Editor
• Date (calendar) tables
• Role playing dimensions

Example Lab Exercise

One of the possible case studies for this course is some fictional data about store sales & profit by date, customer, geography, product. More details are here. By the end of the course, you will have built a data model similar to the screenshot below.