contestada

1. One of the most important assets of any organization is its data (information). This asset is used for two purposes: operational record keeping and analytical decision making. We capture data in the operational systems; and we analyze data in the data warehousing and business intelligence (DW/BI) systems. According to the Kimball Group, what are the four components of the DW/BI Architecture

Respuesta :

ogorwyne

Answer:

1. Operational source systems

2. ETL

3. Presentation area to Support BI

4. BI applications

Explanation:

1. Operational source systems:

These systems here capture the transactions of the business. The main objectives are to process performance as well as availability.

2. ETL systems:

these stands for extract, transformation and load systems.

the extract , has to do with getting the data to be in the warehouse environment. copying it into the Extraction, transformation and the load system in order for it to be be manipulated further.

transformation, this has to do with data cleansing, data combination from different sources and removing duplications from the data.

loading is the last step of ETL, and it has to do with loading data into the target models.

3. Presentation area to Support BI

BI stands for business intelligence. the DW-BI area is where organization, and storage of data is done by . The presentation area should have detailed data, and also atomic data. Data in this are should be presented and stored in schemas that are dimensional.

4. BI applications

the business application areas are the different abilities offered to the users on the presentation area for them to make analytical decisions.

Otras preguntas