Access the City of Chicago’s Data Portal https://data.cityofchicago.org and download the data set on red light camera violations (a file of over 600,000 lines of data located in the Transportation section). Perform an analysis of the data using technology tools such as Excel or Tableau, and write a report on your findings.
The analysis should focus on trends and/or anomalies in the data. For example, you might highlight heavy or light activity in a district of the city; activity trends based on dates; or a deeper dive into specific cameras. The analysis should be robust and thoughtful …even creative.
The report should be approximately 3 pages. Some amount of graphics should be incorporated (e.g., Excel charts or Tableau), and active use of visuals will increase the length of the report. Be sure to include some context, which might include some history and the breadth of the program. The tone of the report should be focused on an analysis to be presented to Mayor Lori Lightfoot, who is wrestling with the trade-off between revenue generated vs. the “PR” effect of the tickets being issued.
Submit a Word document along with supporting files (e.g., Excel and/or Tableau).
The attached file is an example of how the file should look like.
0 comments