Q:

This is my first query to you. I know bits and pieces about BI and the data warehouse. I have experience in OLTP systems. I’m interested in studying data warehousing in detail. What would be the right approach to start with? Could you suggest some good books?

A:

Mike Jennings’ Answer: The Data Warehouse Lifecycle Toolkit by Ralph Kimball, Laura Reeves, Margy Ross, and Warren Thornthwaite.

Joe Oates’ Answer: To get an understanding of the basics of multidimensional design, I would suggest reading The Data Warehouse Toolkit, by Ralph Kimball. Of course, there is a lot more to building a successful data warehouse than is covered in this book, but it is a good place to start. Bill Inmon has published several books on the subject of data warehouse. For a more business-related view, you might also look at one of Sean Kelly’s books.


Chuck Kelley’s Answer: Good books that you should read are 1. The Corporate Information Factory (Bill Inmon, Claudia Imhoff, Ryan Sousa), 2. The Data Warehouse Lifecycle Toolkit (Kimball, Reeves, Ross, Thornthwaite), 3. Building the Data Warehouse (Bill Inmon).

Sid Adelman’s Answer: These are some of the major books in this space:

Adelman, Sid, and Larissa Moss. Data Warehouse Project Management. Boston, MA: Addison Wesley, 2000.

Barquin, Ramon, and Herb Edelstein. Building, Using, and Managing the Data Warehouse, Upper Saddle River, New Jersey: Prentice Hall, 1997.

Barquin, Ramon, and Herb Edelstein. Planning and Designing the Data Warehouse, Upper Saddle River, New Jersey: Prentice Hall, 1997.

Berry, Michael J.A., and Gordon Linhoff. Mastering Data Mining: The Art and Science of Customer Relationship Management, New York: John Wiley & Sons, 1999.

Berry, Michael J.A., and Gordon Linhoff. Mastering Data Mining Techniques for Marketing, Sales and Customer Support, New York: John Wiley & Sons, 1997.

Bischoff, Joyce, and Ted Alexander. Data Warehouse: Practical Advice from the Experts, Upper Saddle River, NJ: Prentice Hall, 1997.

Brackett, Michael H. Data Resource Quality, Reading, Massachusetts: Addison Wesley, 2000.

Brackett, Michael H. Data Warehouse Challenge: Taming Data Chaos, New York: John Wiley & Sons, 1996.

Cabena, Peter, Pablo Hadjinian, Rolf Stadler, Jaap Verhees, and Allesandro Zanasi. Discovering Data Mining from Concept to Implementation, Upper Saddle River, NJ: Prentice Hall, 1997.

Devlin, Barry and Lynne Doran Cote. Data Warehouse: From Architecture to Implementation, Reading, Massachusetts: Addison Wesley, 1996.

Dyche, Jill. The CRM Handbook: A Business Guide to Customer Relationship Management, Reading, Massachusetts: Addison Wesley, 2001.

Dyche, Jill. E-Data: Turning Data into Information with Data Warehousing, Reading, Massachusetts: Addison Wesley, 2000.

English, Larry P. Improving Data Warehouse and Business Information Quality. New York: John Wiley & Sons, 1999.

Edelstein, Herb. Data Mining: Products and Markets. Potomac, MD: Two Crows Corp., 1997.

Hackney, Douglas. Understanding and Implementing Successful Data Marts, Reading, Massachusetts: Addison Wesley, 1997.

Hoberman, Steve, Data Modeler’s Workbench: Tools and Techniques for Analysis and Design, New York: John Wiley & Sons, 2002.

Imhoff, Claudia, Lisa Loftis, and Jonathan G. Geiger. Building the Customer-Centric Enterprise. New York: John Wiley, 2001.

Inmon, W.H. Building the Data Warehouse, 2nd Edition, New York: John Wiley & Sons, 1996.

Inmon, William H., Claudia Imhoff, and Greg Battas. Building the Operational Data Store. New York: John Wiley, 2001

Inmon, W.H., Claudia Imhoff and Ryan Sousa. Corporate Information Factory, New York: John Wiley & Sons, 1997

Inmon, W.H., John A. Zachman, and Jonathan G. Geiger. Data Store, Data Warehousing and the Zachman Framework ,New York: McGraw Hill, 1997/

Inmon, W.H., J.D. Welch, and Katherine L. Glassey. Managing the Data Warehouse, New York: John Wiley & Sons, 1997.

Kelley, Sean. Data Warehousing: The Route to Mass Customization. New York: John Wiley, 1966

Kimball, Ralph. The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying the Data Warehouse, New York: John Wiley & Sons, 1998.

Kimball, Ralph. The Data Warehouse Toolkit, New York: John Wiley & Sons, 1996.

Marco, David. Building and Managing the Meta Data Repository, New York: John Wiley & Sons, 2000.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access