Demo data · Browser-based ETL · dbt-style quality gates
ETL Pipeline — Interactive Simulator
Generate realistic multi-source operational data, run extraction, staging, transformation and mart-building steps, then inspect data quality, business impact and final reporting outputs. This is a safe portfolio simulator: no client data is used.
Portfolio purpose: Shows how automated reporting can reduce manual work, improve data quality and accelerate decision-making.
Manual time saved
—
Estimated weekly analyst effort avoided
Report turnaround
—
From manual collation to automated refresh
Quality score
—
Rows passing validation checks
Reporting mart
—
Clean rows ready for BI tools
1
Extract
Simulates ERP, CRM, HRIS, field operations and donor data arriving through APIs, CSV and SQL-like feeds.
2
Transform & Test
Cleans data types, deduplicates records, validates business rules and blocks poor-quality rows from marts.
3
Load & Report
Builds a reporting fact table, calculates KPIs and exports a mart that can feed Power BI or Excel.
dbt-style quality gates
Source summary
Disbursement / value by programme
Pipeline runtime vs SLA
Impact explained
Scenario notes
fct_pipeline_reporting — mart output preview
Clean reporting table produced after staging, business rules and mart transformations.
⚙️
Ready to run pipeline
Click Generate & Run Pipeline to create demo data, run extraction, staging, transformation, quality tests and final mart output. You can also upload your own CSV with similar fields.