Research And Implementation Of Big Data Business Intelligence System Based On ESL

The business intelligence (BI) is used for the enterprise to effectively integrate the existing data,and it can provide accurate report and put forward decision-making basis.So it can help the enterprise make a complete set of solutions which are good for make smart business decisions.Business intelligence system has been widely used in banking, telecom, insurance, government, healthcare, retail etc,its biggest advantage is that it can transform the huge amount of data accumulated in each of the etc into both accurate and timely message to help the enterprise win the competition.This article is mainly from two parts of theory and practice to illustrate the business intelligence.In the theory part,basing on the background and the present situation we put forward the framework of business intelligence technology.Then we study the three core technologies of technical framework one by one.In the practice part this article treat the sales of retail enterprise as background to design and implement a business intelligence system to provide the function of data analysis for retail enterprise managers promote the sales of enterprise.The content includes:take use of the SSIS service to complete the extraction,cleaning,transform and loading of the data accumulated in the ESL system and establish the data warehouse.Then use the Apriori algorithm integrated in the SSAS service,to complete the OLAP of data in data warehouse.Finally we use the SSRS service to create the report that is suitable for the users and choose the SharePoint2010 as the platform to show the report.In the technical realization aspect the business intelligence system uses the Microsoft’s SQL Server 2008R2 and SharePoint2010 to realize the system.Microsoft SQL Server platform introduced a number of data mining functions,and its data mining function belongs to the business intelligence technology.The main BI function in SharePoint2010 is the business intelligence site.It can provide the report and monitor key performance indicators and allows you to create a unified view of the control panel to the enterprise data.