Architecture BI

Question 1

What is Business Intelligence?

Answer 1

Maybe defined as set of mathematical models and analysis methodology that exploit the available data to generate information and knowledge useful for complex decision making process

Question 2

Data sources

Answer 2

It is very important to collect and integrate the data which are stored in various primary and secondary sources that are heterogeneous in origin and type.

The sources of most part of data belongs to the operational systems which also includes unstructured documents like email and data received from various external sources.

Question 3

Data warehouse

Answer 3

ELT stands for extract transform load. In an ETL process data is extracted from the operational systems and loaded into data warehouse.

The data from various sources is stored in database which is made to support bi analysis

Question 4

Bi methodologies

Answer 4

Data is finally extracted and used to feed mathematical models and analysis methodologies intended to support decision makers.

Question 5

Data exploration

Answer 5

At the third level of pyramid we find tools for performing passive bi methodologies which consists of query and reporting systems as well as statistical and visualization methods.

Question 6

Data mining

Answer 6

4th level includes active bi methodologies whoses purpose is the extraction of knowledge and information from the data

Question 7

Optimization model

Answer 7

Allows us to determine best solution out of set of alternative actions which is usually fairly extensive and sometimes even infinite

Question 8

Decsions

Answer 8

Is the decision where we need to select best alternative for decison making process