The Microsoft Data Warehouse Toolkit (eBook)

With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset

Joy Mundy, Warren Thornthwaite, Ralph Kimball (Autoren)

eBook Download: PDF

2011 | 1. Auflage
704 Seiten
John Wiley & Sons (Verlag)
978-1-118-06793-2 (ISBN)

Infos

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.

Autor

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

Inhalt

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

Produkt-Details

• Erscheint lt. Verlag: 24.2.2011
• Sprache: englisch
• Themenwelt: Informatik ► Datenbanken ► Data Warehouse / Data Mining
• Themenwelt: Mathematik / Informatik ► Informatik ► Netzwerke
• Schlagworte: Computer Science • Database & Data Warehousing Technologies • Data Warehouse • Datenbanken u. Data Warehousing • Informatik
• ISBN-10: 1-118-06793-2 / 1118067932
• ISBN-13: 978-1-118-06793-2 / 9781118067932