The Design And Implementation Of Guizhou Provincial Local Tax Business Intelligence Center

Guizhou Provincial Local Taxation Bureau has began the implementation of provincial data concentration project in2011, concentrate nine city’s tax data and develop a series of decision-supporting systems on this base. The exist decision subsystems included thematic queries system,multidimensional data decision analysis system, mathematical model analysis system are powerful,but there is a common flaw of functional scalability.When you need to add a new analysis report,IT department need to do a series of complex operations such as program,re-compile and publish a system.So Guizhou Provincial Local Taxation Bureau requres a decision-supporting subsystem with strong functional expansion as a supplement.The article made in-depth research on business intelligence technology,from the characteristics of the tax information, combined with the Guizhou provincial tax data concentration project, and made a business intelligence center solution with strong functional expansion,the function that self-define report,self-OLAP, self-Data Mining are achieved,users could develop and share reports through a way of "zero-code".What is more, the capability of self-Data Mining is to allow business department to make data mining operations for revenue data. The system is easy,the people of business department could develop, publish required reports by simply learning.As a subsystem of the decision-supporting system in Guizhou Provincial Local Taxation Bureau,the business intelligence center is required to achieve single sign-on function with other decision-supporting subsystems,this could improve users’ impressions.But,the system current has not been achieved this function. The article made in-depth research on single sign-on technology and get a solution based on ADFS technology.OLAP Oracle can not be displayed in BI site which developmented by SharePoint,the article made research on the Principle of excel connect SQL Server OLAP and get a solution based on Excel and a third-party data connection provider..