This project was completed as part of MSA 8030: Communicating with Data at Georgia State University.
It aims to analyze crime data in Los Angeles to help a company identify the safest location for a new import/export warehouse on the West Coast. The project also focuses on improving presentation and communication skills by delivering actionable insights and updates to stakeholders effectively.
- Source: https://data.lacity.org/Public-Safety/Crime-Data-from-2020-to-Present/2nrs-mtv8/about_data
- File:
Crime_Data_from_2020_to_Present_20241004.csv - Time Frame: 2020 - 2023
- A company is planning an expansion to Los Angeles to strengthen ties with Asian business partners.
- Safety is a major concern when selecting a prime warehouse location for operations.
- The goal is to find the area with the lowest crime rate to protect employees and assets.
- What are the crime trends in Los Angeles from 2020 to 2023?
- Which areas have the lowest crime rates for safe business operations?
- What safeguards should the company implement to ensure security?
- Data Cleaning & Preprocessing: Handling missing values, formatting, and data consistency.
- Exploratory Data Analysis (EDA): Identifying crime trends, patterns, and geographical hotspots.
- Visualization: Charts, heatmaps, and reports to support findings.
- Weekly Updates to Stakeholders: Providing clear, concise progress updates and actionable insights.
- Final Presentation: Communicating findings effectively and tailoring messages to decision-makers.
This project emphasizes not only the technical aspects of data analysis but also the ability to:
- Deliver clear and impactful updates to stakeholders.
- Translate data-driven findings into meaningful recommendations.
- Use visual storytelling techniques to improve engagement and comprehension.
- Tailor messaging to different stakeholders based on their needs and concerns.
- Python (Pandas, NumPy, Matplotlib, Seaborn) for data analysis.
- Power BI / Tableau for visualization.
- Jupyter Notebook / Google Colab for running analyses.
- Identified West LA in Los Angeles for expansion.
- Suggested crime prevention measures for securing warehouse operations.
- Created data-driven recommendations for informed decision-making.
- Lilly Parham, Pamela Alvarado-Zarate & Zainab Siddiqi
- Georgia State University - Master of Science in Analytics
This project is for academic purposes and is based on publicly available crime data. The analysis is intended to demonstrate data storytelling, decision-making, and stakeholder communication skills.