Microsoft Power Platform Functional Consultant (PL-200)
This course will teach you to use Power Platform solutions to simplify, automate, and empower business processes for organizations in the role of a Functional Consultant.
Description
A Power Platform Functional Consultant is responsible for performing discovery, capturing requirements, engaging subject matter experts and stakeholders, translating requirements, and configuring Power Platform solutions and apps. This course covers Power Apps, Power Automate, Power Virtual Agents, and Power BI concepts to teach students how to build an integrated solution for an organization based on business requirements.
About this course
The 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.
Audience Profile
A Power Platform Functional Consultant is responsible for performing discovery, capturing requirements, engaging subject matter experts and stakeholders, translating requirements, and configuring Power Platform solutions and apps. The Functional Consultant implements components of a solution that include application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and custom visualizations.At Course Completion
After completing this course, students will be able 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 Power Platform
- Power Platform overview
- Lab : Validate lab environment
- Identify the key components of the Power Platform
- Describe the role of a functional consultant
Module 2: The Functional Consultant Role
- 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
- 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
- Lab : Create an app
- Lab : Create tables and columns
- Lab : Create relationships
- Lab : Additional table options
- 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
- Make model-driven apps
- Make canvas apps
- Make portal apps
- Lab : App designer
- Lab : Modify forms
- Lab : Modify views
- Lab : Build dashboards
- Lab : Canvas app fundamentals
- Lab : Work with data and services
- Lab : User experience
- Connect to data in Power Apps
- Build a Power App
- Design an application user experience
Module 5: Build Power Automate flows
- Build flows
- Build business process flows
- Build UI flows
- Lab : Create users
- Lab : Create security role
- Lab : Configure a new business rule
- Lab : Advanced business rules
- Lab : Create a flow
- Lab : Build approval flow
- Lab : Build a business process flow
- Lab : Add branching to business process flow
- Create flows
- Create business process flows
- Understand UI flows
Module 6: Work with Power Virtual Agents
- Create a chatbot
- Configure topics
- Automate and integrate
- Configure entities
- Test and publish chatbots
- Lab : Create a Chatbot
- Create a chatbot
- Include a flow in a chatbot
- Create topics and entities
Module 7: Analyze data with Power BI
- Get started with Power BI
- Model data in Power BI
- Create visualizations
- Create dashboards
- Publish and share in Power BI
- Lab : Build a Word template
- Lab : Build an Excel template
- Lab : Duplicate detection
- Lab : Import data
- Lab : Export data
- Lab : Bulk delete
- Create visualizations
- Consume data in Power BI
- Export data visualizations for stakeholders