Microsoft Power BI Cookbook: Gain expertise in Power BI with over 90 hands-on recipes, tips, and use cases, 2nd Edition

Build effective analytical data models, reports, and dashboards using the advanced features of Power BI
Key Features

Updated with new recipes on 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 Description

Microsoft Power BI is a leading business intelligence and data analytics platform that provides tools and services for deriving insights from data. With revised practical recipes, Microsoft Power BI Cookbook, Second Edition helps you navigate Power BI tools and their advanced features. It also demonstrates the use of end-to-end solutions that integrate those features to get the most out of Power BI. This cookbook provides advanced design and development tips, and guidance on enhancing existing Power BI projects.

The updated edition enables you to implement evergreen frameworks that will stay relevant as Power BI updates. Get familiar with Power BI development tools and services by going deep into the data connectivity, transformation, modeling, visualization, and analytical capabilities of Power BI. Microsoft Power BI Cookbook, Second Edition enables Power BI’s functional programming languages of DAX and M to come alive to 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

This book is for BI professionals who wish to enhance their knowledge of Power BI and the value of the Power BI solutions they deliver to business users. Those who are looking at quick solutions to common problems while using Power BI will also find this book to be an extremely useful resource. Familiarity with Power BI and working with datasets is essential. This book is not for beginners.
Table of Contents

Configuring Power BI Tools
Accessing and Retrieving Data
Building a Power BI Data Model
Authoring Power BI Reports
Working in the Service
Getting Serious with Date Intelligence
Parameterizing Power BI Solutions
Implementing Dynamic User-Based Visibility in Power BI
Applying Advanced Analytics and Custom Visuals
Administering and Monitoring Power BI
Enhancing and Optimizing Existing Power BI Solutions
Deploying and Distributing Power BI Content
Integrating Power BI with Other Applications