Problem: -

BlinkIT faces challenges with inconsistent sales performance across its outlets and product categories. This project focuses on optimizing product offerings, refining outlet strategies, and aligning pricing models to maximize revenue across all locations. 

Background

Welcome to the BlinkIT Corporate simulation! BlinkIT is a grocery retail chain operating across multiple cities, aiming to enhance its sales, outlet performance, and product dynamics. The objective is to analyze data using Power BI to uncover key trends and provide actionable insights that drive growth and profitability. 

Solution

BlinKit KPIS Report provides key insights to Identify high- and low-performing products, trends, evaluate outlet performance to tailor strategies, improve inventory, and enhance operations, promote underperforming products and Implement data-driven pricing to maximize margins while staying competitive.

KPIS :-

Total Item -8515

Total Sales - 18.58 M

Price Range :

Min Price :- 31.29

Max Price:- 266.89

AVG price : - 141.01

Avg Outlet Sales :- 2,18.56

Avg Item Visiablity :- 0.07

Medium price item sales - 4.64k

Low price item sales - 2.44k

High price item sales - 1.44 k

Sales by Outlet Size: -

Small size has highest sales :- 48.22%

Medium size has 40.24%

High size has low sales :- 11.53%

Highest Outlet Sales by Outlet types:-

Highest in Supermarket Type1 Tier2 - 6.47M

2nd highest in supermarket Type1 Tier1 :- 4.3M

Lowest outlet sales by outlet type:-

Grocery store Tier1

Grocery store Tier3

Top selling Categories :-

Fruit and vegetable : - highest sales at 2.8 M(15.18%)

hishest visibility - 90.16

Snack foods :- 2nd highest at 2.7M(14.67%)

Household Items :- closely at 2.1 M(11.07%)

Low selling Categories :-

Seafood :- Very low at 0.1 M(0.8%)

Breakfast items :- 0.2 M(1.25%)

Key Insights :-

tem sales by price range :-

A large number of items fall in the medium price range (4.64k items), which may suggest that the

store's pricing strategy focuses on middle-market products

Top Selling Category :-

Fruits and vegetables , snack foods are suggesting customer preferences , enhancing profitability

and also shows highest item visibility

Sales by outlet size :-

small stores and medium stores make up the largest share of sales (48.22% , 40.24%) allows

companies to focus their marketing and inventory strategies on these stores to maximize sales and

profits

outlet type :-

Supermarket Type 1 Tier 2 generates the highest sales at 6.47 million.

Supermarket Type 1 Tier 3 follows with 4.3 million. Efforts on maximizing sales

from focus on high-performing outlets

Outlet Age :-

 outlet age 39 in Item Type Fruits and Vegetables made up 3.23% of Sum of Item Outlet Sales

Events need Improvements :-

Lowest high price sales :-

Lowest number of item falling in high price range(1.44k) . Consider expanding

the premium or luxury product range to cater to higher-end customers and improve

profitability.

Lowest Selling Category :-

Seafood( 0.1M),Breakfast(0.2M) are needing attention to boost overall sales performance ,

lead uneven revenue distribution

Outlet size performance :-

Analyzing underperformance outlet size and Investigate the reasons for low sales in high

outlets, such as product unsuitability, pricing issues, or competition.

Outlet Type :-

Investigate underperforming outlets and analyze why Grocery Store Type 1 has low sales and

explore strategies to improve performance in this segment.

Low Visibility :-

The item is experiencing low visibility and low sales, indicating underperformance in the outlet,

which may be attributed to a lack of customer preference and potential pricing issues.

Business Recommendation :-

• Adjust the product offerings, pricing strategy, and target market focus to better align with customer needs and maximize sales.

• By focusing marketing efforts on top-selling categories, the business can increase visibility and sales in these areas, enhancing profitability

• Implement targeted promotions or bundle offers for low-selling items to boost their sales.

• Refocusing efforts:

Redirect marketing ,increase inventory and sales resources towards small and medium

outlets with higher sales potential.

• Product Diversification:

Introduce new products or variations within the medium outlet category to attract a

broader customer base.

• Market Analysis:

Conduct a thorough analysis to understand why high outlets have lower sales. This

could involve assessing market demand, competition, and pricing strategies. Identify

niche markets or specific industries that may benefit from high outlets and tailor

marketing efforts to these segments.

• Resource allocation:

Allocate resources (marketing, inventory, sales teams) strategically based on outlet

performance.

• Growth potential:

Identify opportunities to expand in high-performing segments and

improve performance in underperforming outlet