The Design And Implement Of Port Logistics Business Intelligence System Based On Data Warehouse And OLAP

To the practical application of logistics for the background, data warehouse technology and its application in small and medium sized logistics enterprises was discussed that the proposed business intelligence solutions designed to help businesses take full advantage of its logistics business support system to produce a large number of valuable data resources to achieve the intelligent information processing and handling, for market operators to provide timely,accurate and scientific decision-making basis to enable enterprises to adapt to the increasingly fierce market competition,enhance the core competitiveness of logistics enterprises.Based on characteristics of the logistics industry to form an instance of a data warehouse throughout the life cycle of each part of the design and implementation methods. Paper,the system analyzes the data warehouse for the entire development life cycle, and in practical applications to Microsoft SQL Server 2000 for the relational storage engine, the first use of ETL process from the source scheduling system in the collection,analysis and conversion to clean the source data, the establishment of a data warehouse for use. To BO ProClarity suite of development tools for data display for a data warehouse development. By supporting the data re-mining,decision makers can learn more detailed information. Report Center of the establishment of the enterprise decision makers can analyze the data on past data to adjust the strategy to predict the future, through the historical data to find trends. Further strengthening the logistics business management and customer analysis , science , enhance the enterprise's decision-making level and operational efficiency.Thesis developed data warehouse system is on-site commissioning, from operation of view,can provide businesses the flexibility to query the business functions,can provide the management of enterprise decision-makers a comprehensive, accurate information about state business functions. This paper proposed the establishment of small and medium enterprise data warehouse logistics methods have similar characteristics also apply to other small and medium enterprises. This approach to the needs of small and medium enterprises,business model established under the complicated conditions of personnel data warehouse environment is a certain reference value.