Retail Inventory Analysis Dashboard

Project Overview

This project explores a retail company’s inventory across product categories and regions.
The goal: help managers decide what to stock more of, what to cut back on, and how to allocate resources smarter.

The dataset is fictional but designed to reflect real-world retail challenges.

Why This Matters for Business

Retailers constantly juggle:

• Too much stock → wasted money & storage space
• Too little stock → missed sales opportunities

This Tableau dashboard gives procurement and product teams a clear view of what’s selling, what’s stagnating, and where to focus next.

Key Business Insights

1. Top Products Drive Most of the Money

• Class A items generated over $300K in 2021 revenue.
• Some Class B products performed nearly as efficiently → growth opportunity.

Action: Increase Class B stock to capture more revenue.

2. Categories Tell Two Stories

• Home Accessories & Decoration: High revenue, slow movement.
• Office & School: Low revenue, but high turnover.
• Jewelry: Weak across the board.

Action: Keep Office & School moving, optimize pricing, reduce Jewelry stock.

3. Regional Focus

• USA, Canada, and Europe dominate orders.

Action: Focus stocking and marketing in these regions first.

4. Year-over-Year Winners

• Products like Doughnut Lip Gloss nearly doubled revenue YoY.
• Demand shifted from Home Accessories → Toys & Edibles.

Action: Double down on trending products.

Final Recommendations

• Scale Class B products to grow sales.
• Cut underperformers like Jewelry.
• Improve pricing/marketing for Office & School.
• Prioritize USA, Canada, and European markets.
• Always stock fast-growing products like Doughnut Lip Gloss.

Bottom line: The dashboard helps teams reduce waste, free up cash, and grow revenue.