Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Data Modeling

samuel pushpak
October 03, 2013

Data Modeling

samuel pushpak

October 03, 2013
Tweet

More Decks by samuel pushpak

Other Decks in Design

Transcript

  1. Data Model Tables on Case Incidances - Under state &

    Year wise - Under crime & Year wise - Under crime & District wise for 2012 - Under state and & Categorized as Women, Children, Jeveniles Typical Columns - States : Andhra Pradesh, Karnataka - Districts : Visakhapatnam, Siang, Bellary, Kolar - Years : 2007 - 2012 - Crime : Murder, Rape, Dacoity, Riots - Classifications : Women, Children, Juveniles Sources MOPSI 2012 report by NCRB
  2. Architecture - CSV for data - Python and Pandas for

    calculations and filtering - D3 for drawing Visualization - Overview (as in Print format) - Explore occurance of crime acrosss districts - Analyse trends across states (year wise) - Hint the user on, how safe a particular place is ?