Before you can design and build a well-structured data model, there are some key concepts that you need to understand. In this section, we will look at these concepts in detail. Then, in the next section, we'll put them into practice when we build a simple data model as a hands-on example.
Data modeling concepts in DAX
Fact tables and dimension tables
In its simplest form, a good data model's design will consist of a primary table (or fact table) containing the numerical figures that you want to aggregate and analyze. This is then joined to several lookup tables (dimension tables) that contain the descriptive data relating to the business entities that you want to use to slice and dice your data.
A fact table, as...
