•  0

Building a Data Warehouse: With Examples in SQL Server

Building a Data Warehouse: With Examples in SQL Server
  • Автор: Vincent Rainardi
  • Издательство: Apress
  • Год: 2007
  • Язык: Английский
  • Страниц: 523
  • Формат: pdf
  • Размер: 10 Мб

Building a Data Warehouse: With Examples in SQL Server

  • Автор: Vincent Rainardi
  • Издательство: Apress
  • Год: 2007
  • Язык: Английский
  • Страниц: 523
  • Формат: pdf
  • Размер: 10 МБ

Описание книги Building a Data Warehouse: With Examples in SQL Server:
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 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.

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.