Microsoft Power Platform Fundamentals
Data Analytics

Course Overview


This program equips participants with the knowledge and skills to design, build, and manage solutions using Microsoft Power Platform. Through guided lectures, interactive demonstrations, and hands-on labs, learners will master low-code/no-code tools to enhance business processes, leverage data effectively, and integrate AI-driven capabilities.



  • Duration: 16 hours / 2 days
  • Delivery Method: Classroom-based, Virtual Instructor Led Training


man holding tablet computer

Description

Learning Objectives

By the end of this course, participants will be able to:

  1. Articulate the strategic business value of Microsoft Power Platform services.
  2. Administer and govern the Power Platform environment securely and efficiently.
  3. Develop and deploy apps using Canvas and Model-Driven approaches.
  4. Automate workflows and processes using Power Automate’s cloud and desktop flows.
  5. Design and launch secure, branded, and functional web portals with Power Pages.


Target Audience

  • Aspiring app developers
  • Business analysts and process owners
  • IT professionals seeking low-code/no-code solutions
  • Entrepreneurs and small business owners
  • Anyone pursuing Microsoft certification in Power Platform Fundamentals



COURSE OUTLINE


Module 1: Business Value of Microsoft Power Platform

Learning Outcomes:

  • Explain the ecosystem and synergy of Power Platform components.
  • Map business challenges to Power Platform solutions.
  • Highlight integration benefits with Microsoft 365 and Teams.


Key Topics:

  • Overview of Power Apps, Power Automate, Power Pages, Dataverse, Connectors, Copilots, and Power FX.
  • AI-powered capabilities with Copilot Studio.
  • Extending solutions across organizational workflows.


Activity:

  • Case Study Discussion: Selecting the right Power Platform service for different business scenarios.


Module 2: Managing the Power Platform Environment

Learning Outcomes:

  • Differentiate Dataverse from traditional databases.
  • Manage tables, relationships, and business rules.
  • Apply governance, compliance, and security models.


Key Topics:

  • Dataverse structure and data modeling.
  • Data import/export options.
  • Admin centers and environment management.
  • Compliance with privacy and accessibility standards.


Activity:

  • Hands-On Lab: Creating Dataverse tables and configuring security roles.


Module 3: Power Apps Capabilities

Learning Outcomes:

  • Develop responsive Canvas Apps connected to multiple data sources.
  • Build and customize Model-Driven Apps from Dataverse tables.
  • Embed AI-driven Copilot features in apps.


Key Topics:

  • Canvas Apps: controls, data connections, responsive design, sharing.
  • Model-Driven Apps: forms, views, and business logic.
  • Copilot integration for enhanced UX.


Activity:

  • Workshop: Build a functional Canvas App and a Model-Driven App from scratch.


Module 4: Power Automate Capabilities

Learning Outcomes:

  • Design automated workflows for cloud and desktop processes.
  • Utilize triggers, actions, and templates effectively.
  • Apply conditional logic, loops, and branching for complex workflows.


Key Topics:

  • Cloud Flows: instant, automated, scheduled.
  • Desktop Flows: robotic process automation.
  • Integration with Microsoft Teams, Outlook, SharePoint, Forms, and approvals.
  • Process Mining for optimization insights.


Activity:

  • Hands-On Lab: Create a cloud flow to automate document approval and notifications.


Module 5: Power Pages Capabilities

Learning Outcomes:

  • Design and publish secure, branded web portals.
  • Configure security roles and permissions.
  • Customize themes and components for organizational branding.


Key Topics:

  • Power Pages architecture and use cases.
  • Copilot-assisted site creation.
  • Design studio workspaces and page creation.
  • Theme customization and component configuration.


Activity:

  • Workshop: Build and customize a Power Pages site with integrated Dataverse data.