Join Amazon Prime and get unlimited Free One-Day Delivery. Already a member? Sign in.

 

or
Sign in to turn on 1-Click ordering.
 
   
More Buying Choices
42 used & new from £7.15
Have one to sell? Sell yours here
 
   
Professional SQL Server Analysis Services 2005 with MDX (Programmer to Programmer)
 
 
Share your own customer images
Search inside this book

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: £20.79 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £11.20 (35%)
In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.

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

Want guaranteed delivery by Wednesday, July 8? Choose Express delivery at checkout. See Details
30 new from £18.72 12 used from £7.15

Frequently Bought Together

Professional SQL Server Analysis Services 2005 with MDX (Programmer to Programmer) + Professional SQL Server 2005 Reporting Services (Wrox Professional Guides) + Professional SQL Server 2005 Integration Services
Price For All Three: £61.07

Show availability and shipping details

Customers Who Bought This Item Also Bought

Professional SQL Server 2005 Reporting Services (Wrox Professional Guides)

Professional SQL Server 2005 Reporting Services (Wrox Professional Guides)

by Paul Turley
2.0 out of 5 stars (1)  £19.49
Professional SQL Server 2005 Integration Services

Professional SQL Server 2005 Integration Services

by Brian Knight
4.0 out of 5 stars (3)  £20.79
Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset

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

by Joy Mundy
4.7 out of 5 stars (3)  £22.09
Microsoft® SQL Server™ 2005 Analysis Services Step by Step (Step by Step (Microsoft))

Microsoft® SQL Server™ 2005 Analysis Services Step by Step (Step by Step (Microsoft))

by Reed Jacobson; Stacia Misner; Hitachi Consulting
3.7 out of 5 stars (3)  £18.52
Microsoft® SQL Server™ 2005 Reporting Services Step by Step (Step by Step (Microsoft))

Microsoft® SQL Server™ 2005 Reporting Services Step by Step (Step by Step (Microsoft))

by Stacia Misner; Hitachi Consulting
3.0 out of 5 stars (1)  £20.79
› Explore similar items

Product details

Customers Viewing This Page May Be Interested in These Sponsored Links

  (What is this?)
SQL Analysis Services
   www.quantix-uk.com/SQL-Analysis    SSAS Experts. Consultancy & Support Microsoft Gold Partner 
SQL Server 2008 + 5 CALs
   www.tekgia.com/SQL_Server_2008    Only £1499 plus VAT for full Commercial Edition 
SQL Server Development
   www.RentACoder.com    Choose from thousands of SQL Server developers to complete your project 
  
 

Product Description

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
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

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)
Check a corresponding box or enter your own tags in the field below
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

Your tags: Add your first tag
 
See most popular tags

What Do Customers Ultimately Buy After Viewing This Item?

Professional SQL Server Analysis Services 2005 with MDX (Programmer to Programmer)
55% 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)
£20.79
Microsoft® SQL Server™ 2005 Analysis Services Step by Step (Step by Step (Microsoft))
15% buy
Microsoft® SQL Server™ 2005 Analysis Services Step by Step (Step by Step (Microsoft)) 3.7 out of 5 stars (3)
£18.52
Applied Microsoft Analysis Services 2005: And Microsoft Business Intelligence Platform
11% buy
Applied Microsoft Analysis Services 2005: And Microsoft Business Intelligence Platform 4.8 out of 5 stars (4)
£33.57
Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset
10% buy
Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset 4.7 out of 5 stars (3)
£22.09
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:
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" (Telford, UK) - 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
 
 
 
Only search this product's reviews


Customer Discussions

 Beta (What's this?)
This product's forum (0 discussions)
  Discussion Replies Latest Post
  No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
  [Cancel]

   

Listmania!

Create a Listmania! list

Look for similar items by category

Look for similar items by subject
















i.e., each product must be in subject 1 AND subject 2 AND ...

Feedback

Health & Beauty at Amazon.co.uk

Elemis Resurface and Renew Skin Care Gift Set of 4 Products
From soap to shavers, massagers to mascara, stock up on your daily essentials or truly pamper yourself.

›Discover Health & Beauty

  

Beauty without the Beast

Olay Regenerist Daily 3 Point Treatment Cream
From au naturel to party glam, we have all the best names in cosmetics and skincare.

›Discover Beauty at Amazon.co.uk

  

A Close Shave

Philips Nivea Coolskin HS8060 Moisturizing Rotary Shaving System
For all types of hair removal, stay smooth with Amazon.co.uk.

›Discover Shaving & Hair Removal

  

Treat Someone

Amazon.co.uk Gift Certificates--available in any amount from £5 to £500 With an Amazon.co.uk Gift Certificate, you can get them what they want (even if you don't know what that is).

›Learn more about Gift Certificates

  
Ad

Where's My Stuff?

Delivery and Returns

Need Help?

Your Recent History

  (What's this?)
You have no recently viewed items or searches.

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.

Look to the right column to find helpful suggestions for your shopping session.
Continue Shopping: Top Sellers

amazon.co.uk Amazon Home
International Sites:  United States  |  Germany  |  France  |  Japan  |  Canada  |  China
Business Programs: Sell on Amazon  |  Fulfilment by Amazon  |  Join Associates  |  Join Advantage
Customer Service  |  Help  |  View Basket  |  Your Account
About Amazon.co.uk  |  Careers at Amazon
Conditions of Use & Sale |  Privacy Notice  © 1996-2009, Amazon.com, Inc. and its affiliates