About the Author |
|
xii | |
Introduction |
|
xiii | |
Organization of this book |
|
xiii | |
Preparing for the exam |
|
xiv | |
Microsoft certifications |
|
xiv | |
Quick access to online references |
|
xv | |
Errata, updates & book support |
|
xv | |
Stay in touch |
|
xv | |
|
Chapter 1 Describe the business value of Microsoft Power Platform |
|
|
1 | (58) |
|
Skill 1.1 Describe the business value of Microsoft Power Platform services |
|
|
2 | (21) |
|
Gain insights into data by using Power BI |
|
|
3 | (7) |
|
Build applications quickly by using Power Apps |
|
|
10 | (2) |
|
Build solutions that use the Microsoft Dataverse |
|
|
12 | (2) |
|
Automate processes by using Power Automate |
|
|
14 | (4) |
|
Use connectors to integrate services and data |
|
|
18 | (2) |
|
Create powerful chatbots by using the Power Virtual Agents web app and Power Virtual Agents in Microsoft Teams |
|
|
20 | (3) |
|
Skill 1.2 Describe the business value of extending business solutions by using Microsoft Power Platform |
|
|
23 | (7) |
|
Describe how Microsoft Power Platform apps work together with Dynamics 365 apps |
|
|
23 | (2) |
|
Describe how Power Platform business solutions work together with Microsoft 365 apps and services |
|
|
25 | (1) |
|
Describe how Microsoft Power Platform apps work together |
|
|
26 | (1) |
|
Describe how to use Microsoft Power Platform solutions with Microsoft Teams |
|
|
27 | (1) |
|
Describe how Microsoft Power Platform business solutions can consume Microsoft Azure services including Azure Cognitive Services |
|
|
28 | (1) |
|
Describe how Power Platform business solutions can consume third-party apps and services |
|
|
29 | (1) |
|
Describe use cases for AppSource |
|
|
29 | (1) |
|
Skill 1.3 Describe Microsoft Power Platform administration and security |
|
|
30 | (26) |
|
Describe how Power Platform implements security, including awareness of Microsoft Dataverse security roles, Azure Identity Services, and Access Management |
|
|
32 | (9) |
|
Describe how to manage apps and users |
|
|
41 | (3) |
|
|
44 | (2) |
|
Describe where to perform specific administrative tasks, including Power Platform admin center and Microsoft 365 admin center |
|
|
46 | (2) |
|
|
48 | (2) |
|
Describe how Microsoft Power Platform supports privacy and accessibility guidelines |
|
|
50 | (3) |
|
Describe Microsoft Power Platform governance capabilities |
|
|
53 | (1) |
|
Describe analytics and how they can be used |
|
|
54 | (2) |
|
|
56 | (1) |
|
|
56 | (1) |
|
Thought experiment answers |
|
|
57 | (2) |
|
Chapter 2 Identify the core components of Microsoft Power Platform |
|
|
59 | (26) |
|
Skill 2.1 Describe Microsoft Dataverse |
|
|
60 | (14) |
|
Introduce Microsoft Dataverse |
|
|
60 | (1) |
|
Describe the difference between databases and Dataverse |
|
|
61 | (1) |
|
Describe the differences between Dataverse and Dataverse for Teams |
|
|
62 | (1) |
|
Describe tables, columns, and relationships |
|
|
63 | (6) |
|
Describe how to use common standard tables to describe people, places, and things |
|
|
69 | (1) |
|
Describe business logic uses, including business rules, real-time workflows, and actions |
|
|
70 | (2) |
|
Describe dataflows and their uses |
|
|
72 | (1) |
|
Describe solutions and their purpose |
|
|
72 | (2) |
|
Skill 2.2 Describe connectors |
|
|
74 | (9) |
|
Describe triggers, including trigger types and where triggers are used |
|
|
75 | (1) |
|
|
76 | (2) |
|
Describe licensing options for connectors, including standard or premium tier |
|
|
78 | (1) |
|
Identify use cases for custom connectors |
|
|
79 | (4) |
|
|
83 | (1) |
|
|
83 | (1) |
|
Thought experiment answers |
|
|
84 | (1) |
|
Chapter 3 Describe the business value of Power BI |
|
|
85 | (58) |
|
Skill 3.1 Identify common Power BI components |
|
|
86 | (23) |
|
Identify and describe uses for visualization controls, including pie, bar, donut, and scatter plots and KPIs |
|
|
86 | (10) |
|
Describe the Power BI Desktop Reports, Data, and Model tabs |
|
|
96 | (3) |
|
Compare and contrast Power BI Desktop and Power BI service |
|
|
99 | (2) |
|
Compare and contrast dashboards, workspaces, and reports |
|
|
101 | (2) |
|
Describe the Power BI security model |
|
|
103 | (5) |
|
Describe using Power BI in mobile apps |
|
|
108 | (1) |
|
Skill 3.2 Connect to and consume data |
|
|
109 | (22) |
|
Connect to and combine data from multiple sources, including Microsoft Excel |
|
|
109 | (3) |
|
Describe how to use Power Query to clean and transform data |
|
|
112 | (5) |
|
Describe and implement aggregate functions |
|
|
117 | (1) |
|
Identify available types of data sources, including Microsoft Excel |
|
|
118 | (5) |
|
Describe use cases for shared datasets |
|
|
123 | (1) |
|
Describe use cases for template apps |
|
|
124 | (1) |
|
Describe options for viewing Power BI reports and dashboards |
|
|
125 | (6) |
|
Skill 3.3 Build a basic dashboard using Power BI |
|
|
131 | (10) |
|
|
131 | (6) |
|
Create a Power BI dashboard |
|
|
137 | (3) |
|
Publish and share reports and dashboards |
|
|
140 | (1) |
|
|
141 | (1) |
|
|
142 | (1) |
|
Thought experiment answers |
|
|
142 | (1) |
|
Chapter 4 Demonstrate the capabilities of Power Apps |
|
|
143 | (34) |
|
Skill 4.1 Identify common Power Apps components |
|
|
143 | (9) |
|
Describe the differences between canvas apps and model-driven apps |
|
|
144 | (6) |
|
Describe use cases for formulas |
|
|
150 | (2) |
|
Skill 4.2 Build a basic canvas app |
|
|
152 | (13) |
|
Describe types of data sources |
|
|
153 | (2) |
|
Connect to data by using connectors |
|
|
155 | (4) |
|
|
159 | (1) |
|
Use controls to design the user experience |
|
|
160 | (3) |
|
|
163 | (2) |
|
Describe embedding into Microsoft Teams |
|
|
165 | (1) |
|
Skill 4.3 Build a basic model-driven app |
|
|
165 | (9) |
|
Create a model-driven app from tables |
|
|
165 | (4) |
|
|
169 | (3) |
|
Create and modify views and columns |
|
|
172 | (1) |
|
|
173 | (1) |
|
|
174 | (1) |
|
|
175 | (1) |
|
Thought experiment answers |
|
|
176 | (1) |
|
Chapter 5 Demonstrate the capabilities of Power Automate |
|
|
177 | (40) |
|
Skill 5.1 Identify common Power Automate components |
|
|
177 | (23) |
|
Identify flow types, including cloud, desktop, and business process flows |
|
|
178 | (3) |
|
Describe use cases for flows and available flow templates |
|
|
181 | (6) |
|
Describe how Power Automate uses connector triggers and actions |
|
|
187 | (4) |
|
Describe loops and conditions, including switch, do until, and apply to each |
|
|
191 | (3) |
|
|
194 | (3) |
|
Describe use cases for approvals |
|
|
197 | (1) |
|
Describe the Power Automate apps, including Power Automate Desktop, Power Automate mobile, and Power Automate portal |
|
|
198 | (2) |
|
Skill 5.2 Build a basic cloud flow ` |
|
|
200 | (15) |
|
Create a cloud flow by using the instant, automated, or scheduled flow template |
|
|
201 | (5) |
|
|
206 | (4) |
|
Use flow steps to perform data operations |
|
|
210 | (2) |
|
|
212 | (3) |
|
|
215 | (1) |
|
|
216 | (1) |
|
Thought experiment answers |
|
|
216 | (1) |
|
Chapter 6 Demonstrate the capabilities of Power Virtual Agents |
|
|
217 | (30) |
|
Skill 6.1 Describe the capabilities of Power Virtual Agents in Microsoft Teams |
|
|
217 | (15) |
|
Describe use cases for Power Virtual Agents within Microsoft Teams |
|
|
218 | (3) |
|
Describe topics, entities, and actions |
|
|
221 | (6) |
|
Describe message nodes, question nodes, conditions, trigger phrases, and the authoring canvas |
|
|
227 | (5) |
|
Skill 6.2 Build and publish a basic chatbot |
|
|
232 | (12) |
|
|
232 | (1) |
|
|
233 | (2) |
|
|
235 | (1) |
|
Launch a Power Automate flow from a chatbot |
|
|
236 | (2) |
|
|
238 | (6) |
|
|
244 | (1) |
|
|
244 | (1) |
|
Thought experiment answers |
|
|
245 | (2) |
Index |
|
247 | |