Categories: Data Analytics / Power BI / Practice Datasets
Tags:

Global Product Inventory Analysis Dashboard – Power BI

This Power BI dashboard, titled “Global Product Inventory Analysis Dashboard,” provides an overview of inventory performance using various metrics and visualizations.

Dataset is available here : https://www.kaggle.com/datasets/keyushnisar/global-product-inventory-dataset-2025

Key Metrics Displayed (Top Section)

  1. Total Price: 1.72M – The total price of inventory.
  2. Total Stock Quantity: 340K – The number of stock units available.
  3. Total Inventory Value: 86.33M – The overall value of inventory in the system.
  4. Average Product Rating: 3.01 – The average customer rating for products.
  5. Average Inventory Value: 12.81K – The mean value per inventory item.

Filters on the Left Panel

Users can filter data based on:

  • Product Category
  • Product Name
  • Color
  • Expiration Status (Is Expired)
  • Size
  • Manufacturing Date Range (from 01-01-2023 to 20-07-2023)

Visualizations & Insights

  1. Expired vs. Unexpired Products (Pie Chart)
    • Expired: 2.27K units (33.74% of total inventory).
    • Unexpired: 4.47K units (66.26% of total inventory).
  2. Total Inventory Value by Product Category (Bar Chart)
    • Electronics, Clothing, and Home Appliances each have an inventory value of 29M.
    • Stock quantity for these categories ranges from 111.1K to 114.7K.
  3. Inventory Value by Color Size Variation and Category (Sankey Chart)
    • Shows how inventory value is distributed across color variations (Green, Blue, Red) and product categories (Clothing, Electronics, Home Appliances).
  4. Total Inventory Value by Product Name (Bar Chart)
    • Top products by inventory value:
      • Monitor: 22.58M
      • Smartphone: 21.99M
      • Headphones: 21.44M
      • Laptop: 20.33M
  5. Total Inventory Value by Warranty Period (Tree Map)
    • Products with a 3-year warranty hold the highest inventory value of 29.66M.
    • Other warranty periods include 28.47M and 28.20M.
  6. Total Inventory Value by Product Dimensions (Bar Chart)
    • Lists dimensions like 6x16x11 cm, 11x11x19 cm, and 15x15x16 cm, all contributing 0.12M to total inventory value.

Conclusion

This dashboard allows users to monitor inventory distribution, product categories, expiration trends, and product value based on various attributes. The inclusion of filters enables deep data exploration for better decision-making.