The Design And Realization Of Shandong Telecom Business Analysis System

With the rapid increase of data amount and widely used of the information management system, enterprises managements need to query and statistics on the data, and online data processing, data mining of large amounts of complex data is also needed, and then analyzes the valuable information, so as to help business decision-makers to make correct decision. In this case, traditional relational database can not satisfy the need for data analysis, data warehouse technology emerge as the times require. The present data warehouse is widely applied in various fields.According to the needs of enterprise development, a business analysis system using data warehouse technology in Shandong Telecom is constructed in this thesis. In order to provide a set of feasible solutions, design and implementation of a data warehouse model including a data extraction, conversion, cleaning and transfer process. Are discussed based on the enterprise business needs, determined by the demand analysis of user service of data required for the analysis, the logical design of data warehouse in the model design, including the selection of appropriate subject, determine the fact table, correlation dimensions, attributes, and according to the problems of data quality of data extraction, cleaning in the process, reproduced highlight, on the test data, sorting, aggregation and cleaning operations, and data warehouse, on-line analytical processing of Shandong telecom is constructed based on MicroStrategy analysis method...