National Insurance Data Warehouse
An Egyptian Form 5 portfolio scenario covering synthetic data generation, cleaning, orchestration, SQL Server warehousing, and Power BI.
A question. A process.
Work you can explore.
Follow the decisions behind the implementation, then inspect the original work.
Chapter 1 of 4 · The question
The question behind the build.
Insurance-style records involve dates, repeated entities, and validation constraints. A useful warehouse needs consistent processing and explicit analytical views.
Follow the implementation.
- 01
Generate synthetic source records for the documented scenario.
- 02
Normalize datatypes, handle duplicates, and validate records.
- 03
Orchestrate processing and loading with Airflow.
- 04
Create SQL Server warehouse structures and analytical views for reporting.
Look beyond the project summary.
Inspect the generation, cleaning, loading, and SQL-validation modules as one connected workflow. The project puts local domain context into a reproducible learning scenario.
Choose where to look deeper.
Search the linked source inventory or narrow it to the kind of artifact you want to inspect. Files open at their original source.
7 linked source files
No linked files match this view.
The source
keeps moving.
Source updated
An end-to-end data pipeline and warehouse solution for managing and analyzing synthetic Egyptian National Insurance data (specifically Form 5 records). This repository covers the complete lifecycle of data, from raw data generation and orchestration to relational warehousing and Business Intelligence (BI) dashboards.
Current README excerpt
An end-to-end data pipeline and warehouse solution for managing and analyzing synthetic Egyptian National Insurance data (specifically Form 5 records). This repository covers the complete lifecycle of data, from raw data generation and orchestration to relational warehousing and Business Intelligence (BI) dashboards.
A source excerpt, not an independently verified outcome.