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, anddiscusses 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.
關於作者：
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.
目錄：
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 DWBI 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.
購物車/收銀台(0) | 在線留言板
| 付款方式
| 聯絡我們
| 運費計算
| 幫助中心 |
加入書簽
HOME
新書上架
