Research On The Design Of Automobile Industry Intelligence Analytic System Based On Data Warehouse

After entering WTO, Chinese automobile enterprises will be in international competition flood tide without going out. Although chinese auto market is not very mature, the overseas gaints of the industry enter into China, intensifing the competition,because this market has the formidable expense potential. How to strengthen themselves'intelligence analysis work and enhance themselves'analysis ability become chinese automobile enterprise's pending issue.In the book "the Future Speed",Bill Gates writes: " The most significant method to distinguishes your company and your competitor's company, causing your company to be the leader in multitudinous company's best method, is to do the best work using the information. How to collect, manage and use information decides your victory and loss." The intelligence analysis takes benchmarking as the cornerstone and use the intelligence work's technology or skill.It is a kind of work that overall analyzes the information and the opportunity. The intelligence analysis is the important method by which the enterprise gains the competitive advantage. It analyses the enterprise's intelligence by using the method of statistics and specialized analysis, providing the scientific basis for enterprise's decision-making.This takes enhancing the automobile enterprise's competitive ability and promoting the automobile enterprise's development as the enterprise's goal. It utilizes the information technology, providing information support for the automobile enterprise's decision-making. In the foundation of the preliminary researching and exploring automobile industry intelligence analysis system based on data warehouse, this thesis discrips the information analysis system's systemstructural design in detail, designs the multi-main bodies multi-dimensional data model, and constructs automobile industry intelligence analysis data warehouse conforming to the automobile industry intelligence analysis request from expounding the automobile industry intelligence analysis system's goal and the function.I expect it to be significant to the construction of the automobile industry intelligence analysis system.This thesis is constituted of six parts:The first part proposes the significance and the research content of this research in the foundation of analyzing the background and the domestic opinion & alien opinion. Facing the intense competition, chinese automobile enterprises must enhance their intelligence analysis ability, so as to enhance their competitive ability.The second part introduced related concept of the intelligence analysis system. It descriminates the concept of the data, information and intelli- gence,and further introduces the concept of the information analysis and the intelligence analysis in this foundation.This thesis discriminates the information analysis and the information analysis as well. At the same time, the thesis has produced concept of the intelligence analysis system, and introduced related technology of the intelligence analysis system.The third part analyzed the automobile industry intelligence analysis system from the aspect of feasibility, the demanding and the function in detail and elaborate necessity, the technical feasibility, the economical feasibility, the management feasibility and the social feasibility of the system. Simultaneously,this thesis analyzes the data, the research method and the expressing form of the results in detail. It analyzes the system's function from the aspect of the qualitative analysis and quota analysis.The fourth part designs the automobile industry intelligence analysis system and the structure model in detail.It designs logical model, the physical model, OLAP and ETL of the data warehouse specially.The fifth part simply appraises the automobile industry intelligence analysis system. The sixth part summaries the contruction of the automobile industry intelligence analysis system and had pointes out disadvantages of the system simultaneously.