Mundy / Thornthwaite / Kimball The Microsoft Data Warehouse Toolkit

With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset
1. Auflage 2011
ISBN: 978-1-118-06795-6
Verlag: John Wiley & Sons
Format: EPUB
Kopierschutz: Adobe DRM (»Systemvoraussetzungen)

E-Book, Englisch, 704 Seiten, E-Book

Best practices and invaluable advice from world-renowned datawarehouse experts
In this book, leading data warehouse experts from the KimballGroup share best practices for using the upcoming "BusinessIntelligence release" of SQL Server, referred to as SQLServer 2008 R2. In this new edition, the authors explain howSQL Server 2008 R2 provides a collection of powerful new tools thatextend the power of its BI toolset to Excel and SharePoint usersand they show how to use SQL Server to build a successful datawarehouse that supports the business intelligence requirements thatare common to most organizations. Covering the complete suite ofdata warehousing and BI tools that are part of SQL Server 2008 R2,as well as Microsoft Office, the authors walk you through a fullproject lifecycle, including design, development, deployment andmaintenance.
* Features more than 50 percent new and revised material thatcovers 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 Exceland SharePoint, Master Data Services, and discusses updatedcapabilities of SQL Server Analysis, Integration, and ReportingServices
* Shares detailed case examples that clearly illustrate how tobest apply the techniques described in the book
* The accompanying Web site contains all code samples as well asthe sample database used throughout the case studies
The Microsoft Data Warehouse Toolkit, Second Editionprovides you with the knowledge of how and when to use BI toolssuch as Analysis Services and Integration Services to accomplishyour most essential data warehousing tasks.

Autoren/Hrsg.

Mundy, Joy

Thornthwaite, Warren

Kimball, Ralph

Inhaltsverzeichnis

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

Über Autor(innen)

Joy Mundy is a member of the Kimball Group and has beenfocusing on data warehousing and business intelligence since theearly 1990s.
Warren Thornthwaite has been building decision supportand data warehousing systems since 1980 and is a member of theKimball Group.
Ralph Kimball, PhD, is known worldwide as an innovator,writer, educator, speaker, and consultant in the field of datawarehousing. He is the founder of the Kimball Group(www.kimballgroup.com), which provides data warehouse consultingand education.