Duration: 3 Days (Instructor-Led)
Price: £1,800 – £2,200 per participant
Delivery Mode: Classroom / Virtual / Hybrid
Course Overview
This advanced 3-day bootcamp combines Microsoft Dynamics 365 Dataverse Multi-Environment Pro Manager (v3.3) with Microsoft Power BI to deliver end-to-end operational analytics for the Education sector. Participants will ingest, stage, deduplicate, analyze, and visualize multi-environment Dataverse data, then publish governed dashboards directly into Power BI for enterprise and executive reporting.
Learning Objectives
– Build governed Dataverse → Power BI analytics pipelines
– Perform multi-environment ingestion and reconciliation
– Design staging tables optimised for BI models
– Create Power BI semantic models from Dataverse data
– Deliver executive-ready dashboards
– Maintain auditability and security across platforms
Course Schedule (3 Days)
Day 1 – Dataverse Foundations & Data Engineering
• Multi-environment strategy (DEV / UAT / PROD)
• Dataverse schema & metadata analysis
• Bulk ingestion (files, APIs, AI)
• Staging tables for analytics
• Lab: build analytics-ready staging tables
Day 2 – Analytics, Deduplication & Power BI Integration
• Deduplication & data quality workflows
• Query → Staging optimisation
• Power BI connection patterns (DirectQuery vs Import)
• Dataflows & semantic models
• Lab: connect Dataverse staging tables to Power BI
Day 3 – Visualisation, Governance & Executive Reporting
• Visual Query Studio & pivot design