Project Overview

Category: Data Analytics, Cloud Computing

This project explores hate crime trends in Austin, Texas (2017–2025) using public datasets from Data.gov and the City of Austin.

Background

Hate crimes represent a critical public safety concern, yet analyzing patterns across years of incident data requires robust data infrastructure. This project demonstrates how modern cloud platforms and visualization tools can transform raw government data into actionable insights for policymakers and community advocates.

Objectives

• Build a scalable data pipeline for multi-year hate crime data from public sources
• Identify demographic and geographic patterns in hate crime incidents
• Create interactive dashboards for exploration and insight discovery
• Deliver findings that can inform public safety strategies and community awareness programs

Work

Technologies Used:

• Snowflake: Cloud data warehouse for integration, cleaning, and modeling
• SQL: Data transformation and analysis queries