Microsoft Power Platform Course

Lesson 1 • Microsoft Dataverse Fundamentals

Introduces Dataverse as the shared data backbone of the platform. Students create tables, columns, and relationships to support app and flow development.

Lesson 2 • Power Platform Overview and Architecture

Covers the four pillars: Power Apps, Power Automate, Power BI, and Power Virtual Agents. Establishes the ecosystem context for all subsequent chapters.

Lesson 3 • Connectors and Data Sources

Explains standard, premium, and custom connectors that link platform tools to external services. Students configure connections used throughout the course.

Lesson 1 • App Navigation and UX Design

Applies navigation patterns and responsive layout techniques to improve usability. Students implement consistent branding and accessible control sizing.

Lesson 2 • Power Fx Formulas and Logic

Teaches the Excel-like Power Fx language for binding data and controlling behaviour. Students write formulas for navigation, filtering, and conditional display.

Lesson 3 • Publishing and Sharing Canvas Apps

Covers app versioning, publishing, and permission assignment to end users. Students share apps with groups and validate access through different roles.

Lesson 4 • Forms, Galleries, and Data Binding

Connects UI controls to Dataverse and other data sources for read and write operations. Students build list-detail screens with galleries and edit forms.

Lesson 1 • Model-Driven App Architecture

Contrasts model-driven and canvas app paradigms and explains when each is appropriate. Students configure a new model-driven app shell in a solution.

Lesson 2 • Business Rules and Process Flows

Implements no-code business logic using business rules and business process flows. Students enforce field requirements and guide users through multi-stage processes.

Lesson 3 • Advanced Dataverse Schema Design

Extends Dataverse knowledge to choices, calculated columns, and rollup fields. Students design a normalised schema supporting complex business scenarios.

Lesson 4 • Security and Role-Based Access

Configures Dataverse security roles, field-level security, and team ownership. Students apply least-privilege access to protect sensitive business data.

Lesson 1 • Error Handling and Flow Reliability

Applies scope actions, run-after settings, and retry policies to build resilient flows. Students implement centralised error notification and flow recovery patterns.

Lesson 2 • Actions, Expressions, and Dynamic Content

Teaches action configuration, dynamic content mapping, and expression authoring. Students transform and route data between connectors using built-in functions.

Lesson 3 • Conditions, Loops, and Parallel Branches

Implements control flow using conditions, switch cases, and apply-to-each loops. Students build flows that process arrays and execute parallel operations efficiently.

Lesson 4 • Power Automate Flow Types and Triggers

Distinguishes cloud flows, desktop flows, and business process flows by use case. Students select appropriate triggers for automated, instant, and scheduled scenarios.

Lesson 1 • Power BI Desktop Interface and Data Import

Introduces the Power BI Desktop workspace and data import from multiple sources. Students connect to files, databases, and cloud services to load datasets.

Lesson 2 • Data Transformation with Power Query

Uses Power Query Editor to clean, reshape, and merge datasets before modelling. Students apply transformations that produce analysis-ready tables.

Lesson 3 • Report Design and Publishing

Applies visual best practices to build clear, interactive reports with slicers and drill-through. Students publish to Power BI Service and configure workspace sharing.

Lesson 4 • Data Modelling and Relationships

Builds star-schema models with fact and dimension tables linked by relationships. Students configure cardinality, cross-filter direction, and calculated tables.

Lesson 1 • Bot Testing, Analytics, and Deployment

Uses the test pane, analytics dashboard, and escalation settings to validate and improve bots. Students publish bots to Teams and web channels with proper authentication.

Lesson 2 • Chatbot Design Fundamentals

Introduces conversational design principles and the Power Virtual Agents authoring canvas. Students map user intents to topics before building any bot logic.

Lesson 3 • Building Topics and Conversation Flows

Constructs topic nodes including messages, questions, conditions, and variable storage. Students create branching conversations that handle multiple user paths.

Lesson 1 • Power Platform Pipelines

Configures built-in pipelines to automate solution promotion across environments. Students run and monitor pipeline deployments with approval gates.

Lesson 2 • Solutions and Component Management

Explains managed and unmanaged solutions as deployment containers for platform artefacts. Students add apps, flows, and tables to solutions and manage dependencies.

Lesson 3 • Exporting, Importing, and Patching

Covers solution export, import, and patch creation for incremental updates. Students migrate changes between environments without overwriting unrelated customisations.

Lesson 4 • Cross-Platform Integration Patterns

Implements integration between Power Platform and Azure services using connectors and APIs. Students connect apps and flows to Azure Functions, Service Bus, and Logic Apps.

Lesson 1 • Tenant-Level Administration

Navigates the Power Platform admin centre to manage capacity, environments, and policies. Students configure tenant settings that govern all makers and users.

Lesson 2 • Enterprise Security Architecture

Applies conditional access, managed identities, and customer-managed keys to harden the platform. Students design a layered security model aligned with organisational standards.

Lesson 3 • Data Loss Prevention Policy Design

Creates DLP policies that classify connectors into business and non-business groups. Students apply environment-scoped and tenant-scoped policies to prevent data leakage.

Lesson 4 • Centre of Excellence Toolkit

Deploys the CoE Starter Kit to gain visibility into platform usage and enforce governance. Students configure inventory, compliance, and nurture components.