Categories: Uncategorized
Tags:

Inventory Classification and Demand Forecasting – Power BI Tutorial

This dashboard titled “Inventory Classification and Demand Forecasting” provides insights into sales, demand trends, and inventory performance across categories and items. Here’s a breakdown of each section:

🔷 Top Left: Monthly Demand Trends for Top 5 Items

  • Chart Type: Line Chart
  • Details: Shows monthly demand (in units) for the top 5 items by Item_ID (ITM_395, ITM_925, ITM_169, ITM_512, ITM_522).
  • Purpose: Helps track how demand changes over time, supporting inventory planning.

Dataset Link: https://www.kaggle.com/datasets/shahriarkabir/abc-xyz-inventory-classification-dataset/data

🔷 Top Center: Sum of Total Sales Value by Category

  • Chart Type: Donut Chart
  • Details:
    • Grocery: Dominates with 912M (85.03%) of total sales.
    • Others: Apparel (99M), Electronics (25M), etc.
  • Purpose: Identifies which product categories drive revenue.

🔷 Bottom Left: Distribution of Price Per Unit & Sales Value

  • Chart Type: Combo Chart (Bar & Line)
  • Details:
    • Bars represent Count of Items by price bins.
    • Line shows Total Sales Value for those bins.
    • Most items are priced under 500 units with the highest sales value in that range.
  • Purpose: Analyzes price sensitivity and contribution to revenue.

🔷 Bottom Center: Top 10 Items by Annual Demand

  • Chart Type: Horizontal Bar Chart
  • Details:
    • Lists items like “Lay Building”, “Decide Clear”, “Light Sport”, etc.
    • Each item has annual demand around 59K–60K units.
  • Purpose: Highlights high-demand items for inventory prioritization.

🔷 Top Right: Filters

  • Dropdowns for:
    • Item_ID
    • Category
    • Item_Name
  • Purpose: Enables dynamic filtering to drill down into specific data segments.

🔷 Right Center: KPI Tiles

  • Total Annual Units: 17M
  • Total Sales Amount: 1bn
  • Purpose: Summarizes the overall scale of operations.

🔷 Bottom Right: Branding

  • Mentions “Learn Power BI @ Slidescope” – probably the creator or training provider.

Summary

This Power BI dashboard offers a comprehensive look at inventory performance, enabling data-driven decisions around:

  • Stocking high-demand items,
  • Prioritizing high-revenue categories,
  • Price optimization,
  • and forecasting future demand.