Extract, Transform, Load

What is ETL ?

• Transfer, Extract data

• Extract, Loading

  Transfer data

• Extract, Transform, Load data

• None of the above

What is the item for a business analyst to view the end result of ETL ? Chose more than one.

• Transaction data

• Mobile app

• Dashboard

• Database

What are the steps involved in ETL process ?

What is the benefit of doing ETL constantly?

Explain the "Transform" means in ETL ?

Explain what is "Load" in the ETL process ?

What is the purpose of having Staging Area? Is it useful ?

At which point does Staging Area occurred in the ETL process ?