Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
Title Page
Copyright and Credits
Microsoft Power BI Quick Start Guide
Packt Upsell
Why subscribe?
PacktPub.com
Foreword
Contributors
About the authors
About the reviewer
Packt is searching for authors like you
Preface
Who this book is for
What this book covers
To get the most out of this book
Download the example code files
Download the color images
Conventions used
Get in touch
Reviews
Getting Started with Importing Data Options
Getting started
Importing data
Excel as a source
SQL Server as a source
Web as a source
DirectQuery
Limitations
Live Connection
Limitations
Which should I choose?
Summary
Data Transformation Strategies
The Power Query Editor
Transform basics
Use First Row as Headers
Remove Columns
Change type
Add Column From Examples
Advanced data transformation options
Conditional Columns
Fill Down
Unpivot
Merging Queries
Appending Queries
Leveraging R
Installation and configuration
The R Script transform
M formula language
#shared
Summary
Building the Data Model
Building relationships
Editing relationships
Creating a new relationship 
Working with complex relationships
Many-to-many relationships
Cross-filtering direction
Enabling filtering from the many side of a relationship
Role-playing tables
Importing the date table
Usability enhancements
Hiding tables and columns
Renaming tables and columns
Default summarization
How to display one column but sort by another
Data categorization
Creating hierarchies
Summary
Leveraging DAX
Building calculated columns
String functions – Month, Year
Format function – Month Year
Age calculation
SWITCH() – age breakdown
Navigation functions – RELATED
Calculated measures – the basics
Calculated measure – basic aggregations
Total Sales
Total Cost
Profit
Profit Margin
Optional parameters
Filter context
Calculate
Percentage of total calculation
Time intelligence
Year to Date Sales
YTD Sales (Fiscal Calendar)
Prior Year Sales 
Summary
Visualizing Data
Data visualization basics
Visuals for filtering
Interactive filtering
The Slicer visual
Visualizing tabular data
The table visual
The Matrix visual
Visualizing categorical data
Bar and Column charts
Pie and Donut charts
The Treemap visual
The Scatter chart
Visualizing trend data
Line and Area charts
Combo charts
The Ribbon Chart
The Waterfall Chart
The Funnel Chart
Visualizing KPI data
The Gauge visual
The KPI visual
Visualizing geographical data
The Map visual
The Filled Map visual
The Shape Map visual
The ArcGIS Map visual
Leveraging Power BI custom visuals
Data visualization tips and tricks
Edit interactions
The Analytics pane
The Top N filter
Show value as
Summary
Digital Storytelling with Power BI
Configuring drillthrough filters
Storytelling with the Selection pane and bookmarks
Bookmarks pane
Selection pane
Summary
Using a Cloud Deployment with the Power BI Service
Deploying to the Power BI service
DATASETS
WORKBOOKS
Creating and interacting with dashboards
Creating your first dashboard
Asking your dashboard a question
Subscribing to reports and dashboards
Sharing your dashboards
Workspaces
Setting up row-level security
Scheduling data refreshes
Summary
On-Premises Solutions with Power BI Report Server
Deploying to Power BI Report Server
Securing reports
Scheduling data refreshes
Summary
Other Books You May Enjoy
Leave a review - let other readers know what you think
← Prev
Back
Next →
← Prev
Back
Next →