Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
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.

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

Nonlinear Computer Modeling of Chemical and Biochemical Data
Nonlinear Computer Modeling of Chemical and Biochemical Data

Assuming only background knowledge of algebra and elementary calculus, and access to a modern personal computer, Nonlinear Computer Modeling of Chemical and Biochemical Data presents the fundamental basis and procedures of data modeling by computer using nonlinear regression analysis. Bypassing the need for intermediary analytical...

Modeling Complex Systems (Graduate Texts in Contemporary Physics)
Modeling Complex Systems (Graduate Texts in Contemporary Physics)
This book is about the dynamics of complex systems. Roughly speaking, a
system is a collection of interacting elements making up a whole such as,
for instance, a mechanical clock. While many systems may be quite complicated,
they are not necessarily considered to be complex. There is no precise
definition of complex systems.
Practical Common Lisp
Practical Common Lisp

Lisp is often thought of as an academic language, but it need not be. This is the first book that introduces Lisp as a language for the real world.

Practical Common Lisp presents a thorough introduction to Common Lisp, providing you with an overall understanding of the language features and how they work. Over a third of the...

Dungeons & Dragons  Dummies
Dungeons & Dragons Dummies
Caught in traffic. Trapped in a cubicle. Stuck in a rut.  Tangled up in red tape.

In the real world, sometimes you feel powerless—but not in Dungeons & Dragons (D & D). In this fantasy-adventure, you have all kinds of special powers. You can slay the evil dragon, overcome the orc or the ogre, haunt the...

The Business of iPhone and iPad App Development: Making and Marketing Apps that Succeed
The Business of iPhone and iPad App Development: Making and Marketing Apps that Succeed

The phenomenal success of the iPhone, iPad and the iPod touch has ushered in a “gold rush” for developers, but with well over 300,000 apps in the highly competitive App Store, it has become increasingly difficult for new apps to stand out in the crowd. Achieving consumer awareness and sales longevity for your iOS app requires a...

Pattern Recognition, Second Edition
Pattern Recognition, Second Edition
Pattern recognition is becoming increasingly important in the age of automation and information handling and retrieval.
This book provides the most comprehensive treatment available of pattern recognition, from an engineering perspective. Developed through more than ten years of teaching experience, Pattern Recognition is appropriate for both
©2019 LearnIT (support@pdfchm.net) - Privacy Policy