How to get out of the trap of pseudo business inte

  • Detail

How to get out of the trap of "pseudo business intelligence"

one of pseudo Bi: Bi can only analyze static information

correct: in fact, what is really useful to enterprises is some real-time information collection and analysis. Enterprises can make timely decisions based on this information

the author believes that "Bi can only analyze static information" is a one-sided understanding of Bi. What he sees is the superficial phenomenon of Bi in practical commercial applications, because the data information given to users by the BI system implemented by most enterprises is indeed relatively static information, which is updated according to a certain time rule, but this does not mean that Bi can only analyze static information, In fact, the whole system architecture of Bi can analyze real-time information

so why don't so many enterprises choose the way of real-time information analysis when implementing Bi

there are two main considerations:

1. Specific requirements for management analysis

Figure 1 Bi users at different levels within the enterprise

as shown in the above figure, Bi users at different levels within the enterprise have different requirements for the real-time degree of information analysis, which is basically reflected in the gradual weakening of 'grassroots personnel' -> 'Middle-level personnel' -> 'senior personnel'. Of course, it does not rule out that the middle and high-level have high real-time requirements in some information analysis fields, such as attention to inventory

therefore, due to the different characteristics of information analysis needs of personnel at all levels in Bi, it is necessary to fully consider the differences of real-time requirements of personnel at different levels in specific information analysis in detailed Bi design, which will directly determine the reasonable arrangement of business analysis topics in Bi and ETL's strategies and specific rules for data extraction, cleaning, loading and conversion

2. The current situation of enterprise information system and the investment cost of the system

when each enterprise implements Bi, the enterprise's information environment, or the way of information system construction, leads to different phased contents of information analysis in the implementation process of Bi, which leads to different strategic choices of static information analysis or real-time information analysis for information analysis, and different costs

a, single system, simple analysis of subject requirements, can take the construction method of real-time analysis

if the user uses a single system, all information, each electronic tensile testing machine has several methods in a business database, facing some simple analysis requirements, do not need the BI system to carry out complex data calculation and conversion process. The design process of this kind of Bi is relatively simple. The analysis information required by Bi can be generated at one time in the business system, and Bi can be accessed and displayed through the front presentation tool, so as to achieve the purpose of real-time analysis

b, multi system, complex analysis subject requirements, can adopt static analysis or static close real-time combination construction method

if the user's data information comes from the comprehensive embodiment of multiple systems, it needs Bi to carry out complex calculation and processing before it can be presented to the user, and the real-time requirements are not high, it can adopt the way of regular update to statically display the information

if users do have some information analysis needs with high timeliness requirements, they can establish a separate topic for processing such needs, and match the adjustable ETL mechanism to ensure the timeliness of data information processing. However, generally, enterprises will not spend high cost to establish a completely real-time Bi theme, and adopt a near real-time approach, such as updating inventory data once an hour

let's take a look at the Bi construction method of "static + near real-time" combination through a case

after years of information development, an enterprise has built many information systems, as shown in the following table: Table 1 an enterprise information system

in the actual BI system requirements construction process, the manager proposed that high-performance modified plastics such as PC and peek have significantly used different business analysis topics and requirements for data timeliness in electronic appliances, and the order information should be able to be seen in real time, In order to meet the needs, the enterprise information center carries out the design of building Bi in the following ways: Table 2 design scheme of building Bi for enterprises

pseudo Bi II: Bi can only analyze structured data

correct: Bi used to focus on the most accessible data, that is, structured information with process as the core - numbers and texts stored in internal databases. According to IDC's prediction, about 95% of the digital information generated worldwide every year is unstructured information. Unstructured information refers to the information that exists disorderly in the computer due to the ambiguity of the carrier, that is, the information that cannot be defined in the record and field format. Instant messages, e-mails, scattered files, voice packets and pixels in the video stream of the surveillance camera all belong to unstructured information

the author believes that:

indeed, at present, the Bi systems we see or the enterprises we know who have implemented Bi do analysis for structured data, and there is little analysis and processing of unstructured data, but this does not mean that users have no demand for unstructured information analysis, but it is caused by the difficulty of analysis and the high investment in implementation

for domestic enterprises, the construction of information systems still stays at the construction stage of basic business systems, such as procurement system, ERP system, knowledge management system (km), etc. As the data information in the enterprise is becoming more and more standardized, the demand for cross system information processing is gradually emerging, which accelerates the demand for the construction of BI system, and they urgently need to deal with the structured data stored in the business system. This way can meet the actual needs of the internal managers of the enterprise to a large extent, and can quickly see the effects of the implementation of Bi

as for the unstructured information, as the valuable electromechanical information that imitates the signal control value, the user has not abandoned it, but through the structured data analysis of Bi and the comprehensive judgment of the learned unstructured information in the actual business analysis and decision-making process to achieve the purpose of assisting decision-making

so, can bi only analyze structured data? The answer is No

in fact, many Bi manufacturers are constantly improving Bi's processing mechanism for unstructured data, so that users can easily and effectively analyze these unstructured data. At present, the most commonly used method is to transform the unstructured data (instant messaging, e-mail, video, etc.) to be processed into structured stored data according to the set data extraction rules through text analysis/content analysis tools, so as to achieve the purpose of analyzing unstructured data

pseudo Bi No. 3: Bi is a proprietary tool for leaders

correct: for a long time, Bi seems to be a special tool for enterprise leaders and financial managers, providing necessary information for senior decision-making. In fact, for the vast number of front-line personnel, it is more necessary for Bi to provide them with timely, rapid, effective and direct guidance in the specific operations of daily operations

the author believes that:

it is certain that Bi is not the exclusive tool of leaders. The ultimate purpose of using bi tools is to help enterprises establish a platform for business decision-making. For the vast number of front-line personnel, as long as there is a need for Bi to provide data support for their daily operations, the use of Bi tools can be opened to front-line personnel. For enterprises implementing Bi, two aspects should be prepared:

1. Consideration of Bi multi-user environment: for opening the BI system to front-line personnel, the requirements of large-scale data queries with a large number of users accessing the BI system must be considered, The design of data set in Bi fully considers the needs of multi-user and large access volume

2. Cost of user license of BI system: at present, most Bi tools open the system through user license, so the use permission when choosing fixtures. When enterprises need to open Bi to front-line personnel, the purchase of user license will increase significantly, and this part of cost expenditure also needs to be considered

let's take a look at a practical case of Bi tools opening to front-line personnel:

an enterprise has built analysis topics that meet different needs for internal Bi, and built corresponding report systems for each analysis topic

1. The analysis topics built are shown in the following figure

Figure 2. The analysis topics built

2. The report systems built for each business analysis topic (end)

Copyright © 2011 JIN SHI