Wiley.com
Print this page Share

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

ISBN: 978-0-470-64038-8
Paperback
704 pages
March 2011
List Price: US $50.00
Government Price: US $32.00
Enter Quantity:   Buy
The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset, 2nd Edition (0470640383) cover image
This is a Print-on-Demand title. It will be printed specifically to fill your order. Please allow an additional 10-15 days delivery time. The book is not returnable.

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

Back to Top