SUMMARY OF BI

Post: original article URL: http://blog.vsharing.com/hpj168/a1106323.html?original author's summary of Bi for Business Intelligence

In the business intelligence system, after a boss asked for a large number of reports, the boss asked for a large number of sales reports and inventory reports. At that time, ERP had reports, but the report form was relatively simple, for example, procurement is a procurement list. The import from the ERP system to the Excel system has not undergone any processing, and occasionally has undergone manual processing. It is only a evaluation of the supplier, however, it took a long morning for the purchasing department to prepare a table, which was not intuitive. Therefore, I was wondering if a report system would support it, the implementation is great. We often like to use Excel to show some things. I remember that there was an Excel expert in the company. Every time mm from the departments that submitted reports, he always looked for him, because he will use many formulas and functions, he has gained the common sense of leadership and has been recognized as a master of the Experts. Finally, he has gained a strong understanding. the beauty of the family. I was also thinking about using the thought of system integration to manage this pile of reports that I needed almost every day. So I thought of Bi and I checked a lot of information. so what is business intelligence?

1. Concept of business intelligence

For business intelligence, with Baidu or Google will search a lot, here using Baidu encyclopedia explanation: http://baike.baidu.com/view/21020.htm? Fr = ala0_1, and the simplest one is (1) According to Dan pratte, business intelligence is essentially about converting the organization's business data into easy-to-understand and valuable information, and provide the correct information to the correct person at the right time in the correct way. (2) According to the definition of IDC of international data companies, business intelligence is the process of collecting, processing, managing and analyzing business information. It aims to enable decision makers at all levels of an enterprise to gain knowledge or insight, they are urged to make more favorable decisions for the enterprise.

In fact, the technical point is that business intelligence is composed of data warehouses, data queries and reports, data mining, Online Analytical OLAP, budgeting and forecasting, and other parts, data is mined through modeling and presented to decision makers in an intuitive manner. To put it bluntly, we will review the past from the perspective of today, look forward to the future, and turn past information into today's knowledge into tomorrow's wealth.

2. Main Problems in the current management system

In fact, as long as you have been familiar with management systems, you will feel that in an enterprise, there are many heterogeneous information systems scattered in various business fields, supporting the business operations of enterprises, at the same time, we will find that the management system has many problems:

(1) inability to share information (2) delayed information communication (3) inability to solve actual management problems (4) inability to provide decision-making support (5) non-conformity with business needs (6) lack of understanding (7) Limited investment (8) Other issues

3. Advantages of BI products over Excel

What are the major advantages of using BI and Excel that we often use, as shown in:

(1) Deep data mining (2) Data Classification (3) timely data query (4) multi-dimensional data analysis (4) Future Trend Analysis (5) three-dimensional comprehensive report (6) intuitive front-end display

4. Benefits of Enterprise BI Import

(1) enhanced information sharing (2) accelerated enterprises' decision-making processes (3) Reduced decision-making costs (4) implemented enterprise performance goals (5) build efficient core competitiveness of enterprises (6) maximize customer value and satisfaction (7) Reduce the time for managers to sort data

5. Basic architecture of BI

 

 

 

 

 

 

 

 

6. Four-phase modeling process of Kimball

Phase 1: select the business processing process to be modeled, and manage the business processing process rather than the Department or function, such as procurement, ordering, inventory and current accounts.

Stage 2. Define the granularity of Service Processing: The granularity definition means that the actual content of each fact table row is clearly defined.

Phase 3: select the dimension used for each row of the fact table. How do business personnel describe the data obtained from the business processing process in this phase.

Stage 4: determine the number of facts used to form the rows of each fact table.

 

 

6. common modes of Data Mining

(1) classification mode (2) regression mode (3) time series mode (4) Clustering mode (5) Association mode (6) sequence mode (7) Genetic Algorithm (8) bayesian Network (9) Artificial Neural Network

 

 

7. Balanced Scorecard Application

Many enterprises use the balanced scorecard for key performance evaluation or strategic performance evaluation.

 

 

 

 

8. technical framework of BI business intelligence system implementation

 

My views on BI products:

(1) The implementation of BI solutions is complicated with high technical content.

(2) There are many solutions, but they are not perfect.

(3) BI has a bright future prospect.

Appendix: common vocabulary of business intelligence
Data Warehouse
In the middle of the 1980s s, Mr. William H. Inmon, the father of data warehouse, defined the concept of data warehouse in his book "building data warehouse", and then gave a more precise definition: Number
Data Warehouses are subject-oriented, integrated, time-related, and unchangeable data sets in enterprise management and decision-making. Unlike other database applications, data warehouses are more like a process of integrating, processing, and analyzing business data distributed across the enterprise. Instead of a product that can be purchased.
Data mart
Data mart, or "Small Data Warehouse ". If the data warehouse is built on an enterprise-level data model. Data mart is a subset of enterprise-level data warehouses. It is mainly for department-level businesses and only for a specific topic. Data mart can alleviate the bottleneck of data warehouse access to a certain extent.

OLAP
The concept of Online Analytical Processing (OLAP) was first proposed by E. F. Codd, the father of relational databases, in 1993. At that time, Codd believed that online transaction processing (OLTP) could not meet the needs of end users for database query and analysis, and SQL for simple queries on large databases could not meet the needs of user analysis. A user's decision analysis requires a large amount of computation on the relational database to obtain results. The query results cannot meet the requirements of decision makers. Therefore, Codd proposes the concept of multi-dimensional database and multi-dimensional analysis, that is, OLAP. Codd proposes 12 principles for OLAP to describe the OLAP system:
Criterion 1 the OLAP model must provide a multi-dimensional conceptual view
Guideline 2 transparency criteria
Criterion 3 estimation of access capability
Criterion 4 stable report capability
Guideline 5 customer/Server Architecture
Criterion 6-dimensional equality Criterion
Criterion 7 Dynamic sparse matrix processing Criterion
Criterion 8 multi-user support criteria
Criterion 9 unrestricted cross-dimensional operations
Guideline 10 intuitive data manipulation
Rule 11 flexible report generation
Criterion 12 unrestricted dimension and aggregation Layers

ROLAP
Based on the 12 Codd standards, each software development vendor is wise and wise. One of the schools thinks that multi-dimensional data can be stored using relational databases. Therefore, A star schema is created based on the sparse matrix representation method. Later, the snowflake structure was evolved. To be different from multidimensional databases, Relational database-based OLAP is called Relational OLAP (ROLAP. Representative Products include Informix Metacube and Microsoft SQL Server OLAP Services.

MOLAP
Arbor Software strictly complies with the definition of Codd and has established a multi-dimensional database to store online analysis system data. It pioneered multi-dimensional data storage. Later, many companies began to adopt multi-dimensional data storage. Known as Muiltdimension OLAP (MOLAP for short), it indicates that the products include the company's (formerly known as Arbor Software), the company's products, such as the data integration system, table store, table store, and table store.

Client OLAP
Compared with Server OLAP. Some analysis tool manufacturers suggest downloading some data locally to provide users with local multi-dimensional analysis. Representative Products include Brio Designer and Business Object.

DSS
The Decision Support System is equivalent to a data warehouse-based application. Decision-making support is to collect and process all relevant data and information to provide information for the decision-making management of enterprises and to provide a basis for decision-making by decision makers.

ETL
Extract, Transform, Cleansing, and Load. An important part of building a data warehouse is that the user extracts the required data from the data source, cleans the data, and finally loads the data to the data warehouse according to the pre-defined data warehouse model.

Ad hoc query
Ad-hoc queries are the most common query of database applications. Using the data warehouse technology, users can obtain desired data from the database at any time.

EIS
The supervisor Information System (______ executive Information System) refers to the Information query requirements of leaders who cannot focus on computer technology, A specially designed application that accesses a data warehouse through a simple graphical interface.

BPR
Business Process Reengineering (Business Process Reengineering) is a task that uses data warehouse technology to discover and correct the drawbacks of an enterprise's Business processes. It is one of the important roles of data warehouses.

BI
Business Intelligence (BI) refers to the general name of warehouse-related technologies and applications. It refers to the use of various smart technologies to enhance the business competitiveness of enterprises.

Data Mining
Data Mining is a decision-making support process. It is mainly based on AI, machine learning, statistics, and other technologies. It is highly automated in analyzing the original Data of enterprises and making disruptive reasoning, discover potential models, predict customer behaviors, help enterprise decision makers adjust market strategies, reduce risks, and make correct decisions.

CRM
Customer Relationship Management (CRM), a data warehouse is a new technology that is based on the database technology but essentially different from traditional database applications, CRM is a new application based on data warehouse technology. However, from the perspective of business operations, CRM is actually an old "application. For example, if a guest is an old customer of a hotel, the hotel will naturally know the habits and preferences of the guest, such as whether the hotel prefers to depend on the road, smoking, bed, breakfast, etc. When the guest is on demand again, the hotel will provide the room and service that the guest prefers without asking for help. This is a type of CRM.

Meta Data
Metadata: data in a data warehouse refers to the data source definitions, target definitions, conversion rules, and other key data generated during data warehouse construction. At the same time, metadata also contains commercial information about the meaning of data. All such information should be properly stored and managed. It facilitates the development and use of data warehouses.