Blinkit-Sales

Blinkit Sales Dashboard

Dashboard Link : https://app.powerbi.com/groups/me/reports/6e5e5f78-d424-4da5-b4b1-73d1b6cbdf58/349ecb3b9c8fa14955af?experience=power-bi

Problem Statement

This dashboard comprises the sales of Blinkit.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 KPI's and Visualization in Power BI.

KPI'S Requirements

1. Total Sales : The overall revenue generated from all items sold.

2. Average Sales : The average revenue per sale.

3. Number of items : The total count of different items sold.

4. Average Rating : The average customer rating for items sold.

Steps followed

• Step 1 : Load data into Power BI Desktop, dataset is a csv file.
• Step 2 : Open power query editor & in view tab under Data preview section, check "column distribution", "column quality" & "column profile" options.
• Step 3 : Also since by default, profile will be opened only for 1000 rows so you need to select "column profiling based on entire dataset".
• Step 4 : Data Cleaning and Quality Check should leverage the dataset more precised.So it can be done in this stage.

• Step 5 : Choose the appropriate model type based on the analysis objective, such as regression or clustering. Train the model on a dataset, evaluate its performance using metrics, and refine it through hyperparameter tuning and cross-validation.
• Step 6 : Transform raw data into a usable format by cleaning, integrating, and enriching it. Store the processed data efficiently and optimize workflows to enhance performance and ensure data is ready for analysis.
• Step 7 : Calculate the required metrics or DAXes using specified formulas and data. Validate these calculations against benchmarks to ensure accuracy, and document the methods used for transparency.
• Step 8 : Design a dashboard layout by planning the arrangement of visual elements like charts and tables based on user requirements. Ensure the design is intuitive and presents data clearly and effectively.
• Step 9 : Compile data and visualizations into a structured report, providing context and explanations for the insights presented. Review and edit the report for clarity before distributing it to stakeholders.
• Step 10 : Analyze data to identify trends and patterns, generating actionable insights. Validate these insights and communicate them clearly, providing recommendations based on the findings and monitoring their impact.

Snapshot of the Blinkit Insights

Business Requirements

Chart Requirements

Total Sales by Fat Content

• Analyse the impact of Fat content on Total Sales

Total Sales by item type

• Identify the performance of different item types of total sales.

Fat content By outletfor total sales

• Compare total sales across diffrent outlets segmented by fat content.

Total Sales by Outlet Establishment

• Evaluate how the age or type of outlet establishmentinfluences total sales.

Sales by Outlet Size

• Evaluate the correlation between outlet size and total sales.

Sales by Outlet Location

• Assess the geographic distribution of sales across different location

All metrics by Outlet type

• Provide a comprehensive view of all metrics

Snapshot

Sales

Rating

Items

Avg sales