Index

All projects.

Four case studies plus one craft build. Every number you'll see is real and traceable to a repo.

01MarketFeed LakehouseMedallion architecture over Alpha Vantage and FRED data: immutable bronze, SCD Type 2 dimensions, and point-in-time-correct marts, orchestrated by Airflow and modeled in dbt.PythonAirflowdbtDuckDBSCD Type 22026

02Fineract Analytics PlatformApache Fineract → PostgreSQL → Debezium/Kafka → ClickHouse → dbt marts and ML features, orchestrated by Airflow with Prometheus/Grafana observability. The whole stack starts with one command.DebeziumKafkaClickHousedbtAirflow2026

03SignalTel Churn Intelligence7,021 customers scored; logistic regression chosen over gradient boosting for recall; F1 0.6129 and ROC-AUC 0.8397, served through a documented FastAPI service in Docker.scikit-learnFastAPIMachine LearningDockerpytest2026

04Tembo Hotel Analysis286 messy bookings cleaned to 285 in PostgreSQL, six business questions answered in SQL, and a three-page Power BI dashboard with 25 DAX measures.SQLPostgreSQLPower BIDAX2026

05DuewrightEngineering craftA task manager with one tested core and two thin interfaces, a CLI and REST API over the same business logic. Phase 1: the tested core, built test-first with ADRs.PythonpytestFastAPIDomain design2026

More experiments and practice repos live on GitHub.