/Boston-Food-Inspection-Data-Analysis

An examination of a dataset collecting data from food inspections conducted at several Boston restaurants.

Boston-Food-Inspection-Data-Analysis

  • Analyzed the Boston Food Inspection dataset containing about 600,000+ inspection and violation records
  • Built a systematic Dimensional Model for the dataset using ER/Studio, creating the essential dimensions and fact
  • Employed Alteryx to clean, prepare and push the data in Google BigQuery, reducing manual work by 75%
  • Developed SQL queries and reports to retrieve necessary data, in-line to the business requirements