Super Store Sales

Overview

The MK's Store Performance Dashboard provides a comprehensive analysis of the store's sales, profits, and operational trends over multiple years. Designed to deliver actionable insights, this dashboard features interactive visualizations that highlight key performance indicators (KPIs), trends, and regional performance metrics. It is a valuable tool for tracking progress and identifying growth opportunities.

Observations and Insights

1. Sales Growth vs. Profit Decline: While total sales show an upward trajectory, the significant drop in profit (e.g., 52.3% in December 2014) suggests increased costs, discounts, or inefficiencies.
2. High Discount Rate: A 14.62% average discount rate in December 2014 may have contributed to the profit decline. While this may boost sales volume (27% increase in quantity sold), it erodes profitability.
3. Geographic Disparities: Certain states underperform significantly in terms of profit, indicating potential inefficiencies or market-specific challenges. A targeted regional strategy could address this imbalance.
4. Category-Specific Opportunities:
   • Furniture: Optimize inventory and reduce discounts for Tables to mitigate losses.
   • Technology: Leverage high-performing subcategories like Phones to drive profit while reassessing underperformers.
   • Office Supplies: Continue leveraging the category's steady profitability.

Explore More Projects

Road Traffic Fatalities

Dashboard

Meteorite Landings

Dashboard

SpaceX Rocket Landings

Machine Learning