Reveal the insights behind your companys data with Microsoft Power BI

Microsoft Power BI allows intuitive access to data that can power intelligent business decisions and insightful strategies. The question is, do you have the Power BI skills to make your organizations numbers spill their secrets?

InMicrosoft Power BI For Dummies, expert lecturer, consultant, and author Jack Hyman delivers a start-to-finish guide to applying the Power BI platform to your own firms data. Youll discover how to start exploring your data sources, build data models, visualize your results, and create compelling reports that motivate decisive action.

Tackle the basics of Microsoft Power BI and, when youre done with that, move on to advanced functions like accessing data with DAX and app integrationsGuide your organizations direction and decisions with rock-solid conclusions based on real-world dataImpress your bosses and confidently lead your direct reports with exciting insights drawn from Power BIs useful visualization tools

Its one thing for your company to have data at its disposal. Its another thing entirely to know what to do with it.Microsoft Power BI For Dummies is the straightforward blueprint you need to apply one of the most powerful business intelligence tools on the market to your firms existing data.

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

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: Its 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! Theres 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