A full data pipeline ingesting Louisville's public health inspection data nightly from the city's ArcGIS open data portal, transforming it into an analytics-ready star schema, and surfacing it through an interactive Metabase dashboard.
Paginated fetch from Louisville's ArcGIS FeatureServer with retry logic. Runs daily on cron.
Raw snapshot loaded into MySQL 8.0 staging table. Truncate-and-reload each run.
Unpivots into star schema: dim_restaurant + fact_inspection. Idempotent upserts.
Self-hosted Metabase with KPIs, trends, grade breakdowns, and zip code search.