Book Image

Mastering Microsoft Power BI

By : Brett Powell

5 (1)

Book Image

Mastering Microsoft Power BI

5 (1)

By: Brett Powell

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.

Preface

Who this book is for

What this book covers

To get the most out of this book

Free Chapter

Planning Power BI Projects

Planning Power BI Projects

Power BI deployment modes

Project discovery and ingestion

Power BI project roles

Power BI licenses

Data warehouse bus matrix

Dataset design process

Dataset planning

Sample project analysis

Connecting to Sources and Transforming Data with M

Connecting to Sources and Transforming Data with M

Query design per dataset mode

M Query examples

M editing tools

Designing Import and DirectQuery Data Models

Designing Import and DirectQuery Data Models

Optimizing performance

Developing DAX Measures and Security Roles

Developing DAX Measures and Security Roles

Date intelligence metrics

Dimension metrics

Ranking metrics

Performance testing

Creating and Formatting Power BI Reports

Creating and Formatting Power BI Reports

Report planning

Live connections to Power BI datasets

Visualization best practices

Choosing the visual

Visual interactions

Report filter scopes

Visualization formatting

Mobile-optimized reports

Report design summary

Applying Custom Visuals, Animation, and Analytics

Applying Custom Visuals, Animation, and Analytics

Drillthrough report pages

ArcGIS Map visual for Power BI

Waterfall chart breakdown

Animation and data storytelling

Designing Power BI Dashboards and Architectures

Designing Power BI Dashboards and Architectures

Dashboards versus reports

Dashboard design

Multi-dashboard architectures

Dashboard tiles

Live report pages

Mobile-optimized dashboards

Managing Application Workspaces and Content

Managing Application Workspaces and Content

Application workspaces

Staged deployments

Dashboard data classifications

Version control

Metadata management

Managing the On-Premises Data Gateway

Managing the On-Premises Data Gateway

On-premises data gateway planning

Gateway clusters

Gateway architectures

Gateway security

Gateway configuration

Managing gateway clusters

Troubleshooting and monitoring gateways

Scheduled data refresh

DirectQuery datasets

Live connections to Analysis Services models

Dashboard cache refresh

Deploying the Power BI Report Server

Deploying the Power BI Report Server

Planning for the Power BI Report Server

Report Server Desktop Application

Report Server Web Portal

Power BI mobile applications

Report server administration

Scale Power BI Report Server

Creating Power BI Apps and Content Distribution

Creating Power BI Apps and Content Distribution

Content distribution methods

Self-Service BI workspace

Sharing dashboards and reports

SharePoint Online embedding

Custom application embedding

Email Subscriptions

Analyze in Excel

Administering Power BI for an Organization

Administering Power BI for an Organization

Data governance for Power BI

Azure Active Directory

Power BI Admin Portal

Usage metrics reports

Power BI Premium capacities

Scaling with Premium and Analysis Services

Scaling with Premium and Analysis Services

Power BI Premium

Power BI Premium capacity allocation

Premium capacity estimations

Analysis Services

Migration of Power BI Desktop to Analysis Services

Other Books You May Enjoy

Other Books You May Enjoy

Leave a review - let other readers know what you think

Customer Reviews

5 (1)

5 star

100%

4 star

0

3 star

0

2 star

0

1 star

0

Other Books You May Enjoy

If you enjoyed this book, you may be interested in these other books by Packt:

Microsoft Power BI Cookbook
Brett Powell

ISBN: 978-1-78829-014-2

Cleanse, stage, and integrate your data sources with Power BI
Abstract data complexities and provide users with intuitive, self-service BI capabilities
Build business logic and analysis into your solutions via the DAX programming language and dynamic, dashboard-ready calculations
Take advantage of the analytics and predictive capabilities of Power BI
Make your solutions more dynamic and user specific and/or defined including use cases of parameters, functions, and row level security
Understand the differences and implications of DirectQuery, Live Connections, and Import-Mode Power BI datasets and how to deploy content to the Power BI Service and schedule refreshes
Integrate other Microsoft data tools such as...