Hi, I’m Krish a Data Analyst passionate about turning data into actionable insights.
This repository contains my end-to-end data analytics project using Excel. Each project focuses on real-world business problems, data cleaning, analysis, visualization, and clear communication of insights.
This project focuses on analyzing Amazon sales data using Microsoft Excel to derive meaningful business insights and track overall sales performance. The goal of the project is to evaluate how actual sales compare against targets, understand product-level demand, and identify regional sales trends across different states and cities.
The dataset was cleaned and structured to ensure accurate analysis. Using Pivot Tables, Pivot Charts, and advanced Excel formulas, an interactive dashboard was designed to present key performance indicators (KPIs) in a clear and business-friendly format. The dashboard enables quick decision-making by summarizing complex data into easy-to-understand visuals.
- Compare Actual vs Target Sales
- Analyze Units Sold performance
- Track number of cities covered
- Identify top-performing products
- Evaluate state-wise and city-wise sales
- Measure percentage achieved and sales gap
- Total Sales Amount
- Units Sold
- % Target Achieved
- Sales Difference
- Market Coverage (# of Cities)
- KPI cards for quick performance overview
- Product-wise units sold ranking
- State-wise and city-wise sales comparison
- Clean layout with filters for easy exploration
- Business-oriented insights and storytelling
- Microsoft Excel
- Data Cleaning & Preparation
- Pivot Tables & Pivot Charts
- Excel Formulas
- Dashboard Design & Data Visualization
The analysis highlights high-performing products and regions while identifying areas where sales targets were not met. This helps stakeholders focus on improvement opportunities and optimize sales strategies.
- Automating data refresh using Power Query
- Adding time-based trend analysis
- Migrating the dashboard to Power BI or Tableau