Reena Pinto

Contact

Superstore Sales & Profitability Analysis

About Project

This project focuses on analyzing Superstore Sales & Profitability data to uncover key drivers of growth and performance. Using Python (Pandas, NumPy, Matplotlib, Seaborn) and Excel, I explored sales trends, customer behavior, discount strategies, product-level performance, and regional differences. The goal was to design actionable, data-driven strategies that improve profits, reduce costs, and boost customer retention.

With over 125 million transaction records, the dashboard delivers insights into unit sales, product demand, and store performance. It also demonstrates how external factors—such as oil prices, transferred holidays, and national events like the 2016 Ecuador earthquake—influence consumer behavior.

The goal of this project is to simplify complex retail data into actionable intelligence, empowering businesses to make smarter decisions on inventory management, pricing strategies, and marketing campaigns.

 

Heading Description
Location :
Ecuador
Client :
Favorita Stores
Project Type :
Data Analytics & Visualization
Duration :
2 Weeks
Completion :
15 Apr 2022
Tools:
Python, Power BI
Deliverables:
Interactive Sales Dashboard

Summary

The analysis revealed that while overall sales were strong, profitability was inconsistent due to regional underperformance, high product returns, and ineffective discounting. Technology products delivered the highest profit margins, while certain office supplies and furniture categories eroded profitability. Customer segmentation showed mid-frequency buyers as an untapped opportunity for loyalty programs. Additionally, shipping delays and negative profits in some cities highlighted operational inefficiencies.

Overall, the study translated raw data into strategic insights—showing how smarter discounting, targeted marketing, improved shipping, and customer loyalty initiatives can significantly improve business performance.

Recommendations

  • Regional Growth: Focus marketing and sales strategies in South & Central to close performance gaps (+15–20% growth).

  • Discount Optimization: Limit heavy discounting in Office Supplies & Furniture to protect profit margins (+10–12% profit).

  • Customer Retention: Launch loyalty programs for mid-frequency buyers to boost Customer Lifetime Value (+12–15%).

  • Returns Management: Improve product quality and support, particularly in Office Supplies, to reduce return costs (-10–15%).

  • Shipping Improvements: Speed up Standard Class shipping and promote First Class to enhance customer satisfaction (+5–7%).

  • City-Level Audits: Review underperforming cities (e.g., Abilene, Beaumont) and replicate successful strategies from top-performing locations like NYC (+10% margin recovery).