Download the attached data set
Link to data set: https://docs.google.com/spreadsheets/d/1JWz_CuhGYSq0qWnX8n9kVamPSogrC8hn/edit?usp=sharing&ouid=101442918329446184656&rtpof=true&sd=true
Use one of the following tools to analyze the data
MS Excel/Pivot tables
Tableau (Free download for 14 days)
MS Power BI ( Free for MS Windows users) (Sorry cool MAC users đ )
The goal is to develop a business logic from a set of data
Present the data by considering the following, provide data visualization to support your point, consider the following:
Count of crimes per category
Count for crimes per category and neighborhood
Try to find a relationship between different variables ( location, resolution, district, neighborhood, Category, subcategory, etc
Include at least 10 data visualizations, including at least one GIS map showing the distribution of data across neighborhoods utilizing the provided coordinates
Discuss your finding from a technical point of view:
The type of data
Thy type of analysis you provided
The source of data
Suggestions to improve the data and the analysis
How can this data be utilized to improve area security