Training programme overview
Advanced course focused on using Codex to drive BI workflows: CSV profiling, star-schema modeling and data marts, DAX expressions, Power BI semantic models, executive reporting and pipeline automation.
Covers using Codex as an assistant to analyze and profile CSVs, generate cleaning SQL and detect anomalies with targeted queries.
Presents star-schema design and building data marts tailored for decision reporting.
Details writing and optimizing DAX expressions and structuring a Power BI semantic model for exploration and KPI delivery.
Shows how to prepare executive narrative reports and automate dataset ingestion, quality checks and deployment.
Training · Advanced
Courses included in this training programme
Advanced BI Methodology with Codex
Advanced BI methodology using Codex to embed AI into data analysis and reporting workflows. Covers Codex’s role, prompt engineering, organizing an analytical workspace, and human review rules to produce reproducible analyses.
4 lessons · 14 activities · 0 exercises · 0 videos
Advanced CSV and SQL Profiling
Advanced CSV and SQL profiling techniques using DuckDB and Codex. Includes CSV ingestion, automated data quality assertions, Codex-assisted SQL profiling, and reading/optimizing EXPLAIN plans to strengthen BI analytics.
4 lessons · 10 activities · 1 exercises · 0 videos
BI Modeling and Data Marts
BI modeling approach and data mart construction with Codex: star schema design, building fact and dimension tables, data mart validation, and documentation and lineage of transformations.
4 lessons · 8 activities · 1 exercises · 0 videos
Excel BI with Codex
Using Excel for BI supported by Codex: CSV consolidation with Power Query, Power Pivot data modeling, DAX and building auditable dashboards. Includes practical exercises for each step.
4 lessons · 8 activities · 1 exercises · 0 videos
Power BI, Advanced DAX and Semantic Model
Deepen Power BI skills by building a robust semantic model and mastering advanced DAX. This module covers loading test datasets, filter context and time intelligence, performance analysis and semantic model documentation to support optimized reporting.
4 lessons · 8 activities · 1 exercises · 0 videos
Executive Reporting and BI Storytelling
Design executive reports and BI storytelling focused on decision-making. This module addresses decision framing, building KPI trees, report design and using Codex to craft executive summaries and construct clear dashboards.
4 lessons · 8 activities · 1 exercises · 0 videos
Automation, Quality and Deployment
Automate, test and deploy Power BI solutions while ensuring quality and governance. The module covers BI testing and non-regression, generated documentation and review, Power BI/Fabric deployment scenarios and governance of the Codex agent for automation.
4 lessons · 8 activities · 1 exercises · 0 videos
Final Certification Project
Complete a final project articulating diagnosis, KPIs, dashboard and executive delivery. The module provides a project brief, data loading, KPI production, dashboard construction and preparation of an executive delivery accompanied by a prompt log of the work.
4 lessons · 9 activities · 1 exercises · 0 videos
Access the platform
Open the catalogue to review course details, access conditions, and your personal progress. Sign in.