Design And Implementation Of Business Intelligence Systems

In this paper,domestic and overseas developing actuality of Commercial Automatization was reviewed and existent problems in the development of CMIS (Commercial Management Information System) were illuminated. The paper analyzed necessity of implementing BPR ( Business Process Reengineering) in designing CMIS.,and detailedly analyzed conception,main point,implemental procedure of BPR. The paper reset organization and commercial business process according to BPR. On this base,I designed and developed CMIS,which achieved automatic management of commercial operating activity.Successful implementation of CMIS supplies the chance for application of BIS (Business Intelligence System) . This paper introduced conception and developing actuality of BI (Business Intelligence) and analyzed necessity and feasibility of BIS' implementation on the base of CMIS,and further illuminated important contents of BI such as DW (Data Warehouse) and OLAP (Online Analytical Processing) .BIS was fundamentally achieved on the base of CMIS Application of BI in the commerce areas was researched. BIS composed of three subsystem:RTFS (Routine Transaction Processing System),DWMS (Data Warehouse Management System),DWCS(Data Warehouse Client System).This paper detailed demonstrate the extract of data from data source,loading data into DW(data warehouse),the creating and management of data source,dimension and cube of DW,and implementing of data mining andOLAP.During the period of Commercial Automatization building,this paper introduces BRP,achieves the optimizing of commercial business process and improves the relevant elements. It establishes favorable foundation for the successful application of CMIS further apply BI(Business Intelligence),design and primarily develop BIS. By developing MIS(Management Information System) into DSS(Decision Support Systems),it can supply decision-making support for the decision-makers of commerce cooperation and make them do the rapid and right decision in the more and more vehement changeable market environment.