ShowsScans

ShowsScans tracks health inspections from 2010–2025, showing failure trends, inspection volume, and which facilities fail most.

Problem Statement

Health inspections are meant to keep people safe, but failure rates change a lot depending on the month, facility type, and how many inspections happen. This dashboard spots patterns, seasonal shifts, and the facilities that fail most — giving a clear view of where risks are higher.

Features

• Monthly inspection failure trends
• Inspection volume vs. failure rates
• Facility types with highest failure rates
• Interactive filters by year and facility type

Files

• pbix/ShowsScans.pbix — Power BI source file
• ShowsScanPBI.pdf — Dashboard Export (Quickview)
• ShowsScans_ChicagoFoodInspections_PrepClean.ipynb — Preprocessing Data, Engineering New Columns, to then go into PowerBI

Data Source

https://data.cityofchicago.org/Health-Human-Services/Food-Inspections/4ijn-s7e5/about_data

Download PowerBI Dashboard

https://github.com/showssteamrolls/ShowsScans/releases/tag/v1.0.0