Microsoft Power BI For Dummies

by Jack A. Hyman

Overview

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.  

Product Details

ISBN-13:	9781119824893
Publisher:	Wiley
Publication date:	01/05/2022
Sold by:	JOHN WILEY & SONS
Format:	eBook
Pages:	416
Sales rank:	371,247
File size:	13 MB
Note:	This product may take a few minutes to download.

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.

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