Data Modeling with Power BI

Welcome to the course

Welcome to the course forum!

The course forum is a dedicated space for you to connect with your classmates, instructors, and course team.

Introduction to Data Modeling

Slide Deck: Introduction to Data Modeling

Introduction to Power BI Data Models

Reading: Effective Data Model

Introduction to the sample dataset

Data Transformation

Data transformation

Setting Column properties

Reading: Working with tables and columns

Introduction to Fact and Dimension tables

Introduction to schemas

Flat Schemas

Star schemas

Snowflake Schemas

Star schemas in depth

Normalization vs. denormalization

Introduction to relationships

Star Schemas_Practical

Using Auto Detect relationships

Primary and foreign keys

Defining relationships

Creating relationship with auto layout

Working with flat schema

Working with flat schema

Creating star schema for flat schema

In this exercise, you can apply your knowledge of these data models to configure the Flat schema.

You will walk through the steps to create a Flat schema in Power BI using the example of an online bicycle store called Adventure Works.

You'll demonstrate how the store uses a schema to consolidate and analyze data, leading to better business decisions.

In the exercise, you must apply your knowledge of data models to build and configure a Flat schema in Power BI.

You'll walk through the steps to create a Flat schema in Power BI using the Adventure Works dataset. 

The goal is to merge two different tables of datasets into a single consolidated dataset to build a Flat schema that can be utilized for data analysis and visualization.

Managing relationships

Cardinality

Cardinality

Reading: Work with relationships and cardinality

Cross filter direction

Reading: Cross Filter Direction

Role-playing dimensions

Working with hierarchies

Reading: Creating Hierarchies

Active and inactive relationship

Optimizing your data models

Congratulations on completing the course.