HAPPY HOLIDAYS: Get a special discount on Apress Access! Subscribe today >>

Building a Data Warehouse

With Examples in SQL Server

Authors: Rainardi, Vincent

Download source code
  • The only book that shows how to implement a data warehouse using SQL Server
  • Interest in this topic for SQL Server is high
  • The code in the book will save companies hundreds of hours of development time and many wrong turns
  • Despite the intensity of the code, managers to programmers will find the book extremely useful
  • This book will be good for SQL Server 2005 and SQL Server 2008
see more benefits

Buy this book

eBook $54.99
price for USA
  • ISBN 978-1-4302-0528-9
  • Digitally watermarked, DRM-free
  • Included format: PDF
  • ebooks can be used on all reading devices
  • Download immediately after purchase
Hardcover $69.99
price for USA
  • ISBN 978-1-59059-931-0
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.
Softcover $69.99
price for USA
  • ISBN 978-1-4302-1196-9
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.
About this book

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.

About the authors

A bio is not available for this author.

Table of contents (17 chapters)

Buy this book

eBook $54.99
price for USA
  • ISBN 978-1-4302-0528-9
  • Digitally watermarked, DRM-free
  • Included format: PDF
  • ebooks can be used on all reading devices
  • Download immediately after purchase
Hardcover $69.99
price for USA
  • ISBN 978-1-59059-931-0
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.
Softcover $69.99
price for USA
  • ISBN 978-1-4302-1196-9
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.

Services for this book

Loading...

Bibliographic Information

Bibliographic Information
Book Title
Building a Data Warehouse
Book Subtitle
With Examples in SQL Server
Authors
Copyright
2008
Publisher
Apress
Copyright Holder
Vincent Rainardi
eBook ISBN
978-1-4302-0528-9
DOI
10.1007/978-1-4302-0528-9
Hardcover ISBN
978-1-59059-931-0
Softcover ISBN
978-1-4302-1196-9
Edition Number
1
Number of Pages
XVI, 523
Topics