The objective of this project is to analyze and transform raw data into meaningful insights using Microsoft Excel. The project focuses on understanding data patterns, improving data quality, and presenting insights through an interactive dashboard.
To perform end-to-end data analysis including data cleaning, transformation, analysis, and visualization, and to build a professional one-page dashboard.
- Microsoft Excel
- Pivot Tables
- Charts
- Slicers
- Basic Excel Formulas
- Removed duplicates and handled missing values
- Standardized and formatted data
- Used text functions for cleaning inconsistent data
- Applied formulas like SUM, AVERAGE, IF, COUNTIF
- Used VLOOKUP, INDEX, MATCH for data retrieval
- Created calculated columns
- Performed descriptive statistics
- Identified patterns using filtering and sorting
- Analyzed key metrics using pivot tables
- Created charts such as bar, pie, line, and area charts
- Used slicers for interactivity
- Designed a clean and structured dashboard layout
- India shows the highest contribution in salary distribution
- Marketing and Sales departments perform strongly compared to others
- Salary trends vary across employees indicating performance differences
- One-page interactive dashboard
- Visual representation of key metrics
- User-friendly and structured layout
This project demonstrates the complete data analysis process using Excel, from data cleaning to dashboard creation. It helped improve analytical thinking, data visualization skills, and the ability to present insights effectively.