Vous voulez voir cette page en fran�ais ? Cliquez ici.

Quantity:

More Buying Choices

23 used & new from CDN$ 35.22

Have one to sell? Sell yours here

Professional SQL Server Analysis Services 2005 with MDX (Paperback)

by Stephen R. Quinn (Author), Sivakumar Harinath (Author) "A data warehouse is a system that takes data from a company's databases and other data sources and transforms it into a structure conducive to..." (more)

2.0 out of 5 stars See all reviews (1 customer review)

List Price:	CDN$ 59.99
Price:	CDN$ 37.79 & eligible for FREE Super Saver Shipping on orders over CDN$ 39. Details
You Save:	CDN$ 22.20 (37%)
	o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o

In Stock.
Ships from and sold by Amazon.ca. Gift-wrap available.

Only 3 left in stock--order soon (more on the way).

17 new from CDN$ 35.22 6 used from CDN$ 62.07

Frequently Bought Together

Total List Price: CDN$ 167.97
Price For All Three: CDN$ 105.81

Show availability and shipping details

This item: Professional SQL Server Analysis Services 2005 with MDX by Stephen R. Quinn
In Stock.
Ships from and sold by Amazon.ca.
Eligible for FREE Super Saver Shipping on orders over CDN$ 39. Details
Professional SQL Server 2005 Reporting Services by Paul Turley
In Stock.
Ships from and sold by Amazon.ca.
Eligible for FREE Super Saver Shipping on orders over CDN$ 39. Details
Professional SQL Server 2005 Integration Services by Brian Knight
In Stock.
Ships from and sold by Amazon.ca.
Eligible for FREE Super Saver Shipping on orders over CDN$ 39. Details

Customers Who Bought This Item Also Bought

Professional SQL Server 2005 Reporting Services

by Paul Turley

3.0 out of 5 stars (3) CDN$ 30.23

MDX Solutions: With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase

by George Spofford

CDN$ 47.99

Professional SQL Server 2005 Integration Services

by Brian Knight

CDN$ 37.79

Microsoft SQL Server 2005 Analysis Services

by Edward Melomed

CDN$ 49.13

The Microsoft�Data Warehouse Toolkit: With SQL Server�2005 and the Microsoft�Business Intelligence Toolset

by Joy Mundy

5.0 out of 5 stars (1) CDN$ 47.99

› Explore similar items

Product Details

Paperback: 864 pages
Publisher: Wrox; 1 edition (May 12 2006)
Language: English
ISBN-10: 0764579185
ISBN-13: 978-0764579189
Product Dimensions: 23.4 x 18.4 x 5 cm
Shipping Weight: 1.3 Kg

Average Customer Review: 2.0 out of 5 stars See all reviews (1 customer review)

Amazon.ca Sales Rank: #143,483 in Books (See Bestsellers in Books)

Would you like to update product info or give feedback on images?

See Complete Table of Contents

Product Description

Written by the lead developers of Analysis Services at Microsoft, this book begins with an overview showing how Analysis Services and MDX can be used to build data warehouses and multidimensional databases
The authors then describe the development processes for building dimensions and cubes from various data sources
Demonstrating a variety of techniques in real-world scenarios, the book shows how MDX can be used to query databases to provide sophisticated analysis of business problems
Finally, the book explains how Analysis Services can be used with other components of SQL Server, including DTS, data mining, and Report Services, to provide comprehensive, end-to-end solutions

From the Back Cover

SQL Server Analysis Services 2005 provides you with the business intelligence platform needed to build full-scale, multidimensional databases. MDX is the query language used to extract information from those multidimensional databases. Analysis Services 2005 supports core business functions such as market analysis, budgeting and forecasting.

Written by members of the Analysis Services product team at Microsoft, this timely and authoritative book shows you how to use Analysis Services along with SQL Server components like Integration Services, Data Mining, and Reporting Services to provide comprehensive, end-to-end solutions. Ultimately you'll learn to solve business problems by leveraging all the tools that SQL Server 2005 has to offer.

What you will learn from this book

The development process for designing Unified Dimensional Models (UDM)
Using to MDX to query databases and for sophicticated business analysis
How to harness features such as multiple measure groups, BI wizards, Key performance indicators, and Actions
How to integrate Analysis Services with other SQL Server 2005 components in order to provide the best possible end-to-end solutions
How to manage and secure Analysis Services efficiently in support of your BI users
How to optimize your design and/or scale Analysis Services to extract the best performance

Who this book is for

This book is for database and data warehouse developers and administrators interested in exploiting the power of BI and leveraging the SQL Server 2005 tool set.

Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

See all Product Description

Inside This Book (Learn More)

First Sentence
A data warehouse is a system that takes data from a company's databases and other data sources and transforms it into a structure conducive to business analysis. Read the first page

Explore More
Concordance

Tag this product

(What's this?)

Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items.

What do customers ultimately buy after viewing this item?

	51% buy the item featured on this page: Professional SQL Server Analysis Services 2005 with MDX 2.0 out of 5 stars (1) CDN$ 37.79
	35% buy The Microsoft�Data Warehouse Toolkit: With SQL Server�2005 and the Microsoft�Business Intelligence Toolset 5.0 out of 5 stars (1) CDN$ 47.99
	5% buy Inside Microsoft� SQL Server(TM) 2005: Query Tuning and Optimization CDN$ 39.68
	4% buy MDX Solutions: With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase CDN$ 47.99

Explore similar items

Customer Reviews

1 Review

5 star:		(0)
4 star:		(0)
3 star:		(0)
2 star:		(1)
1 star:		(0)

Average Customer Review

2.0 out of 5 stars (1 customer review)

Share your thoughts with other customers:

Create your own review

Most helpful customer reviews

2.0 out of 5 stars Quite possibly the worst edited book ever, Jun 6 2007

By	Richard Tench - See all my reviews (REAL NAME)

This is my first wrox book. I'm not sure if they are all like this, or just this one.

I bought this book and began reading it with a positive outlook. The writers seem genuinely nice, and they were senior developers of the product. I liked their sense of humour, and looked forward to becoming competent at what I believe to be an excellent product.

Sadly, the book is riddled with errors--obvious errors and not-so-obvious errors. The latter, of course, are killers. Pretty well every code fragment is broken, either through typos, or because the syntax doesn't match the sample database. Thankfully, you can download code examples that have been corrected. But you can't download corrected text. The errata are scant, and the publisher ignores submissions of corrections (not just mine, but others -- see the reviews on amazon.com--the American amazon).

When I say "riddled with errors", I mean several per page, typically. It is clear that this book was not usage tested, or it was only tested on those familiar wtih SQL Server, Visual Studio, and also perhaps Analysis Services 2000. I'm new to all these, but I'm a bright enough boy. :-)

Now. If you are self-sufficient and very talented, you can puzzle your way through. I don't know SQL Server and still managed to learn the Attach command needed to complete installation of the sample database.

Also I have learned much because of errors and omissions. For example, I learned the hard way that I can't create an object in one tab (of SQL Server Management Studio) and reference it from another tab. Mind you, that took me a few hours, whereas one sentence in the book would have taught me just as well. This is one of hundreds of omissions.

By no means should you use this book to learn MDX. There was little effort to ensure that each new query contained concepts already taught. The only way to read the MDX sections is in two passes. Often something puzzling about one query was only explained a few queries later. If you want to rigourously ensure you understand each query before proceeding, well this book is not for you. Also, the authors give little advice on pros and cons of using different techniques. They will teach you several labourious methods for doing something before teaching you the easy intuitive way.

I'm on page 198 now (after 4 weeks, most evenings), and should consider cutting my losses. But for now, I'll keep working through. I look forward to "Advanced Dimension Design". On earlier similar chapters I've been able to work through the authors' lack of rigour and believe I'll be able to figure it out when the suggested tutorial actions don't work. I'll see how it goes over the next couple weeks.

Was this review helpful to you? Yes No (Report this)

Share your thoughts with other customers: Create your own review

› See all customer reviews...