Building a Data Warehouse: With Examples in SQL Server

Building the Data Warehouse: With Examples in SQL Server describes how to create a data warehouse completely from scratch and shows practical examples on how to do it. Author Vincent Rainardi solutions and advice along with developers, the first data warehouse project, discusses some practical problems are likely to encounter. SQL Server 2005 or later used in the examples and the system user relational database (RDBMS), SQL Server, the version will not be a problem as long.

The book is organized as follows. This book (Part 1 6) at the beginning, for example, architecture definition, design patterns data to understand the methodology of requirements gathering, how to build a data warehouse and creating databases data. Then, in Section 7-10, for example, how the source to fill the system with the data store for data quality and use of metadata to facilitate the loading of data stores. After completing the data warehouse, in Chapters 11 to 15, reports and multidimensional databases and how the data warehouse, business intelligence, relationship management, customer data transmission, and explore ways to provide users with data for others. Sections 16 and 17 to wrap the book: After creating a data warehouse before being released to production, you should test it thoroughly. Production after the application, you must understand how to manage the operation of data storage.

What you will learn

• To create a data warehouse, a thorough understanding of what you need
• Application code to create the data store in SQL Server
• Three-dimensional modeling, methods of data mining, overhead data storage, filling the size and the fact tables, data quality, architecture and data warehouse database design
• This kind of business intelligence reports, analysis and data storage 
• Practical applications such as customer relationship management,

For whom is this book?

There are three types of audience for the book. People who participate in the first data memory. In what they can be considered a guide for a field. The second about what it would take to create a data warehouse, I want to have a good idea those users of databases or administrators. The third hearing, the governance aspects of the task before them to make decisions about data storage, and use books to learn about these issues is essential.