Research On Data Analysis For SP Service Platform Based On OLAP Technology

In recent years, mobile value-added business has been developed rapidly, and the competition between enterprises has become more and more fierce. All Business operators are continuously cutting down the cost, developing new service, maintaining current customers, gaining new market share and responding to the changes of market timely and rapidly. At present, the telecommunications company has been set up relatively well OLTP (online transaction processing) system, Along with time passing, companies have accumulated a large amount of historical data, these operational data is valuable wealth of enterprises, which contains many important information. We could find business information that vital to the development of enterprises through the analysis and deal with the historical data, thereby helping enterprises to make more rational decision-making and enhance the competitiveness of enterprises. So it is necessary and important to set up data warehouse and multi-dimensional analysis for specific topics of user concern.Based on the in-depth research and analysis of the operational data in the SP business platform, this article discussed the design and implementation process of the statistical analysis data warehouse and online analytical mode. The specific content of the thesis is as follows:In this paper, after the introduction of the background and research content of the paper, it briefly introduced the key technology (data warehousing technology and OLAP technology) that the system used, and then the statistical analysis data warehouse model of SP service platform has been analyzed and designed detailed, the design mainly combined with the demand of Business users and the special features of the Service, and builds the data warehouse model which has two subjects (Service Subscribe and Unsubscribe, Service Use). At the same time, data ETL Process and data update strategy has been analyzed and designed elaborately. Finally, it told us the design and implement of multi-dimensional OLAP analysis for the selected topics. For a more intuitive search results will be displayed to users, the thesis used the OWC (Office Web Components) technique to realize data front display. Paper also demonstrated how to conduct multi-dimensional data analysis. And the paper predicts and analysises the channel development and service unsubscribe through the decision trees model and time-series model.