Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Microsoft Power BI Cookbook
  • Table Of Contents Toc
Microsoft Power BI Cookbook

Microsoft Power BI Cookbook - Third Edition

By : Greg Deckler, Brett Powell
4.7 (23)
Buy this Book
close
close
Microsoft Power BI Cookbook

Microsoft Power BI Cookbook

4.7 (23)
By: Greg Deckler, Brett Powell
Buy this Book

Overview of this book

Since its first edition the Power BI Cookbook has been a best-selling resource for BI developers and data analysts to produce impactful, quality BI solutions. This new and updated edition retains the rigorous details and concepts readers of prior editions have enjoyed while also demonstrating powerful new capabilities and updated guidance aligned to the current state of the platform. In this book, with step-by-step instructions, you will learn to navigate the complexities of data integration and visualization in Power BI. From creating robust data models to implementing sophisticated reporting techniques, this Power BI book empowers you to make informed decisions based on actionable insights. It also introduces you to new capabilities such as Hybrid tables and scorecards, enhancing your ability to communicate and analyze business performance. It also expands and improvises on the core of the previous edition like parameterizing Power BI solutions, authoring reports, data intelligence, and integrating advanced analytics. This edition highlights the latest features and upcoming AI enhancements in Power BI. *Email sign-up and proof of purchase required
Table of Contents (17 chapters)
close
close
close
Preface
Icon
Preface
Lock Free Chapter
1
Installing and Licensing Power BI Tools
chevron up
Icon
Installing and Licensing Power BI Tools
Icon
Free Benefits with Your Book
Icon
Technical Requirements
Icon
Installing and Configuring Power BI Desktop
Icon
Installing SQL Server and the AdventureWorks Database
Icon
Installing and Using Power BI Report Builder
Icon
Creating an On-Premises Data Gateway
Icon
Installing Additional Tools
Icon
Thinking about Licensing
Icon
Summary
2
Accessing, Retrieving, and Transforming Data
Icon
Accessing, Retrieving, and Transforming Data
Icon
Technical Requirements
Icon
Importing Data
Icon
Using DirectQuery
Icon
Creating Dataflows
Icon
Applying Filters
Icon
Transforming and Cleansing Data
Icon
Creating Custom Columns
Icon
Combining and Merging Queries
Icon
Profiling Source Data
Icon
Diagnosing Queries
Icon
Extending the Core M Library
Icon
Summary
3
Building a Power BI Semantic Model
Icon
Building a Power BI Semantic Model
Icon
Technical Requirements
Icon
Designing a Semantic Model
Icon
Implementing a Semantic Model
Icon
Creating Relationships
Icon
Configuring Model Metadata
Icon
Enriching a Model with DAX Measures
Icon
Creating Hierarchies and Groups
Icon
Supporting Virtual Table Relationships
Icon
Designing Column-Level Security
Icon
Leveraging Aggregation Tables
Icon
Utilizing Hybrid Tables
Icon
Summary
4
Authoring Power BI Reports
Icon
Authoring Power BI Reports
Icon
Technical Requirements
Icon
Building Rich and Intuitive Reports
Icon
Filtering at Different Scopes
Icon
Integrating Card Visualizations
Icon
Using Slicers
Icon
Controlling Visual Interactions
Icon
Utilizing Graphical Visualizations
Icon
Creating Table and Matrix Visuals
Icon
Enhancing Reports
Icon
Formatting Reports for Publication
Icon
Designing Mobile Layouts
Icon
Creating Paginated Reports
Icon
How to create paginated reports
Icon
Summary
5
Working in the Power BI Service
Icon
Working in the Power BI Service
Icon
Technical Requirements
Icon
Building a Dashboard
Icon
Preparing for Q&A
Icon
Adding Alerts and Subscriptions
Icon
Streaming Semantic Models
Icon
Authoring Dataflows
Icon
Creating Scorecards
Icon
Summary
6
Getting Serious About Date Intelligence
Icon
Getting Serious About Date Intelligence
Icon
Technical Requirements
Icon
Preparing the Date Dimension via the Query Editor
Icon
Authoring Date Intelligence Measures
Icon
Developing Advanced Date Intelligence Measures
Icon
Simplifying Date Intelligence with DAX and Calculated Tables
Icon
Leveraging Calculation Groups
Icon
Summary
7
Parameterizing Power BI Solutions
Icon
Parameterizing Power BI Solutions
Icon
Technical Requirements
Icon
Filtering Reports Dynamically
Icon
Leveraging Query Parameters
Icon
Working with Templates
Icon
Converting Static Queries to Dynamic Functions
Icon
Capturing User Selections with Parameter Tables
Icon
Forecasting with What-If Analysis
Icon
Summary
8
Implementing Dynamic User-Based Visibility in Power BI
Icon
Implementing Dynamic User-Based Visibility in Power BI
Icon
Technical Requirements
Icon
Defining RLS Roles and Filter Expressions
Icon
Designing Dynamic Security Models
Icon
Building Dynamic Security for DirectQuery
Icon
Displaying the Current Filter Context
Icon
Avoiding Manual User Clicks
Icon
Summary
9
Applying Advanced Analytics and Custom Visuals
Icon
Applying Advanced Analytics and Custom Visuals
Icon
Technical Requirements
Icon
Incorporating Advanced Analytics
Icon
Enriching Content with Custom Visuals and Quick Insights
Icon
Creating Geospatial Mapping with ArcGIS Maps
Icon
Democratizing Artificial Intelligence
Icon
Building Animation and Storytelling
Icon
Embedding Statistical Analyses
Icon
Grouping and Binning
Icon
Detecting and Analyzing Clusters
Icon
Forecasting and Anomaly Detection
Icon
Using R and Python Visuals
Icon
Leveraging the WINDOW Function
Icon
Summary
10
Enhancing and Optimizing Existing Power BI Solutions
Icon
Enhancing and Optimizing Existing Power BI Solutions
Icon
Technical Requirements
Icon
Extending and Enhancing Semantic Models
Icon
Improving DAX Measure Performance
Icon
Pushing Query Processing Back to Source Systems
Icon
Strengthening Data Import and Integration Processes
Icon
Isolating and Documenting DAX Expressions
Icon
Improving Data Load Speeds with Incremental Refresh
Icon
Summary
11
Deploying and Distributing Power BI Content
Icon
Deploying and Distributing Power BI Content
Icon
Technical Requirements
Icon
Preparing for Content Creation and Collaboration
Icon
Deploying Content between Environments
Icon
Sharing Content with Colleagues
Icon
Creating and Configuring Workspaces
Icon
Configuring On-Premises Gateway Data Connections
Icon
Publishing Apps
Icon
Distributing Content with Teams
Icon
Summary
12
Integrating Power BI with Other Applications
Icon
Integrating Power BI with Other Applications
Icon
Technical Requirements
Icon
Migrating from Power Pivot for Excel to Power BI
Icon
Accessing and Analyzing Power BI Semantic Models in Excel
Icon
Building Power BI Reports into PowerPoint Presentations
Icon
Integrating with Power Automate and Power Apps
Icon
Leveraging Dataverse and Dynamics 365
Icon
Connecting Dynamics 365 and Power Platform
Icon
Summary
13
Working with Premium and Microsoft Fabric
Icon
Working with Premium and Microsoft Fabric
Icon
Technical Requirements
Icon
Creating a Data Warehouse
Icon
Engineering Data with a Lakehouse
Icon
Backing Up Semantic Models
Icon
Leveraging Direct Lake
Icon
Applying Data Science
Icon
Summary
14
Unlock Your Exclusive Benefits
Icon
Unlock Your Exclusive Benefits
15
Other Books You May Enjoy
Icon
Other Books You May Enjoy
16
Index
Icon
Index

Installing and Licensing Power BI Tools

Microsoft Power BI is a suite of business analytics tools and services that work together to access data sources, shape, analyze and visualize data, and share insights. Although not all the tools are required for every project or deployment of Power BI, synergies are available by utilizing the distinct features and use cases of multiple tools as part of integrated solutions, encompassing diverse data sources, rich data analytics, and visualization types.

In this chapter, we walk through the installation and configuration of the primary tools and services that business intelligence (BI) professionals utilize to design and develop Power BI content. This includes official Microsoft tools such as Power BI Desktop, Power BI Report Builder, SQL Server, the on-premises data gateway, and various third-party tools such as DAX Studio, ALM Toolkit, and Tabular Editor.

The recipes in this chapter are as follows:

  • Installing and configuring Power BI Desktop
  • Installing SQL Server and the AdventureWorks database
  • Installing and using Power BI Report Builder
  • Creating an on-premises data gateway
  • Installing additional tools
  • Thinking about licensing
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Microsoft Power BI Cookbook
End of Section 1
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist download Download options
font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon