Beginning Power BI for Business Users: Learning to Turn Data into Insights [Team-IRA]

✍ Scribed by Paul D. Fuller

• Publisher: Wiley
• Year: 2023
• Tongue: English
• Leaves: 290
• Edition: 1
• Category: Library

✦ Synopsis

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.

✦ Table of Contents

Cover Page
Title Page
Copyright Page
About the Author
About the Technical Editor
Acknowledgments
Contents
Introduction
What Does This Book Cover?
Who Should Read This Book
Companion Download Files
Part 1 Introduction
Chapter 1 Introducing Power BI
What Is Power BI?
Why Would I Use Power BI?
But Why?
Disconnected Data
Fixed Formulas
Will I Still Use Excel?
How Much Is this Going to Cost?
Where Do We Go from Here?
Chapter 2 From Data to Insight
Three Guiding Principles
Distinguishing Data, Information, and Knowledge
Follow a Consistent, Proven Method
Data Sources
Import Data
Prepare Data
Model Data
Report Data
Analyze Data
Use Visualizations Well
Three Ways to Ruin Visual Analytics
Four Ways to Improve Visual Analytics
Conclusion
Part 2 Power BI Guided Walk-Throughs
Chapter 3 Let’s Take a Flyover!
Getting Connected
A Quick Tour of the Power BI Service
Frequented Hotspots of Power BI
Adding Sample Content
Understanding the Power BI Service Interface
Highlighting
Slicers
Filters
Drill-Down
Dashboards
Drill-Through
Visibility
Show as Table
Sorting Visuals
Filtering—One More Time
Power BI Building Blocks
Flyover of Power BI Desktop
Conclusion
Chapter 4 Building Your First Report
Connecting to a Data Source
Examining the Data Model
Exploring the Data
Building Your Report
Designing for Mobile Devices
Conclusion
Chapter 5 Preparing Data
GDP Data
Power Query Overview
Data Arrangement Steps
Calculated Columns
Cleaning Messy Data
Conclusion
Chapter 6 Modeling Data
Dimensional Modeling
Why Does This Matter?
Facts
Types of Facts
Granularity
Dimensions
Using Integer Keys for Relationships
Hierarchies in Dimensions
Date Dimensions
Power Query and Data Modeling
How to Build a Date Dimension
How to Arrange into a Star-Schema
Putting It All into Action
Conclusion
Part 3 Going Deeper into Power BI
Chapter 7 Relationships and Filtering
Filtering Through Relationships
Visuals Interact Independently
The Direction of Relationships
Bidirectional Filtering
Report Filter Types
Visual Filters
Conclusion
Chapter 8 Enhancing Your Report
Configuring Drill-Down
Configuring Drill-Through
Buttons
Bookmarks
Personal Bookmarks vs. Report Bookmarks
Selections and Visibility
Conclusion
Chapter 9 Refreshing, Sharing, and Collaborating
Refreshing Data
Configuring Data Source Credentials
Power BI Data Gateway
Scheduling Refresh
Dataset Modes
Sharing and Collaborating
Workspaces
Power BI Apps
Sharing
Summary
Chapter 10 Introducing DAX
Setup
Calculated Columns
How to Create a Calculated Column
DAX Measures
COUNTROWS and DISTINCTCOUNT
Filter Context
CALCULATE Function
Conclusion
Chapter 11 Conclusion
Where Does My Organization Begin?
Delivery Strategy
Which Delivery Strategy Is Right for My Organization?
Where Do I Go from Here?
Top Gurus
Advice
Index
EULA