The Microsoft Data Warehouse Toolkit:with Sql Serv

Data Warehousing with SQL Server 2005 gives practical examples implemented on the Microsoft's Business Intelligence (BI) toolset. The book is structured around the major phases of a data warehouse project plan: design, develop, deploy, and maintain. It also includes many detailed examples of how to use Business Intelligence Tools like MDX, DTS, and the SQL Server Database etc. to accomplish various data warehousing tasks.


Table of contents :
Foreword
Preface
Acknowledgments
Introduction

Part I Requirements, Realities, and Architecture
· Defining Business Requirements
· Designing the Business Process Dimensional Model
· The Toolset
Part II Developing and Populating the Databases
· Setup and Physical Design
· Designing the ETL System
· Developing the ETL System
· Designing the Analysis Services OLAP Database
Part III Developing the BI Applications
· Business Intelligence Applications
· Building the BI Application in Reporting Services
· Incorporating Data Mining
Part IV Deploying and Managing the DW/BI System
· Working with an Existing Data Warehouse
· Security
· Metadata Plan
· Deployment
· Operations and Maintenance
Part V Extending the DW/BI System
· Managing Growth
· Real-Time Business Intelligence
· Present Imperatives and Future Outlook
Index

Market Description :
· Database and Data Warehouse Developers

About Author :
Ralph Kimball has been a leading visionary in the data warehouse industry since 1982 and is one of today's most internationally well-known speakers, consultants, and teachers on data warehousing. He writes the "Data Warehouse Architect" column for Intelligent Enterprise magazine. Dr. Kimball's coauthors have each founded their own very successful data warehouse consulting firms: Laura Reeves of StarSoft Solutions; Margy Ross of DecisionWorks Consulting; and Warren Thornthwaite of InfoDynamics LLC.

Joy Mundy is a consultant and trainer at Kimball Group. She was formerly at Microsoft, where she was a member of the SQL Server Business Intelligence product development team.

Warren Thornthwaite is a consultant with Kimball Group, a well-known trainer with Kimball University and a co-author of The Data Warehouse Lifecycle Toolkit. He has an extensive background in data warehouse design and development with such organizations as WebTV, Metaphor, and Stanford University.