Book on building a datawarehouse?

• artingstall

  Grasshopper

  Points: 11

  More actions

  October 30, 2003 at 2:47 am

  #106900

  Hello,

  Can anyone suggest a book (or site, or tips) on building a datawarehouse? I have an undestanding on the theory, but miss key stags in actually building the thing.

  Please help!

  Thx

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  October 30, 2003 at 2:49 am

  #480257

  http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=17726 might be of interest to you.

  Frank

  http://www.insidesql.de

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• Jonathan

  SSC-Insane

  Points: 20427

  More actions

  October 30, 2003 at 10:29 am

  #480342

  http://msdn.microsoft.com/library/en-us/dnsql2k/html/sql_dwdesign.asp

  --Jonathan

  
  
  --Jonathan

• cppwiz

  SSCarpal Tunnel

  Points: 4036

  More actions

  October 30, 2003 at 12:48 pm

  #480356

  For tips on a real-world implementation of a data warehouse, I would suggest "Data Warehousing Using the Wal-Mart Model" by Paul Westerman (Morgan Kaufmann Publishers, 2001). Although Wal-Mart used Teradata to build their data warehouse, this book shows the planning, implementation and post-implementation phases that were done for the project. This book is especially good if you are working in the retail industry, but its easy to relate the examples to other industries as well.

• swjohnson

  Hall of Fame

  Points: 3254

  More actions

  October 31, 2003 at 4:12 pm

  #480543

  The best books I have read are by Ralph Kimball. "The Datawarehouse Toolkit" and "The Datawarehouse Lifecycle Tookit". (both are published by Wiley)

  I was fortunate enough to be able to take a couple of classes he taught.

  SJ

  

  ---

  Accepting all invites