- 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
-
Notifications
You must be signed in to change notification settings - Fork 0
desaikun1996/Boston-Food-Inspection-Data-Analysis
This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
About
An examination of a dataset collecting data from food inspections conducted at several Boston restaurants.
Topics
Resources
Stars
Watchers
Forks
Packages 0
No packages published