Chapter 5: Designing a Data Model
Once you have connected to your data, done a bit of analysis, and organized it for reporting, the next step is to create a data model.
A good data model will provide faster and more accurate reporting. If the data model is easy to understand, report developers will take less time to generate reports, and it will make those reports easier to maintain. We'll see how to do that in this chapter.
In this chapter, we will cover the following topics – each using the same names you'll see in the exam:
- Define the tables
- Flatten out a parent-child hierarchy
- Define role-playing dimensions
- Configure table and column properties
- Define quick measures
- Resolve many-to-many relationships
- Create a common date table
- Define the appropriate level of data granularity
- Design the data model to meet performance requirements
