Data Model and Relationships

In this lesson, we will learn data models and relationships in Power BI. We will understand fact and dimension tables, one-to-many relationships, primary and foreign keys, star schema, and how a correct model affects report results. ## Lesson objective In this lesson, we will learn data models and relationships in Power BI. In the previous lesson, we covered data cleaning and transformation with Power Query. We learned key transformation steps such as text cleaning, Trim, Clean, Replace Values, blank values, duplicate rows, Split Column, Custom Column, and Conditional Column. Now we move to one of the most important parts of Power BI: the data model.