Table of Contents
Introduction 1
Part 1: Put Your BI Thinking Caps On 7
Chapter 1: A Crash Course in Data Analytics Terms: Power BI Style 9
Chapter 2: The Who, How, and What of Power BI 23
Chapter 3: Oh, the Choices: Power BI Versions 33
Chapter 4: Power BI: The Highlights 47
Part 2: It’s Time to Have a Data Party 65
Chapter 5: Preparing Data Sources 67
Chapter 6: Getting Data from Dynamic Sources 85
Chapter 7: Cleansing, Transforming, and Loading Your Data 103
Part 3: The Art and Science of Power BI 127
Chapter 8: Crafting the Data Model 129
Chapter 9: Designing and Deploying Data Models 145
Chapter 10: Perfecting the Data Model 167
Chapter 11: Visualizing Data 183
Chapter 12: Pumping Out Reports 213
Chapter 13: Diving into Dashboarding 233
Part 4: Oh, No! There’s a Power BI Programming Language! 247
Chapter 14: Digging Into DAX 249
Chapter 15: Fun with DAX Functions 265
Chapter 16: Digging Deeper into DAX 289
Chapter 17: Sharing and the Power BI Workspace 305
Part 5: Enhancing Your Power BI Experience 325
Chapter 18: Making Your Data Shine 327
Chapter 19: Extending the Power BI Experience 343
Part 6: The Part of Tens 367
Chapter 20: Ten Ways to Optimize DAX Using Power BI 369
Chapter 21: Ten Ways to Make Compelling Reports Accessible and User-Friendly 379
Index 389