The Design And Implementation Of Analysis And Decision Systems For Car Sales

In the construction process of enterprise informatization, a number of management systems have been developed, such as human resources management system, production management system, procurement management system, sales management system, financial management system and customer relationship management system, and so on, and these subsystems have played a significant role in the development of enterprise. However, due to the lack of overall planning when building these systems, some inevitable problems, such as information silo, information countermeasures, and so on, have emerged. The analysis and decision systems for car sales will integrate these distributed systems and intensively manage data, to provide the basis of analysis and decision to enterprise sales. Through this system, the enterprise sales can be guided by data, which has great significance.The analysis and decision systems for car sales integrates the presented human resources management system, production management system, procurement management system, sales management system, financial management system and customer relationship management system, establish data warehouse and provide a variety of reports and charts functions to the enterprise managers. By these functions, the sale actions can be analyzed and decided. The functions include:Analysis report class of sale targets: (statistical drill through annual, quarterly and monthly, or statistical drill through by province, city and county) mainly includes some report functions, such as analysis reports of financial contribution targets, analysis reports of marketing targets and analysis reports of customer targets, and so on. And it supports analysis of pie chart and line chart.Analysis report class of comprehensive sales: (statistical drill through annual, quarterly and monthly, or statistical drill through by province, city and county) mainly includes some report functions, such as analysis reports of sale achievements, analysis reports of sale finance, analysis reports of marketing cost, analysis reports of sale channels, analysis reports of comprehensive customers and analysis reports of comprehensive sales, and so on. And it supports the analysis of the combination of column charts, pie charts, line charts and others. In the construction process of the analysis and decision systems for car sales, there are some essential phases, such as requirements analysis, construction of data warehouse, development of data ETL program, detailed design and coding implementation, and so on.Requirements analysis: according to the analysis of reports of the company's daily work, determine the analysis subject and clear the function what the system wants to develop. The content of requirements analysis is the basis of the system construction.Construction of data warehouse: integrate data of the existing systems, establish "data pool" for enterprise, and realize the sharing of data. To construct data warehouse of the system, it needs to establish data warehouse model of the enterprise in this phase. In this study, Microsoft SqlServer2005 Analysis Service is used to construct data warehouse of the system.Development of data ETL program: establish encoding standard of "data pool", unify data standards and information coding standards, and realize data storage with accuracy, completeness, standardization and no ambiguity. ETL is done for data from a variety of different systems, and the scattered data is collected and integrated. In this study, Micorsoft Sqlserver2005 Integration Services is used to develop ETL program.Detailed design and coding implementation: Microsoft Sqlserver2005 Report Service is used to develop the reports and charts to realize the functions of our system.In this study, firstly the background and current situation of the analysis and decision systems for car sales were analyzed. And through requirements analysis, system design, detailed design coding and testing, the analysis and decision systems for car sales was design and implemented, which can provide mirror to the development of the similar software in future.