Grains: 

1. The number of restaurant in NYC
2. The number of compliances in different areas
3. The number of compliance from march 2018 to March 2020

Fact tables:

1. Number_restaurant table has RESTAURANT, DAY,  MONTH, YEAR, LOCATION
2. Number_compliance table has COMPLIANCE, TYPE, LOCATION, DAY,MONTH, YEAR
3. Number_compliance_2018-2020 table has COMPLIANCE, TYPE, LOCATION, DAY,MONTH, YEAR

Dimensions:

1. Restaurant: RestaurantID,name,type,AddressID,phone number
2. Compliance: ComplianceID,type, description,BoroughsID,DateID
3. Boroughs of NYC: BoroughsID,name
4. Address: AddressID,borough, zip code, street, longitude,latitude
5. Date: DateID, day, month, year
6. Location: LocationID, type, landmark

KPIs：

1. Number of restaurants in different areas/boroughs
2. Compliance over time (before and during COVID-19)
3. The number of compliances in different areas/boroughs

Datasets:

1. 311 THE Service Requests from 2010 to Present https://data.cityofnewyork.us/Health/DOHMH-New-York-City-Restaurant-Inspection-Results/43nn-pn8j
2. DOHMH New York City Restaurant Inspection Results https://data.cityofnewyork.us/Social-Services/311-Service-Requests-from-2010-to-Present/erm2-nwe9/data
3.  Restaurant data 2020

Dimensional Model: