Skip to content

dev-kudli/Food-Inspection-USA

Repository files navigation

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

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

data model

DBT Workflow

dag

Visualization

  • Dashboard A Dashboard_A

  • Dashboard B Dashboard_B

  • Dashboard C Dashboard_C

About

Data Engineering of Dallas and Chicago food inspections

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published