Study And Design Of Business Intelligence System

With China's entry into WTO, the pace of opening to the outside world will be further quickened; there will be more intense competition in the field of trade enterprise. Especially,the retail trade industry is facing an unprecedented degree of challenge. In the future, if a enterprise wants to survive himself in the intense competition, he has to be able to look over the history and fasts to see clearly the future tendency thus to make the decision-making. The fast decision-making came from the correct full analysis to the market, the customer, the enterprise marketing condition and so on. However the system can not be competent for this task, while the Business Intelligence (BI) will do it well. BI is a new technology, which makes integrative use of Data Warehouse (DW), On-Line Analytical Processing (OLAP), and Data Mining (DM) and so on. Via BI, we can transform raw data into usable information and knowledge.Firstly, the basic theory of BI is introduced, including the current concept and evolution.Secondly, the main technology of BI are analyzed,which include DW,OLAP and DM. A data warehouse is a subject-oriented, integrated, time-variant, nonvolatile collection of data in suort of management's decision-making process. In broad sense, the data warehouse is more than just data, is also the process managers that make information available enabling people to make informed decisions. The data warehouse technologies make good use of volumes of data that were accumulated in the long-term operation of corporations, which resolve the contradiction that data is abundant, while information is indigent, and also make it possible for the change of DSS from "model-driven" to "data-driven". We use OLAP to predict, to analysis and to make decision, which is based on data warehouse. Data Mining is the technique that refines the hidden, unknown but potential useful information and knowledge from huge mount of, incomplete, noisy, fuzzy and random business data. This text has described the basic theories in data warehouse and data mining; it is analyzed that the main method used in data mining usually adopts at present.In order to improve the controllability of the whole project process, we introduced life-cycle based project management theory into the development guideline.In this way it can gradually form a set of sound and practical business intelligent system .On the basis of analyzing the characteristics of Chongqing General Trading Group information and operation need, we have provided the general frame of setting up the business intelligent system of Chongqing General Trading Group, and also present the system function summary design and data storage theme analysis design according to the actual needs, finally combining the retail needs and system design of Chongqing General Trading Group, set up the business intelligent system use based on The Microsoft SQL SERVER BI solution.Based on the deep investigation on the theory and alication of BI,the thesis analyzes the role of BI in enterprise management and decision it actually holds. Then the paper goes deep into the research on the Business Intelligence system's construction technique and at last puts forward a BI solution for retail enterprises according to the characteristics of Chongqing General Trading Group. The dissertation is hoped to be valuable for the research on BI theory and alication.