Home > Store > Data > SQL Server

Practical Business Intelligence with SQL Server 2005

Practical Business Intelligence with SQL Server 2005

eBook (Watermarked)

  • Your Price: $38.39
  • List Price: $47.99
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

Also available in other formats.

Register your product to gain access to bonus material or receive a coupon.

Description

  • Copyright 2007
  • Pages: 432
  • Edition: 1st
  • eBook (Watermarked)
  • ISBN-10: 0-13-265214-5
  • ISBN-13: 978-0-13-265214-8

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

Sample Content

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

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership