Summary
Kimball invented dimensional modeling to create an optimal user experience when using a relational database as a source for reporting and analytics. The design is optimized to read data. The design is also optimized for large datasets.
A star schema should be intuitive. It should be easy to use. It improves the productivity of report developers. It also decreases the number of errors made. This makes star schemas well suited for self-service BI where people with potentially few technical skills but lots of process knowledge work with the data.
In this chapter, you learned the skills to design a star schema database model. You learned to design both dimension and fact tables.
In the next chapter, you will implement a star schema design using Azure Synapse Analytics.
