Practical Business Intelligence with SQL Server 2005: In... and over one million other books are available for Amazon Kindle. Learn more
Temporarily out of stock.
Order now and we'll deliver when available. We'll e-mail you with an estimated delivery date as soon as we have more information. Your account will only be charged when we ship the item.
Ships from and sold by Amazon.ca.
Gift-wrap available.
Quantity:1
Practical Business Intell... has been added to your Cart
+ CDN$ 6.49 shipping
Used: Good | Details
Condition: Used: Good
Comment: Buy with confidence. Excellent Customer Service & Return policy.Ships from USA. Please give between 2-5 week for delivery.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Practical Business Intelligence with SQL Server 2005 Paperback – Aug 28 2006


See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
Paperback
"Please retry"
CDN$ 67.99
CDN$ 30.22 CDN$ 3.04

Amazon.ca: Gifts for Mom
CDN$ 67.99 FREE Shipping. Temporarily out of stock. Order now and we'll deliver when available. We'll e-mail you with an estimated delivery date as soon as we have more information. Your account will only be charged when we ship the item. Ships from and sold by Amazon.ca. Gift-wrap available.



Product Details

  • Paperback: 432 pages
  • Publisher: Addison-Wesley Professional; 1 edition (Aug. 28 2006)
  • Language: English
  • ISBN-10: 0321356985
  • ISBN-13: 978-0321356987
  • Product Dimensions: 17.5 x 2.5 x 22.9 cm
  • Shipping Weight: 567 g
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: #1,398,326 in Books (See Top 100 in Books)

Product Description

From the Back Cover

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

 

About the Author

John C. Hancock is a Senior Consultant with Microsoft Consulting Services in

Toronto, Canada, specializing in Business Intelligence technologies. He has

worked with some of Microsoft’s largest and most strategic clients, and his consulting

experience has included architectural consulting, project team lead positions,

performance optimization, and development of customized training courses and

materials. Recently he has worked extensively in the field of intelligence systems

for law enforcement. Prior to Microsoft, he worked as an independent consultant in

the United Kingdom and South Africa. He holds a Bachelor of Science (Honors)

degree in mathematics and computer science.

 

Roger Toren is a Principal Consultant with MCS, based in Vancouver, Canada,

focusing on guiding customers in the design and implementation of Business Intelligence

solutions with SQL Server 2005. He was the lead author on the SQL Server

2000 High Availability guide. He has more than 35 years of experience in IT, covering

a wide variety of industries, including banking, insurance, retail, education,

health care, geo-spatial analysis, and nuclear research. He holds a Bachelor of Science

degree in physics and a Masters of Science degree in computing science. Prior

to joining Microsoft, he taught undergraduate courses in computing science,

worked as an independent consultant, and served as Associate Director in the technology

practice of a major global consulting firm.

 

Customer Reviews

5.0 out of 5 stars
5 star
1
4 star
0
3 star
0
2 star
0
1 star
0
See the customer review
Share your thoughts with other customers

Most helpful customer reviews

Format: Paperback
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!
Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again.

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: 8 reviews
6 of 6 people found the following review helpful
Getting the job done -- and delivering value -- on time Feb. 23 2007
By Bob350 - Published on Amazon.com
Format: Paperback
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.
4 of 4 people found the following review helpful
First job on a data warehouse Oct. 20 2007
By G. Plummer - Published on Amazon.com
Format: Paperback
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.
3 of 3 people found the following review helpful
Great first book on SQL 2005 BI July 18 2008
By Jaewoo Kim - Published on Amazon.com
Format: Paperback Verified Purchase
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.
2 of 2 people found the following review helpful
Introduction to BI Dec 10 2008
By Edward Zeh - Published on Amazon.com
Format: Paperback
I bought this book because I was looking for an introduction into business intelligence. I have a lot of experience with relational database, but none with BI.

The first chapter gives an introduction when and whz BI can be usefull for a company. It explains why so many BI-projects fail and how to make
such project sucessfull.

Chapter 2 gives an overview of the components of SQL Server, especially those which are important for BI.

Each of the remaining chapter presents a BI-projects, which the authors have successully finished. For me the most interesting one was the "balanced scorecard project" of NY-Police. They have now a dashboard showing the current status of the police service, which allows them to continuously improve their service.

This book is more a business than a technical book. If you are looking
for detailed technical information about analysis service look somewhere else. However, if you need guidance on whether you should BI use in your
company, then this book is the right choice.

Following terms are explained in this book:
business intelligence
OLTP
OLAP
Data Mart
Data Warehouse
Cubes
Data Mining
OLTP Reporting and Analysis
MOLAP
ROLAP
MDX (Multi Dimensional Expression Standard)
KPI (Key Performance Indicators)
Star Design
Snowflake Design
Dimensional Model
Measures
Fact Tables
Attributes
Dimensions
4 of 5 people found the following review helpful
Extremely Practical and Hands-On BI Book Jan. 29 2008
By Joseph F. Michel - Published on Amazon.com
Format: Paperback
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!


Feedback