Email the Author

You can use this page to email Cristian Scutaru about 100 Puzzles to Learn Data Warehousing.

Please include an email address so the author can respond to your query

This message will be sent to Cristian Scutaru

This site is protected by reCAPTCHA and the Google  Privacy Policy and  Terms of Service apply.

About the Book

Learning how to design a data warehouse may be difficult. Ralph Kimball has some great legacy books on the dimensional modeling techniques, but they are verbose, with complicated examples. Our illustrated examples here are kept simple on purpose, to help you better understand complicated concepts like periodic snapshot fact tables, degenerate dimensions, late arriving facts or dimensions.

We focus our puzzles on Ralph Kimball's dimensional modeling techniques, but we also introduce you to Extract-Transform-Load (ETL) basics, OLAP fundamentals and some other important things you must know about data warehouses in general. We dive deep into slowly changing dimensions (SCD), with other illustrated examples to help you get the ideas in no time.

You need just some basic prior knowledge about Data Warehouses in general. The explanations and external references from the answers to our questions will help you learn the rest. We also assume you already have some basic background in data modeling for relational databases, and SQL.

These puzzles are for Software Developers and Engineers, Database Engineers and Architects, or Data Analysts. Difficulty level is from beginner to advanced.

We've split the 100 questions into 5 quizzes with 20 single and multi-choice questions each. Try solving each quiz separately, writing down on a piece of paper the answer to each question. Then go to the Answers and Explanations section, and learn more from our solutions to the puzzles. Follow the links to external references for a deep dive on the subject.

An interactive version of this book has been implemented on Udemy as 100 Puzzles to Learn Data Warehousing.


About the Author

Cristian Scutaru’s avatar Cristian Scutaru

@cristiscu

Decades of practical experience in software design and implementation. Former Microsoft employee. Architect of the Data Xtractor Suite - with a visual SQL editor, data visualization charts, data modeling...

I live in beautiful Vancouver/Canada. The mountain is my backyard. I enjoy tennis and hiking...

Logo white 96 67 2x

Publish Early, Publish Often

  • Path
  • There are many paths, but the one you're on right now on Leanpub is:
  • Learn-data-warehousing › Email Author › New
    • READERS
    • Newsletters
    • Weekly Sale
    • Monthly Sale
    • Store
    • Home
    • Redeem a Token
    • Search
    • Support
    • Leanpub FAQ
    • Leanpub Author FAQ
    • Search our Help Center
    • How to Contact Us
    • FRONTMATTER PODCAST
    • Featured Episode
    • Episode List
    • MEMBERSHIPS
    • Reader Memberships
    • Department Reader Memberships
    • Author Memberships
    • Your Membership
    • COMPANY
    • About
    • About Leanpub
    • Blog
    • Contact
    • Press
    • Essays
    • AI Services
    • Imagine a world...
    • Manifesto
    • More
    • Partner Program
    • Causes
    • Accessibility
    • AUTHORS
    • Write and Publish on Leanpub
    • Create a Book
    • Create a Bundle
    • Create a Course
    • Create a Track
    • Testimonials
    • Why Leanpub
    • Services
    • TranslateAI
    • TranslateWord
    • TranslateEPUB
    • PublishWord
    • Publish on Amazon
    • CourseAI
    • GlobalAuthor
    • Marketing Packages
    • IndexAI
    • Author Newsletter
    • The Leanpub Author Update
    • Author Support
    • Author Help Center
    • Leanpub Authors Forum
    • The Leanpub Manual
    • Supported Languages
    • The LFM Manual
    • Markua Manual
    • API Docs
    • Organizations
    • Learn More
    • Sign Up
    • LEGAL
    • Terms of Service
    • Copyright Policy
    • Privacy Policy
    • Refund Policy

*   *   *

Leanpub is copyright © 2010-2025 Ruboss Technology Corp.
All rights reserved.

This site is protected by reCAPTCHA
and the Google  Privacy Policy and  Terms of Service apply.

Leanpub requires cookies in order to provide you the best experience. Dismiss