Data modeling for results

The introduction to data modeling we provided in Chapter 5, Gathering and Loading Data in Python, gave us an understanding of relational databases and fundamental statistics that can be performed against structured data. In those examples, we learned about the relationships of data and how data can be modeled from the perspective of the data producer.Data producers are responsible for storing data in a structure to ensure the data's integrity is consistent. In the previous chapter, we also learned how anEntity Relationship Diagram (ERD)can be used to define the relationships between tables. In this chapter, we will apply these same concepts with the data consumer in mind. As a result, we will focus on creating new relationships with data, making it easier for analysis.This concept was an evolution in reporting and spawned a new industry commonly known as Business Intelligence (BI) and Analytics.

Introducing dimensions and measures

...