For my story I chose to look at noise complaints. I wanted to see where most complaints were lodged (which riding?) and how many the 311 call centre dealt with. I used a 311 dump file that compiled the monthly service requests that is accessible from: http://data.ottawa.ca/en/dataset/2014-311-monthly-service-request-submissions http://data.ottawa.ca/en/dataset/311-monthly-service-request-submissions http://data.ottawa.ca/en/dataset/2015-311-monthly-service-request-submissions I then used MySQL to retrieve all noise complaints from the datasets and compile them into a single excel file. From there I sorted the data according to times when the calls came in. This meant separating the time from the date value in excel by using ‘text to columns.’ From there I sorted all the calls into hour-long blocks (eg: 1 a.m. to 1:59 a.m.). I was able to tally up each hour-long block and see which hours had the highest call volume. It turns out that the 11 p.m. to 11:59 p.m. is the busiest hour. The graph is available here I also created an excel chart showing the total percentage:

I also wanted to see which wards received the most complaints. Not surprisingly, Rideau- Vanier was the ward with the highest volume. This ward has both Sandy Hill and the ByWard Market in it and these are both notoriously loud neighbourhoods. I made another chart here