Microsoft Power Platform Functional Consultant (PL-200T00)

The Microsoft Power Platform empowers organizations to automate business processes, develop their own rich app experiences, and connect with customers better and faster.

Course Outline

The Microsoft Power Platform empowers organizations to automate business processes, develop their own rich app experiences, and connect with customers better and faster.

In this course, students will learn to perform discovery, capture requirements, engage subject matter experts and stakeholders, translate requirements, and configure Power Platform solutions and apps. They will supplement their learnings with hands-on labs to create application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and custom visualizations. Power Platform is comprised of four key products: Power Apps, Power Automate, Power BI, and Power Virtual Agents. In this course, we will cover these four applications in depth, with additional focus on Microsoft Dataverse (formerly Common Data Service), AI Builder, connectors, and portals.

WHO SHOULD ATTEND?

A Microsoft Power Platform Functional Consultant is responsible for creating and configuring apps, automations, and solutions. They act as the liaison between users and the implementation team. The functional consultant promotes utilization of solutions within an organization. The functional consultant may perform discovery, engage subject matter experts and stakeholders, capture requirements, and map requirements to features. They implement components of a solution including application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and simple visualizations.

WHAT YOU'LL LEARN

Students will learn to,

• Work with an organization to gather requirements and implement Power Platform solutions
• Build model-driven, canvas, and portal apps
• Create Power Automate flows
• Design a simple chatbot using Power Virtual Agents
• Analyze data using Power BI visualizations and dashboards

 

COURSE OUTLINE

Module 1: Introduction to the Microsoft Power Platform

This module will provide the learner with background about Microsoft Power Platform and its 4 key components: Power Apps, Power Automate, Power BI, and Power Virtual Agents.

Lessons

• Microsoft Power Platform overview

After completing this module, students will be able to:

• Identify the key components of the Microsoft Power Platform
• Describe the role of a functional consultant

 

Module 2:  The Functional Consultant role

In this module, students will learn more about the functional consultant role and the skills required to successfully implement a Microsoft Power Platform solution for an organization.

Lessons

• Consultant skills overview
• Create and validate documentation
• Engage stakeholders
• Perform quality assurance
• Configure integrations

After completing this module, students will be able to:

• Engage stakeholders with demos
• Create table (entity) relationship diagrams
• Design integrations
• Interact with consultant and customer organization teams

 

Module 3: Work with Dataverse

In this module, students will learn about creating a data model in Microsoft Dataverse, including importing data, using tabular reporting options, and configuring security. They will also learn about creating easy AI with AI Builder.

Lessons

• Work with the data model
• Create and manage processes
• Work with AI Builder
• Configure Dataverse settings
• Import and export data
• Use tabular reporting options
• Configure security settings

After completing this module, students will be able to:

• Understand tables, columns, rows, and relationships
• Configure a data model in Dataverse
• Work in an environment within the Power Platform admin center

 

Module 4: Make Power Apps

In this module, students will learn the business value of the three types of Power Apps. They will then learn to how to configure and design them, including user experience considerations for each type of application.

Lessons

• Make model-driven apps
• Make canvas apps
• Make portal apps

After completing this module, students will be able to:

• Connect to data in Power Apps
• Build a Power App
• Design an application user experience

 

Module 5: Build Power Automate flows

In this module, students will learn how to automate business processes using Power Automate flows, business process flows, and UI flows.

Lessons

• Build flows
• Build business process flows
• Build UI flows

After completing this module, students will be able to:

• Create flows
• Create business process flows
• Understand UI flows

 

Module 6: Work with Power Virtual Agents

In this module, students will learn how to automate customer interactions with a chatbot using Power Virtual Agents.

Lessons

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

After completing this module, students will be able to:

• Create a chatbot
• Include a flow in a chatbot
• Create topics and entities

 

Module 7: Analyze data with Power BI

In this module, students will learn how to work with Power BI Desktop and Power BI Service to analyze data and create visualizations.

Lessons

• Get started with Power BI
• Model data in Power BI
• Create visualizations
• Create dashboards
• Publish and share in Power BI

After completing this module, students will be able to:

• Create visualizations
• Consume data in Power BI
• Export data visualizations for stakeholders

 

LABS OUTLINE

• Lab : Validate lab environment
• Lab : Create an app
• Lab : Create tables and Columns
• Lab : Create relationships
• Lab : Additional table options
• Lab : Build dashboards
• Lab : Modify views
• Lab : Modify forms
• Lab : App designer
• Lab : Canvas app fundamentals
• Lab : Work with data and services
• Lab : User experience
• Lab : Build a business process flow
• Lab : Add branching to business process flow
• Lab : Build approval flow
• Lab : Create a flow
• Lab : Create users
• Lab : Create security role
• Lab : Configure a new business rule
• Lab : Advanced business rules
• Lab : Create a chatbot
• Lab : Build a Word template
• Lab : Build an Excel template
• Lab : Import data
• Lab : Duplicate detection
• Lab : Export data
• Lab : Bulk delete