📊 Excel Dashboards & Data Cleaning Projects

This repository contains multiple data analysis and dashboard projects using Excel, CSV datasets, and Jupyter notebooks. The dashboards are designed to turn raw data into meaningful insights using interactive visualizations, while the notebooks focus on preparing and cleaning real-world datasets.

---

Projects Included:

1. Global Superstore Dashboard (2016)

• File: global_superstore_2016.csv
• Tools: Excel
• Summary:
  Created an interactive dashboard to visualize global sales performance. Used:
  • Pivot tables for dynamic summaries
  • Slicers to filter by region, category, or time
  • Charts for visualizing profits, top products, and shipping trends

---

2. HR Analytics Dashboard

• File: HR_Analytics.csv
• Tools: Excel
• Summary:
  Built an insightful dashboard that highlights:
  • Employee attrition rate by department
  • Job satisfaction and salary comparisons
  • Gender and age-wise distribution The dashboard helps HR teams make data-driven decisions.

---

3. Machine Learning Dataset Overview

• File: ML-Dataset.csv
• Tools: Excel + Data Analysis
• Summary:
  Explored and visualized ML-related features like age, gender, income, and product preferences.
  • Cleaned the dataset using Excel filters & formulae
  • Performed quick EDA before modeling
  • Created charts to observe feature relationships

---

4. 🎓 Student Performance Cleaning Steps

• Files:
  • Student_mat_cleaning steps.ipynb
  • Student_por_cleaning_steps.ipynb
• Tools: Python (Pandas in Jupyter Notebook)
• Summary:
  Cleaned and processed two student datasets:
  • Removed nulls, fixed column types
  • Identified outliers
  • Converted categorical values These datasets are now model-ready for ML or analysis.

---

What These Dashboards Show:

These Excel dashboards demonstrate how large datasets can be transformed into easy-to-read and interactive visuals. They help in:

• Identifying trends and patterns
• Quick decision-making using filters & drilldowns
• Real-world simulation of BI tools like Power BI or Tableau (but done in Excel)

---

Key Skills Used:

• Excel Dashboards (PivotTables, Charts, Slicers)
• Data Cleaning (Pandas, Excel)
• Jupyter Notebooks for preprocessing
• CSV Handling
• Exploratory Data Analysis (EDA)

---

👤 Author:

Harshit (@HARSHIT071004)
A data enthusiast who loves building dashboards that simplify data stories, and cleaning messy datasets to uncover hidden patterns.