Microsoft Power BI cookbook : gain expertise in Power BI with over 90 hands-on recipes, tips, and use cases / Greg Deckler, Brett Powell.

Format:

Book

Author/Creator:

Deckler, Greg, author.

Powell, Brett, author.

Language:

English

Subjects (All):

Business intelligence--Computer programs.

Business intelligence.

Business--Data processing.

Business.

Physical Description:

1 online resource (655 pages)

Edition:

2.

Place of Publication:

2021.

Birmingham : Packt Publishing, [2021]

Summary:

Publisher's note: This edition from 2021 is outdated and does not cover the most recent Power BI updates. A new third edition, updated to the latest release is now available in color Purchase of the print or Kindle book includes a free eBook in the PDF format. Key Features Update your knowledge with new recipes for query optimization, aggregation tables, Power BI API, and paginated reports Work with recipes across diverse Power BI platforms including the Power BI Service and Mobile Applications Implement custom solutions with M and DAX languages through actionable guidance and proven development techniques Book DescriptionThe complete everyday reference guide to Power BI, written by an internationally recognized Power BI expert duo, is back with a new and updated edition. Packed with revised practical recipes, Microsoft Power BI Cookbook, Second Edition, helps you navigate Power BI tools and advanced features. It also demonstrates the use of end-to-end solutions that integrate those features to get the most out of Power BI. With the help of the recipes in this book, you'll gain advanced design and development insight, practical tips, and guidance on enhancing existing Power BI projects. The updated recipes will equip you with everything you need to know to implement evergreen frameworks that will stay relevant as Power BI updates. You'll familiarize yourself with Power BI development tools and services by going deep into the data connectivity, transformation, modeling, visualization, and analytical capabilities of Power BI. By the end of this book, you'll make the most of Power BI's functional programming languages of DAX and M and deliver powerful solutions to common business intelligence challenges.What you will learn Cleanse, stage, and integrate your data sources with Power Query (M) Remove 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 dashboard-ready calculations Implement aggregation tables to accelerate query performance over large data sources Create and integrate paginated reports Understand the differences and implications of DirectQuery, live connections, Import, and Composite model datasets Integrate other Microsoft data tools into your Power BI solution Who this book is for If you're a BI professional who wants to up their knowledge of Power BI and offer more value to their organization, then this book is for you. Those looking for quick solutions to common Power BI problems will also find this book an extremely useful resource. Please be aware that this is not a beginner's guide; you'll need a solid understanding of Power BI and experience working with datasets before you dive in. ]]>

Contents:

Cover

Copyright

Contributors

Table of Contents

Preface

Chapter 1: Configuring Power BI Tools

Technical Requirements

Installing and Configuring Power BI Desktop

Creating an On-Premises Data Gateway

Installing Analyze in Excel from the Power BI Service

Installing and Configuring Additional Tools

Conclusion

Chapter 2: Accessing and Retrieving Data

Viewing and Analyzing M Functions

Managing Queries and Data Sources

Using DirectQuery

Importing Data

Applying Multiple Filters

Selecting and Renaming Columns

Transforming and Cleansing Data

Creating Custom Columns

Combining and Merging Queries

Selecting Column Data Types

Visualizing the M library

Profiling Source Data

Diagnosing Queries

Chapter 3: Building a Power BI Data Model

Designing a Data Model

Implementing a Data Model

Creating Relationships

Configuring Model Metadata

Hiding Columns and Tables

Enriching a Model with DAX

Supporting Virtual Table Relationships

Creating Hierarchies and Groups

Designing Column Level Security

Leveraging Aggregation Tables

Chapter 4: Authoring Power BI Reports

Building Rich and Intuitive Reports

Filtering at Different Scopes

Integrating Card visualizations

Using Slicers

Controlling Visual Interactions

Utilizing Graphical Visualizations

Creating Table and Matrix visuals

Enhancing Reports

Formatting Reports for Publication

Designing Mobile Layouts

Creating Paginated Reports

Chapter 5: Working in the Service

Building a Dashboard

Preparing for Q&amp

A

Adding Alerts and Subscriptions

Deploying Content from Excel and SSRS

Streaming Datasets

Authoring Dataflows.

Conclusion

Chapter 6: Getting Serious with Date Intelligence

Building a Date Dimension Table

Preparing the Date Dimension via the Query Editor

Authoring Date Intelligence Measures

Developing Advanced Date Intelligence Measures

Simplifying Date Intelligence with DAX and Calculated Tables

Leveraging Calculation Groups

Chapter 7: Parameterizing Power BI Solutions

Technical requirements

Filtering reports dynamically

Leveraging query parameters

Working with templates

Converting static queries to dynamic functions

Capturing user selections with parameter tables

Forecasting with what-if analysis

Chapter 8: Implementing Dynamic User-Based Visibility in Power BI

Capturing Current User Context

Defining RLS Roles and Filter Expressions

Designing Dynamic Security Models

Building Dynamic Security for DirectQuery

Displaying the Current Filter Context

Avoiding Manual User Clicks

Chapter 9: Applying Advanced Analytics and Custom Visuals

Incorporating Advanced Analytics

Enriching Content with Custom Visuals and Quick Insights

Creating Geospatial Mapping with ArcGIS Maps

Democratizing Artificial Intelligence

Building Animation and Storytelling

Embedding Statistical Analyses

Grouping and Binning

Detecting and Analyzing Clusters

Forecasting and Anomaly Detection

Using R and Python Visuals

Chapter 10: Administering and Monitoring Power BI

Creating a centralized IT monitoring solution with Power BI

Constructing a monitoring, visualization, and analysis layer

Importing and visualizing dynamic management view (DMV) data

Increasing DBA productivity

Providing documentation.

Analyzing SSAS tabular databases and gateways

Analyzing Extended Events

Visualizing log file data

Leveraging the Power BI PowerShell Module

Chapter 11: Enhancing and Optimizing Existing Power BI Solutions

Enhancing Data Model Scalability and Usability

Improving DAX Measure Performance

Pushing Query Processing Back to Source Systems

Strengthening Data Import and Integration Processes

Isolating and Documenting DAX Expressions

Improving Data Load Speeds with Incremental Refresh

Chapter 12: Deploying and Distributing Power BI Content

Preparing for Content Creation and Collaboration

Managing Content between Environments

Sharing Content with Colleagues

Configuring Workspaces

Configuring On-Premises Gateway Data Connections

Publishing Apps

Publishing Reports to the Public Internet

Enabling the Mobile Experience

Distributing Content with Teams

Chapter 13: Integrating Power BI with Other Applications

Integrating SSRS and Excel

Migrating from Power Pivot for Excel Data to Power BI

Accessing and Analyzing Power BI Datasets in Excel

Building Power BI Reports into PowerPoint Presentations

Connecting to Azure Analysis Services

Integrating with Power Automate and Power Apps

Leveraging Dataverse and Dynamics 365

Connecting Dynamics 365 Finance and Operations and the Power Platform

Why subscribe?

Other Book You May Enjoy

Index.

Notes:

Description based on print version record.

Description based on publisher supplied metadata and other sources.

ISBN:

9781801813044

1801813043

OCLC:

1273974620