From the course: Power BI Data Modeling with DAX
Unlock the full course today
Join today to access over 24,000 courses taught by industry experts.
Check relationships - Power BI Tutorial
From the course: Power BI Data Modeling with DAX
Check relationships
- [Instructor] This is the model, or as many people think of, the relationships view in Power BI Desktop for the Contoso Sales Sample. Here we see tables and the relationships between them. And there are a few things I'd like to point out to you here in this particular view. First, we have a main table here. This is the sales sample, and so it's the sales table. The sales table has information about sales in it. It has columns like product quantity, and price of the product. This table is our fact table, it's a data table. The other tables are supporting tables, they're called lookup tables. And so if I want to know information about the store that something was purchased in, it'll be in the storage table. The products or category those products are in, that's out here on this branch. When I add data into a model, several tables for example from SQL Server, or any other data sources that are related. Power BI Desktop…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.