Super Store Analysis

developed an interactive dashboard that provides comprehensive insights into sales performance, shipping efficiency, and customer behavior. It aims to support strategic decision-making by identifying trends, areas for

improvement, and growth opportunities across different product categories, regions, and customer segments.

Questions and Answers

What is the sales distribution across regions?

The West region has the highest sales, followed by East, Central, and South.

Which product categories are driving the most sales?

Office Supplies and Furniture contribute the most to total sales, with a strong opportunity to expand in these categories.

What shipping method has the most delays?

96% of delays are associated with the First-Class shipping option, indicating inefficiencies in the logistics process.

Which months or periods see the lowest sales?

Sales dip significantly during the first quarter, especially in February, suggesting the need for targeted promotions.

Which regions or states require shipping improvements?

States such as California, New York, Pennsylvania, and Texas have high rates of delayed orders and need shipping optimizations.

Recommendations

Shipping Optimization: Review and improve First-Class shipping logistics to reduce delays, possibly collaborating with delivery partners.

Product Expansion: Increase the product variety in the Southern region to boost sales and meet customer demand.

Promotional Campaigns: Launch targeted discounts and promotions in the first quarter, especially in February, to drive demand during slow periods.

Customer Loyalty Programs: Leverage CLV insights to develop loyalty initiatives focused on high-value customers.

Category Expansion: Expand Office Supplies and Furniture offerings with complementary products to capitalize on their strong sales performance.