Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Mastering Microsoft Power BI
  • Table Of Contents Toc
  • Feedback & Rating feedback
Mastering Microsoft Power BI

Mastering Microsoft Power BI

By : Powell
3.2 (21)
Buy this Book
close
close
Mastering Microsoft Power BI

Mastering Microsoft Power BI

3.2 (21)
By: Powell
Buy this Book

Overview of this book

This book is intended for business intelligence professionals responsible for the design and development of Power BI content as well as managers, architects and administrators who oversee Power BI projects and deployments. The chapters flow from the planning of a Power BI project through the development and distribution of content to the administration of Power BI for an organization. BI developers will learn how to create sustainable and impactful Power BI datasets, reports, and dashboards. This includes connecting to data sources, shaping and enhancing source data, and developing an analytical data model. Additionally, top report and dashboard design practices are described using features such as Bookmarks and the Power KPI visual. BI managers will learn how Power BI’s tools work together such as with the On-premises data gateway and how content can be staged and securely distributed via Apps. Additionally, both the Power BI Report Server and Power BI Premium are reviewed. By the end of this book, you will be confident in creating effective charts, tables, reports or dashboards for any kind of data using the tools and techniques in Microsoft Power BI.
Table of Contents (15 chapters)
close
close
close
Preface
Icon
Preface
Icon
Who this book is for
Icon
What this book covers
Icon
To get the most out of this book
Icon
Get in touch
Free Chapter
1
Planning Power BI Projects
Icon
Planning Power BI Projects
Icon
Power BI deployment modes
Icon
Project discovery and ingestion
Icon
Power BI project roles
Icon
Power BI licenses
Icon
Data warehouse bus matrix
Icon
Dataset design process
Icon
Data profiling
Icon
Dataset planning
Icon
Sample project analysis
Icon
Summary
2
Connecting to Sources and Transforming Data with M
Icon
Connecting to Sources and Transforming Data with M
Icon
Query design per dataset mode
Icon
Data sources
Icon
SQL views
Icon
M queries
Icon
Query folding
Icon
M Query examples
Icon
M editing tools
Icon
Summary
3
Designing Import and DirectQuery Data Models
Icon
Designing Import and DirectQuery Data Models
Icon
Dataset layers
Icon
The Data Model
Icon
Relationships
Icon
Model metadata
Icon
Optimizing performance
Icon
Summary
4
Developing DAX Measures and Security Roles
Icon
Developing DAX Measures and Security Roles
Icon
DAX measures
Icon
Base measures
Icon
Date intelligence metrics
Icon
Dimension metrics
Icon
Ranking metrics
Icon
Security roles
Icon
Performance testing
Icon
Summary
5
Creating and Formatting Power BI Reports
Icon
Creating and Formatting Power BI Reports
Icon
Report planning
Icon
Live connections to Power BI datasets
Icon
Visualization best practices
Icon
Choosing the visual
Icon
Visual interactions
Icon
Slicers
Icon
Report filter scopes
Icon
Visualization formatting
Icon
Map visuals
Icon
Mobile-optimized reports
Icon
Report design summary
Icon
Summary
6
Applying Custom Visuals, Animation, and Analytics
Icon
Applying Custom Visuals, Animation, and Analytics
Icon
Drillthrough report pages
Icon
Bookmarks
Icon
ArcGIS Map visual for Power BI
Icon
Waterfall chart breakdown
Icon
Analytics pane
Icon
Quick Insights
Icon
Custom visuals
Icon
Animation and data storytelling
Icon
Summary
7
Designing Power BI Dashboards and Architectures
Icon
Designing Power BI Dashboards and Architectures
Icon
Dashboards versus reports
Icon
Dashboard design
Icon
Multi-dashboard architectures
Icon
Dashboard tiles
Icon
Live report pages
Icon
Mobile-optimized dashboards
Icon
Summary
8
Managing Application Workspaces and Content
Icon
Managing Application Workspaces and Content
Icon
Application workspaces
Icon
Staged deployments
Icon
Dashboard data classifications
Icon
Version control
Icon
Metadata management
Icon
Summary
9
Managing the On-Premises Data Gateway
Icon
Managing the On-Premises Data Gateway
Icon
On-premises data gateway planning
Icon
Gateway clusters
Icon
Gateway architectures
Icon
Gateway security
Icon
Gateway configuration
Icon
Managing gateway clusters
Icon
Troubleshooting and monitoring gateways
Icon
Scheduled data refresh
Icon
DirectQuery datasets
Icon
Live connections to Analysis Services models
Icon
Dashboard cache refresh
Icon
Summary
10
Deploying the Power BI Report Server
Icon
Deploying the Power BI Report Server
Icon
Planning for the Power BI Report Server
Icon
Installation
Icon
Configuration
Icon
Upgrade cycles
Icon
Report Server Desktop Application
Icon
Report Server Web Portal
Icon
Power BI mobile applications
Icon
Report server administration
Icon
Scale Power BI Report Server
Icon
Summary
11
Creating Power BI Apps and Content Distribution
Icon
Creating Power BI Apps and Content Distribution
Icon
Content distribution methods
Icon
Power BI apps
Icon
Self-Service BI workspace
Icon
Sharing dashboards and reports
Icon
SharePoint Online embedding
Icon
Custom application embedding
Icon
Publish to web
Icon
Data alerts
Icon
Email Subscriptions
Icon
Analyze in Excel
Icon
Summary
12
Administering Power BI for an Organization
chevron up
Icon
Administering Power BI for an Organization
Icon
Data governance for Power BI
Icon
Azure Active Directory
Icon
Power BI Admin Portal
Icon
Usage metrics reports
Icon
Audit logs
Icon
Power BI Premium capacities
Icon
Summary
13
Scaling with Premium and Analysis Services
Icon
Scaling with Premium and Analysis Services
Icon
Power BI Premium
Icon
Power BI Premium capacity allocation
Icon
Premium capacity estimations
Icon
Analysis Services
Icon
Migration of Power BI Desktop to Analysis Services
Icon
Summary
14
Other Books You May Enjoy
Icon
Other Books You May Enjoy
Icon
Leave a review - let other readers know what you think

Power BI Premium capacities

One of the most important responsibilities of a Power BI administrator is the management of Power BI Premium capacities. Power BI Premium is fully described in the following chapter but, from a Power BI service administration perspective, Power BI Premium can be thought of as an organization's dedicated hardware resources to support the use of the Power BI service. Not all of an organization's content needs to be hosted in premium capacity. However, these resources enable the distribution of content to read-only Power BI Free users and they provide more consistent performance, among other scalability and management benefits.

Power BI Premium SKUs (such as P1 and P2) are available on the Purchase services page of the Office 365 admin center. Given that Power BI Premium can also be used to deploy the Power BI Report Server, an example of a premium...

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech
Start a 7-day FREE trial
End of Section 7
Next Section

Create a Note

Modal Close icon
You need to login to use this feature.
notes
bookmark search playlist download
font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Delete Note

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY