An interactive data analysis project using Microsoft Excel to explore Blinkit's sales trends, customer behavior, and delivery insights through dynamic charts and dashboards.
📌 Overview
This project presents an interactive Excel dashboard analyzing sales and operational data from Blinkit, a rapid commerce grocery delivery platform. The goal is to uncover key insights related to sales performance, customer behavior, and delivery trends, all visualized through dynamic charts and filters.
Objectives :-
Analyze sales trends over time Study customer purchasing patterns Evaluate delivery efficiency Create a user-friendly dashboard for easy insights
Tools Used :-
Microsoft Excel (Mac) Pivot Tables Slicers Conditional Formatting Charts & Graphs Data Cleaning Functions (TEXT, IFERROR, VLOOKUP, etc.)
Dashboard Features:-
Dynamic filtering using slicers (Date, Category, Region, etc.) Key KPIs (Total Sales, Orders, Avg. Delivery Time) Visual trends (line, bar, and pie charts) Clean and interactive layout
Data Cleaning Steps:-
Removed duplicates and blank rows Formatted date and time fields Used formulas for transformation and derived columns Ensured consistency in category and product naming