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_5

5. Design a Data Model

Jessica Jolly¹  

(1)

Evanston, IL, USA

 

What is a data model and why is it necessary? This is (perhaps) the most difficult concept to understand for a business user because Excel works in a flat world. Any summarization you want to perform requires that all the data is on the same worksheet. So, at most, you must use some LOOKUP functions to “retrieve” the data you need to include. While having everything on one worksheet is easy to comprehend, it is unwieldy and inefficient. Enter the data model. ...