Table of Contents

Practical Business Intelligence with SQL Server 2005
By John C. Hancock, Roger Toren
...............................................
Publisher: Addison Wesley Professional
Pub Date: August 28, 2006
Print ISBN-10: 0-321-35698-5
Print ISBN-13: 978-0-321-35698-7
Pages: 432

Table of Contents  | Index

		Copyright
		Microsoft Windows Server System Series
		Acknowledgments
		About the Authors
		Preface
		Chapter 1.  Introduction to Business Intelligence
			What Is Business Intelligence?
			Transaction Systems and the Search for Information
			Data Warehouses
			OLAP to the Rescue
			Dimensional Modeling Concepts
			A Practical Approach to Dimensional Modeling
			Business Intelligence Projects
			Summary
		Chapter 2.  Introduction to SQL Server 2005
			SQL Server Components
			SQL Server Database Engine
			Integration Services
			Analysis Services
			Reporting Services
			Data Mining
			Other Technologies
			Summary
		Chapter 3.  Building a Data Warehouse
			Business Problem
			Solution Overview
			Data Model
			Technical Solution
			Managing the Solution
			Next Steps
			Summary
		Chapter 4.  Building a Data Integration Process
			Business Problem
			Solution Overview
			Data Model
			Technical Solution
			Managing the Solution
			Next Steps
			Summary
		Chapter 5.  Building an Analysis Services Database
			Business Problem
			Solution Overview
			Data Model
			Technical Solution
			Managing the Solution
			Next Steps
			Summary
		Chapter 6.  Reporting
			Business Problem
			Solution Overview
			Data Model
			Technical Solution
			Managing the Solution
			Next Steps
			Summary
		Chapter 7.  Data Quality
			Business Problem
			Solution Overview
			Data Model
			Technical Solution
			Managing the Solution
			Next Steps
			Summary
		Chapter 8.  Managing Changing Data
			Business Problem
			Solution Overview
			Data Model
			Technical Solution
			Managing the Solution
			Next Steps
			Summary
		Chapter 9.  Scorecards
			Business Problem
			Solution Overview
			Data Model
			Technical Solution
			Managing the Solution
			Next Steps
			Summary
		Chapter 10.  Data Mining
			Business Problem
			Solution Overview
			Data Model
			Technical Solution
			Managing the Solution
			Next Steps
			Summary
		Chapter 11.  Very Large Data Warehouses
			Business Problem
			Solution Overview
			Data Model
			Technical Solution
			Managing the Solution
			Next Steps
			Summary
		Chapter 12.  Real-Time Business Intelligence
			Business Problem
			Solution Overview
			Data Model
			Technical Solution
			Managing the Solution
			Next Steps
			Summary
		Index