June 2024
Beginner to intermediate
484 pages
11h 56m
English
Content preview from Data Modeling with Microsoft Power BI
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 6. Building a Data Model in Power BI
Because Power BI is a data model-driven tool, it’s important to ensure the information you display and interact with is modeled correctly. In this chapter, you will learn pros and cons of building a data model in Power BI. You will learn “how-to” techniques in DAX, Power Query, and SQL in Parts III, IV, and V. Here, I talk about the principles and options in the Model view of Power BI Desktop.
I begin with a short recap on normalizing and denormalizing before broaching calculation writing. As you will see, certain types of calculations can’t be done before loading the data into Power BI but only by defining the formula inside of Power BI.
Power BI can do common calculations for you without a specified formula. It’s not a good idea to depend on this behavior, though. Always explicitly write even simple formulas.
I recap the importance of having a dedicated Date (and maybe Time) dimension in your Power BI data model. You will learn two ways of modeling role-playing dimensions and that slowly changing dimensions need to be modeled outside of Power BI (in a physical data warehouse layer). I end this chapter with a description of how to define and use hierarchies.
Let’s begin with the most important part: normalizing and denormalizing.
Normalizing and Denormalizing
I introduce normalizing fact tables and denormalizing dimension tables to transform any given data model into a star schema in “Data Model”. In the “Normalizing” and “Denormalizing” ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.