This project focuses on analyzing UK crime data sourced from the data.police.uk API. It was a practical endeavor to sharpen skills in data handling, visualization, and database management using tools like PostgreSQL and Tableau.
The architecture showcases the data pipeline and tools utilized in extracting, transforming, and analyzing the crime data.
The project leverages data from data.police.uk, particularly the crime street data. This dataset provides rich insights into crime reports at street level, enabling comprehensive analysis of trends and patterns across various geographic regions.
The interactive Tableau Dashboard highlights key metrics and insights derived from the crime data, offering a user-friendly way to explore the analyzed information.
- Data Storage: PostgreSQL
- Visualization: Tableau
- Data Extraction and Transformation: Python (via the data.police.uk API)
This project underscores the integration of public APIs with advanced tools to build insightful, data-driven solutions.