Building a Data Warehouse: With Examples in SQL Server (Expert's Voice in SQL Server)

Rainardi, Vincent

ISBN 10: 143024299X / ISBN 13: 9781430242994

Editore: Apress, 2011

Riguardo questo articolo

Item in very good condition! Textbooks may not include supplemental items i.e. CDs, access codes etc. Codice articolo 00084537967

Dati bibliografici

Titolo: Building a Data Warehouse: With Examples in ...

Casa editrice: Apress

Data di pubblicazione: 2011

Legatura: Brossura

Condizione: Very Good

Descrizione articolo

Riassunto:

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

Informazioni sull?autore:

A bio is not available for this author.