Research Of The Automobile Sale Management System Based On Business Intelligence Technology

With the increasingly fierce market competition and the development of computer technology, information technology has become the inevitable demand of various industries. The requirements of information access, processing, handling in the business activities are going higher and higher. The traditional operation-based information management system has been difficult to meet needs of personalized query, analysis and decision support in enterprise. The concept of business intelligence (BI), which is technically supported by data warehousing (DW), online analytical processing (OLAP) and data mining (DM), is widely recognized by companies.According to the company’s business goals, Business Intelligence can convert the business data into a clear, based on facts and be able to conduct information through data analysis and data mining. From the above information, business personnel can find customer trend, increase customer loyalty and explore new sale opportunity. Business intelligence can give a support to enterprise management and decision-making, and help to improve competition of enterprise.This thesis come from The Key of National863High Technology:Related Technologies and Product Development of Business Intelligence Platform for Flexible Manufacturing Industries, Business intelligence and its applications in the automobile sales industry have been studied in it.Firstly, such topics as "what is BI","BI development","the market situation of BI products" have been expounded, while data warehouse, OLAP technology and data mining technology, as the basic techniques of BI, have been introduced at the same time.Secondly, combined with the characteristics of business intelligence technology, a series of solutions about the automobile sale management system based on business intelligence technology, such as a data warehouse for automobile sales analysis and the fact tables and dimension tables of multidimensional model were build through access. The data in automobile data warehouse were demonstrated multidimensionality and done mining analysis using time series algorithm by applying the SQL Server2005Analysis Services, a business intelligence realizing tools, based on established automobile sales warehouse. It is discovered that abnormal sales companies and maintenance rules of each repair site and forecasted the sales of companies in next year, it played an important role on management decision-making and increase sales profit.Finally, multidimensional exhibition and data mining platform was designed by applying Visual Studio2008and Dundas Chart control, it can improve the visualization of data analysis. The multidimensional exhibition data and mining analysis results were displayed in a diagram form, so the data can be showed vividly by this platform, which is more beneficial to make qualitative and quantitative analysis of data for policy-makers.