// PROJECTS

Projects by Role Fit

A focused set of projects for Data Engineering, Analytics Engineering, BI reporting and automation roles. Use the filters to quickly match the evidence to the role you are hiring for.

// DATA ENGINEERING & ANALYTICS ENGINEERING PROJECTS

Data Engineering & Analytics Engineering Projects

Pipeline, modelling, quality and reporting-layer projects for operational and analytical datasets.

DB Train Delay and Route Reliability Pipeline

Role fit: Data Engineering / Analytics Engineering

Tools: Python, PySpark, dbt, Streamlit, API ingestion, data quality

Business problem: German rail routes needed route-level reliability views for delays, cancellations and disruption signals.

What I built: Built a German rail reliability pipeline using API ingestion, Bronze/Silver/Gold data layers, dbt models and route-level KPIs for delay, cancellation and route performance analysis.

Outcome: Computed 11+ route reliability KPIs including average delay, cancellation rate and route category performance.

GitHub README

Smart Energy Forecasting Pipeline

Role fit: Data Engineering / Analytics Engineering

Tools: Python, SQL, dbt, ADLS, forecasting metrics

Business problem: Energy optimization needs trusted datasets across electricity, solar, weather and cost indicators.

What I built: Built an energy data pipeline for electricity, solar, weather and cost data, producing forecasting-ready datasets and decision metrics for energy optimization.

Outcome: Supported 12% potential energy savings analysis using forecast error and energy cost indicators.

GitHub README

Electricity Insights Pipeline

Role fit: Analytics Engineering / BI Analytics

Tools: Python, PostgreSQL, Streamlit, ML metrics

Business problem: Electricity demand and renewable contribution needed structured analytical outputs for comparison and forecasting review.

What I built: Built a PostgreSQL-backed analytics pipeline with machine learning outputs, dashboard views and model evaluation metrics for electricity demand and renewable energy analysis.

Outcome: Created reusable analytical views for demand trends, renewable contribution and forecasting accuracy.

GitHub README

// BI & DATA ANALYTICS PROJECTS

BI & Data Analytics Projects

Dashboard, KPI and exploratory analysis projects for business-facing reporting.

Stroke Risk Analytics Power BI dashboard

Stroke Risk Analytics Dashboard

Role fit: BI Analyst / Healthcare Data Analyst

Tools: Power BI, DAX, Power Query

Business problem: Healthcare risk factors needed a clear reporting view for pattern analysis across patient attributes.

What I built: Built a Power BI healthcare dashboard using 5,110 patient records to analyze stroke risk patterns by age, BMI, glucose, hypertension, heart disease and smoking status.

Outcome: Created clear KPI views and filters for healthcare risk pattern analysis.

GitHub README

Electricity and Renewable Energy Insights Dashboard

Role fit: Data Analyst / BI Analyst

Tools: Python, Streamlit, PostgreSQL, charts

Business problem: Energy analysis needed clear views of demand, renewables and forecasting quality.

What I built: Created dashboard views for actual vs predicted electricity load, renewable contribution, forecast error and model performance.

Outcome: Helped compare demand trends, renewable contribution and forecasting accuracy.

GitHub README

Wine Quality Analysis

Role fit: Data Analyst / EDA

Tools: Python, Pandas, visualization, Jupyter Notebook

Business problem: Wine quality data needed cleaning and visual exploration to identify drivers of quality scores.

What I built: Performed data cleaning, exploratory analysis and visualizations to identify how alcohol, acidity, sugar and wine type relate to wine quality scores.

Outcome: Converted raw wine quality data into clear analytical insights and visual patterns.

GitHub README