nohasabb2005-spec/Morocco-Education-Data-Intelligence-Platform
Domain:
educationRecord type:
project
Creator:
noh
Host:
# 🎓 Morocco Education Data Intelligence Platform
A modern Business Intelligence and Data Engineering platform designed to analyze the Moroccan education system using a Lakehouse-inspired architecture.
---
## 📌 Project Overview
The **Morocco Education Data Intelligence Platform** centralizes educational data from multiple CSV sources into a modern analytics platform.
The project follows an **ELT architecture**, where raw data is stored in **MinIO**, transformed using **dbt**, organized into a **PostgreSQL Data Warehouse** (Bronze, Silver, Gold), and finally visualized with **Power BI** dashboards.
---
## 🎯 Objectives
- Centralize educational datasets
- Improve data quality
- Build a dimensional Data Warehouse
- Automate data transformation with dbt
- Create interactive Power BI dashboards
- Support educational decision-making through KPIs
---
# 🏗️ Architecture
```text
+------------------------+
| CSV Datasets |
+-----------+------------+
|
v
+------------------------+
| MinIO |
| Data Lake |
+-----------+------------+
|
v
+------------------------+
| PostgreSQL |
| Bronze |
+-----------+------------+
|
v
+------------------------+
| dbt |
| Silver |
+-----------+------------+
|
v
+------------------------+
| dbt |
| Gold |
+-----------+------------+
|
v
+------------------------+
| Power BI |
| Dashboards & KPIs |
+------------------------+
```
---
# 🗂️ Data Sources
The platform integrates five educational datasets:
- 👨🎓 Students
- 👨🏫 Teachers
- 📝 National Exams
- 🤝 Social Support Programs
- 📚 Adult Literacy Programs
---
# 📊 Data Warehouse Design
## Bronze Layer
Raw data loaded from MinIO.
Tables
- bronze.eleves
- bronze.enseignants
- bronze.examens
- bronze.appui_social
- bronze.alphabetisation
---
## Silver Layer
Data cleaning and transformation.
Operations include:
- Remove duplic …