Summary
This chapter has introduced you to best practices in structuring your data for data modeling. In the real world, the data produced from most relational database management systems is already normalized. However, there will be instances where you would need to convert denormalized data into normalized data to improve calculations and reduce redundancy. After reading this chapter, you are now able to appreciate the steps you need to take to achieve this. The chapter also covered the key differences between primary keys and foreign keys and the role they play in our data model.
In the next chapter, we will learn about Power Query and how we can use this tool to shape and transform data for our data model.
