BI Business Intelligence Training Series-(i) overview

Introduction:

Businessintelligence, referred to as BI.

Business Intelligence , It means data analysis with modern technology. , to achieve business value , These technologies include data warehousing technology , on-Line Analytical processing technology , Data Mining , Data presentation technology, etc. .

Previous systems:

1, the data volume is large, and the available information is too little.

2, the data form an island, can not form a close relationship.

3, it is difficult to excavate the inner contact, to obtain more valuable information.

4, the change is difficult, once the demand changes slightly, the workload doubled.

Take the report as an example:

traditional reporting system technology has been quite mature, we are familiar with Excel, Crystal Reports, Reporting service, etc. have been widely used. However, with the increase of data and demand, the traditional reporting system is facing more and more challenges.

    leveraging business intelligence Take the report as an example The corresponding data is then queried from the database Span lang= "ZH-CN" > Finally in the generated report in the form line chart or pie chart as shown in query conditions can be freely transformed The data source is the same query results more intelligent more convenient

Related concepts:

dw--data Warehouse Data Warehouse, in the past we mentioned that the database is a data warehouse, similarly, BI also involves the Data warehouse, its data warehouse is the relatively stable integration. The most important point is that it is anti-three-paradigm. More exaggerated, it does not exclude data redundancy, more data redundancy to improve the efficiency of the query.

dm--data Mining Data Mining, highly automated analysis of the company's original data, to make inductive reasoning, from which to dig out the potential model, predict customer behavior, help the decision-makers to adjust the market strategy, reduce risk, make the right decision.

Etl

E--extract Extraction

T--transform Conversion

C--cleaning Cleaning

L--load loading

In this link, the user extracts the data from the data source, cleans the data, and finally loads the entire process into the data warehouse according to a pre-defined model.

Familiar interface:

With VS 2010 As an example, there are three types of items under bi: Ssis,ssas and SSRS.

Ssis--integration Services

is a platform for generating high-performance data integration Solutions. With SSIS, you can manipulate data with simple drag-and-drop controls. Specific examples will be described in detail in the next blog post.

Ssas--analysis Services

A client-side tool that provides the ability to design, create, and manage cubes from the Data Warehouse, as well as provide client access to OLAP data.

Ssrs--reporting Services

A comprehensive server-based platform for centralized management of reporting speed, scalability, and manageability. Can be used to create, manage, and deliver traditional written and web-based interactive reports.

Summary:

BI, which is called Business intelligence or business intelligence, is naturally inseparable from commercial profits. Its use in addition to flexible and convenient to complete the traditional implementation of the original way, more is to tap the potential interests of the relationship, from which to obtain business "information" for the Enterprise services. After a brief introduction of theoretical knowledge, the next article is an introduction to SSIS.

BI Business Intelligence Training Series-(i) overview