Retail Profitability Story: Insights from Sample Superstore

SIRI SIGURLA

2025-06-11

Introduction

  • This storyboard presents business insights from Sample Superstore data.
  • Focus areas: sales, profit, discounting strategy, regional performance.
  • Dataset: 9,994 transactions across U.S. regions.
  • Goal: Identify trends to improve profitability.

Sales vs Profit Overview

## # A tibble: 1 × 3
##   Total_Sales Total_Profit Profit_Margin
##         <dbl>        <dbl>         <dbl>
## 1    2297201.      286397.         0.125
## `geom_smooth()` using formula = 'y ~ x'

Profit by Category & Sub-Category

## `summarise()` has grouped output by 'Category'. You can override using the
## `.groups` argument.

Regional Performance

Discount Impact

## `geom_smooth()` using formula = 'y ~ x'

Top & Bottom States by Profit

Key Takeaways

  • Tables, Bookcases, and Supplies contribute major losses.
  • Heavy discounting often leads to negative profit.
  • Focus profitability improvement efforts on West and East regions.
  • Review pricing strategies in states with consistent losses.

References