100 Puzzles to Learn Data Warehousing (5×20)

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.

Reviews

Also Available on Amazon as a Book (click for a Very Low Price!)