Project Details

Key Steps in Analysis:
1️⃣ Cleaning & Preparing Data – Fixed inconsistencies, handled missing values, and structured data before analysis.
2️⃣ Exploratory Data Analysis (EDA) – Used formulas like COUNTIFS, SUMIFS, XLOOKUP to extract insights.
3️⃣ Power Query Magic – Combined multiple datasets for better insights.
4️⃣ Pivot Tables for Quick Insights – Analyzed male vs. female salaries, bonus calculations, and regional comparisons.
5️⃣ Visualizing Data – Created histograms, box plots, and trend charts.
6️⃣ Dashboard & Reports – Applied formatting tricks, conditional formatting, and data validation for cleaner reports.

📊 Key Insights:
Salary Distribution – Histograms & Box Plots showed salary spread and variation.
Performance & Rating Relationship – Explored how salary relates to performance ratings.
Staff Growth Over Time – Trend analysis of workforce expansion.
Regional Scorecard – Compared between New Zealand and India.

Project Details

I built a Budget Tracker using Excel, and here’s what I learned:
🔹 What You Did (Make It Engaging)
✅ Defined categories to organize income & expenses.
✅ Classified bank transactions to track spending habits.
✅ Created an interactive report to analyze trends easily.
✅ Added filtering options (year/month) for better insights.
✅ Automated updates so the report refreshes without manual work.

Project Details

In this project, I worked on real coffee sales data and transformed it into meaningful insights using Microsoft Excel. Starting with raw and unorganized data, I cleaned it using filters, conditional formatting, and formulas to ensure consistency and accuracy. After preparing the dataset, I created dynamic KPIs such as total sales, profit, and order count, followed by a professional Excel dashboard with interactive visuals using Pivot Tables, Charts, and Slicers. This dashboard highlights performance trends, top-selling products, and customer insights — all in a single view. The project showcases the complete data analysis process: from cleaning and organizing data to designing a visually appealing and insight-driven dashboard. A perfect example of how Excel can be a powerful tool for analytics

Live Interactive Dashboard