Blinkit-Sales-Analysis-Excel

Excel-driven sales and customer insights analysis using formulas, pivot tables, and charts.

Project Overview

This project involves analyzing Blinkit's sales performance, customer satisfaction, and inventory distribution using Excel. The goal is to uncover key insights and optimization opportunities through various KPIs and visualizations.

Business Requirements

Objective:

Conduct a comprehensive analysis of Blinkit's sales data to identify trends, measure performance, and provide actionable insights for decision-making.

KPIs to Track:

Total Sales: Overall revenue generated from all items sold.

Average Sales: Average revenue per sale.

Number of Items: Total count of different items sold.

Average Rating: Average customer rating for items sold.

Analysis & Visualizations:

Total Sales by Fat Content:

Assess how fat content affects total sales and other KPIs (Average Sales, Number of Items, Average Rating).

Total Sales by Item Type:

Identify performance differences among item types with associated KPI insights.

Fat Content by Outlet for Total Sales:

Compare total sales across outlets segmented by fat content, including other KPIs.

Total Sales by Outlet Establishment:

Evaluate sales trends based on outlet age/type.

Sales by Outlet Size:

Analyze correlation between outlet size and total sales.

Sales by Outlet Location:

Assess geographic sales distribution.

All Metrics by Outlet Type:

Comprehensive view of all KPIs broken down by outlet type.