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. ...
© 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_55. Design a Data Model
Jessica Jolly1
(1)
Evanston, IL, USA
Get Microsoft Power BI Data Analyst Certification Companion: Preparation for Exam PL-300 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
