Microsoft Power BI Dashboards Step by Step

✍ Scribed by Errin O'Connor

• Publisher: Microsoft Press
• Year: 2018
• Tongue: English
• Leaves: 305
• Edition: 1
• Category: Library

✦ Synopsis

Your hands-on guide to building effective Power BI dashboards

Expand your expertise–and teach yourself how to create world-class Power BI business analysis dashboards that bring data to life for better decision-making. If you’re an experienced business intelligence professional or manager, you’ll get all the guidance, examples, and code you need to succeed–even if you’ve never used Power BI before.

• Successfully design, architect, and implement Power BI in your organization
• Take full advantage of any Microsoft Power BI platform, including Power BI Premium
• Make upfront decisions that position your Power BI project for success
• Build rich, live dashboards to monitor crucial data from across your organization
• Aggregate data and data elements from numerous internal and external data sources
• Develop dynamic visualizations, including charts, maps, and graphs
• Bring data to life with stunning interactive reports
• Ensure dashboard security and compliance
• Drive user adoption through effective training

✦ Table of Contents

Cover
Title Page
Copyright Page
Dedication
Contents
Acknowledgments
About the author
i: Introduction
Who this book is for
The Step by Step approach
Features and conventions
Download the practice files
Ebook edition
Get support and give feedback
1 Introduction to Power BI
Sidebar: Practice files
An introduction to Power BI
Sidebar: Real-world scenario
Sidebar: Using Power BI effectively to streamline organizational growth
Sidebar: A word on datasets
Power BI features
Power BI platforms
Power BI licensing models
Set up Power BI
Prepare a dashboard in Power BI service
General note for Power BI security
Skills review
Practice tasks
2 Power BI architecture and administration
Power BI architecture
The Power BI Admin Portal
Power BI data models and report development
Sidebar: Relationship view
Skills review
Practice tasks
3 Visuals in Power BI
Overview of visuals in Power BI
Power BI visuals out of the box
Third-party visuals in Power BI
Sidebar: Other ways to import third-party visuals into Power BI
Sidebar: More options
Drill through Power BI visuals
Apply filters in Power BI reports
Sidebar: Slicers
Skills review
Practice tasks
4 Power BI report development
Sidebar: Practice files
Data sources supported by Power BI
Build a Power BI report in Power BI Desktop
Sidebar: Relationship view
Publish your report to Power BI service
Skills review
Practice tasks
5 Use DAX in Power BI
Calculated columns and measures
Sidebar: DAX capabilities
DAX expressions syntax and context
DAX functions
Skills review
Practice tasks
6 Develop Power BI reports from Excel
Sidebar: Practice files
Import data from an Excel workbook into Power BI
Add a measure and a calculated column
Add Power BI visuals to the report
Arrange the visuals
Prepare the report for mobile view
Publish and view the report
Prepare a dashboard from the report
Skills review
Practice tasks
7 Develop Power BI reports from SharePoint Online
Sidebar: Practice files
Build a Power BI report based on data from a SharePoint Online list
Build a Power BI report based on data from a SharePoint Online folder
Refresh report data in a Power BI report
Embed Power BI reports in SharePoint Online
Skills review
Practice tasks
8 Develop Power BI reports from SharePoint On-Premises
Sidebar: Practice files
Import data from a SharePoint On-Premises list into Power BI
Create a Power BI report
Set up a data gateway
Configure Power BI to use the data gateway and set up refresh functionality
Skills review
Practice tasks
9 Develop Power BI reports from SQL
Sidebar: Practice files
Import data from a SQL Server database into Power BI
Create a Power BI report
Set up a data gateway
Configure Row-Level Security (RLS) in Power BI
Sidebar: Limitations of RLS in Power BI
Skills review
Practice tasks
10 Develop Power BI reports from SSAS cube
Sidebar: Practice files
Basic terminology
Import data from an SSAS cube into Power BI
Create a Power BI report
Set up and configure a data gateway
Skills review
Practice tasks
11 Develop Power BI reports from Azure SQL
Sidebar: Practice files
Overview of the Azure SQL portal
Import data from an Azure SQL database into Power BI
Create a Power BI report
Set up a live data connection and data refresh functionality
Skills review
Practice tasks
12 Develop Power BI reports from Oracle
Sidebar: Practice files
Import data from an Oracle database into Power BI
Create a Power BI report
Set up and configure a data gateway
Skills review
Practice tasks
13 Develop Power BI reports from Dynamics 365
Sidebar: Practice files
Import data from Dynamics 365 into Power BI Desktop
Sidebar: URL syntax
Create a Power BI report
Import data from Dynamics 365 into Power BI service
Embed a Power BI dashboard into a Dynamics 365 dashboard
Set up data refresh functionality
Skills review
Practice tasks
Index
A
B
C
D
E
F
G
H
I
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y