• Designed dimensional model in Dataedo for NYPD Arrests Historical data (OpenData) and performed data profiling, data prep, and ETL for staging using Alteryx Designer
• Developed data integration workflow in Talend Open Studio and created dashboards using Tableau and Power BI for trend analysis and generating insights
• Dataedo (data modeling tool)
• Talend Open Studio
• Alteryx Designer
• Google Cloud Platform - BigQuery
• Azure SQL & SQL Server
• MySQL
• Map arrests on map
• Trend charts for number of arrests by date
• Comparisons and contribution visualizations for various attribues including year, age group, arrest borough, etc
We have used the New York City OData platform for obtaining the historic and YTD records of arrests provided by the Office of Management Analysis and Planning at NYC which can be found at the below links:
• Historic Dataset
• YTD Dataset