GB
/
GBP
/
EN_GB

Shaping the future of IT skills

Maximising IT performance through learning

Microsoft Power Platform Functional Consultant - PL-200T00

WGAC-MIC-PL-200T00

Microsoft

Description

Show Tabs
Introduction

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.

Prerequisites & Audience
  • 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 Benefits

Course Objectives

  • Work with an organization to gather requirements and implement Microsoft 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 Topics
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
Module 2: 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 tables
  • Understand data types and behavior
  • Configure security settings
  • Lab: Create an app
  • Lab: Create tables and columns
  • Lab: Create relationships
  • Lab: Additional table 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 Microsoft Power Platform admin center
Module 3: Make model-driven apps with Power Apps

In this module, students will learn the business value of Power Apps model-driven apps. They will then learn to how to configure and design them, including user experience considerations.

Lessons
  • Building blocks of model-driven apps
  • Design model-driven apps
  • Forms and views
  • Lab: Modify views
  • Lab: Modify forms
  • Lab: App designer

After completing this module, students will be able to:

  • Connect to data in Power Apps
  • Build a Power Apps model-driven app
  • Design an application user experience
Module 4: Make canvas apps with Power Apps

In this module, students will learn the business value of Power Apps canvas apps. They will then learn to how to configure and design them, including user experience considerations.

Lessons
  • Power Apps studio
  • Canvas apps capabilities
  • User experience
  • Lab: Build a canvas app
  • Lab: Work with data and services
  • Lab: User experience

After completing this module, students will be able to:

  • Build a Power Apps canvas app
  • Configure user experience in a canvas app
  • Understand the building blocks of a canvas app
Module 5: Make portals with Power Apps

In this module, students will learn the business value of Power Apps portals. They will then learn to how to access Dataverse data in a portal and how portal authentication works.

Lessons
  • Power Apps portals architecture
  • Access Microsoft Dataverse in your portal
  • Authentication and user management

After completing this module, students will be able to:

  • Understand how to use Dataverse data in a portal
  • Recognize types of Power Apps portals for different audiences
  • Register users for portal access
Module 6: Introduction to automation

In this module, students will learn about business rules and when they can be used. Students will also get an overview of Power Automate.

Lessons
  • Business rules
  • Power Automate overview
  • Lab: Configure a new business rule
  • Lab: Create security roles
  • Lab: Create users
  • Lab: Advanced business rules

After completing this module, students will be able to:

  • Create users and grant security roles
  • Create and configure security roles
  • Create and configure advanced business rules
Module 7: Build Power Automate cloud flows

In this module, students will learn the fundamentals of cloud flows, including triggers and flows. They will create two flows, including an approval flow.

Lessons
  • Fundamentals of cloud flows
  • Triggers
  • Actions
  • Lab: Create a flow
  • Lab: Build an approval flow

After completing this module, students will be able to:

  • Create cloud flows
  • Understand the fundamentals of cloud flows
  • Use triggers and actions
Module 8: Build Power Automate desktop flows

In this module, students will learn what desktop flows are and how they are created. Students will also learn how desktop flows are used and how to use process advisor to better understand places to streamline workflows.

Lessons
  • Build desktop flows
  • Use desktop flows
  • Process advisor

After completing this module, students will be able to:

  • Understand the value of desktop flows
  • Identify when to use desktop flows and how process advisor can help
Module 9: Build business process flows

In this module, students will learn the value of business process flows and how to use the business process flow designer. They will also practice building business process flows and learn how they can be automated.

Lessons
  • Why use business process flows
  • Using business process flow designer
  • Automating your business process flow
  • Lab: Build a branching business process flow
  • Lab: Build a business process flow

After completing this module, students will be able to:

  • Create business process flows
  • Use the business process flow designer
  • Know how to add automation to a business process flow
Module 10: Build chatbots 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: Build 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 11: 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
  • Use tabular reporting options in Dataverse
  • Use charts and dashboards in Dataverse
  • Get started with Power BI
  • Model data in Power BI
  • Create visualizations and 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
Module 12: Putting it all together

In this module, students will learn how the concepts of this course pull together and how to use functional consultant skills on Microsoft Power Platform engagements. They will also learn how solutions are used in Microsoft Power Platform and will be introduced to AI Builder.

Lessons
  • Using solutions
  • AI Builder
  • Consultant skills
  • Lab: Build charts
  • Lab: Build dashboards
  • Lab: Build delete data
  • Lab: Build a Word template
  • Lab: Build an Excel template
  • Lab: Duplicate detection
  • Lab: Import data
  • Lab: Export data

After completing this module, students will be able to:

  • Understand how the concepts of this course work together
  • Manage solutions in Microsoft Power Platform
  • Use AI Builder to create and manage models
  • Apply functional consultant skills

Microsoft courses


Dynamics 365 Fundamentals - MB-900T01
CODE: WGAC-MIC-MB-900T01
Microsoft Dynamics 365 Finance - MB-310T00
CODE: WGAC-MIC-MB-310T00
Microsoft Dynamics 365 Customer Service - MB-230T01
CODE: WGAC-MIC-MB-230T01
Microsoft Azure AI Fundamentals - AI-900T00
CODE: WGAC-MIC-AI-900T00
Microsoft 365 Fundamentals - MS-900T01
CODE: WGAC-MIC-MS-900T01
Designing and Implementing Microsoft Azure Networking Solutions - AZ-700T00
CODE: WGAC-MIC-AZ-700T00
Power Platform Developer - PL-400T00
CODE: WGAC-MIC-PL-400T00
Building Applications and Solutions with Microsoft 365 Core Services -MS-600T00
CODE: WGAC-MIC-MS-600T00
Designing and Implementing a Microsoft Azure AI Solution - AI-102T00
CODE: WGAC-MIC-AI-102T00
Microsoft Azure Administrator - AZ-104T00
CODE: WGAC-MIC-AZ-104T00
Azure Architect Technologies - AZ-303T00
CODE: WGAC-MIC-AZ-303T00
Microsoft Power BI Data Analyst - PL-300T00
CODE: WGAC-MIC-PL-300T00
Microsoft Power Platform Functional Consultant - PL-200T00
CODE: WGAC-MIC-PL-200T00
Microsoft Identity and Access Administrator - SC-300T00
CODE: WGAC-MIC-SC-300T00
Administering a SQL Database Infrastructure - 20764
CODE: WGAC-MIC-20764
Microsoft Security, Compliance and Identity Fundamentals - SC-900T00
CODE: WGAC-MIC-SC-900T00
Microsoft Azure solutions for AWS Developers - AZ-020T00
CODE: WGAC-MIC-AZ-020T00
Developing solutions for Microsoft Azure - AZ-204T00
CODE: WGAC-MIC-AZ-204T00
Microsoft Dynamics 365 Supply Chain Management, Manufacturing - MB-320T00
CODE: WGAC-MIC-MB-320T00
Designing and Implementing Microsoft DevOps solutions - AZ-400T00
CODE: WGAC-MIC-AZ-400T00
Querying Data with TransactSQL - 20761
CODE: WGAC-MIC-20761
Microsoft Dynamics 365 Commerce Functional Consultant - MB-340T00
CODE: WGAC-MIC-MB-340T00
Designing Microsoft Azure Infrastructure Solutions - AZ-305T00
CODE: WGAC-MIC-AZ-305T00
Microsoft Dynamics 365 Field Service - MB-240T00
CODE: WGAC-MIC-MB-240T00
Microsoft 365 Messaging - MS-203T00
CODE: WGAC-MIC-MS-203T00
Migrate NoSQL workloads to Azure Cosmos DB - DP-060T00
CODE: WGAC-MIC-DP-060T00
Configuring and Operating a Hybrid Cloud with Microsoft Azure Stack Hub - AZ-600T00
CODE: WGAC-MIC-AZ-600T00
Microsoft Azure Architect Design - AZ-304T00
CODE: WGAC-MIC-AZ-304T00
Microsoft Power Platform Solution Architect - PL-600T00
CODE: WGAC-MIC-PL-600T00
Microsoft Dynamics 365 Business Central Functional Consultant - MB-800T00
CODE: WGAC-MIC-MB-800T00
Azure Stack HCI - WS-013T00
CODE: WGAC-MIC-WS-013T00
Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB - DP-420T00
CODE: WGAC-MIC-DP-420T00
Implementing an Azure Data Solution - DP-200T01
CODE: WGAC-MIC-DP-200T01
Microsoft Teams Voice Engineer - MS-720T00
CODE: WGAC-MIC-MS-720T00
Data Engineering on Microsoft Azure - DP-203T00
CODE: WGAC-MIC-DP-203T00
Microsoft 365 Mobility and Security - MS-101T00
CODE: WGAC-MIC-MS-101T00
Microsoft Azure technologies for AWS architects - AZ-030T00
CODE: WGAC-MIC-AZ-030T00
Microsoft Dynamics 365 Fundamentals Finance and Operations Apps (ERP) - MB-920T00
CODE: WGAC-MIC-MB-920T00
Designing and Implementing Microsoft DevOps Solutions - AZ-400T00
CODE: WGAC-MIT-AZ-400T00
Microsoft Dynamics 365 Supply Chain Management - MB-330T00
CODE: WGAC-MIC-MB-330T00
Designing and Implementing a Data Science Solution on Azure - DP-100T01
CODE: WGAC-MIC-DP-100T01
Administering Windows Server Hybrid Core Infrastructure - AZ-800T00
CODE: WGAC-MIC-AZ-800T00
Windows Client - MD-100T00
CODE: WGAC-MIC-MD-100T00
Microsoft 365 Security Administrator - MS-500T00
CODE: WGAC-MIC-MS-500T00
Transact-SQL Querying - DP-080T00
CODE: WGAC-MIC-DP-080T00
Microsoft Azure Security Technologies - AZ500T00
CODE: WGAC-MIC-AZ-500T00
Microsoft Security Operations Analyst - SC-200T00
CODE: WGAC-MIC-SC-200T00
Microsoft Azure Fundamentals - AZ-900T01
CODE: WGAC-MIC-AZ-900T01
Power Platform App Maker - PL-100T00
CODE: WGAC-MIC-PL-100T00
Microsoft Dynamics 365 Fundamentals Customer Engagement Apps (CRM) - MB-910T00
CODE: WGAC-MIC-MB-910T00
Microsoft Dynamics 365: Core Finance and Operations - MB-300T00
CODE: WGAC-MIC-MB-300T00
Administering Relational Databases on Microsoft Azure - DP-300T00
CODE: WGAC-MIC-DP-300T00
Automating Administration with PowerShell - AZ-040T00
CODE: WGAC-MIC-AZ-040T00
Microsoft Power Platform Fundamentals - PL-900T00
CODE: WGAC-MIC-PL-900T00
Migrate SQL workloads to Azure - DP-050T00
CODE: WGAC-MIC-DP-050T00
Designing and Implementing an Azure AI Solution - AI-100T01
CODE: WGAC-MIC-AI-100T01
Designing an Azure Data Solution - DP-201T01
CODE: WGAC-MIC-DP-201T01
Installation, Storage, and Compute with Windows Server 2016 - 20740
CODE: WGAC-MIC-20740
Microsoft Azure IoT Developer - AZ-220T00
CODE: WGAC-MIC-AZ-220T00
Configuring Windows Server Hybrid Advanced Services - AZ-801T00
CODE: WGAC-MIC-AZ-801T00
Microsoft Azure Fundamentals - AZ-900T00
CODE: WGAC-MIC-AZ-900T00
Microsoft Dynamics 365: Finance and Operations Apps Solution Architect - MB-700T00
CODE: WGAC-MIC-MB-700T00
Microsoft 365 Identity and Services - MS-100T00
CODE: WGAC-MIC-MS-100T00
Microsoft Dynamics 365 Sales - MB-210T01
CODE: WGAC-MIC-MB-210T01
Managing Modern Desktops - MD-101T00
CODE: WGAC-MIC-MD-101T00
Microsoft Information Protection Administrator - SC-400T00
CODE: WGAC-MIC-SC-400T00
Planning and Administering Microsoft Azure for SAP Workloads - AZ-120T00
CODE: WGAC-MIC-AZ-120T00
Managing Microsoft Teams - MS-700T00
CODE: WGAC-MIC-MS-700T00
Microsoft Dynamics 365 Marketing - MB-220T00
CODE: WGAC-MIC-MB-220T00
Microsoft Azure Data Fundamentals - DP-900T00
CODE: WGAC-MIC-DP-900T00
Migrate Open Source Data Workloads to Azure - DP-070T00
CODE: WGAC-MIC-DP-070T00
Azure Administration for AWS SysOps - AZ-010T00
CODE: WGAC-MIC-AZ-010T00
Implementing a Machine Learning Solution with Azure Databricks - DP-090T00
CODE: WGAC-MIC-DP-090T00
We use cookies to understand how you use our site and to improve your experience. To learn more, click here. Read our revised Privacy Policy and Terms and Conditions.