Microsoft Power Platform Functional Consultant

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.

Topics:

• Microsoft Power Platform overview
• Lab: Validate lab environment

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.

Topics:

• 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

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.

Topics:

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

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.

Topics:

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

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.

Topics:

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

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.

Topics:

• Business rules
• Power Automate overview
• Lab: Configure a new business rule
• Lab: Create security roles
• Lab: Create users
• Lab: 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.

Topics:

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

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.

Topics:

• Build desktop flows
• Use desktop flows
• Process advisor

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.

Topics:

• 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

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.

Topics:

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

Module 11: Analyze data with Power Bi

Building Flows with Power Automate

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

Topics:

• 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

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.

Topics:

• 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