quocduyenanhnguyen/California-Crime-Data-Analysis

I analyzed crime incident-based data in California in the year 2022. I used SQL for analysis and Tableau for visualization.

Software I used:

MySQL Workbench: to write SQL

Data source

Description:

• I analyzed crime incident-based data in California in the year 2022. I got the data from FBI Crime Data Explorer. Most of the data already come cleaned and nicely formatted in CSV files. I used SQL for data manipulation and analysis, then visualized the data in Tableau.
• Attached to this repos is my SQL queries and explanation of output.
• Link to Tableau viz part 1: https://public.tableau.com/app/profile/anna.quoc.nguyen/viz/CaliforniaCrime2022part1/Dashboard1
• Link to Tableau viz part 2: https://public.tableau.com/app/profile/anna.quoc.nguyen/viz/CaliforniaCrime2022Part2/Dashboard1
• Link to Tableau viz part 3: https://public.tableau.com/app/profile/anna.quoc.nguyen/viz/CaliforniaCrime2022part3/Dashboard2