Premium
Title Page
12/31/2024
Copyright Page
12/31/2024
Dedication Page
12/31/2024
About the Author
12/31/2024
About the Reviewer
12/31/2024
Acknowledgement
12/31/2024
Preface
12/31/2024
Table of Contents
12/31/2024
1. Introduction to Data and Power BI
12/31/2024
Introduction
12/31/2024
Structure
12/31/2024
Objectives
12/31/2024
Introduction to business intelligence
12/31/2024
Data in organizations
12/31/2024
Historical overview
12/31/2024
Data complexity
12/31/2024
Impact on source systems
12/31/2024
Data quality
12/31/2024
Lack of a consistent 360-degree view
12/31/2024
Lack of historical data
12/31/2024
Data warehouse
12/31/2024
Introducing Power BI
12/31/2024
Power BI ideal sources
12/31/2024
Power BI use case
12/31/2024
Corporate reporting
12/31/2024
Ad-hoc analysis
12/31/2024
Other use cases
12/31/2024
Power BI Desktop and the Power BI service
12/31/2024
Power BI Desktop
12/31/2024
Power BI service
12/31/2024
Power BI licensing
12/31/2024
Free
12/31/2024
Power BI Pro
12/31/2024
Power BI Premium Per User
12/31/2024
Power BI Embedded
12/31/2024
Fabric capacity reservation
12/31/2024
Fabric capacity pay-as-you-go
12/31/2024
Conclusion
12/31/2024
Multiple choice questions
12/31/2024
Answer
12/31/2024
2. Dimensional Modeling
12/31/2024
Dimensional modeling
12/31/2024
Normalizing data
12/31/2024
Data Vault
12/31/2024
Steps to design a star schema
12/31/2024
Choose process
12/31/2024
Determine grain
12/31/2024
Northwind database example
12/31/2024
Defining facts
12/31/2024
Defining dimensions
12/31/2024
Designing a fact table
12/31/2024
Additive facts
12/31/2024
Non-additive facts
12/31/2024
Semi-additive facts
12/31/2024
Designing facts
12/31/2024
Design dimension tables
12/31/2024
Attribute design
12/31/2024
Snowflaking
12/31/2024
Slowly changing dimensions
12/31/2024
Date dimension
12/31/2024
Northwind example
12/31/2024
Answers
12/31/2024
3. The Basics of Power Query
12/31/2024
Get data
12/31/2024
Text or comma separated values
12/31/2024
Excel
12/31/2024
SQL Server
12/31/2024
Select columns
12/31/2024
De-duplicate rows and generate keys
12/31/2024
Merge tables
12/31/2024
Custom columns
12/31/2024
Data types
12/31/2024
Filtering rows
12/31/2024
Other transformations
12/31/2024
Challenge
12/31/2024
Close & Apply
12/31/2024
4. The Basics of Visualizations
12/31/2024
A tour of the interface
12/31/2024
Creating a bar chart
12/31/2024
Setting visualization properties
12/31/2024
Adding a slicer to the report
12/31/2024
Table visuals
12/31/2024
Adding filters to your report
12/31/2024
Pie chart
12/31/2024
Visual interactions
12/31/2024
Configuring report page
12/31/2024
Paginated reports
12/31/2024
5. Advanced Techniques of Power Query
12/31/2024
Analyzing the raw data
12/31/2024
Unpivot data
12/31/2024
Creating a custom function
12/31/2024
Reading multiple files from a folder
12/31/2024
Understanding M-code
12/31/2024
Understanding the date table code
12/31/2024
Using parameters
12/31/2024
Organizing queries
12/31/2024
Optimizing queries and query folding
12/31/2024
Exam tip
12/31/2024
6. Create Interactive Reports
12/31/2024
Pitfalls and considerations
12/31/2024
Pitfalls
12/31/2024
Important considerations
12/31/2024
Determine the message
12/31/2024
Determine the user
12/31/2024
Preferred visualization types
12/31/2024
Using tooltips
12/31/2024
Using hierarchies
12/31/2024
Using drill through
12/31/2024
Using bookmarks
12/31/2024
Sync slicers
12/31/2024
Hiding items on a report
12/31/2024
Using buttons
12/31/2024
Back, bookmark and page navigation
12/31/2024
Web URL
12/31/2024
Drill through
12/31/2024
Questions and answers
12/31/2024
Apply all slicers and clear all slicers
12/31/2024
Page navigator and bookmark navigator
12/31/2024
Shapes and images
12/31/2024
Using visual calculations
12/31/2024
Conditional formatting
12/31/2024
Other visuals
12/31/2024
Gauge, KPI
12/31/2024
Map and filled map
12/31/2024
Scatter chart
12/31/2024
Get more visuals
12/31/2024
Key influencers
12/31/2024
Decomposition tree
12/31/2024
Narrative
12/31/2024
Themes and templates
12/31/2024
7. The Basics of Semantic Models
12/31/2024
Active and inactive relationships
12/31/2024
Types of relationships
12/31/2024
Cross-filter direction
12/31/2024
Attribute properties
12/31/2024
Data type and default aggregation
12/31/2024
Formatting
12/31/2024
Hierarchies
12/31/2024
Hide columns
12/31/2024
Data categories
12/31/2024
Grouping and binning
12/31/2024
Display folder
12/31/2024
Sort by column
12/31/2024
Table properties
12/31/2024
Mark as date table
12/31/2024
Other table properties
12/31/2024
8. DAX
12/31/2024
Introduction to DAX
12/31/2024
Calculated columns
12/31/2024
Parent-child hierarchy
12/31/2024
Calculated measures
12/31/2024
Implicit vs. explicit measures
12/31/2024
% of parent
12/31/2024
Time intelligence functions
12/31/2024
Calculating growth
12/31/2024
Quick measures
12/31/2024
9. Advanced DAX Concepts
12/31/2024
Variables
12/31/2024
Creating a date dimension
12/31/2024
Calculation groups
12/31/2024
Calculate and context switches
12/31/2024
Moving average
12/31/2024
DAX queries and the valuate function
12/31/2024
10. Scalable Power BI Solutions
12/31/2024
Connectivity mode
12/31/2024
Import
12/31/2024
DirectQuery
12/31/2024
Live connection
12/31/2024
Direct Lake
12/31/2024
Composite models
12/31/2024
Table aggregations
12/31/2024
Incremental refresh and real-time data
12/31/2024
Fabric
12/31/2024
Best practices
12/31/2024
11. Security
12/31/2024
Row level security
12/31/2024
Publish a report to a workspace
12/31/2024
Object level security
12/31/2024
Sharing a report
12/31/2024
Manage report permissions
12/31/2024
Configure workspace access
12/31/2024
Sensitivity labels
12/31/2024
12. Working with the Power BI Service
12/31/2024
Configure semantic model connectivity and data refresh
12/31/2024
Creating a dashboard
12/31/2024
Working with reports in the Power BI service
12/31/2024
Configure workspace settings
12/31/2024
Power BI settings
12/31/2024
13. Create App
12/31/2024
Deployment pipeline
12/31/2024
Power BI projects
12/31/2024
Creating a Power BI app
12/31/2024
Working with apps
12/31/2024
Template apps
12/31/2024
14. Monitor Power BI and Fabric
12/31/2024
Monitoring report usage metrics
12/31/2024
View item or workspace lineage
12/31/2024
Admin monitoring workspace
12/31/2024
Microsoft Fabric Capacity Metrics app
12/31/2024
Power BI Desktop tools
12/31/2024