SAS Data Integration Studio 3: Workshop on ETL development with star schemes
The purpose of this workshop is to construct star schemes and utilize them for data warehouse development. You will learn the basic principles of data modelling and star schemes as well as how to create and apply such star schemes. The course is a continuation of subjects presented in SAS Data Integration Studio 1: Essentials.
1) The data warehouse architecture will be examined, i.e. ER modelling, dimensional modelling, star schemes, history etc. You will learn to create a Fact Qualifier analysis for rapid identification of the user’s requirement of data information and conversion into a dimensional data model.
2) Data modelling and star schemes are being constructed in SAS® Data Integration Studio.
During the cource you will learn:
Who should attendThis workshop is targeted at participants working with development of data warehouse and data marts utilizing ETL applications and possibly SAS programming. The participants are facing one or more of these tasks on a daily basis: Data modelling, data warehouse architecture, data warehouse implementation or SAS programming.
As a participant of this workshop it is imperative that you have attended the course SAS Data Integration Studio 1: Essentials or have similar experience. Preferably knowledge of programming (SQL) (SAS SQL 1: Essentials)
This course addresses SAS Data Integration Studio software.
Data warehouse architecture