Building a Data Warehouse: With Examples in SQL Server / Edition 1

Hardcover (Print)
Buy Used
Buy Used from BN.com
$41.17
(Save 41%)
Item is in good condition but packaging may have signs of shelf wear/aging or torn packaging.
Condition: Used – Good details
Used and New from Other Sellers
Used and New from Other Sellers
from $38.50
Usually ships in 1-2 business days
(Save 44%)
Other sellers (Hardcover)
  • All (10) from $38.50   
  • New (6) from $52.43   
  • Used (4) from $38.50   

Overview

Now available in paperback—

Building a Data Warehouse: With Examples in SQL Server describes how to build a data warehouse completely from scratch and shows practical examples on how to do it. Author Vincent Rainardi also describes some practical issues he has experienced that developers are likely to encounter in their first data warehousing project, along with solutions and advice. The relational database management system (RDBMS) used in the examples is SQL Server; the version will not be an issue as long as the user has SQL Server 2005 or later.

The book is organized as follows. In the beginning of this book (chapters 1 through 6), you learn how to build a data warehouse, for example, defining the architecture, understanding the methodology, gathering the requirements, designing the data models, and creating the databases. Then in chapters 7 through 10, you learn how to populate the data warehouse, for example, extracting from source systems, loading the data stores, maintaining data quality, and utilizing the metadata. After you populate the data warehouse, in chapters 11 through 15, you explore how to present data to users using reports and multidimensional databases and how to use the data in the data warehouse for business intelligence, customer relationship management, and other purposes. Chapters 16 and 17 wrap up the book: After you have built your data warehouse, before it can be released to production, you need to test it thoroughly. After your application is in production, you need to understand how to administer data warehouse operation.

What you’ll learn

  • A detailed understanding of what it takes to build a data warehouse
  • The implementation code in SQL Server to build the data warehouse
  • Dimensional modeling, data extraction methods, data warehouse loading, populating dimension and fact tables, data quality, data warehouse architecture, and database design
  • Practical data warehousing applications such as business intelligence reports, analytics applications, and customer relationship management

Who this book is for

There are three audiences for the book. The first are the people who implement the data warehouse. This could be considered a field guide for them. The second is database users/admins who want to get a good understanding of what it would take to build a data warehouse. Finally, the third audience is managers who must make decisions about aspects of the data warehousing task before them and use the book to learn about these issues.

Read More Show Less

Product Details

  • ISBN-13: 9781590599310
  • Publisher: Apress
  • Publication date: 12/27/2007
  • Series: Expert's Voice Series
  • Edition number: 1
  • Pages: 523
  • Product dimensions: 10.00 (w) x 7.00 (h) x 1.19 (d)

Meet the Author

A bio is not available for this author.
Read More Show Less

Customer Reviews

Average Rating 5
( 3 )
Rating Distribution

5 Star

(3)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 3 Customer Reviews
  • Anonymous

    Posted August 1, 2012

    In-Depth

    Mr. Rainardi's book is highly recommended. It's not a survey of DW methods. It's a soup-to-nuts discourse on building one of the DW variations using a real-life project. It's in-depth, but dense reading.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted March 2, 2008

    A fascinating book

    As promised by the Author , this book helps you to build a Data Warehouse in SQL Server 2005, from scratch. Various important topics like Data Extraction ,Data Modeling and Data Quality are explained well in a very lucid language, backed by a good case study. By providing solutions to various potential problems during data extraction , the author touches upon the practical aspect of building a data warehouse. Topics on Data Warehouse architecture and Data Extraction are covered in depth. By introducing the topic of Rational Unified Processes, the author tries to explain how to build a Data Warehouse using multiple iterations. This is a welcome sign. I found the chapter on building reports using SQL SERVER 2005 Reporting Services very helpful. A more of an hands on book, with a sufficient therotical explanation, I felt ecstatic reading the book. I would definetely recommend this book , for any person who plans to attain knowledge or build a Data Ware house using SQL SERVER 2005.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted February 14, 2008

    Excellect resource

    This book was obviously written by a 'doer' and not just from an educators perspective. I find it great for acquiring new knowledge as well as an excellent resource for reference. I could see individuals using this book as a tutorial for acquiring 'soup to nuts' data warehouse knowledge.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing all of 3 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)