Tuesday, October 12, 2010

How out of the trap of pseudo-BI



One pseudo-BI: BI analysis of static information only.

Correct: In fact, enterprises are truly useful real-time information collection and analysis, enterprise according to the information to make timely decisions.

The author believes that "BI can only analyze the static information" is more one-sided understanding of BI, see the BI in the real business applications superficial, because most enterprises of the BI system, to use the data to the user is indeed relatively static information, in accordance with the rules some time to update the information, but this does not mean that the static analysis of BI information can, in fact, the entire BI system architecture that can analyze real-time information.

So why do so many companies do not choose to implement real-time BI information analysis method?

There are two major considerations:

1, management analysis of the specific requirements






As shown above, different levels within the enterprise BI users, real-time analysis of the extent of information required is not the same, the basic expression from the 'grass-roots workers' -> 'middle management' -> 'senior officers' gradual weakening . Of course, does not rule out the middle and upper areas of information analysis in some real-time requirements of a higher, such as inventory concerns and so on.

Therefore, because the level of BI personnel in the analysis of the demand characteristics of information differ in the detailed design of the BI needs to take full account of the specific information at different levels of personnel in real-time requirements on the differences, which will directly determine the BI analysis of the various business theme reasonable arrangements and ETL for data extraction, cleansing, loading, conversion strategies and specific rules of the arrangements.

2, enterprise information system and system status

Since the cost of investment in various enterprises in the implementation of the BI, when enterprise information environment, or the information system in different ways, leading BI solution in the implementation process of the phase content of different information, leading to BI to take in the information analysis static information analysis or the analysis of real-time information on the different strategic choices, and the cost difference.

A, a single system, a simple analysis of the theme needs to take real-time analysis of construction methods

If the user using a single system, all the information in a business database, are faced with some simple analysis of demand, no need for complex data BI system, calculation and conversion process. BI in the design process of such relatively simple systems can be in the business of information on the BI needs of a generation in, BI tools to access through the preceding display can show, to achieve real-time analysis purposes.

B, multi-system, complex needs of the theme, you can take a static analysis or a combination of static plus near real-time way to build a

If the user's data from multiple systems integrated embodiment of the BI needs of complex calculations and processing can be presented to the user to use and less demanding on the real-time, can be taken regularly updated approach to the static display of information.

If the user does have some limitations of the information requirements of a high demand for this type of demand can be a separate deal to build a theme, and matching adjustable mechanism to protect the data ETL processing timeliness. But most companies would not spend the cost to build complete real-time BI topics, the approach taken in nearly real-time methods, such as inventory data, updated for the updated one hour.

The following case look through a "static + near real-time" way to build a portfolio of BI.

After years of an enterprise information technology development and building a multi-information system, the following table:

Location Information System

Manufacturer CSS system + JDE system

Marketing Company KMIS system + KMS system

Trading company procurement system

BI in the actual building process system requirements, the managers of different business topics presented and timeliness of data requirements, and requested information on the order to be able to see more real-time, in order to meet the needs of corporate information centers in building BI design and carry out the following manner:

Analysis of thematic data processing system

Procurement topic Start time 12:00 every night ETL extraction tools to a rolling two-month time interval extracted and loaded into each of the topic

Marketing theme

Cost subject

Orders subject to various enterprise systems in order of production data, documents generated during the production BI systems need to synchronize the data format information; BI's ETL tool to extract time synchronization every one hour and show to the user

The second pseudo-BI: BI can only analyze structured data.

Right: BI in the past always concentrate on those most vulnerable to access the data, that is the core of the structured process of information - stored in the internal database of numbers and text. According to IDC forecasts, worldwide digital information created each year, about 95% of unstructured information. Carrier of unstructured information is vague because of confusion exists in the computer information that is not in the record and field format definition information, instant messaging, e-mail, scattered documents, voice packets and surveillance cameras video stream pixels belong to unstructured information.

I believe that:

Indeed, the current BI system, we have seen or done before we know the enterprise BI, and did the analysis for structured data, unstructured data analysis and processing for the few, but this does not mean that users no demand for unstructured information analysis, but too difficult to analyze and realize the result of high inputs.

For domestic enterprises, the information system also stays in the basic construction of stage business systems, such as procurement systems, ERP systems, knowledge management system (KM) and so on. As enterprises increasingly standardize the data, for cross-system information processing needs of the gradual production, thus accelerating the construction of the BI system needs, and they urgently need to address is indeed stored in the operational system of structured data This approach to a large extent to meet the actual needs of the enterprise managers, while relatively quick to see the effect caused by the implementation of BI.

For unstructured information, as valuable information, the user has not abandoned out, but in practice it is business analysis and decision-making process through structured BI data analysis with the understanding of unstructured information judge to achieve an integrated decision support purposes.

So, BI can only analyze structured data? The answer is no.

In fact, many BI vendors in the continuous improvement of BI's for unstructured data processing system to facilitate users to conveniently and effectively analyze unstructured data. At present, many took the form of text analysis / content analysis tool needs to deal with unstructured data (instant messaging, email, video, etc.) in accordance with the rules set by the data collected into a structured storage of data, to achieve non- structured data for analysis purposes.

The third pseudo-BI: BI is the leader in proprietary tools.

Correct: For a long time, BI seems business leaders and financial managers of the special tools for high-level decision-making to provide the necessary information. In fact, the majority of the frontline staff, the more need for BI in their daily operations for the specific operation to provide timely, fast, effective and direct guidance.

The author believes that:

To be sure, BI is not a leader in proprietary tools, BI tools ultimate goal is to help companies build a platform for business decision support. For the majority of first-line staff, as long as there is need for BI to provide data to support daily operations, BI tools can be used to front-line staff open to it which is for the implementation of the BI enterprises prepared to do both:

1, BI multi-user environment, consider: For the BI system open to the frontline staff, they must take into account the multi-user large centralized access to BI system, a large amount of data query requirements of BI data collection designed to take into account multi-user large traffic demand.

2, BI system user license costs: Most BI tools are the way through the user permission to use an open system permissions, when companies need to BI open to first-line staff, the customer purchasing would permit substantial increase in the cost of this part of the expenditure also be considered.

We look at a BI tool for opening up the frontline of the actual cases:

A business needs for internal BI constructed to meet the needs of different themes and topics for each of the reporting system of the corresponding structures

1, constructed of topics, as shown below






2, the theme for each business analysis report system set up (some examples)










Recommended links:



AVI To Zune



Transport Stream CONVERTER



Specialist Remote Computing



Casino And Gambling Report



RM to MPEG4



Spring Scene Photos Using Photoshop Will Be Processed Into Autumn Scenery



SARFT responded: "shield acronym" Department of misunderstanding



Easy to use Web SERVERS



Psychosomatic Syndrome After Holiday Revelry



Netac flash news Huaqi patent dispute settlement Reached in equal



Dvd Vob To Matroska Software



MII further notice irregularities SP will be ordered to stop



Dynamic Power-BIV5.3.1 Chi Aowei smooth fat version!



GAMES Card brief



What is the Best Tone



No comments:

Post a Comment