Business Analysis with Power Platform Course

Lesson 1 • Dataverse Fundamentals for Business Analysts

Covers Dataverse tables, columns, and relationships as the primary data layer. Students can design simple data models aligned to business requirements.

Lesson 2 • Business Analysis Role in Low-Code Projects

Defines how traditional BA competencies apply within Power Platform delivery. Students understand where they add value versus developers and IT.

Lesson 3 • Setting Up the Development Environment

Guides students through provisioning a Power Platform environment for hands-on practice. Ensures every student has a functional workspace before building begins.

Lesson 1 • Capturing Requirements with Power Apps Forms

Uses canvas and model-driven forms to collect structured stakeholder input. Connects requirements capture directly to a reusable data store in Dataverse.

Lesson 2 • Stakeholder Surveys with Power Pages

Deploys external-facing portals to gather input from stakeholders outside the organisation. Students configure secure, branded survey experiences without custom code.

Lesson 3 • Organising and Prioritising Requirements

Builds a model-driven app to manage, categorise, and prioritise the requirements backlog. Students apply MoSCoW and other prioritisation techniques within the platform.

Lesson 1 • Business Process Modelling Concepts

Covers BPMN notation and swimlane diagrams as the analytical foundation for automation design. Students document as-is processes before proposing any automation.

Lesson 2 • Designing Approval and Escalation Flows

Builds multi-stage approval flows with escalation paths and deadline enforcement. Students automate common BA deliverable review cycles end to end.

Lesson 3 • Robotic Process Automation for Analysts

Introduces Power Automate Desktop for automating legacy desktop tasks identified during process analysis. Students record, edit, and run basic desktop flows.

Lesson 4 • Power Automate Flow Architecture

Explains flow types, connectors, and the action-trigger model that underpins all automation. Students select the correct flow type for each business scenario.

Lesson 1 • Importing, Exporting, and Migrating Data

Teaches data import via Excel, CSV, and dataflows to populate Dataverse tables. Students manage data quality during migration and initial load scenarios.

Lesson 2 • Relationships and Data Integrity

Covers one-to-many, many-to-many, and hierarchical relationships with cascade behaviours. Students enforce referential integrity rules that mirror business policies.

Lesson 3 • Dataverse Security and Compliance

Configures security roles, field-level security, and audit logging to meet governance requirements. Students align data access controls to organisational policies.

Lesson 1 • Integrating Apps with External Systems

Connects Power Apps to external data sources via connectors and custom APIs. Students extend app functionality beyond Dataverse to enterprise systems.

Lesson 2 • Model-Driven App Configuration

Builds model-driven apps using site maps, views, forms, and dashboards. Students configure data-centric apps that scale with growing Dataverse models.

Lesson 3 • Power Fx Formulas for Business Logic

Introduces Power Fx as the formula language for data manipulation and UI behaviour. Students encode business rules directly in the app without external code.

Lesson 4 • Testing and Deploying Power Apps

Covers app testing strategies, version control, and environment-based deployment pipelines. Students release apps through structured promotion from development to production.

Lesson 1 • DAX Measures for Business Metrics

Introduces DAX syntax and evaluation context to calculate key business metrics. Students write measures that answer specific stakeholder questions accurately.

Lesson 2 • Designing Effective Reports and Dashboards

Applies data visualisation best practice to report layout, visual selection, and interactivity. Students produce dashboards that communicate insights clearly to non-technical audiences.

Lesson 3 • Connecting and Shaping Data in Power Query

Uses Power Query to connect, clean, and transform data from multiple sources. Students prepare analysis-ready datasets before building any visuals.

Lesson 4 • Data Modelling in Power BI Desktop

Builds star schema models with fact and dimension tables for efficient reporting. Students create relationships and calculated columns that support complex analysis.

Lesson 1 • Power Platform Governance Frameworks

Defines governance policies for environment strategy, data loss prevention, and maker enablement. Students design governance models that balance control with business agility.

Lesson 2 • Pipelines and Automated Deployment

Configures Power Platform Pipelines and Azure DevOps for automated solution promotion. Students reduce manual deployment errors through repeatable CI/CD processes.

Lesson 3 • Monitoring, Auditing, and Compliance

Uses admin centre analytics, audit logs, and CoE dashboards to monitor platform health. Students identify risks and enforce compliance across the tenant.

Lesson 1 • User Acceptance Testing and Sign-Off

Designs UAT scripts, manages defect tracking, and obtains formal stakeholder sign-off. Students close the delivery loop with documented evidence of solution quality.

Lesson 2 • Capstone Presentation and Reflection

Students present the completed solution to a panel, articulating business value and lessons learned. Structured reflection consolidates learning and identifies growth areas.

Lesson 3 • Solution Handover and Knowledge Transfer

Produces end-user guides, admin documentation, and training materials for the delivered solution. Students ensure sustainable adoption beyond the project team.

Lesson 4 • Defining the Capstone Business Problem

Guides students through scoping a real or realistic business problem suitable for a full platform solution. Students produce a project charter and solution blueprint before building.