IT-professional

PL-200 Microsoft Power Platform Functional Consultant

This 4-day hands-on Microsoft Power Platform Functional Consultant training covers the four essential products within Power Platform: Power Apps, Power Automate, Power BI, and Power Virtual Agents, with an additional focus on Microsoft Dataverse, AI Builder, connectors, and portals.

Course objectives

You will learn to perform discovery, capture requirements, engage subject matter experts and stakeholders, translate requirements, and configure Microsoft Power Platform solutions and apps. In addition, the hands-on labs will allow you to create application enhancements, customise user experiences, systems integrations, data conversions, custom process automation, and custom visualisations.

  • Work with an organisation 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
  • Analyse data using Power BI visualisations and dashboards

Target audience

A Microsoft Power Platform Functional Consultant is responsible for creating and configuring apps, automation, and solutions. They act as the liaison between users and the implementation team. The functional consultant promotes the 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.

Prerequisites

Attendees in this course should have experience in Microsoft Power Platform Fundamentals PL-900 and:

  • Experience as an IT professional or student.
  • Working knowledge of Microsoft Power Platform and its key components.
  • Knowledge of Microsoft Dataverse (or general data modelling) and security concepts

Outline

Module 1: Introduction to Microsoft Power Platform

  • Identify the key components of Microsoft Power Platform
  • Describe the role of a functional consultant
Module 2: The Functional Consultant role
  • Engage stakeholders with demos
  • Create table (entity) relationship diagrams
  • Design integrations
  • Interact with consultant and customer organisation teams
Module 3: Work with Dataverse
  • Understand tables, columns, rows, and relationships
  • Configure a data model in Dataverse
  • Work in an environment within the Microsoft Power Platform admin center
Module 4: Make Power Apps
  • Connect to data in Power Apps
  • Build a Power App
  • Design an application user experience
Module 5: Build Power Automate flows
  • Create flows
  • Create business process flows
  • Understand UI flows
Module 6: Work with Power Virtual Agents
  • Create a chatbot
  • Include a flow in a chatbot
  • Create topics and entities

Module 7: Analyze data with Power BI

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