Project Milestone 2 – KPI’s and Data Source

  • Data Sources:
    • TLC Trip Record Data:
      • https://www1.nyc.gov/site/tlc/about/tlc-trip-record-data.page
    • Weather Data:
      • https://www.ncdc.noaa.gov/cdo-web/datasets/GHCND/stations/GHCND:USW00094728/detail
    • Motor Vehicle Collisions:
      • https://data.cityofnewyork.us/Public-Safety/Motor-Vehicle-Collisions-Crashes/h9gi-nx95
  • KPI’s identified:
    • Collision rate during precipitation
    • Impact of weather on the tip amount
    • Frequency of most fatal accidents in each borough
    • Time where most collisions occur
  • Draft Dimensional Modeling:
    • https://drive.google.com/file/d/1mLSx29szKF8PyUZBwYVCnb6P_c_Y60Zt/view?usp=sharing