Final Assignment: Overview
For this assignment, imagine you work for the City of New York and their Data Science department. The City Council has increasingly seen more and more noise complaints over the past decades and wants to pro-actively act on it. NYC generally sees two types of noises: The sounds of the city (car horns, loud neighbors, construction equipment, barking dogs) and the sound of New Yorkers complaining about it. Luckily, the city has been aware of the problem and established a noise code in 2007 with arich database(Links to an external site.).
The City Council and the Department of Environmental Protection now asks you to analyze the database to assess the noise pollution in the city and present the status quo to the mayor.
Link to database:https://nycopendata.socrata.com/Social-Services/311-Service-Requests-from-2010-to-Present/erm2-nwe9?
Instructions for Final Assignment
Your objective is topresent a full-fledged analysis to the Mayor of New York Cityusingdata storytellingbased on the NYC noise code database. Your analysis should incorporate the following at a minimum:
- Descriptive insights (numbers and visuals) into the various dimensions of the City's noise complaints. This gives context to the problem and what the data look like.
- Provide well thought-through visuals that can depict the various dimensions of the data set,including *but not limited to* thematic maps. A well thought-out visual is not just a chart from your software -consider slide-style content where you have action titles, text elements to explain things, etc.
- Provide "predictive insights" into noise complaints.What do you expect things to look like in the futurewithout action, and what could they look like with action? (Note, do NOT create statistical / machine learning models for this part.You should make reasonable assumptions based on historical data that you can observe directly with your charts - a good time series chart should tell the story here!)
- Offer a distinct conclusion andprescriptionsfor the mayor (e.g., what can be done now, how can it be improved?)
- Allow the mayor to understand your thought process in a non-technical way (including assumptions or key trade-offs you made). The mayor is not a technically savvy consumer of data graphics, so design accordingly.
Your delivery to the mayor is a PowerPoint / Google Presentation slide set. Remember the mayor is not a data scientist and has limited time: use your best data storytelling as well as well chosen visuals.
Tools to Use In Your Analysis
You will create your “data story” using your EDA and visualization skills inR/Python and Tableau.Create your slide deck in PowerPoint or Google Presentation. Note: if you use Tableau, you need to make sure that you do not have visual artifacts from Tableau software in your presentation! Make sure that the look of your work isprofessional.
These data are very large. Here's a tip: use the user interface that lets you download the data to filter it down to something smaller! Click "View Data" then "Filter" to filter the data to something more usable, then "Export" to download the data you filtered. You do not need many years of data for this analysis! Perhaps only recent years...
Deliverables For Final Project Must Include:
- PowerPoint / Google Presentation slide deck featuring your analysis
- Presentation of your analysis: talking points in the notes section for each slide.
- Submit any Python/R code that you write in .R file format.