Exploring Features of Splunk: Crime Data Analysis in Atlanta

In this assignment you will be exploring the features of Splunk. For this assignment you will be sharing a Word document  or PDF with Screen Shots of each step. Please make sure the screenshot is in a resolution which makes it readable. 
To complete this assignment first you will
Make sure you install splunk following the instructions shared with you in the lecture and are able to run it. Screenshot should show your browser window with splunk open in it. (1 points)
Load the attached CSV Download attached CSVfile in Splunk. The dataset is related to crimes reported in Atlanta between 2009-2017. Source of data is https://data.world/bryantahb/crime-in-atlanta-2009-2017Links to an external site. 
I went over how to load CSV file in Splunk in the lecture videos. Screenshot should show the dataset loaded in your browser window (1 points)
3. Query for all “AUTO THEFT” and take a screenshot of the query and results for the query.  You don’t have to show all the results. Just enough to make   sure you are able to run the query(2 points)
4. Query for all “AUTO THEFT” which occurred between 1st of January of 2011 (Inclusive) and 31st December 2013 (Inclusive)  take a screenshot of the query and results for the query.  You don’t have to show all the results. Just enough to make sure you are able to run the query (4 points)
5. Create a pie chart of various types of crimes e.g. Auto Theft, AGG ASSAULT etc. The Screenshot should show the pie chart. (4 points)
6. Query the data to show type of crime and the frequency and sort it by the most common type of crime to least common type of crime.Screenshot should show the query along with the results.  (8 points). 
7. Create a bar chart to show on X axis – neighborhood and Y-axis the frequency of crimes in the neighborhood (10 points)
8. Create a dashboard which includes chart from step 5 and 7. Screenshot should show the dashboard view as shown in the lecture. (10 points) 

Comments

Leave a Reply