Walmart Superstore Retail Analysis

Problem Statement

Walmart Superstore was dealing with high-volume sales but inconsistent profitability. The leadership lacked visibility into product-level performance and regional trends. Without a centralized reporting tool, it was difficult to identify which areas required strategic attention.

Project Goal

To build a comprehensive Excel dashboard that enables stakeholders to:

• Monitor performance KPIs in real time

• Track profitability across regions and segments

• Optimize underperforming categories and reduce returns

Key Features

• Interactive filters for Region, Segment, Category, and Order Priority

• Visual KPIs: Sales, Profit, Quantity, Returns, Shipping Cost

• Segment-level profitability breakdown

• State-wise sales heatmaps

Returns analysis to identify refund-heavy products

Outcome

The final dashboard offered Walmart’s leadership a one-stop view of business performance. It helped streamline inventory decisions, identify loss-making sub-categories, and align marketing efforts with high-margin product lines.