The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset, 2nd EditionISBN: 978-0-470-64038-8
Paperback
704 pages
March 2011
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