Power BI – Data Model Essentials

Duration: 120 Minutes

Overview

This course is designed to give participants an overview of the core principles of data modeling in Power BI, providing a hands-on approach that balances theory with practical examples.

Audience

For Beginner/ Intermediate Power BI users who are familiar with basic report-building features but want to enhance their skills in data modeling.

Understanding the Data Model

• What is the Data Model?
• Normalising Data
• Dimension vs Fact Tables

Tables in Power Query

• Importing Tables into Power Query
• Data Transformation Techniques
• Splitting and Merging Table Data
• Use of Primary and Foreign Keys

Working in Data Model

• Cardinality in the Data Model
• Managing Table Relationships
• Hiding Field and Tables
• Table and Field Properties
• Using the Star Schema
• Using the Snowflake Schema

Create Visuals using Related Tables

• Add Visual (Charts, Tables, Matrix)
• Adding Data to Visuals