Categories
Uncategorized

Crime data analysis report as a crime analyst with Excel data

NOTE to the writer: there are 3 files uploaded and ZIP file is the data for writing the report and there is a sample
report .
###
Project_description.pdf
Your assignment is to complete a report for your Chief Constable on last year’s crime trends. The Chief is very
busy, so only the most important and relevant information should be included. You will want to include SOME
graphs, maps and tables, but DO NOT leave it to the Chief to interpret them – it is up to you to explain what
they mean and why they are important.
Begin by looking at your data from many angles. Some questions to ask and start analyzing:
1. Are there any hot spots/hot places in the data? If so, present them in an appropriate form (tables, charts,
graphs) as you see fit.
2. Are there any temporal (time, days, months, etc.) trends in the data? If so, present them in an appropriate form
(tables, charts, graphs) as you see fit.
3. If you were the local analyst, what would be your next step with respect to analysis? Are there any prevention
opportunities available to you based on the data? What would you present to the Chief Constable if he/she asked
to know everything about your chosen crime type in the data?
The data may represent any type of crime you wish. Your final report should be written up in Word, with the
appropriate tables, charts and graphs included with the text in a memo to the Chief Constable. You may refer to
this document for some ideas on how to appropriately incorporate your description of the problem with
applicable graphs and maps:
http://vancouver.ca/police/assets/pdf/statistics-reports/report-2008-2010-sex-assaults.pdf
Please also remember the tips and tricks surrounding your tables, charts and graphs. Your report should be clean,
clear, and easy to read. It should contain actionable and PRIORITIZED information – do NOT simply paste
everything you can onto the page for the Chief – you must do your job as an Analyst and only include that
information which is the MOST RELEVANT and that the Chief MUST SEE.
Basics:
• 6 (min) pages (this includes charts and graphs, so again, prioritize your information)
• 11 or 12 point font, 1” margins (ensure your graphs, charts and tables adhere to the margins)
• Saved in PDF from Word (“Save As”, “PDF”)
• Use Template provided
1
** YOU MUST ALSO SUBMIT YOUR EXCEL FILE, AND I WILL BE LOOKING FOR YOUR USE OF
FORMULAS AND CLEAR ANALYSIS OF THE DATA!**
###
Extra info:
Data Files (crime data)
Data can be downloaded from the following link:
https://geodash.vpd.ca/opendata/
Suggested Steps
1. Clean your data (Excel)
a. Make new “time” field
b. Clean any “date” fields that need it
2. Snoop around your data
a. Using pivot tables (or whatever you like), check out:
i. Times of crimes
ii. Dates of crimes
iii. Days of the week
iv. Seasons!
v. Are certain crimes happening on certain dates/times/seasons?
vi. Are certain addresses popping up more often?
vii. Are the years different?
viii. What about crime around holidays? Special Events (Olympics)?
3. Get an idea of what you’d like to focus on
a. A certain crime type?
b. Comparison of two crime types? (e.g., auto theft vs. burglary, etc.)
c. Comparison of seasons?
d. Weekend vs. weekday crimes?
e. Daytime vs. nighttime crimes?
f. Or are you interested more in something totally different?
g. DO NOT ANALYZE ALL OF THE DATA – YOU MUST CHOOSE SOMETHING SMALLER AND
MORE MANAGEABLE THAT MAKES SENSE!
4. Work your way back through the weekly modules to do the analysis.
5. Write up your results!

Leave a Reply

Your email address will not be published. Required fields are marked *