This module provides a foundational introduction to the Microsoft Power Platform and its four primary components: Power Apps, Power Automate, Power BI, and Power Virtual Agents. You ll understand the capabilities and roles of each tool and prepare to explore the platform through hands-on labs.

Lessons:

• Overview of the Microsoft Power Platform and its components

Lab:

• Validate the lab environment to ensure readiness for practical exercises

After completing this module, students will be able to:

• Identify and distinguish the key components of the Power Platform

• Articulate the role and responsibilities of a Power Platform Functional Consultant

This module is focused on developing the role and mindset of a Power Platform Functional Consultant. You ll learn how to engage effectively with stakeholders, capture and validate business requirements, create essential documentation, and ensure quality through integrations and solution mappings.

Lessons:

• Overview of essential consultant skills (e.g., communication, requirement gathering, solution mapping)

• Techniques for creating and validating documentation such as process flows and requirement diagrams

• Strategies for engaging stakeholders with demonstrations and interactive sessions

• Performing quality assurance to ensure solution effectiveness and user satisfaction

• Planning and configuring integrations to extend the Power Platform s capabilities

Lab:

• Creating and using documentation artifacts like entity-relationship diagrams

• Engaging stakeholders through demo scenarios

• Designing integration workflows to connect components or external services

After completing this module, students will be able to:

• Engage stakeholders effectively by presenting live demos of Power Platform components

• Develop clear relationship diagrams that illustrate data and entity structures

• Design and propose integration strategies aligning with functional requirements

• Collaborate efficiently with both consultant peers and client teams to align on solution delivery

This module dives into the responsibilities, core competencies, and deliverables of the Power Platform Functional Consultant. You ll explore best practices for stakeholder engagement, documentation, quality assurance, and the integration components required to translate business needs into successful digital solutions.

Lessons:

• Consultant skills and responsibilities overview

• Creating and validating solution documentation

• Engaging with stakeholders effectively

• Performing quality assurance for delivered solutions

• Configuring integrations with external systems

Lab:

• Engage stakeholders via demonstration-based sessions

• Develop table/entity relationship diagrams for solution mapping

• Design integration scenarios between Power Platform components and systems

After completing this module, students will be able to:

• Communicate effectively with business stakeholders using demonstrations and documentation

• Create conceptual diagrams that map entities and relationships in Dataverse

• Design integration flows that link Power Platform applications to external systems

• Collaborate confidently with both consulting and customer teams to ensure alignment

In this module, you will explore the business value and configuration of the three types of Power Apps: Model-driven, Canvas, and Portals. You ll learn design and user experience considerations specific to each type, enabling you to deliver tailored application experiences across various business scenarios.

Lessons:

• Create Model-Driven Apps: understand data-driven design, common UI patterns, and scenarios

• Build Canvas Apps: focus on pixel-perfect layout, UI customization, and leveraging data sources

• Configure Portal Apps: deliver external-facing web experiences with secure data integration

Lab:

• Using the App Designer to build apps

• Modifying forms and views for better user workflows

• Building dashboards to visualize app data

• Practicing Canvas App fundamentals and working with varied data sources and services

• Applying user experience best practices in app design

After completing this module, students will be able to:

• Connect Power Apps to underlying data sources and structures

• Build functional Power Apps tailored to specific business needs

• Design intuitive, responsive, and effective application user experiences

In this module, you will learn how to automate business processes using Power Automate. You ll explore creating automated flows, designing guided business process flows, and understanding the basics of robotic process automation (UI flows), enabling efficient and repeatable task automation.

Lessons:

• Build cloud flows using Power Automate to integrate services and trigger actions

• Design business process flows to guide users through multi-step processes

• Understand the concept and capabilities of UI flows for desktop automation

Lab:

• Managing users and configuring security roles as part of automation setup

• Creating and configuring business rules to scale business logic

• Building cloud flows including approval workflows

• Creating a business process flow with branching logic for dynamic user experiences

After completing this module, students will be able to:

• Create robust Power Automate flows that streamline and automate organizational tasks

• Design business process flows to enforce and guide user-driven workflows

• Understand the scenarios where UI flows (desktop automation) can be applied to mimic user interaction

In this module, you ll learn how to design and deploy interactive chatbots using Power Virtual Agents. The focus is on setting up dialogue topics, leveraging AI entities, integrating with automated processes, and ensuring a seamless customer or user experience.

Lessons:

• Create a chatbot with Power Virtual Agents

• Configure conversational topics to guide user interactions

• Integrate or trigger Power Automate flows within chatbot dialogues

• Define and configure entities to capture user input accurately

• Test chatbot behavior and publish it for production use

Lab: Create a Power Virtual Agents chatbot from scratch

• Design conversation topics and define corresponding entities

• Integrate a Power Automate flow into the chatbot for dynamic responses

• Test chatbot interactions and publish the bot for user access

After completing this module, students will be able to:

• Build a fully functional chatbot using Power Virtual Agents

• Embed automations within chatbot dialogues through Power Automate

• Create and manage conversation topics and entities to drive meaningful interactions

In this module, you will develop the ability to analyze data using Power BI, both on the desktop client and via the Power BI service. You will learn to model data, create compelling visualizations and dashboards, and deliver actionable insights. Additionally, you’ll explore how to export and share your reports with stakeholders for better collaboration and decision-making.

Lessons:

• Get started with Power BI (understand components and workflow)

• Model data effectively in Power BI

• Create visualizations to represent data insights

• Build interactive dashboards to monitor key metrics

• Publish and share Power BI content via Power BI Service

Lab:

• Building exportable templates (Word, Excel)

• Importing and exporting data within Power BI

• Detecting duplicate data patterns

• Performing bulk delete operations for cleanup

After completing this module, students will be able to:

• Create rich visualizations in Power BI that convey data-driven stories

• Ingest, model, and consume data effectively within Power BI toolsets

• Export visual content for stakeholders to support collaborative analysis