Using data to create and preserve value

Question 1

What are Data extraction, transformation and loading systems (ETL)?

Answer 1

These take data from an existing database , convert it into different form and place it into new database.

Question 2

How do we Extract the Data? (ETL)

Answer 2

Data is firstly analysed to understand its content, format and structure. It is then read from specified source and what is required is extracted.

Question 3

How do we Transform the Data (ETL) ?

Answer 3

Convert extracted data, using rules or look-up tables or by combining data, into a set form so that it can be placed into another database.

Question 4

How do we Load the Data (ETL) ?

Answer 4

Write the transformed data into the target database (data warehouse) where it is held in a systematic and logical way so it is ready for future interrogation by business intelligence systems.

Question 5

What is the definition of Business Intelligence (BI) systems?

Answer 5

Describe the technological architecture that extract, assemble, store and access data to provide reports and analysis.