The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset, 2nd Edition
- 12h 21m
- Joy Mundy, Ralph Kimball, Warren Thornthwaite
- John Wiley & Sons (US)
- 2011
Learn to use SQL Server 2008 R2 to build a successful data warehouse
As the most influential thought leaders in the data warehousing and business intelligence industry, the Kimball Group has developed pioneering techniques that serve as industry standards for DW/BI system design, development, and management. With this new edition of their bestseller, veteran experts from the Kimball Group get you up to speed with using the new Business Intelligence release of SQL Server: SQL Server 2008 R2. Covering the complete suite of data warehousing and BI tools that are part of SQL Server 2008 R2, the authors follow the full project lifecycle, including design, development, deployment, and maintenance.
In addition to a substantial update to the content of the previous edition as well as a look at the new features and functionality of SQL Server 2008 R2 such as PowerPivot and Master Data Services, this new version includes detailed examples that illustrate how to best apply the techniques described in the book. The authors share their own trial-and-error experiences of building a DW/BI system with the Microsoft tools so that you can benefit from their challenges and successes. You'll also discover how using the Kimball Lifecycle to build your DW/BI system encourages you to zero in on four primary principles: focus on the business, build an information infrastructure, deliver in meaningful increments, and deliver the entire solution. With these principles in hand, you'll be well on your way to building a successful DW/BI system that supports business intelligence requirements common to most organizations.
No matter your role in the process of working on a DW/BI project, The Microsoft Data Warehouse Toolkit, Second Edition shows you how to:
- Focus your efforts on the best opportunities
- Select, install, and configure the appropriate components of SQL Server 2008 R2 and other Microsoft products
- Design the dimensional model and create the database structures for the relational and Analysis Services databases
- Build an ETL System in Integration Services to populate the DW/BI databases
- Build the BI applications and data mining models to deliver value to your organization
- Manage, secure, and grow the DW/BI system for long-term success
With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset
About the Authors
Joy Mundy has focused on DW/BI systems since 1992 with stints at Stanford, WebTV, and Microsoft's SQL Server product development organization. Joy graduated from Tufts University with a BA in Economics, and from Stanford University with an MS in Engineering Economic Systems.
Warren Thornthwaite began his DW/BI career in 1980. After managing Metaphor's consulting organization, he worked for Stanford University and WebTV. Warren holds a BA in Communications Studies from the University of Michigan and an MBA from the University of Pennsylvania's Wharton School.
Ralph Kimball founded the Kimball Group. Since the mid 1980s, he has been the DW/BI industry's thought leader on the dimensional approach and has trained more than 10,000 IT professionals. Prior to working at Metaphor and founding Red Brick Systems, Ralph co]invented the Star workstation at Xerox's Palo Alto Research Center (PARC). Ralph has a Ph.D. in Electrical Engineering from Stanford University.
In this Book
-
Introduction
-
Defining Business Requirements
-
Designing the Business Process Dimensional Model
-
The Toolset
-
System Setup
-
Creating the Relational Data Warehouse
-
Master Data Management
-
Designing and Developing the ETL System
-
The Core Analysis Services OLAP Database
-
Design Requirements for Real‐Time BI
-
Building BI Applications in Reporting Services
-
PowerPivot and Excel
-
The BI Portal and SharePoint
-
Incorporating Data Mining
-
Designing and Implementing Security
-
Metadata Plan
-
Deployment
-
Operations and Maintenance
-
Present Imperatives and Future Outlook
YOU MIGHT ALSO LIKE
