Dashboard Overview

The dashboard provides a centralized view of inventory performance through KPIs, charts, slicers, and interactive filters.

🔹 Key Analysis

• 📦 Total Stock Quantity – Tracks the overall quantity of items available in inventory.
• 💰 Total Stock Value – Measures the total monetary value of available inventory.
• 📊 Average Stock Quantity – Shows the average quantity of stock maintained per item.
• 💵 Average Stock Value – Displays the average value of inventory items.
• 🔄 Restock Quantity – Identifies the quantity of inventory that needs to be restocked.
• 📋 Item by Status – Categorizes inventory into:
  • Below Reorder
  • Sufficient
• 🏷️ Total Stock Value by Category – Compares inventory value across different product categories.
• 🏭 Warehouse Analysis – Allows inventory to be analyzed by warehouse location.
• 🤝 Supplier Analysis – Provides supplier-level filtering and analysis.
• 🔎 Restocking Analysis – Helps identify items that require replenishment.

🎛️ Interactive Features

The dashboard includes interactive filters/slicers for:

• Category
• Supplier
• Warehouse Location
• Stock Status
• Item Name

These filters allow users to dynamically explore different areas of the inventory data.

🛠️ Tools & Techniques

• Microsoft Excel
• Pivot Tables
• Pivot Charts
• Slicers
• Excel Formulas
• Data Analysis
• Data Visualization
• Inventory KPI Analysis
• Business Intelligence

🎯 Objective

The objective of this project is to convert raw inventory data into an interactive business dashboard that helps organizations monitor stock levels, understand inventory value, identify items below reorder levels, and make better inventory management decisions.

💡 Business Questions Answered

This dashboard helps answer questions such as:

• How much stock is currently available?
• What is the total value of the inventory?
• Which categories hold the highest stock value?
• How much inventory needs to be restocked?
• Which items are below the reorder level?
• Which suppliers provide inventory?
• How is inventory distributed across warehouses?
• What percentage of items have sufficient stock versus those below the reorder level?

📂 Project

This repository contains the Microsoft Excel workbook with the complete Inventory Management Dashboard and its supporting analysis.

#DataAnalytics #MicrosoftExcel #ExcelDashboard #InventoryManagement #DataVisualization #BusinessIntelligence