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 Microsoft 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. Microsoft 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, AI Builder, connectors, and portals.
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.
Job role: Functional Consultant
Preparation for exam: PL-200
Experience as an IT professional or student
Working knowledge of Microsoft Power Platform and its key components
Knowledge of Microsoft Dataverse (or general data modeling) and security concepts
Course outline
Module 1: Introduction to 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
Lab : Validate lab environment
After completing this module, students will be able to:
Identify the key components of 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
Lab : Create an app
Lab : Create tables and columns
Lab : Create relationships
Lab : Additional table options
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 Microsoft 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
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
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
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
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
Lab : Create a chatbot
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
Lab : Build a Word template
Lab : Build an Excel template
Lab : Import data
Lab : Duplicate detection
Lab : Export data
Lab : Bulk delete
After completing this module, students will be able to:
Create visualizations
Consume data in Power BI
Export data visualizations for stakeholders