Book description
Build effective analytical data models, reports, and dashboards using the advanced features of Power BI.
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 Description
The 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.
Table of contents
- Preface
- Configuring Power BI Tools
-
Accessing and Retrieving Data
- Technical Requirements
- 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
- Conclusion
-
Building a Power BI Data Model
- Technical Requirements
- 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
- Conclusion
-
Authoring Power BI Reports
- Technical Requirements
- 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
- Conclusion
- 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
- Technical Requirements
- 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
- Conclusion
-
Administering and Monitoring Power BI
- Technical requirements
- 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
- Conclusion
-
Enhancing and Optimizing Existing Power BI Solutions
- Technical Requirements
- 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
- Conclusion
-
Deploying and Distributing Power BI Content
- Technical Requirements
- 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
- Conclusion
-
Integrating Power BI with Other Applications
- Technical Requirements
- 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
- Conclusion
- Other Book You May Enjoy
- Index
Product information
- Title: Microsoft Power BI Cookbook - Second Edition
- Author(s):
- Release date: September 2021
- Publisher(s): Packt Publishing
- ISBN: 9781801813044
You might also like
book
Microsoft Power BI Cookbook
Get more out of Microsoft Power BI turning your data into actionable insights About This Book …
book
Microsoft Power BI Quick Start Guide - Second Edition
An accessible fast paced introduction to all aspects of Power BI for new or aspiring BI …
book
Microsoft Power BI Quick Start Guide - Third Edition
Bring your data to life with this accessible yet fast-paced introduction to Power BI, now in …
book
Microsoft Power Apps Cookbook - Second Edition
Practical recipes and real-world examples to help you create custom solutions and automate processes. Use Power …