Self-hosted analytics projects built on real-world data — from IoT sensor streams to public open data. Each one covers ingestion, transformation, and interactive visualization end to end.
Tracks electric vehicle charging energy, calculates electricity costs at a configurable rate, and estimates monthly savings versus an equivalent gasoline vehicle. Includes cumulative savings over time and daily cost comparisons.
Nightly ETL pipeline ingests food service inspection data from Louisville's ArcGIS open data portal, transforms it into a star schema in MySQL, and surfaces KPIs, grade distributions, score trends, and zip code search through Metabase.