Practical Business Intelligence with SQL Server 2005


book cover
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
overview

Design, Build, and Manage High-Value BI Solutions with SQL Server 2005

In this book, two of Microsoft's leading consultants illustrate how to use SQL Server 2005 Business Intelligence (BI) technologies to solve real-world problems in markets ranging from retail and finance to healthcare. Drawing on extensive personal experience with Microsoft's strategic customers, John C. Hancock and Roger Toren offer unprecedented insight into BI systems design and step-by-step best practices for implementation, deployment, and management.

Hancock and Toren introduce practical BI concepts and terminology and provide a concise primer on the Microsoft BI platform. Next, they turn to the heart of the bookconstructing solutions. Each chapter-length case study begins with the customer's business goals, and then guides you through detailed data modeling. The case studies show how to avoid the pitfalls that derail many BI projects. You'll translate each model into a working system and learn how to deploy it into production, maintenance, and efficient operation.

Whether you're a decision-maker, architect, developer, or DBA, this book brings together all the knowledge you'll need to derive maximum business value from any BI project. 

     •  Leverage SQL Server 2005 databases, Integration Services, Analysis Services, and Reporting Services

     •  Build data warehouses and extend them to support very large databases

     •  Design effective Analysis Services databases

     •  Ensure the superior data quality your BI system needs

     •  Construct advanced enterprise scorecard applications

     •  Use data mining to segment customers, cross-sell, and increase the value of each transaction

     •  Design real-time BI applications

     •  Get hands-on practice with SQL Server 2005's BI toolset



book cover
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