The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset / Edition 2

The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset / Edition 2

1.0 1
by Joy Mundy, Warren Thornthwaite
     
 

Learn to use SQL Server 2008 R2 to build a successful data warehouse

As the most influential thought leaders in the data warehousing and business intelligence industry, the Kimball Group has developed pioneering techniques that serve as industry standards for DW/BI system design, development, and management. With this new edition of their bestseller,

See more details below

Overview

Learn to use SQL Server 2008 R2 to build a successful data warehouse

As the most influential thought leaders in the data warehousing and business intelligence industry, the Kimball Group has developed pioneering techniques that serve as industry standards for DW/BI system design, development, and management. With this new edition of their bestseller, veteran experts from the Kimball Group get you up to speed with using the new Business Intelligence release of SQL Server: SQL Server 2008 R2. Covering the complete suite of data warehousing and BI tools that are part of SQL Server 2008 R2, the authors follow the full project lifecycle, including design, development, deployment, and maintenance.

In addition to a substantial update to the content of the previous edition as well as a look at the new features and functionality of SQL Server 2008 R2 such as PowerPivot and Master Data Services, this new version includes detailed examples that illustrate how to best apply the techniques described in the book. The authors share their own trial-and-error experiences of building a DW/BI system with the Microsoft tools so that you can benefit from their challenges and successes. You'll also discover how using the Kimball Lifecycle to build your DW/BI system encourages you to zero in on four primary principles: focus on the business, build an information infrastructure, deliver in meaningfulincrements, and deliver the entire solution. With these principles in hand, you'll be well on your way to building a successful DW/BI system that supports business intelligence requirements common to most organizations.

No matter your role in the process of working on a DW/BI project, The Microsoft Data Warehouse Toolkit, Second Edition shows you how to:

  • Focus your efforts on the best opportunities
  • Select, install, and configure the appropriate components of SQL Server 2008 R2 and other Microsoft products
  • Design the dimensional model and create the database structures for the relational and Analysis Services databases
  • Build an ETL System in Integration Services to populate the DW/BI databases
  • Build the BI applications and data mining models to deliver value to your organization
  • Manage, secure, and grow the DW/BI system for long-term success

With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset

Read More

Product Details

ISBN-13:
9780470640388
Publisher:
Wiley
Publication date:
03/08/2011
Edition description:
New Edition
Pages:
696
Sales rank:
732,382
Product dimensions:
7.40(w) x 9.20(h) x 1.60(d)

Table of Contents

Foreword xxvii

Introduction xxix

Part 1 Requirements, Realities, and Architecture 1

Chapter 1 Defining Business Requirements 3

Chapter 2 Designing the Business Process Dimensional Model 29

Chapter 3 The Toolset 79

Chapter 4 System Setup 99

Part 2 Building and Populating the Databases 133

Chapter 5 Creating the Relational Data Warehouse 135

Chapter 6 Master Data Management 165

Chapter 7 Designing and Developing the ETL System 187

Chapter 8 The Core Analysis Services OLAP Database 245

Chapter 9 Design Requirements for Real-Time BI 305

Part 3 Developing the BI Applications 321

Chapter 10 Building BI Applications in Reporting Services 323

Chapter 11 PowerPivot and Excel 375

Chapter 12 The BI Portal and SharePoint 403

Chapter 13 Incorporating Data Mining 429

Part 4 Deploying and Managing the DW/BI System 491

Chapter 14 Designing and Implementing Security 493

Chapter 15 Metadata Plan 523

Chapter 16 Deployment 545

Chapter 17 Operations and Maintenance 583

Chapter 18 Present Imperatives and Future Outlook 613

Conclusion 623

Index 625

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >