https://data.cityofchicago.org/Transportation/Red-Light-Camera-Violations/spqx-js37

Access the City of Chicago's Data Portal (https://data.cityofchicago.org/ (Links to an external site.)

) 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 we have studied, such as Excel or Tableau, and 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.

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).