Integration of ERP and Bi in the hottest Enterpris

  • Detail

The integration of ERP and Bi in enterprises

after the application of ERP system, enterprises must also have a comprehensive analysis system to help enterprises conduct effective analysis. Therefore, Bi (Business Intelligence) came into being, providing effective methods and tools for enterprises to solve the problem of information value

bi confused cio

bi has become another application hotspot of enterprise informatization after ERP. After the large-scale information construction, the information systems led by ERP have been widely used. A large amount of data generated by these systems and the historical data of the enterprise itself cannot be converted into effective information value in time. At the same time, with the competitive needs of the market changing with the environment, the enterprise needs to understand its own shortcomings and the changing trend of the market. Therefore, enterprises need to use Bi for systematic analysis and processing in order to meet their own challenges

according to the survey, in 2010, CIOs were most concerned about the application of advanced technologies such as Bi (Business Intelligence), cloud computing, Web2.0, etc. now domestic enterprises have increasingly strong demand for bi. However, from the perspective of practical application, the application effect of Bi by enterprises can be tested through tensile test, which is not very ideal. At present, the success rate of Bi deployment is less than 30%. CIOs still have many doubts when doing Bi, just like doing ERP projects in the past, Be more careful

how should ERP and Bi be integrated? How are their respective values reflected in the enterprise? What is the status of BI application? What are the problems in the process of ERP and Bi integration? What puzzles CIOs to successfully deploy Bi

Zhudong, general manager of AVIC international information management department, believes that the fundamental reason for the low success rate of Bi is that Bi pays more attention to management and the implementation process is more complex. The implementation of Bi requires CIOs to understand both management and business as well as it technology. However, there are few such real composite CIOs. The CIOs responsible for Bi projects are either pure business or pure it technology, resulting in such a high failure rate of Bi

bi originates from data, while ERP system contains data. Therefore, when considering the project planning, it is a good choice if the BI system can directly use the data in the ERP system. But so far, Bi and ERP systems are two relatively independent applications

ERP or Bi first

Sha Shuang, director of the information center of Li Ning group, believes that Bi requires enterprises to have a good information foundation and should be considered after the completion of ERP and other basic information systems. At the same time, when selecting Bi tool products, we should also have an overall plan for our own informatization

Sha Shuang said that after integrating the original data of the enterprise, the extraction, transformation, cleaning and loading of data in 2016 can be considered only a technical problem. It is reasonable to say that ETL tools should undertake the task of ensuring data quality, such as eliminating the information with blank fields and finding out the data with wrong decimal points. However, most of the current ETL tools focus on the functions of data extraction, conversion and loading, and do not pay enough attention to data quality assurance. Therefore, in most Bi projects at present, there is a lack of implementers to ensure data quality from a technical point of view

bi system has strict requirements for data format during data analysis. For example, some fields cannot be empty (for example, four arithmetic operations may be required during data analysis, so the divisor cannot be empty). For example, some fields require a fixed format (such as the date field, which requires a unified format, such as yyyy-mm-dd, etc.)

therefore, the BI system not only requires enterprises to provide data in a fixed and standardized format, but also ensures the accuracy of basic data. The analysis results of the BI system all depend on the basic data. If the basic data is wrong, even if the error rate is 5%, the error of the final result may be about 20% or even greater after some analysis of the BI system. If Bi uses ERP data, it should not only ensure that the format meets Bi needs, but also improve the accuracy of basic data

the Bi applications of enterprises no longer only focus on data warehouse, data mining and other applications, but turn to deep-seated applications such as business analysis. Business analysis is the closest level to business in the field of business intelligence

fengfanghui, information director of China population and Development Research Center, believes that Bi and decision support system have many similarities. Of course, they are not the same thing, but in the decision support system, there must be a BI system. If the BI system is well developed, it will bring considerable benefits to the enterprise, or it will bring benefits to maximize profits. Bi and decision support systems can not exist alone, but are business driven. Therefore, Bi has also begun to be deployed in public institutions and government departments. (end)

Copyright © 2011 JIN SHI