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. At 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 requirements, designing data models, and creating databases. Then in Chapters 7 to 10, you learn how to fill the data warehouse, for instance, takes from source systems, loading the data stores, maintaining data quality, and utilizing the metadata. After you fill in 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 business intelligence, customer relationship management, and other purposes. Once your application is in production, you need to understand how to manage the operation of a data warehouse. What you will learn? Detailed understanding of what it takes to build a data warehouse implementation code in SQL Server to build a data warehouse dimensional model, method of data extraction, loading data warehouses, filling the table dimensions and facts, data quality, data warehouse architecture, design Practical data warehousing and database applications such as business intelligence reporting, analysis applications, and customer relationship management Who is this book?