Data Model for Container Shipping
This shows a typical Lifecycle of Containers and Customers. The KPIs row is an important contribution to BI and Data Warehousing. Stage 1:Plan Stage 2:Buy Containers Stage 3:Use "Container Shipments" Stage 4:Dispose of Containers Stage 5:Analyse Performance Customer Services and CRM Booking Tracking Documentation Services KPIs Unit Price % Occupancy % Utilisation % Effectiveness Life Contribution+Disposal Price Profitability © DataBase Answers Ltd. 2011