About these puzzles

• 5 interactive quizzes with 20 questions each, for max 60 minutes per quiz, with a 70% passing score.

• All questions are original, with detailed answers, explanations and references.

• Most questions present original illustrated examples of dimensional modeling.

• The focus is on Kimball's dimensional modeling technique.

• ER model diagrams are kept simple, to better help you learn the essential concept.

• Everything about fact tables and dimension tables, including star, snowflake and constellation schemas.

• We help you better understand advanced concepts such as slowly changing dimensions.

• Acquired skills will help you do better at job technical interviews or certification exams.

Domains or categories

• General - Overview about Data Warehouses.

• Modeling - Ralph Kimball's Dimensional Modeling Techniques.

• SCD - Slowly Changing Dimensions.

• OLAP - Online Analytical Processing Fundamentals.

• ETL - Extract-Transform-Load Basics.

How to use these puzzles

• Start with the first quiz, and try to answer the best you can, without carrying about the time limit or score.

• Stop the quiz anytime, if you're not patient enough to go over all 20 questions.

• Review the questions and check both the right and wrong choices for each question.

• Read the detailed explanation for each question - many end up with some important hints.

• Go through the recommended external references to learn more.

• Continue with the other four quizzes, and repeat each quiz at least once.

100 Puzzles to Learn Data Warehousing is also available as a book on Amazon.