Microsoft Power Platform Functional Consultant (PL-200)

During the intensive training days with our trainer , you will work with the official Microsoft course materials.

Course overview:

Module 1: Introduction to Microsoft Power Platform
This module provides the learner with background knowledge about the Microsoft Power Platform and its four main components: Power Apps, Power Automate, Power BI and Power Virtual Agents.

Lessons

• Overview of Microsoft Power Platform
• Exercise: Validation of the lab environment

Module 2: Working with Dataverse
In this module, participants will learn how to create a data model in Microsoft Dataverse, including importing data, using tabular reporting options and configuring security. They will also learn how to create simple AI using AI Builder.

Lessons

• Working with tables
• Understanding data types and behavior
• Configure security settings

Exercises:

1. Create an application
2. Create tables and columns
3. Create relationships
4. Additional table settings

Module 3: Building Model-Driven Applications with Power Apps
In this module, participants will learn about the business value of Power Apps model-driven applications. They will then learn how to configure and design them, including usability considerations.

Lessons

• Building blocks of model-driven applications
• Design of model-driven applications
• Forms and views

Exercises:

1. Changing views
2. Modify forms
3. App Designer

Module 4: Building Canvas Applications with Power Apps
In this module, participants will learn about the business value of Power Apps Canvas apps. They will then learn how to configure and design them, including usability considerations.

Lessons

• Power Apps Studio
• Canvas apps functions
• User experience

Exercises:

1. Creating a canvas application
2. Working with data and services
3. User experience

Module 5: Creating portals with Power Apps
In this module, participants learn about the business benefits of Power Apps portals. They will then learn how to access Dataverse data in a portal and how portal authentication works.

Lessons

• Architecture of Power Apps portals
• Access to Microsoft Dataverse in your portal
• Authentication and user administration

Module 6: Introduction to automation
In this module, participants learn about business rules and when they can be used. Participants will also receive an overview of Power Automate.

Lessons

• Business rules
• Overview of Power Automate

Exercises:

1. Configure a new business rule
2. Create security roles
3. Create user
4. Extended business rules

Module 7: Create Power Automate Cloud Flows
In this module, participants will learn the basics of cloud flows, including triggers and flows. They will create two flows, including an approval flow.

Lessons

• The basics of cloud flows
• Trigger
• Actions

Exercises:

1. Create a flow
2. Create an approval process

Module 8: Creating and automating desktop flows
In this module, participants will learn what desktop flows are and how to create them. participants will also learn how to use desktop flows and how to use process consultants to better understand where to streamline workflows.

Lessons

• Create desktop flows
• Using desktop flows
• Process Advisor

Module 9: Creating business process flows
In this module, participants learn about the value of business process flows and how to use the Business Process Flow Designer. They will also practice creating business process flows and learn how to automate them.

Lessons

• Why use business process flows
• Using the business process flow designer
• Automate your business process flow

Exercises:

1. Create a branched business process flow
2. Create a business process flow

Module 10: Creating chatbots with Power Virtual Agents
In this module, participants learn how to automate customer interactions with a chatbot using Power Virtual Agents.

Lessons

• Create a chatbot
• Configure topics
• Automate and integrate
• Configuring entities
• Test and publish chatbots

Exercise:

1. Create a chatbot

Module 11: Analyzing data with Power Bi
In this module, participants learn how to work with Power BI Desktop and Power BI Service to analyze data and create visualizations.

Lessons

• Using tabular reporting options in Dataverse
• Use of diagrams and dashboards in Dataverse
• First steps with Power BI
• Modeling data in Power BI
• Create visualizations and dashboards
• Publish and share in Power BI

Module 12: Putting it all together
In this module, participants will learn how the concepts in this course relate to each other and how to apply functional consulting skills to Microsoft Power Platform projects. They will also learn how solutions are used in Microsoft Power Platform and get an introduction to AI Builder.

Lessons

• Use of solutions
• AI Builder
• Consultant skills

Exercises:

1. Create diagrams
2. Create dashboards
3. Delete data
4. Create a Word template
5. Create an Excel template
6. Recognize duplicates
7. Import data
8. Export data

The content of this intensive training is derived from the exam "PL-200: Microsoft Power Platform Functional Consultant".