Dicision Support System Design And Development Based On OLAP

Decision support system is a kind of computer application system which can calla variety of information resources and analytical tools to provide decision-makers aenvironment with analysis of the problem, establishment of a model, simulation of thedecision-making process and programs. Traditional decision support system achievedecision support from the viewpoint of the model and knowledge, focus on thedecision-making process and use the knowledge come from knowledge engineering.But the traditional decision support system neglects the state and the background ofthe enterprise where the decision-making comes from. In fact, a large number ofhistorical data generated in the enterprise operation process contains not only thestatus and trends of the business running, but also a large number of environmentalinformation. And taking full advantage of the information can help decision-makersgrasp the business running trend and make right decisions. Data-driven decisionsupport system, one kind of decision support system, sum up the regularity anddevelopment trend of the business activities to support the decision-making processby emphasizing the use of relevant technology for mass data’s collection, collation,analysis, mining, comparison, prediction and display. So that enterprise managers canaccurately grasp the company’s overall operating conditions, and specify the correctdevelopment strategy.Enterprises sales information is characterized by huge amount of data, dispersedand fragment, department, like customers, sales channels, sales, market, production,has its own independent information management systems, information indepartments is fragmentation. At the same time, in order to develop a timely andcorrect sales strategy, management and operational personnel query demand is moreand more complex. Therefore, in order to meet the management and decision-makingneeds of business people, it is necessary to build an information sharing platformwhich can provide a comprehensive and integrated analysis of the data. So thatenterprises can be targeted to develop long-term marketing strategy and short-termsales plans with accurate data as support, and it can better understand the marketdemand, lower sales costs and improve economic efficiency. OLAP online analyticalprocessing is a data access and analysis software technology which is sharemultidimensional information and for specific problem. It can processes large amountof data in accordance with the complex query requirements of the analysts quickly and flexibly. Then feedback the query result to the decision-makers by an intuitiveand easy-understanding way. So that decision-makers can accurately grasp theenterprises business situation and understand the needs of the object, then develop theright strategy.A complete enterprise sales decision support system was designed andimplemented according to the characteristics of enterprises sales data by using datawarehouse, online analytical processing, and front-end display technology. Themanagement and operational staff are provided a unified sales data analysis platform,in order to bring competitive advantage for enterprises by fast and accurate analysis ofdata.First, the concept, development process and the current situation of the decisionsupport system was introduced. Then it introduced the effect of the data-drivendecision support systems in the enterprise, and some theory and technology, such asETL, data warehouse and OLAP.Secondly, the sales decision support system architecture was designed accordingto the actual business needs of the enterprises include the model of the data warehouse,ETL process, the application layer, as well as front-end presentation layer.Finally, the concrete realization of the system is described in detail, includingdata ETL process, data warehouse, OLAP data analysis layer and system reportsspecific implementation process. And further detailed study on how to improve theperformance of OLAP online analytical processing.Decision support system as a state-of-the-art modern information technologyproviding enterprises with effective decision-support information and solutions so asto reduce the burden of managers engaged in low-level information processing andanalysis to improve the efficiency and effectiveness of decision-making, so thatenterprises will have stronger market competitiveness.