MySQL Workbench: to write SQL
- 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