Expert Cube Development with Microsoft SQL Server 2008 An... and over 1.5 million other books are available for Amazon Kindle . Learn more


or
Sign in to turn on 1-Click ordering.
Trade in Yours
For a £7.85 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Colour:
Image not available

 
Start reading Expert Cube Development with Microsoft SQL Server 2008 An... on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Expert Cube Development with Microsoft SQL Server 2008 Analysis Services [Paperback]

Chris Webb
4.8 out of 5 stars  See all reviews (6 customer reviews)
RRP: £30.99
Price: £29.44 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
You Save: £1.55 (5%)
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. Gift-wrap available.
Want it Thursday, 20 June? Choose Express delivery at checkout. Details

Formats

Amazon Price New from Used from
Kindle Edition £14.51  
Paperback £29.44  
Trade In this Item for up to £7.85
Trade in Expert Cube Development with Microsoft SQL Server 2008 Analysis Services for an Amazon.co.uk gift card of up to £7.85, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Special Offer until June 30, 2013: Receive an additional £5 promotional Gift Card, when you trade-in at least £10 worth of books. Learn more

Book Description

10 July 2009 1847197221 978-1847197221
Microsoft's SQL Server Analysis Services 2008 is an OLAP server that allows users to analyze business data quickly and easily. However, designing cubes in Analysis Services can be a complex task: it's all too easy to make mistakes early on in development that lead to serious problems when the cube is in production. Learning the best practices for cube design before you start your project will help you avoid these problems and ensure that your project is a success.

This book offers practical advice on how to go about designing and building fast, scalable, and maintainable cubes that will meet your users' requirements and help make your Business Intelligence project a success.

This book gives readers insight into the best practices for designing and building Microsoft Analysis Services 2008 cubes. It also provides details about server architecture, performance tuning, security, and administration of an Analysis Services solution.

In this book, you will learn how to design and implement Analysis Services cubes. Starting from designing a data mart for Analysis Services, through the creation of dimensions and measure groups, to putting the cube into production, we'll explore the whole of the development lifecycle.

This book is an invaluable guide for anyone who is planning to use Microsoft Analysis Services 2008 in a Business Intelligence project.

Frequently Bought Together

Expert Cube Development with Microsoft SQL Server 2008 Analysis Services + Microsoft SQL Server 2008 Analysis Services Step by Step, Book/CD Package
Price For Both: £54.71

Buy the selected items together


Product details


More About the Authors

Discover books, learn about writers, and more.

Product Description

About the Author

Marco Russo is a consultant and trainer in software development based in Italy, focusing on development for Microsoft Windows operating systems. He's involved in several Business Intelligence projects, including those of relational and multidimensional warehouse design, with particular experience in sectors like banking and financial services, manufacturing and commercial distribution. He previously wrote several books about .NET and recently co-authored "Introducing Microsoft LINQ" and "Programming Microsoft LINQ", both published by Microsoft Press. He also wrote "The many-to-many revolution", a mini-book about many-to-many dimension relationships in Analysis Services, and co-authored the "SQLBI Methodology" with Alberto Ferrari. Marco is a founder of SQLBI (http://www.sqlbi.com) and his blog is available at http://sqlblog.com/blogs/marco_russo

Alberto Ferrari is a consultant and trainer for the BI development area with the Microsoft suite for Business Intelligence. His main interests are in the methodological approaches to BI development and he works as a trainer for software houses that need to design complex BI solutions. He is a founder, with Marco Russo, of the site www.sqlbi.com, where they publish whitepapers and articles about SQL Server technology. He co-authored the "SqlBI Methodology", which can be found on the SqlBI site.

Chris Webb has been working with Microsoft Business Intelligence tools for almost ten years in a variety of roles and industries. He is an independent consultant and trainer based in the UK, specializing in Microsoft SQL Server Analysis Services and the MDX query language. He is the co-author of "MDX Solutions for Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase", is a regular speaker at conferences, and blogs on BI at http://cwebbbi.spaces.live.com. He is a recipient of Microsoft's Most Valuable Professional award for his work in the SQL Server community.


Customer Reviews

3 star
0
2 star
0
1 star
0
4.8 out of 5 stars
4.8 out of 5 stars
Most Helpful Customer Reviews
2 of 2 people found the following review helpful
5.0 out of 5 stars No. 2 SSAS Book 12 Aug 2010
Format:Paperback
I - almost - completely agree with the comprehensive review by Rainardi. This is a top SSAS book, and the two other top three books are those by Teo Lachev (SSAS 2005) and by Irina, Edward & Alexander (SSAS 2008). To be a little more precise, however, this should only by your "No. 2 SSAS Book". You need one of the others first, depending on which SSAS version you are using. That'll give you a comprehensive overview, and then this book has the potential to make you a full-blown professional. It should not be your first book, though, since the level required is (in many parts) quite sophisticated, and since coverage is incomplete and "biased" by experience of what has the most practical importance.
Comment | 
Was this review helpful to you?
6 of 7 people found the following review helpful
5.0 out of 5 stars Best SSAS book 23 Nov 2009
By Vincent
Format:Paperback
This SSAS 2008 book is superb. For me it is, by far, the most useful book on SSAS (the second being Irina, Edward & Alexander's SSAS 2008, and the third is Teo Lachev's). I learned a lot from this book. The book is invaluable to me because in the last 2 years I have been doing a lot of cube development and in doing so I have discovered and developed some techniques or methods. And that was exactly what they wrote: their experience in developing cubes, plus their opinions and tips. Chris Webb in SSAS world is an authoritative figure and I consider his SSAS skills to be one of the highest in the world, along the lines of Mosha Pasumansky, Deepak Puri, Edward Melomed and Darren Gosbell. Marco Russo is famous in SSAS world because of his Many-to-Many Revolution, one of the very first things I learned when I started doing cube development. Alberto Ferrari is SSAS expert (I learned from him that materialized ref dim can produce incorrect results, something that I experienced myself) and he's a speaker at Euro PASS 2009. So reading this book is like getting the experiences of 3 SSAS experts. A book which content is derived from books online, i.e. the 'how to do stuff', is not too useful for me, as I can read it in the BOL myself. But a book that contains 3 experts' experience and thoughts, that's invaluable. And that is what this book is. Being a writer myself (I wrote data warehousing book on SQL Server 2 years ago), I can understand why not many experts want to spend their precious time to sit down and write their experiences in a book. Because writing a technical book is tiring and the money is not great. So when an expert does it, grab that book and learn. And this time it's not only one but three!
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
5.0 out of 5 stars absolutely superb 15 Jan 2011
Format:Paperback|Amazon Verified Purchase
This book is not for absolute beginners but I am amazed page after page to read answers about questions I asked myself without always finding the answer.

This is both deep and practical.
I like the fact that it does not assume SSAS is the best answer to all problems.
For instance, it does mention that SSAS is not that great for chart of accounts compared to some other products, or that you would be better off not relying exclusively on SSAS to solve your currency rates problems.

In my current project, for instance, our developers have problems handling Year To Date calculations (please don't laugh) and the answer to similar date related calculations is so clearly explained in this book.

I thoroughly enjoyed this reading and plan to go back to it regularly for priceless "how to" advice.

You may want to check this article as this is how I learned about this book and it might convince you whether or not it is for you
(.....)
Comment | 
Was this review helpful to you?
Format:Paperback|Amazon Verified Purchase
Warning. This book is not for beginners but for us, OLAP cube developer that have already several OLAP cubes (SSAS) projects in production environment and are now dealing with advance topics such as scalability, fast design, implementation and maintenance. I had the privilege of having Chris Webb (author) as my Microsoft Instructor here in Dublin, Ireland. I am very impress with his expertise using MDX query language. Chapter 3, Designing More Complex Dimensions, Chapter 9: Securing the Cube and Chapter 10 on Productionization are definitely my favorites. There is a good collection resources and tools for monitoring Cube Performance and Usage. A must read for serious Cube Developers, especially those facing scalability and complexity challenges.
Comment | 
Was this review helpful to you?
5.0 out of 5 stars Excellent book once you've mastered the basics 15 Nov 2011
Format:Paperback
Having worked with the MS BI stack for several years I was well aware of Chris Webb work.

This book is an excellent pragmatic guide to takling & solving the kind of real world challenges in SSAS projects that the main stream MS books either gloss over or side-step entirely.

Want to know how to impliment currency coversion? Covered.

Want to see a couple of different approaches to dynamic run-time security? Covered (this was a particular life-saver).

Being a non-MS Press book the content is truthful and honest.

The only critism I have is that the index is abysmal but the chapters are well laid out & organised so you can find what you want with out too much hunting.

In summary this is the book to buy after you've bought the MS Press ones and are scratching your head with real-world challenges.
Comment | 
Was this review helpful to you?
Format:Paperback
This is one of the good books on the subject. It caters for every level(i.e. beginners, experts etc) of readers something to take. Some of the confusing aspects of SSAS has been explained neatly. I liked it as it served the purpose for me.
Comment | 
Was this review helpful to you?
Would you like to see more reviews about this item?
Were these reviews helpful?   Let us know
Search Customer Reviews
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
 

Search Customer Discussions
Search all Amazon discussions
   


Listmania!


Look for similar items by category


Feedback


Amazon.co.uk Privacy Statement Amazon.co.uk Delivery Information Amazon.co.uk Returns & Exchanges