Cover
Title Page
Copyright Page
Contents at a glance
Contents
About the Author
Introduction
Organization of this book
Preparing for the exam
Microsoft certifictions
Quick access to online references
Errata, updates & book support
Stay in touch
Chapter 1 Describe the business value of Microsoft Power Platform
Skill 1.1: Describe the business value of Microsoft Power Platform services
Gain insights into data by using Power BI
Build applications quickly by using Power Apps
Build solutions that use the Microsoft Dataverse
Automate processes by using Power Automate
Use connectors to integrate services and data
Create powerful chatbots by using the Power Virtual Agents web app and Power Virtual Agents in Microsoft Teams
Skill 1.2: Describe the business value of extending business solutions by using Microsoft Power Platform
Describe how Microsoft Power Platform apps work together with Dynamics 365 apps
Describe how Power Platform business solutions work together with Microsoft 365 apps and services
Describe how Microsoft Power Platform apps work together
Describe how to use Microsoft Power Platform solutions with Microsoft Teams
Describe how Microsoft Power Platform business solutions can consume Microsoft Azure services including Azure Cognitive Services
Describe how Power Platform business solutions can consume third-party apps and services
Describe use cases for AppSource
Skill 1.3: Describe Microsoft Power Platform administration and security
Describe how Power Platform implements security, including awareness of Microsoft Dataverse security roles, Azure Identity Services, and Access Management
Describe how to manage apps and users
Describe environments
Describe where to perform specific administrative t ask including Power Platform admin center and Microsoft 365 admin center
Describe data policies
Describe how Microsoft Power Platform supports privacy and accessibility guidelines
Describe Microsoft Power Platform governance capabilities
Describe analytics and how they can be used
Chapter summary
Thought experiment
Thought experiment answers
Chapter 2 Identify the core components of Microsoft Power Platform
Skill 2.1: Describe Microsoft Dataverse
Introduce Microsoft Dataverse
Describe the difference between databases and Dataverse
Describe the differences between Dataverse and Dataverse for Teams
Describe tables, columns, and relationships
Describe how to use common standard tables to describe people, places, and things
Describe business logic uses, including business rules, real-time worflow an actions
Describe dataflows and their uses
Describe solutions and their purpose
Skill 2.2: Describe connectors
Describe triggers, including trigger types and where triggers are used
Describe actions
Describe licensing options for connectors, including standard or premium tier
Identify use cases for custom connectors
Chapter summary
Thought experiment
Thought experiment answers
Chapter 3 Describe the business value of Power BI
Skill 3.1: Identify common Power BI components
Identify and describe uses for visualization controls, including pie, bar, donut, and scatter plots and KPIs
Describe the Power BI Desktop Reports, Data, and Model tabs
Compare and contrast Power BI Desktop and Power BI service
Compare and contrast dashboards, workspaces, and reports
Describe the Power BI security model
Describe using Power BI in mobile apps
Skill 3.2: Connect to and consume data
Connect to and combine data from multiple sources, including Microsoft Excel
Describe how to use Power Query to clean and transform data
Describe and implement aggregate functions
Identify available types of data sources, including Microsoft Excel
Describe use cases for shared datasets
Describe use cases for template apps
Describe options for viewing Power BI reports and dashboards
Skill 3.3: Build a basic dashboard using Power BI
Create a Power BI report
Create a Power BI dashboard
Publish and share reports and dashboards
Chapter summary
Thought experiment
Thought experiment answers
Chapter 4 Demonstrate the capabilities of Power Apps
Skill 4.1: Identify common Power Apps components
Describe the differences between canvas apps and model-driven apps
Describe use cases for formulas
Skill 4.2: Build a basic canvas app
Describe types of data sources
Connect to data by using connectors
Create an app from data
Use controls to design the user experience
Publish and share an app
Describe embedding into Microsoft Teams
Skill 4.3: Build a basic model-driven app
Create a model-driven app from tables
Modify forms
Create and modify views and columns
Publish and share an app
Chapter summary
Thought experiment
Thought experiment answers
Chapter 5 Demonstrate the capabilities of Power Automate
Skill 5.1: Identify common Power Automate components
Identify flow types, including cloud desktop, and business process flows
Describe use cases for flow and available flow templates
Describe how Power Automate uses connector triggers and actions
Describe loops and conditions, including switch, do until, and apply to each
Describe expressions
Describe use cases for approvals
Describe the Power Automate apps, including Power Automate Desktop, Power Automate mobile, and Power Automate portal
Skill 5.2: Build a basic cloud flow
Create a cloud flow by using the instant, automated, or scheduled flow template
Modify a cloud flow
Use flow steps to perform data operations
Run a cloud flow
Chapter summary
Thought experiment
Thought experiment answers
Chapter 6 Demonstrate the capabilities of Power Virtual Agents
Skill 6.1: Describe the capabilities of Power Virtual Agents in Microsoft Teams
Describe use cases for Power Virtual Agents within Microsoft Teams
Describe topics, entities, and actions
Describe message nodes, question nodes, conditions, trigger phrases, and the authoring canvas
Skill 6.2: Build and publish a basic chatbot
Create a chatbot
Create a topic
Call an action
Launch a Power Automate flow from a chatbot
Publish a chatbot
Chapter summary
Thought experiment
Thought experiment answers
Index
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z