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 14. Building a Data Model with Power Query and M
Once you understand the moving parts of Power Query and the M language (see Chapter 13), it’s time to see what this tool has in store for you to bring a data model into shape. You can achieve many tasks by finding your way around in the UI. No matter what kind of transformation you are applying, every step is “recorded” as a step in a script in language M. Think of this feature as something similar to Excel’s macro recorder. Some steps will show a gear icon, which will open a dialog box and guide you through options to change a step’s logic. You can also directly edit the scripts, if you want.
In this chapter, you’ll learn how and why to touch some of the scripts directly. Editing the script is sometimes just faster, compared to navigating through the UI with the mouse. In other cases, it might be that a feature of the powerful language M is just not available via the UI. Especially when it comes to making the transformation either flexible or resilient against changes in the data source, M can do some magic.
You’ll also learn how to normalize fact tables and denormalize dimension tables (to form a star schema) using Power Query. I’ll introduce you to calculations in M and show you how you can transform flags and indicators into user-friendly text. A whole section is dedicated to creating a date table, which is mandatory for time-intelligence calculations in DAX and increases the usability of a data model by offering a variety ...
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.