Data warehouse is the target of extracted, transformed and loaded.

ETL is one of the most time consuming aspects of business analysis work.  There could be many sources of information from which to extract information.  Transformation puts some quality on the information that is extracted.  Loading of transformed data is done in the data warehouse.

ETL is a good method for standardizing data, putting quality around data, and formatting data.

 

Leave a Reply

%d bloggers like this: