The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft business Intelligence Toolset, Second Edition

In this new edition, the authors explain how sql server 2008 r2 provides a collection of powerful new tools that extend the power of its bi toolset to excel and sharepoint users and they show how to use sql server to build a successful data warehouse that supports the business intelligence requirements that are common to most organizations. Covering the complete suite of data warehousing and bi tools that are part of sql server 2008 r2, as well as microsoft office, the authors walk you through a full project lifecycle, including design, development, deployment and maintenance. Part 1 requirements, realities, and architecture. · defining business requirements. · designing the business process dimensional model. · the toolset. · system setup. Part 2 building and populating the databases. · creating the relational data warehouse. · master data management. · designing and developing the etl system. · the core analysis services olap database. · design requirements for real-time bi. Part 3 developing the bi applications. · building bi applications in reporting services. · powerpivot and excel. · the bi portal and sharepoint. · incorporating data mining. Part 4 deploying and managing the dw/bi system. · designing and implementing security. · metadata plan. · deployment. · operations and maintenance. · present imperatives and future outlook.