|
The subject from the business needs of the telecom services sector , OLAP and data mining - based customer call data analysis project from different points of view in order to solve the mobile enterprise income analysis , using different methods call analysis and brand business forecast establish customer call data analysis system based on OLAP and data mining , focuses on customer call data table , customers call list table , list format table , a political subdivision format table , the table of the type of call , voice format table , SMS format tables , statistics type table data resources , data warehouse , online analytical technology and mining techniques to analyze customer call information , assisted decision support high - level decision-makers . Topics focused on the OLAP application , to achieve customer call information - based data warehouse design , with a wide range of DTS tools heterogeneous data conversion , to solve the large amount of data , data conversion , and online analytical processing , in this on data warehouse cube , established analytical dimensions and metrics . Departure from the multiple dimensions and different coarse fine-grained multi-level analysis of customer call information , customer call information online analytical processing and auxiliary decision support . This topic using the database system of the Microsoft SQL Server 2000 database server as a data warehouse and OLAP database , using the the DTS data conversion tool for heterogeneous database sources , Analysis Services data analysis tools , technical data warehouse data conversion , star type modeling , cube design , OLAP query analysis , data mining, analysis , data show functional modules . In actual use , this paper OLAP architecture achieved certain results , the use of data warehouse for decision analysis for telecom operators made ??their own efforts .
|