Customer Calls Based On Olap And Data Mining, Data Analysis

This project comes from the telecommunication service demand, it' s based on OLAP and the data mining phone conversation record analysis project, it' s precisely for analysis the income situation of mobile business from the different angle. Carries on the call characteristic analysis and the brand service forecast with the different method, Establishment based on OLAP and data mining phone conversation record analysis system, Aims mainly at the phone conversation data sheet, detailed list form table, administrative area form table, call type table, pronunciation form table, short note form table, statistical type table, Using the data warehouse, the on-line analysis technology and the excavation technology carry on the analysis to the customer telephone conversation information, Thus provides the auxiliary policy-making support to the high level decision-making personnel.This research emphasis on application of OLAP, has realized based on the phone conversation data warehouse design. First used the many kinds of DTS tool to realize the transformation isomerism database to the data warehouse system corresponding table in, Solves the great data quantity data conversion and the online analysis processing question; Has established the multi-dimensional data set in this number according to the warehouse in, Establish the analysis dimension and the measure. Has carried on the multi-level analysis from many dimensions and the different thick fine grain union to the customer telephone conversation information, Realization to customer telephone conversation information data online analysis processing and auxiliary policy-making.This research used Microsoft Corporation' s database system SQL Server 2,000 to take the data warehouse and the OLAP database server, In view of isomerism database origin, Uses the DTS data conversion tool, Analysis Services data analysis tool, In the technology has realized the data...