From the course: Using Power BI with Excel

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Data tables vs. lookup tables

Data tables vs. lookup tables - Power BI Tutorial

From the course: Using Power BI with Excel

Start my 1-month free trial Buy for my team

Data tables vs. lookup tables

“

- [Instructor] There are two different types of tables that can make up a data model. The two different types of tables are data tables and look up tables. In the Excel to Power BI data source, we can see age and total sales and other numerical values. This is because this is a data table. Now on the other hand, customer information doesn't contain numerical values. What it contains is information that gives context to numerical values. For example, we have customer, the city they live, in the state they live in, what MSA they belong to, and also zip code. This is detailed information that can give broader context to when a sale or a purchase occurs. The same applies to location information. This doesn't give context about the customers but more so the supply chain, the locations that are producing the items and also carrying out sales. The reason we don't want to combine data tables and look up tables is that…

Contents