The Importance of the ETL Process

This video is part of LearnItFirst’s SQL Server 2012: A Comprehensive Introduction course. More information on this video and course is available here:

http://www.learnitfirst.com/Course170

The concept of ETL is one of the more important concepts that will be covered in the last couple chapters of this course. Even if you are not working with ETL today and now, chances are high that at some point you will be asked to. This video will explain the scenario in which a business has several different databases, and how to make it all fit together.

Highlights from this video:

– What is Microsoft’s ETL tool?
– What enables a business to use so many different databases?
– What different options do you have for building a dashboard?
– Needs of the organization versus the requirements of the vendor

and much more…