The ETL in SSIS and Processing in Analysis Services module provides you with the instructions and devices to develop hands on skills in the following topics:

  • Creating a simple ETL package
  • Developing and processing an OLAP cube

Exercise 1 - Creating a Simple ETL Package

In this exercise, you will create a simple ETL package in the SSIS designer. The ETL package extracts data from a OLE DB data source and writes the data to another OLE DB data source.

Exercise 2 - Developing and Processing an OLAP Cube

In this exercise, you will create an OLAP cube. An OLAP cube provides quick response to complex queries by storing data in an optimized way by using dimensions and measures.

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.