Professional SQL Server Analysis Services 2005 with MDX and over 360,000 other books are available for Amazon Kindle – Amazon’s new wireless reading device. Learn more

 

or
Sign in to turn on 1-Click ordering.
 
 
Express Checkout with PayPhrase
What's this? | Create PayPhrase
Sorry!
More Buying Choices
56 used & new from $11.88

Have one to sell? Sell yours here
 
   
Professional SQL Server Analysis Services 2005 with MDX (Programmer to Programmer)
 
 
Start reading Professional SQL Server Analysis Services 2005 with MDX on your Kindle in under a minute.

Don’t have a Kindle? Get your Kindle here.
 
  

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

~ (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)
Key Phrases: Cancel Figure, Dim Geography, United States (more...)
3.4 out of 5 stars  See all reviews (9 customer reviews)

List Price: $49.99
Price: $31.49 & this item ships for FREE with Super Saver Shipping. Details
You Save: $18.50 (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
Upgrade this book for $9.99 more, and you can read, search, and annotate every page online. See details
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.

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

Want it delivered Wednesday, November 11? Choose One-Day Shipping at checkout. Details
37 new from $25.81 19 used from $11.88

Formats

Amazon Price New from Used from
  Kindle Edition $25.19 -- --
  Paperback $31.49 $25.81 $11.88

Frequently Bought Together

Professional SQL Server Analysis Services 2005 with MDX (Programmer to Programmer) + Professional SQL Server 2005 Reporting Services + Professional SQL Server 2005 Integration Services (Programmer to Programmer)
Price For All Three: $89.37

Show availability and shipping details

  • This item: Professional SQL Server Analysis Services 2005 with MDX (Programmer to Programmer) by Sivakumar Harinath

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • Professional SQL Server 2005 Reporting Services by Paul Turley

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • Professional SQL Server 2005 Integration Services (Programmer to Programmer) by Brian Knight

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details


Customers Who Bought This Item Also Bought

Professional SQL Server 2005 Integration Services (Programmer to Programmer)

Professional SQL Server 2005 Integration Services (Programmer to Programmer)

by Brian Knight
3.7 out of 5 stars (33)  $31.49
Microsoft SQL Server 2005 Analysis Services

Microsoft SQL Server 2005 Analysis Services

by Edward Melomed
3.8 out of 5 stars (18)  $43.86
Microsoft® SQL Server(TM) 2005 Analysis Services Step by Step (Step by Step (Microsoft))

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

by Reed Jacobson
2.9 out of 5 stars (14)  $26.39
Expert SQL Server 2005 Integration Services (Programmer to Programmer)

Expert SQL Server 2005 Integration Services (Programmer to Programmer)

by Brian Knight
4.3 out of 5 stars (15)  $31.49
Delivering Business Intelligence with Microsoft SQL Server 2005: Utilize Microsoft's Data Warehousing, Mining & Reporting Tools to Provide Critical Intelligence to A

Delivering Business Intelligence with Microsoft SQL Server 2005: Utilize Microsoft's Data Warehousing, Mining & Reporting Tools to Provide Critical Intelligence to A

by Brian Larson
4.2 out of 5 stars (25)  $31.49
Explore similar items

Editorial Reviews

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.


Product Details

  • Paperback: 864 pages
  • Publisher: Wrox; illustrated edition edition (May 30, 2006)
  • Language: English
  • ISBN-10: 0764579185
  • ISBN-13: 978-0764579189
  • Product Dimensions: 9.2 x 7.2 x 2 inches
  • Shipping Weight: 2.8 pounds (View shipping rates and policies)
  • Average Customer Review: 3.4 out of 5 stars  See all reviews (9 customer reviews)
  • Amazon.com Sales Rank: #118,016 in Books (See Bestsellers in Books)

More About the Author

Sivakumar Harinath
Discover books, learn about writers, read author blogs, and more.

Visit Amazon's Sivakumar Harinath Page

Inside This Book (learn more)

What Do Customers Ultimately Buy After Viewing This Item?


Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 
(4)
(2)

Your tags: Add your first tag
 

 

Customer Reviews

9 Reviews
5 star:
 (4)
4 star:
 (1)
3 star:
 (1)
2 star:
 (1)
1 star:
 (2)
 
 
 
 
 
Average Customer Review
3.4 out of 5 stars (9 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
25 of 27 people found the following review helpful:
5.0 out of 5 stars Great Book, August 31, 2006
By K. Griffiths (Houston, TX) - See all my reviews
(REAL NAME)   
I needed to know quickly how to implement a BI solution and ordered three books: Delivering Business Intelligence with Microsoft SQL Server 2005 by Brian Larsen, Applied Microsoft Analysis Services by Teo Lachev, and this book. Of the tree books, this is the only one I really needed. This book had everything I wanted to know about Analysis Services. I was also impressed with the knowledge and information regarding how to design dimensions and cubes especially when it comes to tough situations such as how to apply security. If you need to implement a BI solution, I highly recommend this book.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
12 of 12 people found the following review helpful:
2.0 out of 5 stars What a mess, March 18, 2007
By L. Van Staalduinen (The Netherlands) - See all my reviews
(REAL NAME)   
I do not understand why this book gets such high ratings by other readers. I found this book a real mess. My concise evaluation of "Professional SQL Server Analysis Services 2005 with MDX":
· general: bad as a tutorial, but it might serve as a good reference,
· incorrect code: see below,
· incorrect references to other chapters,
· extremely inconsistent use of names of the cube, tables, dimensions, measures, etc., which makes the learning process more like a puzzle,
· subjects, details are scattered over many chapters (which has some advantages as well), but complicates the learning process.

In chapter 3 of this book it starts with code samples, that are incorrect in almost any sense. Not really being a novice, but having my first experience with SSAS (that is: the 2005 version, I had some experience with the 2000 predecessor), I was blaming my ignorance. I could better do not: I simply had to correct about every code sample.
I made a long list of errata, that I have sent to Wiley/Wrox on January 9, 2007. These errata are very detailed and specific, but I do not find the results in the list of errata of this book on the Wiley or Wrox site. They simply did not process my errata.
So, I finally bought "Microsoft SQL Server 2005 Analysis Services" by Melomed, et.al. (Sams, 2007). My first impression: very good, indeed. I just have it for two days now, so my review will take a few more months.
Leendert.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
10 of 12 people found the following review helpful:
5.0 out of 5 stars An absolute must for business intelligence...., August 22, 2006
By D. Gresty "Hammerit" (Littleton, CO United States) - See all my reviews
(REAL NAME)   
I have over 9 years of database experience, with about 4 years in MS Data Warehousing experience which included Reporting Services and DTS.

With the major improvements made with SQL Server 2005, this book allowed me to create a TOTAL business intelligence system which included SSIS, Analysis Services, MDX and Reporting. The book is easy to read and contains valuable information that I haven't seen in other books.

I know following the information in this book is that the client received a top notch system from beginning to the end.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews

4.0 out of 5 stars Hardcore MDX programming: nothing more, nothing less
Other reviewers have already commented on the grammar, and sometimes difficult to follow examples. More often than not a topic is introduced, explained in overly simple terms,... Read more
Published 1 month ago by nine.jack.nine

1.0 out of 5 stars Vague and often Baffling
The intial chapters give a reasonable overview of how to use the wizards and how to get started doing basic customization. Read more
Published 9 months ago by Edward Roberts

1.0 out of 5 stars Good Cop / Bad Cop
Half of the chapters in this book are well planned and very readable. But the other half are just terrible. Read more
Published 19 months ago by Dan Zeltner

5.0 out of 5 stars Excellent tutorial on SSAS 2005
I am a DBA, and bought this book hoping to learn quickly basics of implementing SSAS project. This book exceeded all my expectations. Read more
Published 22 months ago by Vladimir Kievsky

3.0 out of 5 stars Great book if you can get past the poor grammar
After reading the previous reviews of this book, I think my expectations may have to been to high. Overall the book is good, but I feel like it could have been more in-depth in... Read more
Published on February 20, 2007 by Anthony Martin

5.0 out of 5 stars The Definitive Book on Analysis Services
Microsoft has been extending the capabilities of their SQL Server product to make it more useful in enterprise environments. Read more
Published on July 7, 2006 by John Matlock

Only search this product's reviews



Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

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


Active discussions in related forums
Search Customer Discussions
Search all Amazon discussions
   




Product Information from the Amapedia Community

Beta (What's this?)


Look for Similar Items by Category


Look for Similar Items by Subject

 

Feedback

If you need help or have a question for Customer Service, contact us.
 Would you like to update product info or give feedback on images?
Is there any other feedback you would like to provide?

Your comments can help make our site better for everyone.


Your Recent History

 (What's this?)

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