Skip to main content

Adjustment

The data model revolves around tracking container quantities with measures such as Adjustment Quantity of the Container, Initial Quantity of the Container, and Quantity in Units of Consumption. Views like Adjustments, Total_Adjusted_Amount, Adjustments_By_Type, Adjustments_By_Date, Adjustments_By_Product, and Adjustments_By_Customer offer insights into adjustments made, aggregated amounts, breakdown by type, dates, products, and customers for analysis, trend monitoring, performance evaluation, and customer profiling purposes within the dataset.

Benefits of This Data Model​

  • Enhanced Analysis: The data model allows for detailed analysis of adjustments by type, date, product, and customer, providing insights for decision-making.
  • Performance Evaluation: Through the views and dimensions provided, performance evaluation at various levels such as product, customer, and site can be efficiently carried out.
  • Trend Monitoring: The model supports trend monitoring by organizing adjustments by date, enabling the tracking of patterns and trends over time for strategic planning.
  • Customer Profiling: With segmentation of adjustments by customer, the data model facilitates customer behavior analysis and profiling for better understanding and targeting.

Key Performance Indicators (KPIs)​

  • Ajustement Quantité du contenant: This measure represents the adjustment quantity of the container, indicating any changes made to the quantity within the container.
  • Initiale Quantité du contenant: This measure represents the initial quantity of the container, providing information about the starting quantity present in the container.
  • UC Quantité: This measure represents the quantity in units of consumption, indicating the quantity allocated for consumption.

Available Visualizations​

View NameDescription
AdjustmentsProvides detailed information on all adjustments made in the dataset.
Total_Adjusted_AmountAggregates the total amount of all adjustments made in the dataset.
Adjustments_By_TypeBreaks down adjustments by different types for analysis and comparison.
Adjustments_By_DateOrganizes adjustments by date to track trends and patterns over time.
Adjustments_By_ProductAnalyzes adjustments on a product level for performance evaluation and decision-making.
Adjustments_By_CustomerSegments adjustments by customer for customer behavior analysis and profiling.