Data Warehouse (OLAP) Design Techniques
* Looking for a flexible schedule (after hours or weekends)? Please call 858-208-4141 or email us: sales@ccslearningacademy.com.
Student financing options are available.
Transitioning military and Veterans, please contact us to sign up for a free consultation on training and hiring options.
Looking for group training? Contact Us
About This Course
Course Description
Students will learn basic concepts, such as the purpose of Data Warehouses and how it is different from an OLTP database. The course will provide a thorough understanding of data warehousing concepts such as different types of dimensions, facts, and methodologies to design Data Warehouses or Data Marts. Student will be able to design DWHs using schemas such as STAR, SNOW FLAKE, and GALAXY. Students will be able to design multiple Slowly Changing, Degenerate, and Inferred Dimensions. In the concluding section, student will learn about ETL processes and options available to handle multiple data loads.