Business Intelligence system--statistics and analysis of company operation, system operation, etc.

Opening

Commercial intelligence systems, business INTELLIGENCE,BI, data centers, the names of different, the same responsibilities, the following unified called BI system.

BI load for the company's operational effectiveness, system operation and revision effect, based on the data level, comparative objective statistics and analysis, for the senior management of the company's operations, for the product department for the design of the site and the revision or algorithm adjustment before and after the effect, to provide reference and consideration.

The BI system is responsible for statistical analysis related, the real-time requirements of the data is not high, allowing more than one day of data latency, for the specific business closely related, or real-time requirements of high statistical analysis, should not be placed in the BI system, but should be placed in their own business support system.

A bi system is a data system that helps enterprises better utilize data to improve the quality of decision-making techniques, and is the process of drilling information and knowledge from a large amount of data. Simply speaking is the process of application of business, data and data value. The underlying BI is statistical analysis, and the advanced level of BI is decision support, from "What happened before, why it happened", to "what is happening now, what will happen in the future".

noun explanation

BI: Business Intelligence (Intelligence)

ETL: Extract, Transform, and load (extraction-transformation-loading)

ODS: Operational datastore (Operational data Storage)

DW: Data Warehouse (Warehouse)

DM: Data mart, data Mining

OLAP: Online Analytical processing (online analysis process)

System Solutions

(1) According to the needs of statistics, data extraction, from the business System database, extracted to the BI database

(a), the process of extraction, may be a daily timing, hourly timing, trigger, etc., in particular, according to the specific scenario

(b), extracted logic, to be able to ensure that repeated extraction, such as a day of data problems ...

(c), the process of extraction, may involve some computational logic, such as the calculation of gross margin, the need for commodity cost price, for cost price acquisition, there may be some logic

(d), a data-extraction approach that could introduce third-party frameworks that streamline development workloads, such as Datax

(2) Data collection

(a), data labelling: depending on the needs of the business, some data needs to be flagged, analyzed through logs, or recorded in a database, such as placing a order: source, ref, POS

(b), website traffic: Insert code or analysis log, http://blog.csdn.net/puma_dong/article/details/38943251#t12

(c), log Analysis: Collect user Access path, dwell time, exit page, etc.

(3) Results presented

(a), the use of a good JS framework graphical presentation of BI reports, such as jquery plug-ins, but not recommended ExtJS framework, too much packaging and learning cost reasons

(b), SMS reminders, reminders of important results

(4) Formula definition

(a) Bi's product definition, a clear definition of the content of the data to be displayed, such as the gross profit margin formula, conversion rate, etc.

system Function settings

Present:

(1) Real-time Data report

(2) post-sale related reports

(3) Commodity inventory related report

(4) channel advertising related reports

(5) Website traffic related reports

Data:

(1) Traffic statistics

(2) Data extraction Middleware

Cond

No skeleton there is no flesh and blood, so-called with, Mao, think of a little to write down, follow-up supplement ...

Business Intelligence system--statistics and analysis of company operation, system operation, etc.