Reference for doing Data Warehousing in SQL Server

  • Everybody (well almost) knows that if you want to learn the design patterns for building a data warehouse, you read a book like Ralph Kimball's "The Data Warehouse Toolkit".  That book gives you a bunch of theory about Slowly Changing Dimensions etc... Is there a book that's sort of a companion to that where they walk you through implementing some of those things in your database? (The ETL book or something?)

    Kimball's book is good, but a little practice stuff would be super helpful. (I see there's a 3rd edition... is it that much better than 2nd edition?)

    Thanks!

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • If I have some time, I plan to do something about that next year. Stay tuned!

  • <checking calendar>

    Nope, still 2024.

    Drat!

  • Martin,

    have you read Joe Caserta's book on ETL (from the Kimball collection)? ISBN: 978-0764567575

    I'm just trying to get my head around doing the ETL etc and building proper dimensional models in the data warehouse, and any good pointers on "do it this way, NOT that way". =)

    Thanks,

    Pieter

  • I haven't and can unfortunately not comment on it, but Joe is well-known and respected for his work with the Kimball Group. It would definitely not hurt to read his book.

    In my opinion, you're going to have to be willing to do a lot of reading and a lot of experimentation...or pay for training/consulting if you'd rather fast-track your learning. Most of the people who are experts in this area have spent thousands of hours perfecting those skills.

  • thanks Martin. I'll probably just get a used copy. If I don't like it, I'm only out like $10.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply