✅Blinkit Analysis 🛒

❇️Business Requirements

To conduct a comprehensive analysis of Blinkit's sales Performance, customer satisfaction, and inventory distribution to identify key insights and opportunities for optimization using various KPIs and visualizations in Power BI.

❇️KPI's (Key Performance Indicator) Requirements 📊

(A). Total Sales : The Overall revenue generated from all items sold.

(B). Average Sales : The Average revenue per sale.

(C). Number of Items : The total count of different items sold.

(D). Average Rating : The Average customer rating for items sold.

❇️Chart's Requirements 📶

1️⃣ Total Sales by Fat Content

🎯 Objective : Analyze the impact of fat content on total sales.
📊 Additional KPI Metrics : Assess how other KPIs(Average Sales, Number of Items, Average Rating) vary with fat content.
📶Chart Type : Donut Chart.

2️⃣ Total Sales by Item Type

🎯 Objective : Identify the performance of different item types in terms of total sales.
📊 Additional KPI Metrics : Assess how other KPIs(Average Sales, Number of Items, Average Rating) vary with fat content.
📶Chart Type : Bar Chart.

3️⃣ Fat Content Outlet for Total Sales

🎯 Objective : Compare total sales across different outlets segmented by fat content.
📊 Additional KPI Metrics : Assess how other KPIs(Average Sales, Number of Items, Average Rating) vary with fat content.
📶Chart Type : Stacked Column Chart.

4️⃣ Total Sales by Outlet Establishment

🎯 Objective : Evaluate how the age or type of outlet establishment influence total sales.
📶Chart Type : Line Chart.

5️⃣ Sales by Outlet Size

🎯 Objective : Analyze the correaltion between outlet size and total sales.
📶Chart Type : Donut/Pie Chart.

6️⃣ Sales by Outlet Location

🎯 Objective : Assess the Geographic distribution of Sales across different locations.
📶Chart Type : Funnel Map.

7️⃣ All Metrics by Outlet Type

🎯 Objective : Provide a comprehensive view of all key metrics(Total Sales, Number of Items, Average of Sales, Average of Rating) broken down by different Outlet types.
📶Chart Type : Matrix Card.