The Microsoft data warehouse toolkit : with SQL server 2008 R2 and the Microsoft Business Intelligence toolset / Joy Mundy and Warren Thornthwaite, with Ralph Kimball.

Format:

Book

Author/Creator:

Mundy, Joy, 1961-

Contributor:

Thornthwaite, Warren, 1957-

Kimball, Ralph.

Language:

English

Subjects (All):

Data warehousing.

Client/server computing.

SQL server.

Genre:

Electronic books.

Physical Description:

1 online resource (698 pages)

Edition:

2nd ed.

Other Title:

Data warehouse toolkit

Place of Publication:

Indianapolis, IN : Wiley, c2011.

Summary:

Best practices and invaluable advice from world-renowned data warehouse experts In this book, leading data warehouse experts from the Kimball Group share best practices for using the upcoming “Business Intelligence release” of SQL Server, referred to as SQL Server 2008 R2. 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. Features more than 50 percent new and revised material that covers the rich new feature set of the SQL Server 2008 R2 release, as well as the Office 2010 release Includes brand new content that focuses on PowerPivot for Excel and SharePoint, Master Data Services, and discusses updated capabilities of SQL Server Analysis, Integration, and Reporting Services Shares detailed case examples that clearly illustrate how to best apply the techniques described in the book The accompanying Web site contains all code samples as well as the sample database used throughout the case studies The Microsoft Data Warehouse Toolkit, Second Edition provides you with the knowledge of how and when to use BI tools such as Analysis Services and Integration Services to accomplish your most essential data warehousing tasks.

Contents:

Introduction

Part 1: Requirements, Realities, and Architecture

Chapter 1. Defining Business Requirements

Chapter 2. Designing the Business Process Dimensional Model

Chapter 3. The Toolset

Chapter 4. System Setup

Part 2: Building and Populating the Databases

Chapter 5. Creating the Relational Data Warehouse

Chapter 6. Master Data Management

Chapter 7. Designing and Developing the ETL System

Chapter 8. The Core Analysis Services OLAP Database

Chapter 9. Design Requirements for Real-Time BI

Part 3: Developing the BI Applications

Chapter 10: Building BI Applications in Reporting Services

Chapter 11. Power Pivot and Excel

Chapter 12. The BI Portal and SharePoint

Chapter 13. Incorporating Data Mining

Part 4: Deploying and Managing the DW/BI System

Chapter 14: Designing and Implementing Security

Chapter 15. Metadata Plan

Chapter 16. Deployment

Chapter 17. Operations and Maintenance

Chapter 18. Present Imperatives and Future Outlook.

Notes:

Includes index.

ISBN:

9786613374561

9781118067956

1118067959

9781283374569

1283374560

9781118067932

1118067932

OCLC:

741107251