The main objective of this project is 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 visualizations in Power BI.
Steps Followed:
1.Requirement Gathering 2.Data Walkthrough 3.Data cleaning 4.Data Modelling 5.Data Processing 6.DAX calculations 7.Dashboard layouting 8.Charts Development and formatting 9.Dashboard/Report Development 10.insights Generation
KPI's Requirements:
Total sales: The overall revenue generated from all items sold. Average sales: The average revenue per sale. No. of items: The total count of different items sold. Average Rating: The average customer rating for items sold. Chart's requirements:
1.Total Sales by Fat content: Objective:Analyze the impacty of fat content on total sales. Additional KPI metrics:Assess how other KPI's (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 type in terms of total sales. Additional KPI metrics:Assess how other KPI's (Average sales,Number of items,Average rating)vary with fat content. Chart Type:Bar chart
3.Fat content by outlet for sales: Objective:Compare total sales across different outlets segmented by fat content. Additional KPI metrics:Assess how other KPI's (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 influences total sales. Additional KPI metrics:Assess how other KPI's (Average sales,Number of items,Average rating)vary with fat content. Chart Type:Line chart
5.Sales by outlet size: Objective:Analyze the correlation between total sales and outlet size. Additional KPI metrics:Assess how other KPI's (Average sales,Number of items,Average rating)vary with fat content. Chart Type:Donut Chart
Sales by outlet location: Objective:Analyze the geographic distribution of sales across different locations. Additional KPI metrics:Assess how other KPI's (Average sales,Number of items,Average rating)vary with fat content. Chart Type:Funnel chart