Matches in SemOpenAlex for { <https://semopenalex.org/work/W2380041392> ?p ?o ?g. }
Showing items 1 to 73 of
73
with 100 items per page.
- W2380041392 abstract "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.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 youll learn A detailed understanding of what it takes to build a data warehouseThe implementation code in SQL Server to build the data warehouseDimensional modeling, data extraction methods, data warehouse loading, populating dimension and fact tables, data quality, data warehouse architecture, and database designPractical data warehousing applications such as business intelligence reports, analytics applications, and customer relationship managementWho is this book 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.Related Titles Beginning Relational Data Modeling, Second EditionData Mining and Statistical Analysis Using SQL" @default.
- W2380041392 created "2016-06-24" @default.
- W2380041392 creator A5013973663 @default.
- W2380041392 date "2008-01-07" @default.
- W2380041392 modified "2023-09-27" @default.
- W2380041392 title "Building a Data Warehouse: With Examples in SQL Server" @default.
- W2380041392 hasPublicationYear "2008" @default.
- W2380041392 type Work @default.
- W2380041392 sameAs 2380041392 @default.
- W2380041392 citedByCount "46" @default.
- W2380041392 countsByYear W23800413922012 @default.
- W2380041392 countsByYear W23800413922013 @default.
- W2380041392 countsByYear W23800413922014 @default.
- W2380041392 countsByYear W23800413922015 @default.
- W2380041392 countsByYear W23800413922016 @default.
- W2380041392 countsByYear W23800413922017 @default.
- W2380041392 countsByYear W23800413922019 @default.
- W2380041392 countsByYear W23800413922021 @default.
- W2380041392 crossrefType "book" @default.
- W2380041392 hasAuthorship W2380041392A5013973663 @default.
- W2380041392 hasConcept C135572916 @default.
- W2380041392 hasConcept C136764020 @default.
- W2380041392 hasConcept C141589383 @default.
- W2380041392 hasConcept C143008350 @default.
- W2380041392 hasConcept C154420247 @default.
- W2380041392 hasConcept C164120249 @default.
- W2380041392 hasConcept C194222762 @default.
- W2380041392 hasConcept C201932085 @default.
- W2380041392 hasConcept C41008148 @default.
- W2380041392 hasConcept C510870499 @default.
- W2380041392 hasConcept C77088390 @default.
- W2380041392 hasConcept C93518851 @default.
- W2380041392 hasConcept C97854310 @default.
- W2380041392 hasConceptScore W2380041392C135572916 @default.
- W2380041392 hasConceptScore W2380041392C136764020 @default.
- W2380041392 hasConceptScore W2380041392C141589383 @default.
- W2380041392 hasConceptScore W2380041392C143008350 @default.
- W2380041392 hasConceptScore W2380041392C154420247 @default.
- W2380041392 hasConceptScore W2380041392C164120249 @default.
- W2380041392 hasConceptScore W2380041392C194222762 @default.
- W2380041392 hasConceptScore W2380041392C201932085 @default.
- W2380041392 hasConceptScore W2380041392C41008148 @default.
- W2380041392 hasConceptScore W2380041392C510870499 @default.
- W2380041392 hasConceptScore W2380041392C77088390 @default.
- W2380041392 hasConceptScore W2380041392C93518851 @default.
- W2380041392 hasConceptScore W2380041392C97854310 @default.
- W2380041392 hasLocation W23800413921 @default.
- W2380041392 hasOpenAccess W2380041392 @default.
- W2380041392 hasPrimaryLocation W23800413921 @default.
- W2380041392 hasRelatedWork W1495859460 @default.
- W2380041392 hasRelatedWork W1510220247 @default.
- W2380041392 hasRelatedWork W1582283863 @default.
- W2380041392 hasRelatedWork W1893018 @default.
- W2380041392 hasRelatedWork W189554500 @default.
- W2380041392 hasRelatedWork W2072764742 @default.
- W2380041392 hasRelatedWork W2108971776 @default.
- W2380041392 hasRelatedWork W2132476035 @default.
- W2380041392 hasRelatedWork W2140190241 @default.
- W2380041392 hasRelatedWork W2176376458 @default.
- W2380041392 hasRelatedWork W2234182594 @default.
- W2380041392 hasRelatedWork W2238567556 @default.
- W2380041392 hasRelatedWork W2267554628 @default.
- W2380041392 hasRelatedWork W2282090486 @default.
- W2380041392 hasRelatedWork W2291106234 @default.
- W2380041392 hasRelatedWork W2460821513 @default.
- W2380041392 hasRelatedWork W2976602204 @default.
- W2380041392 hasRelatedWork W41353397 @default.
- W2380041392 hasRelatedWork W57116089 @default.
- W2380041392 hasRelatedWork W599503780 @default.
- W2380041392 isParatext "false" @default.
- W2380041392 isRetracted "false" @default.
- W2380041392 magId "2380041392" @default.
- W2380041392 workType "book" @default.