๐ Crime Data Analysis (Excel Project) This project focuses on exploring crime patterns using Microsoft Excel. It includes complete data cleaning, preprocessing, Exploratory Data Analysis (EDA), Pivot Tables, Pivot Charts, and an interactive Excel dashboard. The goal is to identify key crime trends and present insights in a clear and visual format suitable for decision-making and reporting.
๐ Project Overview This Excel-based EDA project includes: Cleaning and preprocessing raw crime data Handling missing or inconsistent values Using Pivot Tables to summarize crime counts Creating Pivot Charts for visual trend analysis Building a dashboard to visualize major crime categories, state-wise trends, and year-wise patterns Extracting meaningful insights to understand crime distribution
๐ ๏ธ Tools & Techniques Used Microsoft Excel Data Cleaning Pivot Tables Pivot Charts Data Visualization Dashboard Creation Trend Analysis