Introduction |
|
xi | |
Organization of this book |
|
xi | |
Preparing for the exam |
|
xi | |
Microsoft certifications |
|
xii | |
Quick access to online references |
|
xii | |
Errata, updates, & book support |
|
xiii | |
Stay in touch |
|
xiii | |
|
Chapter 1 Prepare the data |
|
|
1 | (52) |
|
Skill 1.1 Get data from different data sources |
|
|
1 | (1) |
|
Identify and connect to a data source |
|
|
2 | (4) |
|
Change data source settings |
|
|
6 | (1) |
|
Select a shared dataset or create a local dataset |
|
|
7 | (2) |
|
|
9 | (3) |
|
|
12 | (1) |
|
Change the value in a parameter |
|
|
13 | (4) |
|
|
17 | (1) |
|
Skill 1.2 Clean, transform, and load the data |
|
|
18 | (1) |
|
|
19 | (4) |
|
Resolve inconsistencies, unexpected or null values, and data quality issues |
|
|
23 | (3) |
|
Identify and create appropriate keys for joins |
|
|
26 | (2) |
|
Evaluate and transform column data types |
|
|
28 | (2) |
|
Shape and transform tables |
|
|
30 | (11) |
|
|
41 | (4) |
|
Apply user-friendly naming conventions to columns and queries |
|
|
45 | (1) |
|
|
46 | (1) |
|
Resolve data import errors |
|
|
47 | (1) |
|
|
48 | (1) |
|
|
49 | (2) |
|
Thought experiment answers |
|
|
51 | (2) |
|
|
53 | (58) |
|
Skill 2.1 Design a data model |
|
|
53 | (1) |
|
Define the tables and design a data model that uses a star schema |
|
|
54 | (2) |
|
Configure table and column properties |
|
|
56 | (2) |
|
Design and implement role-playing dimensions |
|
|
58 | (3) |
|
Define a relationship's cardinality and cross-filter direction |
|
|
61 | (5) |
|
Create a common date table |
|
|
66 | (2) |
|
Skill 2.2 Develop a data model |
|
|
68 | (1) |
|
|
68 | (2) |
|
|
70 | (1) |
|
Create calculated columns |
|
|
71 | (2) |
|
Implement row-level security roles |
|
|
73 | (6) |
|
|
79 | (4) |
|
Skill 2.3 Create model calculations by using DAX |
|
|
83 | (1) |
|
Create basic measures by using DAX |
|
|
83 | (3) |
|
Use CALCULATE to manipulate filters |
|
|
86 | (5) |
|
Implement Time Intelligence using DAX |
|
|
91 | (2) |
|
Replace implicit measures with explicit measures |
|
|
93 | (1) |
|
Use basic statistical functions |
|
|
94 | (1) |
|
Create semi-additive measures |
|
|
95 | (2) |
|
|
97 | (3) |
|
Skill 2.4 Optimize model performance |
|
|
100 | (1) |
|
Remove unnecessary rows and columns |
|
|
100 | (1) |
|
Identify poorly performing measures, relationships, and visuals |
|
|
101 | (1) |
|
Reduce cardinality levels to improve performance |
|
|
102 | (2) |
|
|
104 | (1) |
|
|
105 | (3) |
|
Thought experiment answers |
|
|
108 | (3) |
|
Chapter 3 Visualize and analyze the data |
|
|
111 | (66) |
|
|
111 | (1) |
|
Add visualization items to reports |
|
|
112 | (1) |
|
Choose an appropriate visualization type |
|
|
113 | (11) |
|
Format and configure visualizations |
|
|
124 | (1) |
|
|
125 | (1) |
|
Apply and customize a theme |
|
|
126 | (2) |
|
Configure conditional formatting |
|
|
128 | (2) |
|
Apply slicing and filtering |
|
|
130 | (3) |
|
Configure the report page |
|
|
133 | (1) |
|
Use the Analyze in Excel feature |
|
|
134 | (1) |
|
Choose when to use a paginated report |
|
|
135 | (1) |
|
Skill 3.2 Create dashboards |
|
|
135 | (1) |
|
Manage tiles on a dashboard |
|
|
136 | (2) |
|
|
138 | (1) |
|
|
139 | (1) |
|
Add a Quick Insights result to a dashboard |
|
|
140 | (2) |
|
|
142 | (1) |
|
Pin a live report page to a dashboard |
|
|
143 | (1) |
|
Skill 3.3 Enhance reports for usability and storytelling |
|
|
144 | (1) |
|
|
144 | (3) |
|
|
147 | (2) |
|
Edit and configure interactions between visuals |
|
|
149 | (1) |
|
Configure navigation for a report |
|
|
150 | (1) |
|
|
151 | (1) |
|
|
152 | (2) |
|
Group and layer visuals by using the Selection pane |
|
|
154 | (1) |
|
Drill down into data using interactive visuals |
|
|
155 | (1) |
|
|
156 | (1) |
|
Design reports for mobile devices |
|
|
156 | (1) |
|
Skill 3.4 Identify patterns and trends |
|
|
157 | (1) |
|
Use the Analyze feature in Power BI |
|
|
158 | (1) |
|
|
159 | (1) |
|
Choose between continuous and categorical axes |
|
|
160 | (1) |
|
Use groupings, binnings, and clustering |
|
|
161 | (3) |
|
|
164 | (4) |
|
|
168 | (1) |
|
Create reference lines by using the Analytics pane |
|
|
168 | (2) |
|
|
170 | (2) |
|
|
172 | (2) |
|
Thought experiment answers |
|
|
174 | (3) |
|
Chapter 4 Deploy and maintain assets |
|
|
177 | (26) |
|
Skill 4.1 Manage files and datasets |
|
|
177 | (1) |
|
Identify when a gateway is required |
|
|
178 | (1) |
|
Configure a dataset scheduled refresh |
|
|
178 | (2) |
|
Configure row-level security group membership |
|
|
180 | (2) |
|
Provide access to datasets |
|
|
182 | (3) |
|
Manage global options for files |
|
|
185 | (1) |
|
Skill 4.2 Manage workspaces |
|
|
186 | (1) |
|
Create and configure a workspace |
|
|
186 | (2) |
|
|
188 | (1) |
|
Configure and update a workspace app |
|
|
189 | (4) |
|
Publish, import, or update assets in a workspace |
|
|
193 | (2) |
|
Apply sensitivity labels to workspace content |
|
|
195 | (1) |
|
Configure subscriptions and data alerts |
|
|
196 | (2) |
|
Promote or certify Power Bl content |
|
|
198 | (1) |
|
|
199 | (1) |
|
|
200 | (1) |
|
Thought experiment answers |
|
|
201 | |
Index |
|
203 | |