Acknowledgements |
|
xiii | |
Introduction |
|
xvii | |
Organization of this book |
|
xvii | |
Microsoft certifications |
|
xviii | |
Microsoft Virtual Academy |
|
xviii | |
Quick access to online references |
|
xviii | |
Errata, updates, & book support |
|
xix | |
Stay in touch |
|
xix | |
Important: How to use this book to study for the exam |
|
xxi | |
|
Chapter 1 Consuming and transforming data by using Power Bl Desktop |
|
|
1 | (82) |
|
Skill 1.1 Connect to data sources |
|
|
1 | (30) |
|
Connect to databases, files, and folders |
|
|
2 | (2) |
|
|
4 | (1) |
|
|
5 | (1) |
|
|
5 | (1) |
|
Implications of using DirectQuery |
|
|
6 | (2) |
|
|
8 | (1) |
|
|
9 | (1) |
|
Connecting to Microsoft SQL Server |
|
|
10 | (2) |
|
Connecting to Access database |
|
|
12 | (1) |
|
Connecting to an Oracle database |
|
|
13 | (2) |
|
Connecting to a MySQL database |
|
|
15 | (1) |
|
Connecting to PostgreSQL database |
|
|
15 | (2) |
|
Connecting to data using generic interfaces |
|
|
17 | (1) |
|
Connecting to Text/CSV files |
|
|
17 | (1) |
|
|
18 | (1) |
|
|
19 | (1) |
|
|
20 | (2) |
|
Connecting to a SharePoint folder |
|
|
22 | (1) |
|
Connecting to web pages and files |
|
|
22 | (2) |
|
Connecting to Azure Data Lake Store and Azure Blob Storage |
|
|
24 | (1) |
|
|
25 | (1) |
|
|
25 | (1) |
|
Import Excel workbook contents |
|
|
26 | (1) |
|
Connect to SQL Azure, Big Data, SQL Server Analysis Services (SSAS) |
|
|
27 | (1) |
|
Connecting to Azure SQL Database and Azure SQL Data Warehouse |
|
|
27 | (1) |
|
Connecting to Azure HDInsight Spark |
|
|
28 | (1) |
|
Connecting to SQL Server Analysis Services (SSAS) |
|
|
28 | (1) |
|
Connecting to Power BI service |
|
|
29 | (2) |
|
Skill 1.2 Perform transformations |
|
|
31 | (43) |
|
Design and implement basic and advanced transformations |
|
|
32 | (1) |
|
|
32 | (3) |
|
Using the Power Query Editor interface |
|
|
35 | (9) |
|
|
44 | (8) |
|
|
52 | (3) |
|
|
55 | (1) |
|
|
56 | (4) |
|
Creating new columns in tables |
|
|
60 | (3) |
|
|
63 | (1) |
|
Change data format to support visualization |
|
|
64 | (10) |
|
|
74 | (9) |
|
|
74 | (1) |
|
Meet data quality requirements |
|
|
75 | (2) |
|
|
77 | (2) |
|
Thought experiment answers |
|
|
79 | (1) |
|
|
79 | (4) |
|
Chapter 2 Modeling and visualizing data |
|
|
83 | (188) |
|
Skill 2.1 Create and optimize data models |
|
|
83 | (24) |
|
|
84 | (11) |
|
Optimize models for reporting |
|
|
95 | (7) |
|
|
102 | (2) |
|
|
104 | (3) |
|
Skill 2.2 Create calculated columns, calculated tables, and measures |
|
|
107 | (99) |
|
Create DAX formulas for calculated columns |
|
|
107 | (27) |
|
|
134 | (39) |
|
|
173 | (32) |
|
|
205 | (1) |
|
Skill 2.3 Measure performance by using KPIs, gauges, and cards |
|
|
206 | (11) |
|
|
207 | (1) |
|
|
208 | (5) |
|
Calculate actual to target |
|
|
213 | (1) |
|
Configure values for gauges |
|
|
214 | (2) |
|
Use the format settings to manually set values |
|
|
216 | (1) |
|
Skill 2.4 Create hierarchies |
|
|
217 | (8) |
|
|
217 | (2) |
|
Create hierarchies based on business needs |
|
|
219 | (2) |
|
Add columns to tables to support desired hierarchy |
|
|
221 | (4) |
|
Skill 2.5 Create and format interactive visualizations |
|
|
225 | (30) |
|
Select a visualization type |
|
|
225 | (13) |
|
Configure page layout and formatting |
|
|
238 | (1) |
|
Configure interactions between visuals |
|
|
239 | (3) |
|
Configure duplicate pages |
|
|
242 | (1) |
|
Handle categories that have no data |
|
|
242 | (1) |
|
Configure default summarization and data category of columns |
|
|
242 | (3) |
|
Position, align, and sort visuals |
|
|
245 | (2) |
|
Enable and integrate R visuals |
|
|
247 | (2) |
|
|
249 | (1) |
|
Use bookmarks and themes for reports |
|
|
250 | (5) |
|
Skill 2.6 Manage custom reporting solutions |
|
|
255 | (16) |
|
Configure and access Microsoft Power BI Embedded |
|
|
256 | (1) |
|
Enable developers to create and edit reports through custom applications |
|
|
257 | (1) |
|
Enable developers to embed reports in applications |
|
|
257 | (2) |
|
Use the Power BI API to push data into a Power BI dataset |
|
|
259 | (2) |
|
Enable developers to create custom visuals |
|
|
261 | (1) |
|
|
262 | (4) |
|
Thought experiment answers |
|
|
266 | (1) |
|
|
267 | (4) |
|
Chapter 3 Configure dashboards, reports, and apps in the Power BI Service |
|
|
271 | (62) |
|
Skill 3.1 Access on-premises data |
|
|
271 | (8) |
|
Connect to a data source by using a data gateway |
|
|
272 | (5) |
|
Publish reports to the Power BI service from Power BI Desktop |
|
|
277 | (1) |
|
Edit Power BI service reports by using Power BI Desktop |
|
|
277 | (2) |
|
Skill 3.2 Configure a dashboard |
|
|
279 | (12) |
|
|
279 | (3) |
|
|
282 | (1) |
|
|
283 | (1) |
|
Customize the URL and title |
|
|
283 | (1) |
|
Enable natural language queries |
|
|
284 | (7) |
|
Skill 3.3 Publish and embed reports |
|
|
291 | (11) |
|
|
291 | (3) |
|
Publish to Microsoft SharePoint |
|
|
294 | (2) |
|
Publish reports to a Power BI Report Server |
|
|
296 | (6) |
|
Skill 3.4 Configure security for dashboards, reports, and apps |
|
|
302 | (18) |
|
Create a security group by using the Admin Portal |
|
|
302 | (3) |
|
Configure access to dashboards and app workspaces |
|
|
305 | (4) |
|
Configure the export and sharing setting of the tenant |
|
|
309 | (3) |
|
Configure row-level security |
|
|
312 | (8) |
|
Skill 3.5 Configure apps and apps workspaces |
|
|
320 | (8) |
|
Create and configure an app workspace |
|
|
321 | (1) |
|
|
322 | (6) |
|
|
328 | (1) |
|
Thought experiment answers |
|
|
329 | (1) |
|
|
330 | (3) |
Index |
|
333 | |