Shop now Learn more Shop now Shop Clothing clo_fly_aw15_NA_shoes Shop All Shop All Amazon Fashion Cloud Drive Photos Shop now Learn More Shop now Shop Fire HD 6 Shop Kindle Paperwhite Shop now Shop Now Shop now
and over 2 million other books are available for Amazon Kindle . Learn more
£24.04
  • RRP: £36.99
  • You Save: £12.95 (35%)
FREE Delivery in the UK.
In stock.
Dispatched from and sold by Amazon.
Gift-wrap available.
Quantity:1
Professional Microsoft SQ... has been added to your Basket
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 all 3 images

Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX (Wrox Programmer to Programmer) Paperback – 28 Sep 2012

4 customer reviews

See all formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
Paperback
"Please retry"
£24.04
£19.33 £19.49
£24.04 FREE Delivery in the UK. In stock. Dispatched from and sold by Amazon. Gift-wrap available.

Special Offers and Product Promotions

  • Save £20 on Amazon.co.uk with the aqua Classic card. Get an initial credit line of £250-£1,200 and build your credit rating. Representative 32.9% APR (variable). Subject to term and conditions. Learn more.

Frequently Bought Together

  • Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX (Wrox Programmer to Programmer)
  • +
  • Professional Microsoft SQL Server 2012 Integration Services
  • +
  • Professional Microsoft SQL Server 2012 Reporting Services
Total price: £67.90
Buy the selected items together



Product details

  • Paperback: 1176 pages
  • Publisher: John Wiley & Sons; 1 edition (28 Sept. 2012)
  • Language: English
  • ISBN-10: 1118101103
  • ISBN-13: 978-1118101100
  • Product Dimensions: 18.8 x 5.4 x 23.6 cm
  • Average Customer Review: 2.8 out of 5 stars  See all reviews (4 customer reviews)
  • Amazon Bestsellers Rank: 496,735 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Product Description

From the Back Cover

Get up to speed on the premier business intelligence toolset SQL Server 2012 is packed with powerful new Analysis Services features that will dramatically enhance business intelligence. Written by key members of Microsoft's product team, this book shows you how to apply these new capabilities to create sophisticated BI solutions. In order to accomplish this, you'll learn how to design, build, and work with the multidimensional and tabular Business Intelligence Semantic Model (BISM) using SQL Server Analysis Services. You'll then use MDX and DAX to query those databases so you can provide advanced analysis of business problems and build end-to-end solutions to meet your needs. Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX: Shows how to utilize SQL Server Data Tools to build Analysis Services multidimensional and tabular databases Shares fundamental concepts of DAX and MDX and dives into advanced concepts such as parent-child hierarchies and time-based analysis Demonstrates methods for analyzing and optimizing DAX and MDX query performance Describes how to use Excel 2010 in conjunction with Analysis Services to analyze data and effectively use PowerPivot® for SharePoint® Explains Power View setup and configuration and presents real-world scenarios to help simplify reporting Wrox Professional guides are written by working developers to address everyday needs. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job. wrox.com Programmer Forums Join our Programmer to Programmer forums to ask and answer programming questions about this book, join discussions on the hottest topics in the industry, and connect with fellow programmers from around the world. Code Downloads Take advantage of free code samples from this book, as well as code samples from hundreds of other books, all ready to use. Read More Find articles, ebooks, sample chapters, and tables of contents for hundreds of books, and more reference resources on programming topics that matter to you.

About the Author

Sivakumar Harinath is a senior program manager with the SQL Server Analysis Services team. Ronald Pihlgren is a senior tester with the SQL Server Analysis Services team. Denny Guang-Yeu Lee is a principal program manager with the SQL Customer Advisory Team. John Sirmon is a senior program manager with the SQL Server Customer Advisory Team at Microsoft. Robert M. Bruckner is a principal architect with the SQL Server Reporting Services team.


Inside This Book

(Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

2.8 out of 5 stars
Share your thoughts with other customers

Most Helpful Customer Reviews

By Martin Smith on 24 Mar. 2014
Format: Paperback Verified Purchase
As a complete newbie to SSAS I found this really helpful.

I read it cover to cover over the space of 4 days and certainly feel massively more informed on the topic now.

Only criticisms I have are that the Understanding MDX chapter was pretty tough going and I feel should have had better explanations also a couple of sections in chapter 17 are baffling and I can only assume the wrong code snippets were printed (pages 788 and 794)
Comment 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
By Alexander Brown on 17 Jan. 2014
Format: Paperback
well worth getting very detailed book. contains everything i needed to know about MDX and Microsoft SQL server reporting services.
Comment 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
By Mr Darren Weekes on 16 July 2014
Format: Kindle Edition Verified Purchase
Poor grammar, poor worked examples, poor explanations.
Comment 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
0 of 2 people found the following review helpful By Amazon Customer on 13 Mar. 2013
Format: Kindle Edition Verified Purchase
The problem with the book is it uses the generic Adventure Works Database. This changes regularly and as a hardly any of the examples and practices work. I changed some things to get it going but really its poor not to supply a database with the book. Given up after 7%
1 Comment 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: 7 reviews
2 of 2 people found the following review helpful
There must be something better. Would not recommend this book. 10 Aug. 2014
By Arthur - Published on Amazon.com
Format: Paperback Verified Purchase
Poorly written and incongruous. Examples and work do not start from scratch, but require you to download their version of the db and prebuilt Analysis Cubes, which do not compile. Cube is so complex that there is no hope of troubleshooting it without knowing everything in the book before you start. Book starts with an example of what is possible in MDX without telling you how it works. You do not see how it all fits together and how to create something valuable until you can reach the end of the book.
This book is more of a snow job to show you how great the author is, but is not really designed to teach you how to use Analysis Services.
When reading the lessons, it goes into great detail telling you how the nuts and bolts behind the scenes work. Book was written to be large so that it would look impressive on your shelf, but trying to find examples that will help you solve a problem, or even getting useful information from this diatribe is practically impossible. It is more a list of disassociated words than it is something that can be read and used. Might as well purchase a dictionary, at least in it the words are ordered.
That said, there is some good information in it so it is not a total waste;but, I took a Microsoft class which lasted a week and focused on what was important, and it blew this book away. It started from scratch showing you how to build reports, then how to build the cube and use MDX followed by Tabular models and DAX. Every lesson built upon the previous one, and it started simple and built up to a complex model. They recommended the Microsoft book by Alberto Ferrari. I have ordered it and will rate it after reading and using it, but since the class was based on the Microsoft book I have a feeling that it will be a much better resource.
10 of 14 people found the following review helpful
Good Luck first timers 3 Mar. 2013
By Echo5Tango - Published on Amazon.com
Format: Paperback Verified Purchase
IF you ever been down this road before you will appreciate my love/hate for this book. The samples used and even the wonderful cubes built off of the project file do NOT contain the 2012 data within the AdventureWorksDW2012.mdf file samples referenced. All of these databases run up to 2010 and the cube examples have WHERE conditions for Q4, 2011..good luck! I have downloaded 4 different flavors of the 2012 DW to try and match up the data presented in this book. The WROX publisher website sends you in circles to top it off - you will not find the sample database these great authors used. I now have two books that both will provide a warm winter for me...at least until they are fully consumed by the fires they deserve.

If you are real new to this subject please do not get this book if you are going to depend on samples as your road map or you too will find yourself in the winter using this book and its companion on SSIS 2012 as fuel.

Anyone out there finds the elusive yet appropriate 2012DW respond to this review please!
1 of 1 people found the following review helpful
Underwhelming 24 Dec. 2014
By Amazon Customer - Published on Amazon.com
Format: Kindle Edition Verified Purchase
I have been a Microsoft trainer for 15 years in the BI space. After checking out several books in this genre, I can say this book is underwhelming. Not for beginners. This is an adequate secondary source for reference at best. For the beginner the read through is bad. For example, The critical MDX language chapter has examples with expression tokens that are never explained. Critical concepts around attributes and hierarchies are not explained well. Again, I would use this a reference when needed and turn to other learning resources for true understanding.
Four Stars 23 Aug. 2014
By Innocent M. - Published on Amazon.com
Format: Paperback Verified Purchase
The book is designed for those who already have IT experience and already working as DBAs
2 of 4 people found the following review helpful
Big help. Thank you Authors. 26 Nov. 2012
By Amazon Customer - Published on Amazon.com
Format: Paperback
This will be my first time to use the said product. This book is very detail in the covering all the necessary entry points and pitfalls that you will encounter during the learning process. Please note that it is very hard to know this product, but the book was able to go over the main points. This in turn made the product learnable. If you are serious in using this tool, then this is the book for you. Also I like that you can download from Wrox the necessary materials that are needed for the chapters. This is a big help. Overall this book is priceless.
Were these reviews helpful? Let us know


Feedback