Course Outline
Day 1 · Developer Foundations
- S1 Object model and APIs — How Power BI is structured for programmatic access.
- S2 Advanced Power Query — Custom M functions, error handling and query parameters.
- S3 Dataflows — Reusable, centralised transformation logic.
- S4 Source control — Tabular Editor, TMDL and lifecycle approaches.
- S5 Metadata and documentation — Automating model documentation.
LAB Build custom M functions, a shared dataflow and a source-controlled model.
OUTPUT Reusable dataflow, function library and source-controlled model.
Day 2 · Advanced DAX and Model Engineering
- S1 Advanced DAX patterns — Segmentation, ranking and virtual tables.
- S2 Calculation groups — Reusable calculation logic with Tabular Editor.
- S3 Composite models and aggregations — Blending import and DirectQuery with aggregations.
- S4 Performance tuning — DAX Studio, VertiPaq Analyzer and query plans.
- S5 Large-model strategies — Incremental refresh and hybrid tables.
LAB Diagnose and optimise a slow model using calculation groups and aggregations.
OUTPUT Optimised, documented, high-performance model.
Day 3 · Embedding and Automation
- S1 The REST API — Datasets, refreshes and workspace operations.
- S2 Power BI Embedded — Embed for your organisation and for your customers.
- S3 Scripting automation — PowerShell and Python for administration.
- S4 CI/CD — Deployment pipelines and automated release.
- S5 Governance and security — Service principals and tenant settings.
LAB Embed a report in a web page and automate dataset refresh via the API.
OUTPUT Embedded report with automated, secured refresh.
Day 4 · Custom Visuals, Integration and Capstone
- S1 Custom visual development — The visuals SDK with TypeScript and D3.
- S2 Power Platform integration — Power Automate flows and Power Apps.
- S3 Real-time and streaming datasets — Push datasets and live dashboards.
- S4 Solution architecture — Bringing the pieces together.
- S5 Capstone — Design and present a developer solution.
CAPSTONE Deliver an embedded, automated solution with a Power Platform integration.
OUTPUT Developer capstone solution.
Deliverables
- Dataflows and M functions
- Optimised model with calculation groups
- Embedded report and automation scripts
- Custom visual or Power Platform integration
KPIs
- Optimise a model with professional tooling
- Embed a report via the REST API
- Automate a deployment pipeline
Post-Course Roadmap
Recommended next steps: Microsoft Fabric, advanced custom visual development and enterprise Power Platform architecture.
Requirements
A foundational understanding of Power BI and prior programming experience are essential prerequisites for participation.
Testimonials (2)
workshops, practical examples
Martin Stuparek - Orange Slovensko, a.s.
Course - Monitoring with Grafana
The content is very helpful, and the trainer makes it more easier to understand
