Paul D. Fuller

Beginning Power BI for Business Users (eBook, ePUB)

Learning to Turn Data into Insights

• Format: ePub

Produktbeschreibung

Discover the utility of your organization's data with Microsoft Power BI In Beginning Power BI for Business Users: Learning to Turn Data into Insights, accomplished data professional and business intelligence expert Paul Fuller delivers an intuitive and accessible handbook for professionals seeking to use Microsoft's Power BI to access, analyze, understand, report, and act on the data available to their organizations. In the book, you'll discover Power BI's robust feature set, learn to ingest and model data, visualize and report on that data, and even use the DAX scripting language to unlock still more utility from Microsoft's popular program. Beginning with general principles geared to readers with no or little experience with reporting or data analytics tools, the author walks you through how to manipulate common, publicly available data sources--including Excel files and relational databases. You'll also learn to: * Use the included and tested sample code to work through the helpful examples included by the author * Conduct data orchestration and visualization to better understand and gain insights from your data An essential resource for business analysts and Excel power users reaching the limits of that program's capabilities, Beginning Power BI for Business Users will also benefit data analysts who seek to prepare reports for their organizations using Microsoft's flexible and intuitive software.

---

Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in D ausgeliefert werden.

Produktdetails

• Verlag: John Wiley & Sons
• Erscheinungstermin: 20. September 2023
• Englisch
• ISBN-13: 9781394190300
• Artikelnr.: 69561349

Autorenporträt

PAUL D. FULLER has over 25 years' experience in app development, business intelligence, and data warehousing. He offers technical leadership and delivery oversight for complex and challenging data platform projects. He is an expert in Power BI, dimensional data modeling, and data warehousing.

Inhaltsangabe

Introduction xxi

Part 1: Introduction

Chapter 1: Introducing Power BI 3

What Is Power BI? 3

Why Would I Use Power BI? 7

But Why? 7

Disconnected Data 8

Fixed Formulas 9

Ten Reasons Why Power BI Transforms Your Work 10

Will I Still Use Excel? 12

How Much Is this Going to Cost? 14

Where Do We Go from Here? 16

Chapter 2: From Data to Insight 17

Three Guiding Principles 17

Distinguishing Data, Information, and Knowledge 18

Follow a Consistent, Proven Method 21

Data Sources 21

Files 21

Databases 22

Online Services 23

Plan Ahead 23

Import Data 25

Prepare Data 26

Model Data 28

Report Data 29

Analyze Data 30

Use Visualizations Well 31

Three Ways to Ruin Visual Analytics 32

Use as Many Cool Gadgets as You Can Find 32

Overwhelm the User with Tons of Detail 32

Pick the Wrong Tool for the Job 34

Four Ways to Improve Visual Analytics 35

Reduce the Nondata Pixels 35

Enhance the Data Pixels 36

Conclusion 38

Part 2: Power BI Guided Walk-Throughs

Chapter 3: Let's Take a Flyover! 41

Getting Connected 41

A Quick Tour of the Power BI Service 42

Frequented Hotspots of Power BI 42

Adding Sample Content 43

Understanding the Power BI Service Interface 44

Highlighting 47

Slicers 50

Filters 52

Drill-Down 54

Dashboards 55

Drill-Through 58

Visibility 59

Show as Table 59

Sorting Visuals 60

Filtering-- One More Time 61

Power BI Building Blocks 61

Flyover of Power BI Desktop 62

Navigating Power BI Desktop 63

Conclusion 65

Chapter 4: Building Your First Report 67

Connecting to a Data Source 67

Examining the Data Model 68

Exploring the Data 75

Building Your Report 85

Designing for Mobile Devices 101

Conclusion 102

Chapter 5: Preparing Data 103

GDP Data 103

Power Query Overview 105

Data Arrangement Steps 106

Rename Query 106

Remove Rows 106

Remove Columns 107

Applied Steps So Far 107

Promote Headers 108

Renaming Columns 108

Empty Values 109

Handling Aggregated Data 109

Filtering Rows 110

Unpivoting Data 110

Change Column Data Type 112

Changing Values in Columns 112

Duplicating Columns 113

Multiply by a Million 113

Removing Implicit Measures 114

Column Formatting 115

Calculated Columns 115

Add Previous Year Column 116

Hiding Columns 117

LOOKUPVALUE Function 118

DIVIDE Function 119

Visualize Our GDP Data 120

Where Are We? 121

Cleaning Messy Data 122

Handle Many-to-Many Relationships 123

Duplicate a Query 125

Split Column 125

Format Column 127

Remove Duplicates 127

Index Column 128

Merge Data 128

Applying Changes 129

Finding the Power Query Button 131

Simple Cleanup Tasks 131

Replacing Values 132

Custom Columns 133

More Cleanup 135

Cleaning Date Columns 136

Conclusion 138

Chapter 6: Modeling Data 139