| Door-to-Door container transportation service is more and more popular in the past few years, the management mode of container lines had also been changed from Port-to-Port type to Door-to-Door type.But the container shipping companies had a lot of daily operation systems, such as vessel system, container system, cargo system, finance system and some other systems. If Door-to-Door management mode is used, the analyst has to extract different data from different systems and then manually merge these data. The Line companies need a concentrated platform, which can supply the object oriented data, and a plenty of analysis tools.Data warehouse system fits for the line companies'needs. This article will help to discuss how to set the data warehouse business scope, data warehouse designing, data warehouse application, and recommend some useful cases.In the first part, this article will use strategic driven method to set DW scope, and then use SMART rule to simplify the DW scope, weighted score method to set up implementation priority.In the second part, this article will introduce architecture design, ETL, user interface, metadata management, and the application of DW system.In the final section, this article will introduce two cases, that helped C Company saved USD 10,000,000 cost during 2007. |
PDF Full Text Request