Blinkit Analytics Dashboard using PowerBi

---

This project involves creating interactive dashboards to analyze sales data over a decade. The dashboard focuses on dairy items, displaying key metrics like total sales, sales trends by year, fat content distribution, and location type. It provides a comprehensive overview of all item types, highlighting total sales, sales trends, item ranking by sales, and similar distribution metrics for fat content and location types. These dashboards facilitate data-driven decision-making by providing clear visual representations of sales performance and item distribution. The project aims to help stakeholders understand market trends and optimize inventory management.

Steps Involved:

1. Cleaning Data

• Removing unnecessary columns and duplicates.
• Handling missing values.
• Changing data types as needed.

2. Data Analysis

• Used DAX functions, measures, and calculated columns to perform detailed analysis.

3. Mertics

1. The total number of sales transactions made is 1.20M Sales.
2. The average customer rating out of 5 is 3.92.
3. The total number of items available for sale is 9K.

4. Insights:

• Fruits and Vegetables has the highest sales of 178K.
• Snack Foods has 173K sales is second highest.
• In YOY chart 2020 (peak year) has sale of 295K.
• The pie chart divides the sales based on the location type:

1. Tier 1: 28.05%
2. Tier 2: 39.77%
3. Tier 3: 32.18%

Sanpshots:

---