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

About the Author

Jack Hyman is Chief Executive Officer of HyerTek, an IT consulting firm specializing in Microsoft’s business platforms. He is Associate Professor in the Computer Information Sciences department at the University of the Cumberlands. He has written several books in the For Dummies series, as well as certification study guides for the Microsoft Azure technology.