Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Building a Data Warehouse: With Examples in SQL Server

Buy
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 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 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.

(HTML tags aren't allowed.)

Diabetes: The Biography (Biographies of Diseases)
Diabetes: The Biography (Biographies of Diseases)

Diabetes is a disease with a fascinating history and one that has been growing dramatically with urbanization. According to the World Health Authority, it now affects 4.6% of adults over 20, reaching 30% in the over 35s in some populations. It is one of the most serious and widespread diseases today. But the general perception of diabetes is...

Practice Makes Perfect: Italian Verb Tenses, Premium Third Edition
Practice Makes Perfect: Italian Verb Tenses, Premium Third Edition
Go beyond conjugation to master Italian verbs and their usage


Verbs play a vitally important role in every sentence, and the selection of a particular verb and a specific tense has a great impact on meaning. To help you understand why a certain tense works in a given situation,...
Handbook of Networks in Power Systems II (Energy Systems)
Handbook of Networks in Power Systems II (Energy Systems)

Energy has been an inevitable component of human lives for decades. Recent rapid developments in the area require analyzing energy systems not as independent components but rather as connected interdependent networks. The Handbook of Networks in Power Systems includes the state-of-the-art developments that occurred in the power systems...


CompTIA Project+ Study Guide: Exam PK0-004
CompTIA Project+ Study Guide: Exam PK0-004

The bestselling Project+ preparation guide, updated for the latest exam

The CompTIA Project+ Study Guide, Second Edition is your comprehensive resource for taking Exam PK0-004. With 100% coverage of all exam objectives, bolstered by real-world scenarios and the Sybex interactive learning environment, this book...

Sams Teach Yourself Microsoft Office 2003 in 24 Hours
Sams Teach Yourself Microsoft Office 2003 in 24 Hours

In just 24 lessons of one hour or less, you will be able to understand, utilize, and leverage Microsoft Office 2003 so you can get your work done. Using a straightforward, step-by-step approach, each lesson builds on the previous ones, enabling you to learn the essentials of Microsoft office 2003 and all its components from the...

Deploying Optical Networking Components (McGraw-Hill Telecom)
Deploying Optical Networking Components (McGraw-Hill Telecom)

With cheaper bandwidth and greater robustness, optical networking components are looking increasingly tempting--perhaps even mandatory for maintaining your network's competitive edge. Here's how you get there from here, without being overwhelmed by optical science.

Optical technologies' advantages over copper have caught your...

©2021 LearnIT (support@pdfchm.net) - Privacy Policy