Mohamed-Abdelaaty/Enterprise-BI-Solution-for-Digital-Egypt-Pioneers-Initiative-DEPI-
Domain:
socioeconomicCreator:
Moh
Host:
Enterprise BI solution: PostgreSQL QC pipeline, Power BI model & DAX measures for DEBI Round 5 training program.
๐ช๐ฌ Enterprise BI Solution for Digital Egypt Pioneers Initiative (DEPI)
An end-to-end Business Intelligence solution for DEBI Round 5 โ from raw PostgreSQL data,
through automated daily quality checks, to a full Power BI semantic model and report.
---
## ๐ Overview
**DEPI_R5_Report** gives the Digital Egypt Builders Initiative (DEBI)
Round 5 program team the operational insight needed to manage and improve training delivery โ
covering trainees, training providers (TPs), groups, instructors, halls, and sessions โ so the
client can make timely decisions on session planning, quality, and trainee outcomes.
| | |
|---|---|
| **Initiative** | Digital Egypt Builders Initiative (DEBI), Ministry of Communications and Information Technology (MCIT) |
| **Vendor** | WAVZ For Digital Transformation |
| **Role** | BI Engineer โ end-to-end solution design, data modeling, DAX, and report authoring |
| **Source system** | PostgreSQL |
| **BI platform** | Power BI Desktop โ PBIP/PBIR project format, TMDL semantic model definitions |
This repo documents the full solution: the data-quality layer in SQL, the automated daily
QC-and-email pipeline in Python, the star-schema semantic model, the DAX measure library, and
the Power BI report itself.
---
## ๐ฏ Objectives & Scope
The client requested a single report delivering insight across six subject areas:
- **Trainees** โ demographics, attendance, performance
- **Training Providers (TPs)** โ delivery volume and quality
- **Groups** โ round/group-level tracking and target progress
- **Instructors** โ assignment and performance *(on hold โ see Known Gaps)*
- **Halls** โ physical-session capacity and quality
- **Sessions** โ planned vs. conducted vs. non-conducted, online and physical
---
## ๐๏ธ Architecture
```
PostgreSQL (source)
โ
โโโ 7 daily QC views โโโโโโโบ qc_pipeline.py โโโโโโโบ CSV exports + Outlook email
โ (daily automated data quality report)
โ
โโโ Fact โฆ