Stock KPI
The data model captures stock quantities, container capacities, and occupancy rates across locations. It includes measures such as Stock Quantité and Contenant Quantité Maximum, reflecting inventory levels and storage limits. Views like Occupancy Rate and Overall Occupancy Rate analyze space utilization, while In Stock vs Capacity compares stock levels to maximum limits. The model also organizes stores by Stock Qty and displays stock status based on controlled fill levels, providing a comprehensive overview of key stock-related metrics.
Benefits of This Data Model
- Enhanced Space Utilization: The data model enables analyzing and optimizing space utilization across locations by providing insights into occupancy rates and comparing current stock levels to maximum capacities.
- Effective Stock Monitoring: With dimensions such as Magasin Type and Stock Quantité, the model allows for detailed monitoring of stock levels at different store types, facilitating proactive inventory management decisions.
- Comprehensive Performance Analysis: The model supports a thorough examination of stock-related metrics through the Key Performance Indicator View, offering a holistic view of key indicators for assessing operational efficiency.
- Precise Stock Status Evaluation: By incorporating dimensions like Control Packing and assessing stock status based on controlled fill levels, the model provides a precise evaluation of stock levels and ensures accurate reporting on inventory status.
Key Performance Indicators (KPIs)
- Stock Quantité: This measure represents the quantity of stock available in the inventory.
- Contenant Quantité Maximum: This measure indicates the maximum quantity that a container can hold.
- Location Occupancy Rate: This measure calculates the percentage of space utilized in a given location.
- Location Occupancy Rate 100%: This measure captures the percentage of space fully occupied in a specific location.
Available Visualizations
| View Name | Description |
|---|---|
| Occupancy Rate | Calculates the percentage of stock capacity currently in use. |
| In Stock vs Capacity | Compares the current stock level to the maximum capacity. |
| Key Performance Indicator View | Provides a comprehensive overview of stock-related metrics. |
| Overall Occupancy Rate | Calculates the total occupancy rate across all stock items. |
| Stores by Stock Qty | Organizes stores based on the quantity of stock they hold. |
| Stock par Controle Remplissage | Displays stock status based on controlled filling levels. |