Design And Implementation Of Product Sales Analysis System Based On Business Intelligent

With the continuous development of enterprises,many enterprises have accumulated a large amount of data,and how to carry out multi-dimensional analysis of these data is a hot issue in the current research.Business intelligence simplifies the work of enterprise management to the maximum extent,achieving the intelligent management of enterprise data analysis.Firstly,the paper leaded theory and method of business intelligence into product sales management,considered customer demand as the basis of system analysis,summed up the functional requirements of the system according to business needs,and designed the system according to the functional requirements.Product sales analysis mainly displayed the data to the user in the form of charts and data reports,and the user adopted the interface conditions for data interaction.In this paper,the on-line analytical processing technology was studied deeply,and the deep rules and patterns hidden in the product sales data were found by using this technology,which can provide the decision and help for the enterprise's overall development.This paper designed the multi-dimensional model of product sales analysis,designed the overall structure of the analysis system,and gave the detailed design process.This paper introduced the online analytical processing technology,and showed the analysis model and analysis results from four dimensions of channels,customers,products and time for data analysis.This paper realized the multidimensional analysis of product sales data,elaborated on the process of multidimensional analysis of sales data,can roll up,drill down,rotate shaft and do the partitioning and slicing operation for the data by using the cube.The system will use the chart to show the data visualized,business decision-makers making more reliable product sales strategy.The product sales data analysis system based on business intelligence that the paper designed and realized applied OLAP technology of the business intelligence to the analysis of the data,sales data analysis generating histogram,line chart,pie and scatter.And it can be check respectively in accordance with the year,quarter and month.At the same time,rolling up and drilling down on the map,in the map you can see the data view,and an area bar in the mobile area can enlarge or shrink the time range to check the sales situation and to guide the sales decision of enterprises,whichimproves the management efficiency of the enterprise.