Quantity:

More Buying Choices

37 used & new from �18.03

Have one to sell? Sell yours here

Professional SQL Server Analysis Services 2005 with MDX (Programmer to Programmer) (Paperback)

by Sivakumar Harinath (Author), Stephen R. Quinn (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.3 out of 5 stars See all reviews (3 customer reviews)

RRP:	�31.99
Price:	�19.79 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save:	�12.20 (38%)
	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.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.

Want guaranteed delivery by Tuesday, November 17? Choose Express delivery at checkout. See Details

29 new from �18.03 8 used from �18.03

Frequently Bought Together

Price For All Three: �54.96

Show availability and delivery details

This item: Professional SQL Server Analysis Services 2005 with MDX (Programmer to Programmer) by Sivakumar Harinath
In stock.
Dispatched from and sold by Amazon.co.uk.
This item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
Professional SQL Server 2005 Integration Services by Brian Knight
In stock.
Dispatched from and sold by Amazon.co.uk.
This item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
Professional SQL Server 2005 Reporting Services (Wrox Professional Guides) by Paul Turley
In stock.
Dispatched from and sold by Amazon.co.uk.
This item Delivered FREE in the UK with Super Saver Delivery. See details and conditions

Customers Who Bought This Item Also Bought

Professional SQL Server 2005 Integration Services

by Brian Knight

4.0 out of 5 stars (3) �19.29

Professional SQL Server 2005 Reporting Services (Wrox Professional Guides)

by Paul Turley

2.0 out of 5 stars (1) �15.88

SQL Server 2005 Analysis Services Step by Step Book/CD Package (Step by Step (Microsoft))

by Reed Jacobson; Stacia Misner; Hitachi Consulting

3.7 out of 5 stars (3) �17.02

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

by Joy Mundy

4.7 out of 5 stars (3) �20.59

Applied Microsoft Analysis Services 2005 & Microsoft Business Intelligence Platform

by Teo Lachev

4.8 out of 5 stars (4) �29.48

› Explore similar items

Product details

Paperback: 864 pages
Publisher: John Wiley & Sons; illustrated edition edition (30 May 2006)
Language English
ISBN-10: 0764579185
ISBN-13: 978-0764579189
Product Dimensions: 23.4 x 18.4 x 5 cm

Average Customer Review: 2.3 out of 5 stars See all reviews (3 customer reviews)

Amazon.co.uk Sales Rank: 218,225 in Books (See Bestsellers in Books)

Popular in these categories:

#19 in	Books > Computing & Internet > Databases > Applications > Microsoft SQL Server > Advanced & Intermediate
#26 in	Books > Computing & Internet > Microsoft Windows > Programming > SQL Server
#86 in	Books > Computing & Internet > Databases > Applications > SQL > Microsoft SQL Server

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

See Complete Table of Contents

Customers Viewing This Page May Be Interested in These Sponsored Links

(What is this?)

SQL Server Analysis Tool opens new browser window

www.Quest-Software.co.uk - Real Time Performance Tuning for MS SQL. Download Free Trial.

Microsoft SQL Analysis opens new browser window

www.AnalysisServices.info - SQL Server Analysis Services Talk to the Experts Today!

SQL Server Developer opens new browser window

www.cloudstreet.co.uk - Bespoke Software For Your Business �3k - �30k projects. Call Now!

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

Suggested Tags from Similar Products

(What's this?)

Be the first one to add a relevant tag (keyword that's strongly related to this product)

mdx

sql server 2005 analysis services

technical books

ssas

sql server 2005 programming

sql server 2005 mdx

sql server 2005

sql server 2000

sql analysis services

rc business intelligence

bijan07

What Do Customers Ultimately Buy After Viewing This Item?

	46% buy the item featured on this page: Professional SQL Server Analysis Services 2005 with MDX (Programmer to Programmer) 2.3 out of 5 stars (3) �19.79
	19% buy SQL Server 2005 Analysis Services Step by Step Book/CD Package (Step by Step (Microsoft)) 3.7 out of 5 stars (3) �17.02
	15% buy Applied Microsoft Analysis Services 2005 & Microsoft Business Intelligence Platform 4.8 out of 5 stars (4) �29.48
	12% buy Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset 4.7 out of 5 stars (3) �20.59

Explore similar items

Customer Reviews

3 Reviews

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

Average Customer Review

2.3 out of 5 stars (3 customer reviews)

Share your thoughts with other customers:

Create your own review

Most Helpful Customer Reviews

4 of 4 people found the following review helpful:

1.0 out of 5 stars Do not buy this book, 27 May 2007

By	P. Simon - See all my reviews (REAL NAME)

This book uses the sample database that ships with SQL Server but that database has been changed since the book was written, so the examples in the book do not match up.

There are a number of cases where it says that if you do X in SQL Server then Y will happen, but it doesn't.

There are cases where it gives some example code, and then shows a result that would have been produced by different code which is confusing.

There is no distinction between general discussion and steps that you need to take to follow the examples, which makes them very hard to follow.

There are a number of errata.

I have raised these issues with Wrox who have referred them to the Authors but so far I have not received any reply. The only replies I have had are from other readers who are also struggling with this book.

I am so disappointed that I am going to buy a different book.

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

1 of 1 people found the following review helpful:

4.0 out of 5 stars Not a bad book, 4 Jul 2007

By	B. Eaton "twiglet27" - See all my reviews (TOP 1000 REVIEWER) (REAL NAME)

After years of relational data management work, this book was my first introduction to Analysis Services. It did what few other texts have managed and explained clearly the purpose of both Data Warehousing and Analysis Services. For that reason I look favourable on it despite its shortcomings.

These shortcomings are (in no particular order):

- Index is not too good (true of most recent Wrox publications)
- Goes from very simple to very techical with nothing in between
- Doesn't provide a very good transition path from users with relational database experience
- Er...that's it

To be fair thought this is actually a very good reference, a not half-bad skimmers guide, and an excellent tutorial. If you work through all the chapters (in which case you're obviously not doing it for a living) then everything you need to know is in there somewhere. The chaps writing it seem to know everything so it can get a bit heavy sometimes though.

In any case, I've managed to attain a reasonable level of competency after 3 months on-the-job use so it can't be that bad.

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

0 of 1 people found the following review helpful:

2.0 out of 5 stars Could/Should have been much much better , 6 Jul 2007

By	JDL "JDL" (UK London) - See all my reviews

Personally I found the book hard to follow it seemed to go over simple areas in a lot of detail then the harder (more interesting stuff) was just skimmed over.....
Some examples with the financial functions would have been good, showing some real modelling of Data.

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

Share your thoughts with other customers: Create your own review

› See all 3 customer reviews...

.jsOffDisplayBlock { display: block; } .jsOffDisplayInline { display: inline; } .jsOffVisibility { visibility: visible; } .jsOnDisplayBlock { display: none; } .jsOnDisplayNoneBlock { display: block; } .jsOnDisplayNoneInline { display: inline; } .jsOnDisplayInline { display: none; } .jsOnVisibility { visibility: hidden; } .jqOnDisplayBlock { display: none; } .jqOnDisplayInline { display: none; } .jqOnVisibility { visibility: hidden; } .jqOnDisplayNoneBlock { display: block; } .jqOnDisplayNoneInline { display: inline; }