Telecom Business System Construction

At present, the data warehouse application is already more universal, from the telecommunication, bank, stock certificate, arriving the profession realms, such as automobile and tax administration, etc. SDCNC is the group leader of CNC. As an important part of Chinese telecommunication , the data warehouse construction of SDCNC does not begin yet.This subject applies the warehouse technology of the data to the decision analysis system of automobile sale to the need of enterprise's development, make every effort to offer a feasible solution. This data warehouse model which we attempt to finish, can be divided into ETL(data collection(Extract), change(Transforms), wash(Cleaning), the course loaded(Load). )DW(data warehouse), three parts of DM(the data are excavated).This text has probed into the business demands of enterprises again at first, the analysis about initial data, it is mainly that relevant database does not meet the needs of enterprise' s business development on the data analyzing level, set up data warehouse, combine OLAP analysis technology and data excavate technology, is it favorite to enterprise knowledge message of development to find of a large amount question fast to business datum at the same time.The demand is analysed have already confirmed that analyses the data needed in customer service. Will confirm the blueprint in the future of warehouse system of the data on design phase in model. The main task at this stage is that the logic of carrying on the data warehouse is designed, including choose the suitable theme, confirm fact form, linking relevant, attribute an grain size divide, design correct from structure and major key, other key relation, etc.. Step that model is mainly designed including four are basic: Confirm the suitable theme, level of grain size of division, designing and linking forms and designing the estimation of the fact form, data quantity, etc..The data collecting is one of the necessary steps of the construction data warehouse with the data processing. While the data collect, clean, loading, the quality problems of the data are shown especially out. Examine and put the data in order .guarantee the consistency of the datain the data warehouse, gather operation to some data, will raise the inquiry of the data warehouse, speed of analysis, and the comprehensive data con not enter the data warehouse in intact, unanimous, the detail of these. And introduce the ETL , illustrate the importance of data quality in this subject, and the classification of data quality, and also illustrate the design and implement of ETL.This thesis still combines the OLAP analysis the tool MicroStrategy that adopts to the item , and used the MicroStrategy to do a simple OLAP analysis. Then summarize some experiences collecting at the process of data warehouse constructing, and prospected the work direction of the aftertime.