In this chapter, you learned about why it is important to build a well-defined data model. Not only does it make it easier to understand and report from as an end user, but it also makes it easier to work with as a BI professional by making the execution of DAX code easier to understand. From here, you learned about a couple of different schema designs with the star and snowflake shaped schemas. You also learned about some important data modeling concepts that you then put into practice by building a simple data model using hands-on examples.
Then, you looked at how to load data and create relationships and how to use DAX functions to extend your data model by creating calculated columns, calculated tables, and measures. Finally, you learned how to extend your data model further by adding a custom date table to it using the CALENDAR function.
In the next chapter, we&apos...
