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

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
	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
Chapter 3: 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
Chapter 4: 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
Chapter 5: Working in the Service
	Technical Requirements
	Building a Dashboard
	Preparing for Q&A
	Adding Alerts and Subscriptions
	Deploying Content from Excel and SSRS
	Streaming Datasets
	Authoring Dataflows
	Conclusion
Chapter 6: Getting Serious with Date Intelligence
	Technical Requirements
	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
	Conclusion
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
	Conclusion
Chapter 8: Implementing Dynamic User-Based Visibility in Power BI
	Technical Requirements
	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
	Conclusion
Chapter 9: 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
Chapter 10: 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
Chapter 11: 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
Chapter 12: 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
Chapter 13: 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
	Why subscribe?
Other Book You May Enjoy
Index