Practical Business Intelligence with SQL Server 2005 pdf epub fb2

Practical Business Intelligence with SQL Server 2005 by John C. Hancock, Roger Toren pdf epub fb2

Practical Business Intelligence with SQL Server 2005 Author: John C. Hancock, Roger Toren
Title: Practical Business Intelligence with SQL Server 2005
ISBN: 0321356985
ISBN13: 978-0321356987
Other Formats: txt mobi lit lrf
Pages: 432 pages
Publisher: Addison-Wesley Professional; 1 edition (September 7, 2006)
Language: English
Category: Computers & Technology
Size PDF version: 1526 kb
Size EPUB version: 1414 kb
Subcategory: Computer Science

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