In this chapter, you will learn about the importance of building a well-defined data model, both from the point of view of a BI professional and in terms of making DAX code easier to write.

By the end of this chapter, you will have learned about the basics of good data modeling and why it is important to have a well-structured data model. You'll learn about importing data from different data sources and transforming it into a structure that is easy for both you and your end users to understand. Then, we'll look at a couple of different schema designs as well as some data modeling concepts. There will also be some hands-on examples of loading data, creating relationships, and using DAX functions to extend your model through the addition of calculated columns, calculated tables, and measures. Finally, you'll learn how to extend your data model...