Joy Mundy, Warren Thornthwaite, Ralph Kimball

The Microsoft Data Warehouse Toolkit

• Broschiertes Buch

Produktbeschreibung

The techniques pioneered by the Kimball Group have become the industry standard for data warehouse design, development, and management. In this new edition of the Microsoft Data Warehouse Toolkit, the authors share best practices for using these techniques in SQL Server 2008 R2 and Office 2010. It features brand new content on PowerPivot for Excel and SharePoint, Master Data Services, and updated capabilities of SQL Server Analysis, Integration, and Reporting Services. Full of case samples, this book serves as a helpful resource for database and data warehouse developers and managers.

---

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.

Produktdetails

• Verlag: Wiley & Sons
• Artikelnr. des Verlages: 14564038000
• 2nd ed.
• Seitenzahl: 704
• Erscheinungstermin: 8. März 2011
• Englisch
• Abmessung: 235mm x 189mm x 40mm
• Gewicht: 1020g
• ISBN-13: 9780470640388
• ISBN-10: 0470640383
• Artikelnr.: 32461237

Autorenporträt

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.

Inhaltsangabe

Foreword. Introduction. Part 1 Requirements, Realities, and Architecture.
Chapter 1 Defining Business Requirements. Chapter 2 Designing the Business
Process Dimensional Model. Chapter 3 The Toolset. Chapter 4 System Setup.
Part 2 Building and Populating the Databases. Chapter 5 Creating the
Relational Data Warehouse. Chapter 6 Master Data Management. Chapter 7
Designing and Developing the ETL System. Chapter 8 The Core Analysis
Services OLAP Database. Chapter 9 Design Requirements for Real-Time BI.
Part 3 Developing the BI Applications. Chapter 10 Building BI Applications
in Reporting Services. Chapter 11 PowerPivot and Excel. Chapter 12 The BI
Portal and SharePoint. Chapter 13 Incorporating Data Mining. Part 4
Deploying and Managing the DW/BI System. Chapter 14 Designing and
Implementing Security. Chapter 15 Metadata Plan. Chapter 16 Deployment.
Chapter 17 Operations and Maintenance. Chapter 18 Present Imperatives and
Future Outlook. Index.