Practical Business Intelligence with SQL Server 2005

by John C. Hancock and Roger Toren

Book 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)... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0321356985
• ISBN13: 9780321356987
• Release Date: August 2006
• Publisher: Addison-Wesley Professional
• Length: 412 Pages
• Weight: 1.36 lbs.
• Dimensions: 0.9" x 7.1" x 9.2"

Customer Reviews

Great first book on SQL 2005 BI

BI is about turning data into useful knowledge. This book is geared towards the beginners of SQL 2005 BI. It differs from many other books in the market in that it defines the general architecture of a SQL 2005 BI. They involve OLTP, ETL, DW, OLAP, and query and reporting (Reporting Services). The author describes each step in a case method so the reader can understand when and how SQL 2005 BI can be utilized to meet a business requirement. I have found author's suggestions on buildling an effective DW and how it relates to building an effective OLAP Cube to be particularly useful. The downside is that this is not particularly detailed and it is missing many pieces such as MDX. But it is not meant to be a comprehensive reference but a mere introduction to the possibilities of SQL 2005 BI. To that end, the book does its job well.

Extremely Practical and Hands-On BI Book

I cannot recommend this book highly enough! On a topic that regrettably, is otherwise extremely short on practical and accessible information - Practical BI achieves that in a very effective and concise manner, introducing practical BI concepts and terminology then applying them. John and Roger cover off the Microsoft BI platform quite admirably. The heart of Practical BI is constructing real-world solutions. Each chapter consists of a case study that begins with the customer's business goals, and then guides you through to the solution in a detailed and thorough manner - complete with source code that actually works - fully and completely. That's the kicker for me - the source code provided along with the book covers the cost of the book - many times over. It is very reassuring to fall back on the solid working source examples, and to pick up from where you have the time and desire to apprentice. It is a pleasure to work through this book - the lessons take, even novices, a long way down the road to mastering Microsoft's BI world. For my BI Intro Presentation to our Toronto SQL User Group - TSQL.ca, I will be presenting exclusively large sections of this book. The book gets you anxious to roll up your sleeves and get working in BI. The case study examples are very pertinent to the real world. Well done John and Roger!

The definitive guide to SQL Server Business Intelligence

This book delivers exactly what the title promises -- A practical guide to learning and understanding Microsoft SQL Server 2005 BI. I've purchased more than a dozen books on the subject. This is the one that offers the most understandable and concise explanation of the capabilities of the product without a lot of fluff. It is my "go to" guide whenever I need a refresher.

First job on a data warehouse

I recently started my first job as a full time dba using sql server 2005 and am working on a data warehouse for the first time. This book helped me immensely in understanding what I am doing and how to do it. It's a steep learning curve in a tough environment but immensely rewarding.

Getting the job done -- and delivering value -- on time

Data warehouse projects are notorious for running late, costing a fortune, and failing to deliver much more than a conference room full of fancy flow sheets. I worked on developing a complex data warehouse in the years before SQL Server 2005, and I wish this book had been available when I started. Although this book provides a good overview of the pertinent features of SQL Server 2005, it is not an enclycopedia of Analysis and Reporting Services. That is ok. The greatest value is in having each topic area organized around an practical example, and in presenting the example from a business-value and project-management approach that too many IT "experts" fail to apply: 1. Clarify the business problem that needs to be solved. 2. Define how to meet the business requirments 3. Design the architecture and data model 5. Work up the technical solution (testing along the way) 6. Manage the deployment, security, updating, and maintanence issues The book also has a healthy focus on the real issues of data quality. Along the way, the authors sprinkle gems about why some approaches work better than others. Programmers who are not responsible for project design can still benefit from knowing how a well-run project would work. And anyone responsible for Business Intelligence projects definitely needs the knowledge contained in this book.