Microsoft Power Course

Lesson 1 • Power Platform Overview and Components

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

Lesson 2 • Environment and Tenant Management

Defines environments as isolated containers for apps, flows, and data. Learners configure default and sandbox environments for safe development.

Lesson 3 • Connectors and Data Sources

Explains standard, premium, and custom connectors that link Power Platform to external data. Learners map data sources to appropriate connector types.

Lesson 1 • Connecting Apps to Data Sources

Demonstrates binding canvas apps to Dataverse, SharePoint, and SQL sources. Learners perform CRUD operations and handle delegation warnings.

Lesson 2 • Controls, Layouts, and Responsive Design

Covers galleries, forms, buttons, and containers for building adaptive UIs. Learners apply layout containers to support multiple screen sizes.

Lesson 3 • App Testing, Sharing, and Publishing

Covers quality assurance, version control, and distribution of canvas apps. Learners share apps with users and groups while managing permissions.

Lesson 4 • Power Fx Formulas and Logic

Introduces Power Fx as the declarative formula language driving app behaviour. Learners write expressions for filtering, navigation, and conditional logic.

Lesson 1 • Forms, Views, and Dashboards

Teaches customisation of main forms, quick-view forms, and system views. Learners assemble interactive dashboards from charts and view components.

Lesson 2 • Business Rules and Validation Logic

Applies no-code business rules to enforce field requirements and visibility. Learners configure scope settings to control rule execution context.

Lesson 3 • Security Model in Dataverse

Implements role-based access control using security roles, teams, and field-level security. Learners align data access to organisational hierarchy requirements.

Lesson 4 • Model-Driven App Architecture

Contrasts model-driven and canvas app paradigms to clarify when each is appropriate. Learners understand how Dataverse schema drives UI generation automatically.

Lesson 1 • Power Automate Flow Types and Triggers

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

Lesson 2 • Approval Workflows and Adaptive Cards

Designs multi-stage approval flows with escalation and timeout handling. Learners send Adaptive Cards to Teams for interactive in-channel approvals.

Lesson 3 • Working with Dynamic Content and Expressions

Uses dynamic content tokens and Power Automate expressions to manipulate data. Learners write functions for string, date, array, and conditional operations.

Lesson 4 • Actions, Conditions, and Control Logic

Builds flow logic using conditions, switches, loops, and parallel branches. Learners apply control actions to handle complex multi-path business processes.

Lesson 1 • DAX Measures and Calculations

Writes DAX measures for aggregations, time intelligence, and ratio analysis. Learners understand filter context and row context to produce accurate calculations.

Lesson 2 • Data Modelling and Relationships

Builds star schema models with fact and dimension tables for optimal DAX performance. Learners configure relationships, cardinality, and cross-filter direction.

Lesson 3 • Data Transformation with Power Query

Cleans and reshapes data using Power Query Editor before loading to the model. Learners apply transformations, merge queries, and manage query dependencies.

Lesson 4 • Power BI Desktop Interface and Data Import

Navigates Power BI Desktop views and imports data from multiple source types. Learners distinguish Report, Data, and Model views and their respective functions.

Lesson 1 • Power BI Service Navigation and Workspaces

Explores the Power BI Service interface and workspace roles for team collaboration. Learners create workspaces, assign roles, and organise content effectively.

Lesson 2 • Power BI Apps and Content Distribution

Packages workspace content into Power BI apps for broad organisational distribution. Learners configure app navigation, audience permissions, and update cycles.

Lesson 3 • Dashboards, Tiles, and Alerts

Builds service-side dashboards by pinning visuals and setting data-driven alerts. Learners differentiate reports and dashboards and apply Q&A natural language queries.

Lesson 4 • Dataflows and Centralised Data Prep

Creates reusable Power Query transformations as dataflows for shared data preparation. Learners link dataflows to datasets and schedule incremental refresh.

Lesson 1 • Variables and Slot Filling

Uses bot variables to capture, store, and reuse user input across conversation turns. Learners configure slot filling to collect required information efficiently.

Lesson 2 • Bot Deployment and Channel Configuration

Publishes bots to Microsoft Teams, web chat, and custom channels. Learners configure authentication, welcome messages, and channel-specific settings.

Lesson 3 • Bot Analytics and Continuous Improvement

Analyses bot performance using built-in analytics to identify escalation and abandonment. Learners refine trigger phrases and topics based on session data.

Lesson 4 • Integrating Power Automate with Bots

Connects bots to Power Automate flows for data retrieval and action execution. Learners pass input and output variables between bot topics and flow steps.

Lesson 1 • Cross-Product Integration Patterns

Designs integration scenarios combining Power Apps, Power Automate, Power BI, and Teams. Learners apply event-driven and API-based patterns to enterprise workflows.

Lesson 2 • Custom Connectors and API Integration

Builds custom connectors from OpenAPI definitions to extend platform connectivity. Learners configure authentication, actions, and triggers for proprietary APIs.

Lesson 3 • Solutions and Application Lifecycle Management

Packages apps, flows, and tables into managed and unmanaged solutions for deployment. Learners use pipelines and environment variables to promote solutions across stages.

Lesson 4 • Power Apps Component Framework

Introduces PCF controls for building reusable, code-based UI components. Learners scaffold, develop, and deploy PCF controls within model-driven apps.