Linked e-resources
Details
Table of Contents
Intro
Table of Contents
About the Author
About the Technical Reviewer
Introduction
Chapter 1: Power BI First Report
Business Scenario
Power BI Software Licensing
Build Your First Power BI Report
Data and Requirements
Install Power BI Desktop
Report Building
Add a Text Box
Add Slicers
Add a Pie Chart
Add a Matrix Table
Add a Line Chart
Clean up the Report
Conclusion
Chapter 2: Power BI Core Components
Build a Report with Power Query
Business Scenario
Data Processing Automation
Create a New Query
Combine Power Query Tables
Add a New Column
Seamless Data Integration
Add a New Report Page
Power Query Summary
Building a Report with a Data Model
Why a Data Model?
Minimize Data Redundancy
Facilitate Data Reuse
Filter Across Multiple Fact Tables
Implement the Data Model
Create a Basic Data Model
Reduce Data Redundancy
Customized Calendar Table
Use Common Filter Table on Multiple Fact Tables
Data Model Summary
DAX: Data Analysis Expression
Create a Basic Measure in DAX
Filter Context in DAX
Row Context in DAX
Create a Calendar Table Using DAX
The Calculate Function in DAX
Ignore the Filter Context
Add a Filter Context
Update the Filter Context
Date Intelligence with CALCULATE
Variables in DAX
Organize DAX Measures
DAX Summary
Conclusion
Chapter 3: Power BI Service
Publishing and Sharing Reports
Business Scenario
Sharing Risks
My Workspace
Sharing Links
Share with Others in Your Organization
A Better Way of Sharing
Local Power BI Support
Get Power BI Pro License
Determine Sharing Method
Publish into Non-Personal Workspace
Sharing via Direct Access
User Access Approval and Review Processes
Report-Sharing Summary
Automation
Data Connection
Export Flat Files in a Shared Folder
Data Transformation
Scheduling with Power BI Gateways
Power BI Gateway
Conclusion
Mini-Hackathon
Hackathon Data
Objectives
Time Limit
Chapter 4: Data Visualization
Chart Selection
Pie and Donut Charts
Column and Bar Charts
Line Charts
Table vs. Matrix Visuals
Scatter Charts
Sunburst Diagrams
Summary
Data Explanation vs. Exploration
Data Exploration
Export Underlying Data
Setting 1: Power BI Desktop Options
Setting 2: Power BI Service Options
Data Explanation
Summary
Report Design
Business Scenario
Structure the Reports
Report Navigation
Power BI Dashboard
Design Template for Exploration Reports
Color Selection
The 60-30-10 Color Rule
Color Association
RAG Colors
Color Blindness
Conclusion
Mini-Hackathon
Hackathon Data
Objectives
Time Limit
Chapter 5: Power BI Governance
Why Governance?
A Business Scenario
Adoption-Driven Governance Framework
Usage Data
Workspace Usage Report
Table of Contents
About the Author
About the Technical Reviewer
Introduction
Chapter 1: Power BI First Report
Business Scenario
Power BI Software Licensing
Build Your First Power BI Report
Data and Requirements
Install Power BI Desktop
Report Building
Add a Text Box
Add Slicers
Add a Pie Chart
Add a Matrix Table
Add a Line Chart
Clean up the Report
Conclusion
Chapter 2: Power BI Core Components
Build a Report with Power Query
Business Scenario
Data Processing Automation
Create a New Query
Combine Power Query Tables
Add a New Column
Seamless Data Integration
Add a New Report Page
Power Query Summary
Building a Report with a Data Model
Why a Data Model?
Minimize Data Redundancy
Facilitate Data Reuse
Filter Across Multiple Fact Tables
Implement the Data Model
Create a Basic Data Model
Reduce Data Redundancy
Customized Calendar Table
Use Common Filter Table on Multiple Fact Tables
Data Model Summary
DAX: Data Analysis Expression
Create a Basic Measure in DAX
Filter Context in DAX
Row Context in DAX
Create a Calendar Table Using DAX
The Calculate Function in DAX
Ignore the Filter Context
Add a Filter Context
Update the Filter Context
Date Intelligence with CALCULATE
Variables in DAX
Organize DAX Measures
DAX Summary
Conclusion
Chapter 3: Power BI Service
Publishing and Sharing Reports
Business Scenario
Sharing Risks
My Workspace
Sharing Links
Share with Others in Your Organization
A Better Way of Sharing
Local Power BI Support
Get Power BI Pro License
Determine Sharing Method
Publish into Non-Personal Workspace
Sharing via Direct Access
User Access Approval and Review Processes
Report-Sharing Summary
Automation
Data Connection
Export Flat Files in a Shared Folder
Data Transformation
Scheduling with Power BI Gateways
Power BI Gateway
Conclusion
Mini-Hackathon
Hackathon Data
Objectives
Time Limit
Chapter 4: Data Visualization
Chart Selection
Pie and Donut Charts
Column and Bar Charts
Line Charts
Table vs. Matrix Visuals
Scatter Charts
Sunburst Diagrams
Summary
Data Explanation vs. Exploration
Data Exploration
Export Underlying Data
Setting 1: Power BI Desktop Options
Setting 2: Power BI Service Options
Data Explanation
Summary
Report Design
Business Scenario
Structure the Reports
Report Navigation
Power BI Dashboard
Design Template for Exploration Reports
Color Selection
The 60-30-10 Color Rule
Color Association
RAG Colors
Color Blindness
Conclusion
Mini-Hackathon
Hackathon Data
Objectives
Time Limit
Chapter 5: Power BI Governance
Why Governance?
A Business Scenario
Adoption-Driven Governance Framework
Usage Data
Workspace Usage Report