Reveal the insights behind your company’s 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 organization’s numbers spill their secrets?
In Microsoft 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 firm’s data. You’ll 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 you’re done with that, move on to advanced functions like accessing data with DAX and app integrations
- Guide your organization’s direction and decisions with rock-solid conclusions based on real-world data
- Impress your bosses and confidently lead your direct reports with exciting insights drawn from Power BI’s useful visualization tools
It’s one thing for your company to have data at its disposal. It’s 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 firm’s existing data.
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.
