This portfolio project is titled: austin_hate_crimes_2017-2022 and it analyzes hate crime reports in Austin Texas U.S.A from 2017 to 2022 using Excel, SQL, and visualized using Tableau. The raw data used for this project was gotten from: https://catalog.data.gov/dataset/?q=hate+crimes&sort=score+desc%2C+name+asc&res_format=CSV&ext_location=&ext_bbox=&ext_prev_extent=0%2C0%2C0%2C0

The Excel file titled: austin_hate_crimes_2017-2022_cleaned contains a combined and cleaned version of the raw dataset mostly using conditional formatting and IF statments.

The SQL file titled: austin_hate_crimes_queries contains all the queries that were used in obtaining and analyzing our cleaned data in Microsoft SQL Server.

The Tableau file titled: austin_hate_crimes_2017-2022_dashboard is the visualization of result of our SQL queries. It can also be found at this link here: https://public.tableau.com/app/profile/chidubem.ngini/viz/Austin_Hate_Crimes_2017-2022/Dashboard1?publish=yes