Goal: Conduct exploratory data analyzes on publicly available datasets using Tableau

Dataset: You will be working with 311s open data available from NYCs Open Data initiative. Filter and download for only first 6 months of 2017 i.e. from 1/1/2017 to 6/30/2017. This file will be around 700-800mb so it may take a while depending upon your connection.

Tasks:

Also download the data dictionary file to know more about each field

Import the dataset in Tableau and clean and process it as needed.

Explore the data by analyzing a few individual variables (both categorical and continuous i.e. dimensions and measures) to understand what its about.

Once you are comfortable with the contents of the dataset, pick one agency that has at least a few thousand records for further investigation.

Identify a minimum of five questions containing at least 2-3 variables. Make sure at least two of the questions include calculated variables.

Before you start creating visualizations, think of the various questions that this dataset can answer and then proceed to creating visualizations. This dataset is quite rich in terms of its variety of data types: We have temporal (time-based) data, geographic location data, and categorical data. Because of this, there are many ways one could choose to visualize this dataset. Here are a few (low-hanging fruit) examples. You want to try out more than one approach:

i.Some ideas include how response time varies by complaint type, are certain complaints common in some zip codes but not in others? Are certain types of complaints prevalent near school zones? Trend in complaint statistics over period of time across multiple categories or locations? Etc.