Microsoft Power BI Data Analyst Certification Companion: Preparation for Exam PL-300

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

J. JollyMicrosoft Power BI Data Analyst Certification CompanionCertification Study Companion Serieshttps://doi.org/10.1007/978-1-4842-9013-2_6

6. Develop a Data Model

Jessica Jolly¹  

(1)

Evanston, IL, USA

 

In the previous chapter, we covered the basic principles of creating a data model. A star schema, dim and fact tables, and relationships are the building blocks of a data model. Once you have those in place, you can proceed to refine your model. The one assumption that we made was that all the data we needed was either in the source(s), or we created it using the Power Query Editor. But sometimes that isn’t sufficient or possible; we need to explore how to ...