Karan Das
Data Analyst | Excel Dashboards | Power BI | SQL
New to Contra
Karan is building their profile!
š Interactive Excel Dashboard with Data Cleaning & Insights
š Project Overview
This project demonstrates how raw, unstructured data can be transformed into a clean dataset and converted into an interactive Excel dashboard for better business insights.
āļø Work Done
Imported raw data and cleaned it using Excel and Power Query
Removed duplicates and handled missing values
Standardized formats for consistency (dates, text, numbers)
Created calculated fields for key metrics
Built an interactive dashboard using Pivot Tables, Charts, and Slicers
š Dashboard Features
Dynamic filtering using slicers
Clear visualization of trends and performance
KPI tracking for quick decision-making
User-friendly layout for easy navigation
š” Key Insights
Identified performance trends over time
Highlighted top and low-performing categories
Enabled quick comparison across different segments
š ļø Tools Used
Microsoft Excel
Power Query
Pivot Tables & Charts
š Outcome
The final output is a fully interactive dashboard that helps users:
Analyze data quickly
Make informed decisions
Reduce manual reporting effort
š Open to similar projects involving Excel dashboards, data cleaning, and reporting automation.
1
21
š Excel Sales Dashboard & Data Cleaning Project
š Problem
Businesses often deal with messy, unstructured sales data (missing values, duplicates, inconsistent formats), making it difficult to generate accurate reports and insights.
āļø Solution
In this project, I transformed raw sales data into a clean, structured dataset and built an interactive Excel dashboard for better decision-making.
š ļø What I Did
Cleaned and structured raw CSV data using Excel formulas and Power Query
Removed duplicates, handled missing values, and standardized formats
Created calculated columns for KPIs like Total Sales, Profit, and Growth
Built an interactive dashboard with slicers and dynamic charts
š Key Insights Delivered
Identified top-performing products and regions
Highlighted monthly sales trends
Enabled quick filtering for better business analysis
š» Tools Used
Microsoft Excel
Power Query
Pivot Tables & Charts
š Outcome
The final dashboard allows users to:
Track performance in real-time
Make data-driven decisions
Save hours of manual reporting effort
š If you need a similar dashboard or data cleaning service, feel free to reach out.
1
22