Building a Data Warehouse
With Examples in SQL Server
(Sprache: Englisch)
Here is the ideal field guide for data warehousing implementation. It describes how to build a data warehouse completely from scratch and shows practical examples on how to do it. Includes code that will save companies hundreds of hours of development time.
Leider schon ausverkauft
versandkostenfrei
Buch (Gebunden)
52.42 €
Produktdetails
Produktinformationen zu „Building a Data Warehouse “
Here is the ideal field guide for data warehousing implementation. It describes how to build a data warehouse completely from scratch and shows practical examples on how to do it. Includes code that will save companies hundreds of hours of development time.
Klappentext zu „Building a Data Warehouse “
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.
The book is intended to contain practical explanations of essential topics in implementing a data warehouse that everybody who wishes to embark on a data warehousing journey will need to understand in order to build their first data warehouse. Not only that, but they get the SQL Server code so that they can go ahead and implement the data warehouse, create reports, utilize business intelligence, CRM, and more. Essentially, it is a field guide for data warehousing implementation.
Inhaltsverzeichnis zu „Building a Data Warehouse “
to Data Warehousing.- Data Warehouse Architecture.- Data Warehouse Development Methodology.- Functional and Nonfunctional Requirements.- Data Modeling.- Physical Database Design.- Data Extraction.- Populating the Data Warehouse.- Assuring Data Quality.- Metadata.- Building Reports.- Multidimensional Database.- Using Data Warehouse for Business Intelligence.- Using Data Warehouse for Customer Relationship Management.- Other Data Warehouse Usage.- Testing Your Data Warehouse.- Data Warehouse Administration.
Autoren-Porträt von Vincent Rainardi
Vincent Rainardi is an Experienced DATA WAREHOUSE ARCHITECT. Expertise in migrating data warehouses from SQL Server 2000 to SQL Server 2005 platform. 2 MCPs in SQL Server 2000 Enterprise Edition: Database Design and Database Administration. 5 years of experience in building data warehouses and OLAP cubes on Microsoft, Gaec, IBM and Informix platforms. Tools include SQL Server 2000 & 2005 DTS & SSIS, Analysis Services, Reporting Services, ProClarity, Hyperion Essbase, DataMirror, Embarcadero ER/Studio, Sharepoint, BusinessObjects Crystal Reports, Hummingbird Genio.
Bibliographische Angaben
- Autor: Vincent Rainardi
- 2008, 1st ed., XVI, 523 Seiten, Maße: 17,8 x 25,4 cm, Gebunden, Englisch
- Verlag: APress
- ISBN-10: 1590599314
- ISBN-13: 9781590599310
Sprache:
Englisch
Kommentar zu "Building a Data Warehouse"
0 Gebrauchte Artikel zu „Building a Data Warehouse“
Zustand | Preis | Porto | Zahlung | Verkäufer | Rating |
---|
Schreiben Sie einen Kommentar zu "Building a Data Warehouse".
Kommentar verfassen