Practical Business Intelligence with SQL Server 2005 by John C. Hancock, Roger Toren | | Paperback | Barnes & Noble
Practical Business Intelligence with SQL Server 2005

Practical Business Intelligence with SQL Server 2005

by John C. Hancock, Roger Toren
     
 

ISBN-10: 0321356985

ISBN-13: 9780321356987

Pub. Date: 09/11/2006

Publisher: Addison-Wesley

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

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 book—constructing 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

Product Details

ISBN-13:
9780321356987
Publisher:
Addison-Wesley
Publication date:
09/11/2006
Series:
Microsoft Windows Server System Series
Edition description:
1ST
Pages:
432
Product dimensions:
6.90(w) x 9.00(h) x 1.00(d)

Table of Contents

Acknowledgments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvi

About the Author. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .xvii

Preface. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .xviii

Chapter 1 Introduction to Business Intelligence . . . . . . . . . . 11

Chapter 2 Introduction to SQL Server 2005 . . . . . . . . . . . . . 29

Chapter 3 Building a Data Warehouse. . . . . . . . . . . . . . . . . . 63

Chapter 4 Building a Data Integration Process . . . . . . . . . . . 99

Chapter 5 Building an Analysis Services Database. . . . . . . 141

Chapter 6 Reporting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .179

Chapter 7 Data Quality . . . . . . . . . . . . . . . . . . . . . . . . . . . . .215

Chapter 8 Managing Changing Data . . . . . . . . . . . . . . . . . . 245

Chapter 9 Scorecards . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 271

Chapter 10 Data Mining. . . . . . . . . . . . . . . . . . . . . . . . . . . . 309

Chapter 11 Very Large Data Warehouses . . . . . . . . . . . . . 343

Chapter 12 Real-Time Business Intelligence. . . . . . . . . . . . .379

Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .399

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >