1 / 8

Life in Hampton Roads

Life in Hampton Roads. Data Visualization Project Progress Report February 25, 2012. Team Members. Andrew Wharton Timothy Werner Harshith Bandi. Project. Life in Hampton Roads (LIHR) survey

jewell
Download Presentation

Life in Hampton Roads

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Life in Hampton Roads Data Visualization Project Progress Report February 25, 2012

  2. Team Members • Andrew Wharton • Timothy Werner • HarshithBandi

  3. Project • Life in Hampton Roads (LIHR) survey • Goal: “To develop a baseline of social/economic indicators for use by local government and other community organizations” • Measuring local quality of life based on indicators

  4. Data • Telephone survey • SPSS Format • Had to extract to CSV format • Three different files • 2010 • 2011 • 2012 • Numeric and nominal answers

  5. Approach • Cleaning • Remove non-essential data • Handle missing data • Give a special value • Separate numeric data from nominal data • Aggregation • Combine multiple questions/answers into more generic categories • This allows us to easily combine all three years

  6. Approach (cont.) • Scatterplot Matrix for numeric data • Shows a lot of data in small space • Shows trend over time • Word cloud for nominal data • Shows common opinions on specific topics • Filtering and sorting

  7. Issues • Data cleaning • Time-consuming • File formats • Cryptic labeling (q1, q2, etc.)

  8. Development • Tableau for initial analysis • Get an overview • Check for anomalies • d3 for final product • HTML • JavaScript • CSS

More Related