This project involves a comprehensive analysis of Blinkit's sales data, aimed at understanding the sales performance, customer satisfaction, and inventory distribution. The analysis uses Power BI to identify key insights and opportunities for optimization across various KPIs such as Total Sales, Average Sales, Number of Items Sold, and Average Customer Rating.
The project follows a structured approach to ensure accurate and actionable insights:
-
Requirement Gathering / Business Requirements
Understanding the goals of the analysis and identifying key metrics and insights to be tracked. -
Data Walkthrough
Analyzing the structure and content of the raw sales data. -
Data Connection
Connecting to data sources to import relevant datasets. -
Data Cleaning / Quality Check
Cleaning the dataset to remove inconsistencies, handle missing values, and prepare for analysis. -
Data Modeling
Structuring the data in Power BI to create relationships between tables and enable efficient data processing. -
Data Processing
Transforming and aggregating the data for analysis. -
DAX Calculations
Using DAX (Data Analysis Expressions) for complex calculations and metrics generation. -
Dashboard Layout
Designing a clear and effective layout for the dashboard. -
Charts Development and Formatting
Creating and formatting charts to visualize KPIs effectively. -
Dashboard / Report Development
Finalizing the dashboard with all necessary visuals, filters, and formatting. -
Insights Generation
Deriving actionable insights from the analysis to drive business decisions.
The primary objective of this project is to perform a detailed analysis of Blinkit's sales performance and identify key areas for improvement. The dashboard enables the evaluation of various sales KPIs and their impact on business metrics, such as:
- Total Sales: Overall revenue generated from all sold items.
- Average Sales: Average revenue generated per sale.
- Number of Items: Total number of different items sold.
- Average Rating: Average customer rating for sold items.
-
Total Sales by Fat Content
Objective: Analyze the impact of fat content on total sales.
Chart Type: Donut Chart
Additional Metrics: Includes Average Sales, Number of Items, and Average Rating for various fat content levels. -
Total Sales by Item Type
Objective: Identify the performance of different item types in terms of total sales.
Chart Type: Bar Chart
Additional Metrics: Includes Average Sales, Number of Items, and Average Rating by item type. -
Fat Content by Outlet for Total Sales
Objective: Compare total sales across different outlets, segmented by fat content.
Chart Type: Stacked Column Chart
Additional Metrics: Includes Average Sales, Number of Items, and Average Rating by outlet. -
Total Sales by Outlet Establishment
Objective: Evaluate the impact of outlet establishment age or type on total sales.
Chart Type: Line Chart -
Sales by Outlet Size
Objective: Analyze the relationship between outlet size and total sales.
Chart Type: Donut / Pie Chart -
Sales by Outlet Location
Objective: Assess the geographic distribution of sales across various outlet locations.
Chart Type: Funnel Map -
All Metrics by Outlet Type
Objective: Provide a detailed breakdown of all KPIs (Total Sales, Average Sales, Number of Items, Average Rating) by outlet type.
Chart Type: Matrix Card
The insights generated from this dashboard have revealed several important trends that can drive decision-making:
-
High Sales in Specific Outlet Sizes:
Large outlets contribute the most to total sales, which shows a clear correlation between outlet size and revenue. However, small and medium-sized outlets still hold a significant portion of the market, providing opportunities for optimization and market penetration. -
Fat Content's Influence on Sales:
Products with regular fat content have higher sales than low-fat content items, indicating consumer preference toward higher-fat options. This can inform future product inventory decisions. -
Item Type Performance:
The top-performing categories in terms of total sales include Fruits and Vegetables and Snack Foods. This insight can help in deciding which product categories should receive more marketing attention or stocking priority. -
Sales Concentration by Outlet Location:
Outlets located in Tier 3 cities have the highest sales compared to Tier 1 and Tier 2 locations. This suggests a strong consumer demand in less urbanized regions, potentially indicating market saturation in major cities and opportunities for expansion in smaller towns. -
Sales Trends Over Time by Outlet Establishment:
Older outlets tend to show stable growth in sales performance, especially around the 2016-2018 period, which could be attributed to business maturity and consumer trust. Newer outlets seem to have slower sales growth, likely requiring focused marketing or operational improvements. -
Customer Satisfaction Consistency:
The Average Rating across all outlets remains steady at around 3.9, indicating a generally consistent customer experience, but also pointing toward potential areas for improvement in service or product quality to boost customer satisfaction.
- Power BI: Used for data visualization and dashboard development.
- DAX (Data Analysis Expressions): For calculating KPIs and custom metrics.
- Data Cleaning: Performed using Power Query.
- Data Sources: Sales transaction data, customer data, and outlet details.
- Fat Content & Sales: Certain fat content levels correlate with higher total sales, indicating consumer preferences for specific types of products.
- Outlet Size Impact: Larger outlets tend to generate higher sales, likely due to a larger product variety and better customer footfall.
- Sales Distribution by Location: Regional trends indicate higher sales in specific geographic locations, providing opportunities for market expansion.
- Item Type Performance: Some item types outperform others in terms of both sales volume and customer ratings, revealing potential areas for product focus.
- Download the Power BI File:(BlinkIT Sales Analytics.pbix)
- Open in Power BI Desktop: Ensure Power BI Desktop is installed on your system.
- Explore the Dashboard: Use the available filters and slicers to drill down into the data and uncover more specific insights.