Week 1 Data Analysis Discussion

Type in a key word for the data you want to search for in search box or browse by topic

Select one of the databases found (CSV) will open into Excel easily

Download the file into Excel

Create an Pivot table based on the data you downloaded

State why you selected these fields and analyze the data in the pivot table. For example, you may say that your analysis was based on the "source" of the snow removal requests and the number of requests from that source was used to see what method of communication was generating the highest number of requests. Based on the data in the pivot table, it shows that over 60% of the sidewalk snow removal requests are made by phone. The impact for this city may be that they need more people to answer phones during the winter or the city may want to encourage residents to use other means of reporting such as email or webforms.