Practical Business Intelligence with SQL Server 2005 (Microsoft Windows Server System Series)

Posted: Fri, 25 Jan 2008 09:33:00 +0000
Publisher:Addison-Wesley Professional; 1 edition
Language: English
ISBN: 0321356985
Paperback: 432 pages
Data: September 7, 2006
Format: CHM
Description: Design, Build, and Manage High-Value BI Solutions with SQL Server 2005

In this book, two of Microsofts 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 Microsofts 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 customers business goals, and then guides you through detailed data modeling. The case studies show how to avoid the pitfalls that derail many BI projects. Youll 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 Service
? 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 2005s BI toolset


Download