Food-Inspection-USA
Problem Statement
Explore Restaurant Food Inspections results over the period of 10 years to derive insights on
- Inspection over the years
- Inspection results
- Which restaurants were most inspected
- Which restaurants were involved in most violation
- Other inferences as observed during the course of visualization
Dataset
Chicago Food Inspection - OpenData
Architecture Diagram
Data Modelling
| Facts (Pink) | Dimensions (Blue) |
|---|---|
| fact_food_inspection | dim_facility_type |
| fact_inspection_violation | dim_geography |
| dim_inspection_result | |
| dim_inspection_result | |
| dim_inspection_type | |
| dim_inspection_restaurant | |
| dim_risk_category |
DBT Workflow
Visualization
-
Dashboard A
-
Dashboard B
-
Dashboard C