Preface |
|
xi | |
|
|
1 | (12) |
|
|
2 | (4) |
|
|
2 | (2) |
|
|
4 | (1) |
|
|
4 | (1) |
|
|
5 | (1) |
|
How Did We Get to Power BI? |
|
|
6 | (3) |
|
SQL Server: Microsoft's Relational Database |
|
|
7 | (1) |
|
SQL Server Analysis Services Multidimensional: One Small Step into BI |
|
|
7 | (1) |
|
SQL Server Reporting Services: Pixel-Perfect Reporting, Automated Reports, and More |
|
|
7 | (1) |
|
Excel: A Self-Service BI Tool |
|
|
7 | (1) |
|
|
8 | (1) |
|
Important New Functionality That Leads to Power BI |
|
|
8 | (1) |
|
|
8 | (1) |
|
Power BI Desktop Under the Hood |
|
|
9 | (1) |
|
VertiPaq: The Storage Engine |
|
|
9 | (1) |
|
|
10 | (1) |
|
What Makes Power BI Different from Its Competitors? |
|
|
10 | (2) |
|
|
12 | (1) |
|
2 The Report and Data Views |
|
|
13 | (30) |
|
Report View: Home Section of the Ribbon |
|
|
14 | (11) |
|
|
15 | (1) |
|
|
15 | (6) |
|
|
21 | (1) |
|
|
22 | (2) |
|
The Calculations Subsection |
|
|
24 | (1) |
|
The Final Subsections: Sensitivity and Share |
|
|
24 | (1) |
|
Report View: The Insert Tab |
|
|
25 | (3) |
|
|
25 | (1) |
|
|
25 | (1) |
|
The AI Visuals Subsection |
|
|
25 | (1) |
|
The Power Platform Subsection |
|
|
26 | (1) |
|
|
26 | (2) |
|
Report View: The Modeling Tab |
|
|
28 | (3) |
|
The Relationships Subsection |
|
|
28 | (1) |
|
The Calculations Subsection |
|
|
29 | (1) |
|
The Page Refresh Subsection |
|
|
29 | (1) |
|
|
29 | (1) |
|
|
29 | (1) |
|
|
30 | (1) |
|
Report View: The View Tab |
|
|
31 | (1) |
|
|
31 | (1) |
|
The Scale to Fit Subsection |
|
|
31 | (1) |
|
The Page Options Subsection |
|
|
31 | (1) |
|
The Show Panes Subsection |
|
|
32 | (1) |
|
Report View: Help Section |
|
|
32 | (1) |
|
Report View: External Tools Section |
|
|
33 | (1) |
|
The Pane Interface of the Report View |
|
|
33 | (5) |
|
|
34 | (1) |
|
|
35 | (2) |
|
A Quick Rundown of the Other Panes |
|
|
37 | (1) |
|
|
38 | (3) |
|
|
41 | (2) |
|
3 Importing and Modeling Our Data |
|
|
43 | (26) |
|
|
43 | (4) |
|
|
47 | (10) |
|
|
47 | (5) |
|
|
52 | (3) |
|
|
55 | (2) |
|
|
57 | (10) |
|
|
58 | (7) |
|
|
65 | (2) |
|
|
67 | (2) |
|
4 Let's Make Some Pictures (Visualizing Data 101) |
|
|
69 | (32) |
|
|
69 | (2) |
|
|
71 | (3) |
|
|
73 | (1) |
|
|
73 | (1) |
|
|
73 | (1) |
|
|
74 | (2) |
|
|
76 | (7) |
|
Stacked Bar and Column Charts |
|
|
77 | (2) |
|
Clustered Bar and Column Charts |
|
|
79 | (1) |
|
100% Stacked Bar and Column Charts |
|
|
80 | (2) |
|
|
82 | (1) |
|
|
82 | (1) |
|
|
83 | (4) |
|
|
83 | (1) |
|
|
84 | (1) |
|
|
85 | (1) |
|
Line and Stacked Column Chart/Clustered Column Chart |
|
|
86 | (1) |
|
|
87 | (1) |
|
Donuts, Dots, and Maps, Oh My! |
|
|
87 | (6) |
|
|
88 | (1) |
|
|
89 | (1) |
|
|
90 | (1) |
|
|
91 | (1) |
|
|
92 | (1) |
|
|
93 | (6) |
|
|
93 | (1) |
|
|
94 | (1) |
|
|
95 | (1) |
|
|
96 | (2) |
|
|
98 | (1) |
|
|
99 | (2) |
|
5 Aggregations, Measures, and DAX |
|
|
101 | (26) |
|
A Primer on the DAX Language |
|
|
101 | (3) |
|
|
102 | (1) |
|
|
102 | (1) |
|
|
103 | (1) |
|
|
103 | (1) |
|
Aggregations, More Than Some Sums |
|
|
104 | (10) |
|
|
104 | (2) |
|
|
106 | (2) |
|
|
108 | (2) |
|
Standard Deviation, Variance, and Median |
|
|
110 | (1) |
|
Count and Count (Distinct) |
|
|
111 | (2) |
|
First, Last, Earliest, and Latest |
|
|
113 | (1) |
|
Measures and DAX Fundamentals |
|
|
114 | (12) |
|
Implicit and Explicit Measures |
|
|
114 | (2) |
|
|
116 | (1) |
|
|
117 | (3) |
|
We Heard You Like DAX, So We Put Some DAX in Your DAX |
|
|
120 | (2) |
|
|
122 | (2) |
|
|
124 | (2) |
|
|
126 | (1) |
|
6 Putting the Puzzle Pieces Together: From Raw Data to Report |
|
|
127 | (34) |
|
|
127 | (5) |
|
Choose and Transform the Data When You Import |
|
|
128 | (1) |
|
Transformations in Power Query |
|
|
129 | (3) |
|
Second Data Import and Wrangling |
|
|
132 | (12) |
|
Consolidating Tables with Append |
|
|
134 | (4) |
|
Using Merge to Get Columns from Other Tables |
|
|
138 | (6) |
|
|
144 | (5) |
|
|
145 | (1) |
|
Identifying Our Relationship Columns |
|
|
146 | (1) |
|
|
147 | (2) |
|
|
149 | (12) |
|
|
150 | (1) |
|
Cards Help Identify Important Data Points |
|
|
150 | (6) |
|
|
156 | (4) |
|
|
160 | (1) |
|
7 Advanced Reporting Topics in Power BI |
|
|
161 | (20) |
|
|
161 | (12) |
|
|
162 | (3) |
|
|
165 | (2) |
|
|
167 | (5) |
|
|
172 | (1) |
|
|
173 | (4) |
|
|
173 | (1) |
|
DAX Integration of the Parameter |
|
|
174 | (2) |
|
|
176 | (1) |
|
|
177 | (3) |
|
Limitations of Using R and Python |
|
|
177 | (1) |
|
Enabling R and Python for Power BI |
|
|
178 | (1) |
|
R and Python in Power Query |
|
|
178 | (1) |
|
|
179 | (1) |
|
|
180 | (1) |
|
8 Introduction to the Power BI Service |
|
|
181 | (28) |
|
The Basics of the Service: What You Need to Know |
|
|
181 | (1) |
|
|
182 | (14) |
|
|
184 | (1) |
|
|
185 | (2) |
|
|
187 | (3) |
|
|
190 | (3) |
|
|
193 | (1) |
|
|
193 | (2) |
|
|
195 | (1) |
|
|
195 | (1) |
|
|
196 | (2) |
|
|
198 | (4) |
|
|
198 | (1) |
|
Shared Capacity Workspaces |
|
|
198 | (3) |
|
Dataflows in Shared Workspaces |
|
|
201 | (1) |
|
Putting Your Data in Front of Others |
|
|
202 | (5) |
|
Adding Users to a Workspace |
|
|
202 | (1) |
|
Sharing via a Link or Teams |
|
|
203 | (2) |
|
|
205 | (1) |
|
|
205 | (2) |
|
|
207 | (2) |
|
9 Licensing and Deployment Tips |
|
|
209 | (22) |
|
|
209 | (6) |
|
|
210 | (1) |
|
Premium Per User Licensing |
|
|
211 | (1) |
|
Premium Per Capacity, the Big Boy |
|
|
212 | (3) |
|
Workspace and App Management |
|
|
215 | (14) |
|
Workspace Generation and Access Control |
|
|
216 | (4) |
|
Managing Users in a Workspace |
|
|
220 | (2) |
|
Adding Users to Roles for RLS Implementation |
|
|
222 | (1) |
|
App Creation and Management |
|
|
223 | (5) |
|
|
228 | (1) |
|
|
229 | (2) |
|
|
231 | (28) |
|
|
232 | (9) |
|
Add External Tools, Remove External Tools, and Modify Display Order |
|
|
233 | (2) |
|
Learning, Theme Generation, Visual Generation |
|
|
235 | (4) |
|
|
239 | (2) |
|
|
241 | (4) |
|
|
245 | (6) |
|
|
248 | (1) |
|
Table and Measure Management |
|
|
249 | (2) |
|
The ALM Toolkit for Power BI |
|
|
251 | (3) |
|
|
254 | (4) |
|
|
255 | (1) |
|
|
256 | (1) |
|
|
256 | (1) |
|
|
257 | (1) |
|
|
258 | (1) |
A Commonly Used DAX Expressions |
|
259 | (12) |
B Some Favorite Custom Visuals |
|
271 | (10) |
Index |
|
281 | |