1CHAPTER 1
146Consolidating Tables with Append
2INTRO TO POWER BI
147Considerations for Consolidating Tables with Append
3What Is Power BI?
148Using Merge to Get Columns from Other Tables
4Power BI Components
149Building Relationships
5Power BI Desktop: Its components
150Autodetect during load
6The Power BI Service
151Create a relationship with Autodetect
7The Power Platform
152Create a relationship manually
8How Did We Get to Power BI?
153Edit a relationship
9SQL Server: Microsoft’s Relational Database
154Editing relationships using different methods
10SQL Server Analysis Services Multidimensional: One Small Step into BI
155Important
11SQL Server Reporting Services: Pixel-Perfect Reporting, Automated Reports, and More
156Configure more options
12Excel: A Self-Service BI Tool
157Cardinality
13Power Pivot
158Cross filter direction
14Important New Functionality That Leads to Power BI
159Make this relationship active
15Power BI Desktop is born
160Understanding additional options
16Power BI Desktop under the Hood
161Automatic relationship updates: Identifying Our Relationship Columns
17VertiPaq: The Storage Engine
162Time to Get Building
18DAX: The Formula Engine
163Let’s Get Reporting
19What Makes Power BI Different from Its Competitors?
164We Need a Name...
20Conclusion
165Cards Help Identify Important Data Points
21CHAPTER 2
166Bars, Columns, and Lines
22THE REPORT AND DATA VIEWS
167Conclusion
23Use the ribbon in Power BI Desktop
168CHAPTER 7
24Report View: Home Section of the Ribbon
169ADVANCED REPORTING TOPICS IN POWER BI
25The Clipboard Subsection
170AI-Powered Visuals
26The Data Subsection
171Key Influencers
27The Queries Subsection
172Using the Key Influencers Visual in Power BI
28The Insert Subsection
173Let’s work with an example.
29The Calculation Subsection
174Decomposition Tree
30Report View: The Insert Tab
175Key Benefits of the Decomposition Tree
31The Pages Subsection
176Using the Decomposition Tree Visual in Power BI
32The Visuals Subsection
177Q&A
33The AI Visuals Subsection
178Smart Narrative
34The Power Platform Subsection
179What-If Analysis
35The Elements Subsection
180Benefits of What-If Analysis in Power BI
36Report View: The Modeling Tab
181Techniques for What-If Analysis in Power BI
37The Relationships Subsection
182Best Practices for What-If Analysis in Power BI
38The Calculations Subsection
183Parameter Setup
39The Page Refresh Subsection
184DAX Integration of the Parameter
40The Security Subsection
185Parameter Modification
41The Q&A Subsection
186R and Python Integration: Benefits of R and Python Integration
42Report View: The View Tab
187Practical Applications
43The Themes Subsection
188Limitations of Using R and Python
44The Scale to Fit Subsection
189Enabling R and Python for Power BI
45The Page Options Subsection
190R and Python in Power Query
46The Show Panes Subsection
191R and Python Visuals
47Report View: Help Section
192Conclusion
48Report View: External Tools Section
193CHAPTER 8
49The Pane Interface of the Report View
194INTRODUCTION TO THE POWER BI SERVICE
50Visualizations Pane
195The Basics of the Service: What You Need to Know
51Fields and Filters Panes
196The Navigation Menu
52A Quick Rundown of the Other Panes
197Home and Browse
53Data View
198Create
54Conclusion
199Data Hub
55CHAPTER 3
200Settings
56IMPORTING AND MODELING OUR DATA
201Metrics
57Getting Our Data
202Apps
58Importing the Data
203Deployment Pipelines
59The Power Query Ribbon: The Home Tab
204Learn
60Transform Tab
205Publishing Your Work
61The Add Column Tab
206What Is a Workspace?
62The Model-View
207My Workspace
63What Is a Relationship?
208Shared Capacity Workspaces
64Types of Relationships in Power BI
209Dataflows in Shared Workspaces
65Creating and Managing Relationships in Power BI
210Putting Your Data in Front of Others
66Benefits and Applications of Relationships in Power BI
211Adding Users to a Workspace
67The Properties Pane
212Sharing via a Link or Teams
68Conclusion
213Sharing via a Link
69CHAPTER 4
214Sharing via Teams
70LET’S MAKE SOME PICTURES (VISUALIZING DATA 101)
215Sharing via SharePoint
71Why Visualize Data?
216Creating an App
72The Visualizations pane
217Conclusion
73Fields
218CHAPTER 9
74Format
219LICENSING AND DEPLOYMENT TIPS
75Analytics
220Licensing
76Visual Interactivity
221Power BI service licenses
77Enable the visual interaction controls
222Free per-user license
78Change the interaction behavior
223Pro license
79Column and Bar Charts
224Premium per user (PPU) license
80Stacked Bar and Column Charts
225Premium capacity
81Clustered Bar and Column Charts
226Workspace and App Management: Workspace Generation and Access Control
82100% Stacked Bar and Column Charts: Small Multiples
227Managing Users in a Workspace
83Waterfall Chart
228Remove a user or change their role in a workspace.
84Benefits of Using Waterfall Charts in Power BI
229Adding Users to Roles for RLS Implementation
85Creating a Waterfall Chart in Power BI
230The Golden Dataset(s)
86Line and area charts.
231On-Premises vs. Cloud Deployment for Power BI
87Line Chart
232On-Premises Deployment
88Creating a Line Chart
233Cloud Deployment
89Area Chart
234Scaling Power BI Deployments for Enterprise Use
90Stacked Area Chart
235Best Practices for Power BI Deployment
91Line and Stacked Column Chart/Clustered Column Chart
236Troubleshooting Licensing Issues in Power BI
92Ribbon Chart
237Common Licensing Issues
93Donuts, dots, and maps.
238Troubleshooting Licensing Issues
94Funnel Chart
239Tips for Optimizing Power BI License Costs
95Scatter Chart
240Conclusion
96Pie and Donut Chart
241CHAPTER 10
97Treemap
242THIRD-PARTY TOOLS
98Map Visuals
243Get to Know Business Ops
99The “Flat Visuals”
244Add External Tools, Remove External Tools, and Modify Display Order
100Gauge
245Learning, Theme Generation, Visual Generation
101Card/Multi-Row Card
246Additional DAX Resources
102KPI
247DAX Studio
103Table/Matrix
248What can you do with DAX Studio in Power BI?
104Slicer
249Download, Install, and Setup DAX Studio Power BI
105Conclusion
250DAX Studio UI Basics
106CHAPTER 5
251Metadata Panel
107AGGREGATIONS, MEASURES, AND DAX
252The Ribbon
108A Primer on the DAX Language
253Query Pane
109Measures
254Output Pane
110Calculated Columns
255How to Write Queries in DAX Studio?
111Calculated Tables
256Tabular Editor
112Types of Functions
257Creating Roles
113Aggregations, More than Some Sums
258Table and Measure Management
114Sum
259The ALM Toolkit for Power BI
115Average
260Bravo
116Minimum and Maximum
261Analyze Model
117Standard Deviation, Variance, and Median
262DAX Formatting
118Standard Deviation
263Manage Dates
119Variance
264Export Data
120Median
265Understanding Bravo's Data Export Options
121Count and Count (Distinct)
266Preparing Data in Bravo
122First, Last, Earliest, and Latest
267Exporting Data from Bravo
123Measures and DAX Fundamentals
268Conclusion
124Implicit and Explicit Measures
269Commonly Used DAX Expressions: Aggregation Functions
125Implicit Measures
270Date and Time Functions
126Characteristics of Implicit Measures in Power BI
271Time Intelligence Functions
127Applications of Implicit Measures in Power BI
272Filter Functions
128Explicit Measures
273Logical Functions
129Characteristics of Explicit Measures in Power BI
274DAX Operators
130Applications of Explicit Measures in Power BI
275Some Favorite Custom Visuals
131DAX Syntax Fundamentals
276SandDance
132CALCULATE: Examples of CALCULATE Function Usage
277Smart Filter Pro
133We Heard You like DAX, So We Put Some DAX in Your DAX
278Chiclet Slicer
134Nested DAX Functions
279Timeline Storyteller
135Examples of Nested DAX Expressions
280Synoptic Panel
136Row and Filter Context
281Word Cloud
137Row Context
282Card with States
138Filter Context
283Radar Chart
139Interaction between Row and Filter Context
284Hexbin Scatterplot
140One Final DAX Example
285Hierarchy Slicer
141Conclusion
286Gantt chart by MAQ Software
142CHAPTER 6
287Bullet chart
143PUTTING THE PUZZLE PIECES TOGETHER: FROM RAW DATA TO REPORT
288Sunburst Chart
144Your First Data Import
289Conclusion
145Choose and Transform the Data When You Import
290INDEX