SPECIAL OFFERS
Keep up with new releases and promotions. Sign up to hear from us.
Register your product to gain access to bonus material or receive a coupon.
This eBook includes the following formats, accessible from your Account page after purchase:
EPUB The open industry format known for its reflowable content and usability on supported mobile devices.
PDF The popular standard, used most often with the free Acrobat® 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.
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
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