IIT 55300 Export, Translation, and Load (ETL)

The basic theme of this course will be how to set up Export/Translation/and Load (ETL) processes to fill a data warehouse from a variety of different existing sources. The student will learn that the ETL process is typically the most time-consuming and misunderstood task in data warehousing and other data integrations. Microsoft SQL Server Integration Service will be used as the ETL tool for workshops and homework assignments.