Microsoft Certified: Power Platform Functional Consultant Associate (PL200)

Microsoft Power Platform Functional Consultant (PL-200T00)

Module 1: Describe the business value of the Microsoft Power Platform

• Explore Microsoft Power Platform
• Describe the business value of the Power Platform
• Explore connectors and Microsoft Dataverse
• Describe how Power Platform works with Microsoft 365 apps and services
• Explore how Power Platform works with Microsoft Teams
• Describe how Power Platform works with Microsoft Dynamics 365 apps
• Describe how Power Platform solutions consume Microsoft Azure services
• Explore how Microsoft Power Platform apps work together

Module 2: Get Started with Power Pages

• Get started with Power Pages
• Core tools and components of Power Pages
• Overview of Power Pages security
• Overview of Power Pages extensibility

Module 3: Create and use analytics reports with Power BI

• Use Power BI
• Building blocks of Power BI
• Tour and use the Power BI service

Module 4: Manage workspaces and datasets in Power BI

• Distribute a report or dashboard
• Monitor usage and performance
• Recommend a development life cycle strategy
• Troubleshoot data by viewing its lineage
• Configure data protection

Module 5: Create tables in Dataverse

• Table characteristics
• Dual-write vs. virtual tables
• Dataverse auditing
• Import data into your Microsoft Dataverse database

Module 6: Manage tables in Dataverse

• Identify tables and table types in Dataverse
• Create a custom table
• Enable attachments within a table

Module 7: Create and manage columns within a table in Dataverse

• Define columns in Microsoft Dataverse
• Column types in Microsoft Dataverse
• Add a column to a table
• Create a primary name column
• Restrictions that apply to columns in a table
• Create an auto numbering column
• Create an alternate key

Module 8: Create a relationship between tables in Dataverse

• Relate one or more tables - Introduction
• Relationship types that are available in Microsoft Dataverse
• Create a one-to-many relationship between tables
• Create a many-to-many relationship between tables
• Edit or delete relationships

Module 9: Working with choices in Dataverse

• Define choice column
• Standard choices column

Module 10: Get started with security roles in Dataverse

• Introduction to environment roles
• Understand environment roles
• Adding or disabling an environment user
• Understand security concepts in Dataverse
• Understand user security roles and security role defaults
• Check the roles that a user belongs to
• Configure Dataverse teams for security
• Configure Dataverse group teams for security

Module 11: Use administration options for Dataverse

• Introduction to Microsoft Power Platform Admin Center portal
• Use Microsoft Power Platform Admin Center portal
• Tenant storage capacity
• Advanced Customization options in Power Apps Portal
• Enable and disable auditing

Module 12: Manage Dynamics 365 model-driven app settings and security

• Configure role-based security
• Manage teams and business units
• Explore settings and customizations

Module 13: Introduction to Microsoft Power Platform security and governance

• Identify Microsoft Power Platform environments
• Data Loss Prevention policies
• Microsoft Power Platform Center of Excellence Starter Kit

Module 14: Get started with model-driven apps in Power Apps

• Introducing model-driven apps
• Components of model-driven apps
• Design model-driven apps
• Incorporate business process flows

Module 15: Configure forms, charts, and dashboards in model-driven apps

• Forms overview
• Form elements
• Configure multiple forms
• Use specialized form components
• Configure views overview
• Configure grids
• Use specialty views
• Configure charts overview
• Dashboards overview
• Use interactive streams and tiles

Module 16: Get started with Power Apps canvas apps

• Introduction to Power Apps
• Power Apps building blocks
• Ways to build Power Apps
• Power Apps related technologies
• Additional Power Apps related technologies
• Designing a Power Apps app

Module 17: Connect to other data in a Power Apps canvas app

• Overview of the different data sources
• Work with action-based data sources
• Power Automate is a companion to Power Apps

Module 18: Manage apps in Power Apps

• Power Apps review

Module 19: Build your first app with Power Apps and Dataverse for Teams

• Create your first app with the hero template
• Customize your app with Power Apps Studio
• Publish your app
• Install template apps

Module 20: Access Dataverse in Power Pages websites

• Use lists to display multiple Dataverse records
• Use forms to interact with Dataverse data

Module 21: Authentication and user management in Power Pages

• Power Pages authentication settings
• User registration in Power Pages
• Authentication management for Power Pages users
• Power Pages authentication providers

Module 22: Power Pages maintenance and troubleshooting

• Power Pages website maintenance
• Power Pages website troubleshooting

Module 23: Define and create business rules in Dataverse

• Define business rules - Introduction
• Define the components of a business rule
• Create a business rule

Module 24: Get started with Power Automate

• Introducing Power Automate
• Troubleshoot flows

Module 25:Use the Admin center to manage environments and data policies in Power Automate

• Administer flows
• Export and import flows
• Learn how to distribute button flows

Module 26: Use Dataverse triggers and actions in Power Automate

• Dataverse triggers
• Use triggers
• Work with Dataverse actions

Module 27: Extend Dataverse with Power Automate

• Set up a flow and configure its trigger
• Email Dataverse record
• Add to-do items

Module 28: Introduction to expressions in Power Automate

• Introduction to expressions
• Get started with expressions
• Notes make things easier
• Types of functions
• Write complex expressions

Module 29: Build your first Power Automate for desktop flow

• Set up the environment
• Explore Power Automate for desktop
• Create your first Power Automate for desktop flow
• Record Power Automate for desktop actions

Module 30: Run a Power Automate for desktop flow in unattended mode

• Set up an unattended desktop flow
• Create a new cloud flow that calls an existing flow in unattended mode
• Perform a test run
• Best practices

Module 31: Optimize your business process with process advisor

• Get familiar with process advisor
• Create your first recording
• Edit recordings and group actions
• Analyze recordings and interpret results
• Automation recommendations

Module 32: Get started with Power Virtual Agents bots

• Get started working with environments
• Create bots and work with the Power Virtual Agents interface
• Create topics
• Test bots
• Publish bots and analyze performance

Module 33: Enhance Power Virtual Agents bots

• Use Power Automate to add actions
• Transfer conversations to agents by using Omnichannel for Customer Service
• Create topics for existing support content
• Analyze bot performance

Module 34: Manage topics in Power Virtual Agents

• Work with bot topics
• Branch a topic
• System topics
• Create topics for existing support content
• Work with system fallback topics
• Manage topics

Module 35: Manage Power Virtual Agents

• Environments in Power Virtual Agents
• Bot topics permissions
• Bot entities and flow permissions
• Monitor and diagnose
• Administer and manage
• Export and import bots
• Authentication

Module 36: Get started building with Power BI

• Use Power BI
• Building blocks of Power BI
• Tour and use the Power BI service

Module 37: Get data with Power BI Desktop

• Explore Power BI Desktop
• Connect to data sources
• Get data from Excel
• Transform data to include in a report
• Combine data from multiple sources
• Clean data to include in a report

Module 38: Model data in Power BI

• How to manage your data relationships
• Create calculated columns
• Optimize data models
• Create measures
• Create calculated tables
• Explore time-based data

Module 39: Use visuals in Power BI

• Create and customize simple visualizations
• Create slicers
• Map visualizations
• Matrices and tables
• Create scatter, waterfall, and funnel charts
• Modify colors in charts and visuals
• Page layout and formatting

Module 40: Explore data in Power BI

• Quick insights in Power BI
• Create and configure a dashboard
• Ask questions of your data with natural language
• Create custom Q&A suggestions
• Share dashboards with your organization
• Display visuals and tiles in full screen
• Edit tile details and add widgets
• Get more space on your dashboard

Module 41: Publish and share in Power BI

• Publish Power BI Desktop reports
• Print and export dashboards and reports
• Introducing Power BI Mobile
• Create workspaces in Power BI
• Build apps
• Use apps
• Integrate OneDrive for Business with Power BI
• Publish to web

Module 42: Manage solutions in Power Apps and Power Automate

• Add and remove apps, flows, and entities in a solution
• Edit a solution-aware app, flow, and table
• Exercise - Import and export solutions
• Build and deploy a complex solution with flows, apps, and entities
• Automate solution management

Module 43: Load/export data and create data views in Dataverse

• View data in a table
• Create or edit views of data in a table
• Load data into a table
• Export data from a table
• Add, update, or delete data in a table by using Excel
• Import data using Power Query
• Generate a new dataflow from an Excel Template
• Dataflow and Azure integration

Module 44: Get started with AI Builder

• Choose an AI capability
• Create your first model
• Ways to use your models

Module 45: Manage models in AI Builder

• Model lifecycle
• Manage model versions
• Share your models

Module 46: Use AI Builder in Power Automate

• AI Builder in Power Automate saves time
• Exercise - Use AI Builder actions in Power Automate
• Advanced usage of AI Builder in Power Automate

Module 47: Functional Consultant skills

• Create entity relationship diagrams
• Create and document mock-ups
• Document functional requirements and artifacts
• Complete fit-gap analysis
• Discuss stakeholder management responsibilities
• Understand industry accelerators
• Define Application Lifecycle Management
• Participate in testing
• Evaluate options
• Define connectors
• Understand Power Apps component framework

Module 48: Solution Architect series: Plan application lifecycle management for Power Platform

• Key considerations for ALM
• Solutions
• Configuration and reference data
• Release process
• ALM with Azure DevOps