This lesson is part of the paid course

Module 06 · Business Intelligence with Power BI25 min

Star Schema and Relationships

Fact and dimension tables, cardinality and why flat files break measures.

By the end of this lesson you can

Design a star schema
Fix an ambiguous relationship

Know someone who should take this course?

They will land on the course page with the free lessons open to them.

Lesson feedback

No ratings for this lesson yet.

Power Query Transformations Calculated Columns vs Measures

Course content

0/73

01Data Analysis Foundations

0 / 9

02Excel & Google Sheets for Analysts

0 / 11

Mini projects

1.Retail Sales Dashboard in Excel

03Statistics for Data Analysts

0 / 11

Mini projects

1.A/B Test Analysis for a Checkout Change

04SQL for Data Analysis

0 / 12

Mini projects

1.E-commerce SQL Analysis

05Python for Data Analysis

0 / 12

Mini projects

1.EDA on Indian Startup Funding

06Business Intelligence with Power BI

0 / 9

Business Intelligence with Power BI

0 / 9

Power BI Foundations

0 / 3

1.Power BI Desktop TourFree
2.Power Query Transformations23m
3.Star Schema and Relationships25m

Exercises

1.Build Eight DAX Measures

Interview Q&A

1.Power BI & BI Interview Questions

DAX and Measures

0 / 3

Dashboards and Storytelling

0 / 3

Mini projects

1.Executive Sales Dashboard in Power BI

07Capstone Projects & Career Preparation

0 / 9

Capstone projects

1.Capstone — Telecom Customer Churn, End to End

Stay updated