II
ABSTRACT
How to make use of the modern information technology and scientific means
accurately to grasp auto parts market supply and demand, and ensure that the effective
operation of the supply chain and accomplish targeted developing marketing strategy
have important meaning for improving the enterprise competition ability and
maximize the marketing benefits. Business Intelligence (Intelligence, referred to as a
friend BI) provides a data transform for the information and knowledge of technology.
It can effectively use enterprise perennial large amounts of historical data to analysis
and decision.
This thesis analyses studies the application of business intelligence in auto
parts sales analysis by developing some auto parts manufacturing enterprise intelligent
sales decision-making system project based on the enterprise and it’s current ERP
system operation database.Firstly, the paper investigate carefully the insufficiency of
the ERP system in operation for decision-making in sales analysis based on the sales
performance analysis of this enterprise, and studied business intelligence theory and
key technologies to laid a foundation for sales analysis of multidimensional data model
and establishing an analysis model . Thereafter, advances a kind of analysis solution of
auto parts sales analysis based on business intelligence, i.e. transfer, cleanup and load
the related business source data, establish sales analysis data warehouse, and
Multi-dimension data model, then realize the multidimensional on-line analysis of
sales situation and prediction algorithm and the front-end display applications.
At present, the sales analysis scheme with BI architecture provided by this paper
can compensate the defects of mining potential information of goods sales, already can
accurate analysis of the sales of goods, and it also can analysis accuratly the sales of
goods and inspecte the sales achievement of departments.it’ll playe an important role
in assisting the topExecutives of the company to make trategic decisions. This thesis
discussed the design and application researching of auto parts intelligent sales
policy-decision scheme by closely combining the implementation of project
construction process, mainly using data warehouse, OLAP technologyand prediction
algorithm.
Keywords: Policymaking ,Data Warehouse ,Multidimensional
Analysis,Time Series Forecasting,Data Mining