CHAPTER 4

Modeling Data in Model View

Power BI Desktop includes extensive features for performing data modeling on your datasets. In this chapter, you work with Model View, which enables you to work with complex datasets that contain many tables. Model View displays all your model’s tables, columns, and relationships, enabling you not only to grasp complex relationships between many tables easily but also to manipulate them.

A screenshot exposes the model view which displays all your model’s tables, columns, and relationships.

Create Dimension Tables

Create Relationships Between Tables

Create a Star Schema

Create a Hierarchical Schema

Using the Properties Pane

Create Dimension Tables

A dimension table is one of the components of a data warehouse ...

Get Teach Yourself VISUALLY Power BI now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial