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

…  See more details below

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

Read More

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

Ch. 1Introduction to business intelligence11
Ch. 2Introduction to SQL Server 200529
Ch. 3Building a data warehouse63
Ch. 4Building a data integration process99
Ch. 5Building an analysis services database141
Ch. 6Reporting179
Ch. 7Data quality215
Ch. 8Managing changing data245
Ch. 9Scorecards271
Ch. 10Data mining309
Ch. 11Very large data warehouses343
Ch. 12Real-time business intelligence379

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >