Research On Application Of Data Warehouse And Data Mining Technology On Telecommunication Business Customer Analysis

With the transformation of the operation pattern among the telecommunication enterprise from production to customer, the competition also transform from frequent price to service quality. One the hand, these need telecommunication enterprises improve their science decision-making urgently, improve service quality and raise market competitiveness. On the other hand, telecommunication enterprise has accumulate large amount of electronic business data, a lot of valuable information can be found from these business data by data warehouse technology and data mining technology ,and offering a well decision to enterprise .At first, the text explains the background of the article, the application trend of telecommunication enterprises data warehouse and the content of the research. It briefly introduces data warehouse technology, UDM, OLAP, data mining technology, SQL Sever 2005 business intelligence. The content including the concept, the character and the critical technology of data warehouse ,the integration service, analysis service and reporting service of SQL server 2005 business intelligence.The second, the paper introduce the business requirement and status of telecommunication business customer analysis system, the content include the application requirement of telecommunication enterprise for data warehouse, actuality status and existent problem. It states the requirement of establishing data mart, multidimensional analysis, data mining analysis and displaying the result. According to the requirement, the paper explains particularly some examples.The third, the article expatiate the design and realization of the system. The content include the data mart establishing process of telephone charge calculation of the business customers analysis system, multitude source data loading, the multidimensional analysis, data mining analysis and the result displaying .Finally, the paper indicate some innovation and some questions of demanding continuative researching.