For a tutorial video that walks you through the process of using the Open Data Bits library of documentation to build your own open data mashups, we have created a video that can be watched by clicking here.

Data Source Link

https://nycopendata.socrata.com/Health/Restaurant-Inspection-Results/4vkw-7nck

Available Access Formats

.txt

Sources and Modeling

Row Color Derived Column
Row Color Column Not Used by Open Data Bits

Logical Model

Calculated Columns & Calculations

Name DAX Expression Type
AREA CODE =LEFT([PHONE],3) Calculated Column
PHONE PREFIX =MID([PHONE],4,3) Calculated Column
INSPDATE Date Key =DATE(YEAR([INSPDATE]),MONTH([INSPDATE]),DAY([INSPDATE])) Calculated Column
INSPDATE Time Key =TIME(HOUR([INSPDATE]),MINUTE([INSPDATE]),SECOND([INSPDATE])) Calculated Column
Inspection Count Inspection Count:=COUNTROWS(‘WebExtract’) Calculation
Graded Count Graded Count:=CALCULATE([Inspection Count],FILTER(‘WebExtract’,[CURRENTGRADE]<>””)) Calculation
C Grades C Grades:=CALCULATE([Inspection Count],FILTER(‘WebExtract’,[CURRENTGRADE]=”C”)) Calculation
Score Avg Score Avg:=CALCULATE(AVERAGE([SCORE]),FILTER(‘WebExtract’,[SCORE] <> BLANK())) Calculation
Score Min Score Min:=CALCULATE(MIN([SCORE]),FILTER(‘WebExtract’,[SCORE] <> BLANK())) Calculation
Score Max Score Max:=CALCULATE(MAX([SCORE]),FILTER(‘WebExtract’,[SCORE] <> BLANK())) Calculation

Examples for Reference

Open Data Bits – NYC Restaurant Inspections Results Open Data

Open Data Bits – Mash Up Minneapolis and New York City Restaurant Inspection Data