Major-Crime-Indicators_Capstone-Project

Project Topic: Toronto Police Crime Data Analysis

Data_Set: Major-Crime-Indicators

Dataset

Tools: Python, SQL, PowerBI

• Python Pandas for understanding the data and cleaning.
• SQL exploring the data with accessing selected quires
• Power BI visualizing data

Process flow diagram

Phase 1 (Python,SQL)

• Data Collection / Sourcing
• Cleaning and storing the data

Phase 2 (Power BI)

• Data Modeling (star/snowflake)
• Categories data as per the Shema
• Load into Power BI
• Work on KPI

Phase 3 (Power BI)

• Power BI Dashboard
• Delivering the Insights

Problem Statement

KPI's REQUIREMENT

Dashboard REQUIREMENT