1 Introduction of Business Intelligence Management System
Business Intelligence Management System (BI) is a brand-new technology, which extracts, transforms and uploads the data from the source system (which can be SAP-ERP, other transaction processing systems, text files, databases or other BW/BI systems) to the data warehouse, and presents it to users in the form of EXCEL, WEB and other reports. It is a new technology that uses data warehouse, online analysis and data mining to process and analyze data.
2 Business Intelligence Management System Implementation Background
With the gradual progress of enterprise information construction, the amount of data is increasing day by day. Although enterprises have massive data, they cannot provide decision-making tools with comprehensive information and efficient operation for decision-makers, nor can they provide business monitoring and data analysis tools with various forms and rich dimensions for management. At the specific operational level, the operation efficiency of complex statements is extremely low. This problem is manifested in the following aspects:
(1) The report format is single;
(2) The data analysis angle is single, and the phenomenon of information island is serious;
(3) There are limitations in the field of report analysis. If we want to conduct joint analysis across multiple fields, the analysis efficiency is an insurmountable gap. If you want to realize data analysis across application systems, it is even more elusive;
(4) The query efficiency is not ideal. SAP-ERP system is a business processing system, not a data analysis system, so with the increase of data volume and data complexity, the query efficiency will drop sharply.
(5) There is no early warning function. Therefore, the demand for data mining and analysis in various business systems is more and more urgent. In such an era of "Big Data" with explosive data growth, data analysis and processing capabilities are increasingly relied on by more and more enterprises.
Techniques to maximize the value of enterprise data.
3 the implementation value of business intelligence management system
The implementation of business intelligence system can bring great value to enterprises and realize the transformation from data to information, from information to knowledge and from knowledge to decision-making. Specific performance in:
3. 1 report has strong function, high efficiency and good effect.
(1) The business intelligence system can drill up and down, drag left and right, rotate vertically and horizontally according to different "dimensions", display various data through continuous three-dimensional dynamic tables, and cluster and sort these data. In addition to displaying data through dynamic charts, it can also be displayed through color graphics, and the graphics can be stretched, blocked, rotated, and perspective, which is more intuitive and visible. At the same time, it can also mark the data in various ways, for example, the sales data is particularly good in green, and the sales data is particularly poor in red, and so on. You can also track and analyze the data, realize the early warning function, and bring a new feeling of handy analysis to managers;
(2) The business intelligence system uses data warehouse (BW) to extract, transform and upload the massive data of diversified systems, taking data analysis as the center, avoiding the competition with the resources of business programs, which not only alleviates the problem of business processing efficiency, but also improves the query speed of reports. According to the survey, many reports that run for more than ten hours in SAP system can be completed in just a few seconds in business intelligence system.
(3) The report has a variety of graphic presentation methods, with beautiful interface and freely selectable format, such as crystal report, document format, dashboard, webpage presentation, IPAD presentation, etc.
3.2 Powerful data mining function to quickly extract valuable information from massive data.
(1) A powerful data mining analysis platform, taking financial report analysis as an example. Financial report is the most direct means to reflect the financial situation and operating results of enterprises. Analyzing these data is of great significance for strengthening enterprise management and improving management level. Business intelligence system can present financial report data from multiple dimensions and ways; In addition, trend analysis, ratio analysis and comprehensive analysis can also be carried out on the financial situation and operating results of enterprises: trend analysis can provide
[page] Compare accounting statements horizontally and vertically; Ratio analysis provides a good support platform for analyzing the profitability, solvency and operational ability of enterprises; Comprehensive analysis, such as DuPont analysis chart, can make the data level and logical relationship of financial analysis more intuitive, so that report users can quickly grasp the influencing factors, influencing degrees and changing trends of various indicators, thus improving the efficiency of business decision-making.
(2) Take the business process as the basic analysis object, and quickly locate the abnormal points of the business. By defining the process kanban, the key links are taken as data monitoring objects, and when the data is abnormal, it can be directly reflected on the process kanban, and detailed data traceability function is provided. Take the procurement business process as an example: purchase order signing-> Approved-> Receiving goods-> Quality inspection->; Warehousing->; Invoice posting-> Payment, this process needs more than a dozen reports in SAP-ERP to be fully expressed, but in the business intelligence system, the business progress of each link can be displayed through a process kanban, through which managers can see the problems at a glance and analyze detailed data, providing powerful data analysis tools for managers.
(3) Flexible and diverse data presentation forms. China's corporate reports have complex formats and diverse styles. The business intelligence system provides self-help reports for this situation. Users can drag and drop as needed to achieve the desired effect, and at the same time, they can save the interface as a variant to facilitate the next search. The query interface and report interface are unified, and what you see is what you get, which is convenient for users to use.
3.3 Powerful access control function
The report authority management function is very powerful, which can not only control the query authority of the report, but also refine the authority to various analysis objects, such as cost centers. Ensure data security through powerful control functions.
4 success factors of business intelligence management system
4. 1 The decision-making management attaches great importance to it.
The business intelligence management system aims to make relevant strategies and plans through data extraction, sorting and analysis, and finally through the analysis results, so as to achieve the purpose of rationally allocating resources, improving operational efficiency, saving costs and improving efficiency. If the decision-makers and management don't have a deep understanding of informatization and the purpose of implementing business intelligence management system is not clear enough, it is easy to cause the project to go online, but it doesn't really play a role.
4.2 A sound project management system
The person in charge of the project should pay enough attention to the concept of project management, and each project node should have a clear project plan, reasonable task decomposition, clear work objectives and serious project tracking, so as to make the whole project plan feasible and risk controllable and ensure the smooth progress of the project. In addition, the business intelligence project is essentially a "communication" project, and the whole project management should pay attention to communication and cooperate with users to complete the analysis theme, so the whole project management should pay attention to team management;
4.3 High-skilled project implementation team
Project implementers should have enough experience in implementing business intelligence projects, master mainstream information software management ideas, such as ERP-SAP system, and master the theory and technology of business intelligence systems and related business processes, so as to quickly enter the role, correctly guide users' needs, and make overall plans for demand analysis, development, design and programming.
5 Business Intelligence Management System Implementation Planning and Prospect
The construction of business intelligence system is a complex iterative process, and the realization of the system depends on the integrity and accuracy of data. The project promotion needs to be comprehensively considered from the aspects of complexity, urgency and construction cost of the analysis project. Therefore, it is suggested that enterprises adopt overall planning and implement the construction process step by step. According to the company's management and decision-making needs, business intelligence projects can be implemented for specific modules of the company's business systems, such as finance, procurement, performance appraisal and salary system. , thus truly providing decision support such as performance cockpit for decision makers; Provide powerful management tools such as data analysis, mining and forecasting for management; Provide convenient and diverse query tools for business operators.