Design And Research Of The Business Analyzing System Based On Data Warehouse For Telecom Corporation

Telecommunications is one of the most data-intensive industries that anyone can imagine. The company must execute the transaction and then keep track of it in order to monitor network performance, issue bills, and perform network planning and optimization exercises. These data were being stored separately in various business systems, have not been effective development and utilization. One of the most fascinating things about the telecommunications industry is the way the business has been able to take advantage of technology, data, and knowledge in order to provide better service to its customers. Competition makes data more important than ever before. The challenge then is to have the right data accessible and analyzed by the right data tools, manipulated by the right decision makers. The future of data warehousing and data mining must certainly sound attractive. We are going to get serious about using this technology to solve business problems. The data warehousing provides us an opportunity to improve our overall service to our customers and thus improve our business. Data Mining is a sophisticated tool which will provide not only reporting but analysis that will help us to see correlations and ultimately business opportunities we had not previously identified.This paper will explain the value of warehouse in promoting enterprise core competencies through the introduction of a concrete case about Telecom Business Analyzing System implementation. In the period of postgraduate study, I participate in the design and development of the domestic telecom business analysis system. This system is based on the data warehouse. A data warehouse is a collection of data assembled for the express purpose of making information available to users. It can supplement the process of turning the technological telecommunications potentials into economic and practical reality for people, businesses, and governments all over the world.The main content of this article is the research on the theory and methods of Telecom Business Analyzing System and warehouse. The main job of this article includes three parts. First of all, Design of The Telecom Business Analyzing System (TBAS). This part described the system architecture of TBAS. It included Telecommunications System Architecture design, system deployment, network design and functionality of the modular design and so on. Secondly, We introduce the theory and ways of establishing data warehouse based on business system foundation in telecom company, providing the basic theories for the data warehouse application in telecom company and practical methods. It includes the data warehouse application system construction design, data model design, data size design, division design and data market design. Finally, Telecom data warehouse ETL design. ETL is one step of the data warehouse building. Based on the research of the theories related to data quality problems, and for the requirements of high level data quality to telecom enterprises, a data quality control architecture oriented telecom applications is designed. An ETL system for the purpose of data cleaning is implemented.