Deliver to your Kindle or other device


Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.
SQL Server Analysis Services 2012 Cube Development Cookbook

SQL Server Analysis Services 2012 Cube Development Cookbook [Kindle Edition]

Baya Dewald , Steve Hughes , Paul Turley

Print List Price: £37.99
Kindle Price: £16.19 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £21.80 (57%)
* Unlike print books, digital books are subject to VAT.


Amazon Price New from Used from
Kindle Edition £16.19  
Paperback £37.99  
Kindle Summer Sale: Over 500 Books from £0.99
Have you seen the Kindle Summer Sale yet? Browse selected books from popular authors and debut novelists, including new releases and bestsellers. Learn more

Customers Who Viewed This Item Also Viewed

Product Description

Product Description

In Detail

Microsoft SQL Server is a relational database management system. As a database, it is a software product whose primary function is to store

and retrieve data as requested by other software applications. SQL Server Analysis Services adds OLAP and data mining capabilities for SQL Server databases. OLAP

(online analytical processing) is a technique for analyzing business data for effective business intelligence.

This practical guide teaches you how to build

business intelligence solutions using Microsoft’s core product – SQL Server Analysis Services. The book covers the traditional multi-dimensional model which has

been around for over a decade as well as the tabular model introduced with SQL Server 2012.

Starting with comparing MultiDimensional and tabular models –

discussing the values and limitations of each, you will then cover the essential techniques for building dimensions and cubes. Following on from this, you will be

introduced to more advanced topics, such as designing partitions and aggregations, implementing security, and synchronizing databases for solutions serving many


The book also covers administrative material, such as database backups, server configuration options, and monitoring and tuning performance. We also

provide a primer on MultiDimensional eXpressions (MDX) as well as Data Analysis expressions (DAX) languages.

This book provides you with data cube

development techniques, and also the ongoing monitoring and tuning for Analysis Services.


A practical cookbook packed with recipes to

help developers produce data cubes as quickly as possible by following step by step instructions, rather than explaining data mining concepts with


Who this book is for

If you are a BI or ETL developer using SQL Server Analysis services to build OLAP cubes, this book is ideal for you.

Prior knowledge of relational databases and experience with Excel as well as SQL development is required.

About the Author

Baya Dewald

Baya Dewald has been working with Microsoft SQL Server for over 15 years and with Analysis Services since its debut in 1999. Baya has architected, developed and administered databases with millions of users and cubes measured in Terabytes. Throughout his career Mr. Dewald has held various certifications including Microsoft Certified Solution Developer, Microsoft Certified Systems'; Engineer and Microsoft Certified Database Administrator. Mr. Dewald has managed DBA teams and published over 100 technical articles in SQL Server Magazine, SQL Professional, Tech Target and InformIT. He also contributed to several technical titles as a co-author and technical reviewer. Baya can be reached at

Steve Hughes

Steve Hughes is a Practice Lead at Magenic. In his current role, he develops strategy and helps guide data, business intelligence, collaboration, and data integration development using Microsoft technologies, including SQL Server, SharePoint, and BizTalk. He continues to deliver data and business intelligence solutions using these platforms. He has been working with technology for over 15 years with much of that time spent on creating business intelligence solutions. He is passionate about using data effectively and helping customers understand that data is valuable and profitable. He also has experience working with a large software company as a service vendor and there received awards for customer satisfaction and engineering excellence.

In 2010, he received the Consultant of the Year honor at Magenic. He has delivered multiple presentations on SQL server, data architecture, and business intelligence over the years. Steve can often be found at Professional Association for SQL Server (PASS) events where he serves as a regional mentor and is active with the Minnesota SQL Server User Group (MNPASS). He shares his insights from the field on his blog at

Paul Turley

Paul is a Mentor with SolidQ and a Microsoft SQL Server MVP. He consults, writes, speaks, teaches & blogs about business intelligence and reporting solutions. He works with companies around the world to visualize and deliver critical information to make informed business decisions. He is a Director of the Oregon SQL PASS chapter & user group, the lead author of Professional SQL Server 2012 Reporting Services and 11 other titles from Wrox & Microsoft Press. Paul's blog is

Product details

  • Format: Kindle Edition
  • File Size: 18342 KB
  • Print Length: 342 pages
  • Page Numbers Source ISBN: 1849689806
  • Publisher: Packt Publishing (26 Dec 2013)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B00HJR6R0Y
  • Text-to-Speech: Enabled
  • X-Ray:
  • Amazon Bestsellers Rank: #281,084 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?

More About the Authors

Discover books, learn about writers, and more.

Customer Reviews

There are no customer reviews yet on
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on (beta) 4.0 out of 5 stars  2 reviews
2 of 2 people found the following review helpful
4.0 out of 5 stars Deserves a broader audience 11 May 2014
By Dimitri Shvorob - Published on
The title, and the "Overview" section below it, misrepresent the book and limit its audience by portraying it as a collection of "recipes" for advanced SSAS users. In fact, the book is aimed at SSAS beginners, and is a typical software guide. Compared with the likely competitors, "Cookbook" has more depth and quality than the similarly-sized "Getting started with SQL Server 2012 cube development" by Simon Lidberg, and less material than the doorstop-sized "Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX" by Harinath et al. MDX and (especially) the tabular model are two areas where "Cookbook" badly sags - referring to the Russo-Ferrari-Webb BISM tome may be unavoidable - but elsewhere it does a good job.
0 of 1 people found the following review helpful
4.0 out of 5 stars A Definite book for Business Intelligence (BI) Professionals 11 Jun 2014
By Pethuru Raj - Published on
I got a golden opportunity to read through the book titled as “SQL Server Analysis Services 2012 Cube Development Cookbook”. This is well-written book for business intelligence (BI) application developers and system administrators. Especially those who are conversant with the Microsoft product “SQL Server Analysis Services” are to be benefited immensely through this easy-to-grasp book. This book gives step-by-step recipes for developing Analysis Services objects that can be composed to craft composite Analytics services that are more business-aware and attuned. Those passionate readers can quickly learn through a flurry of practical examples on deriving robust and resilient BI solutions for a variety of scenarios using the Analysis Services multidimensional model as well as the Tabular model. The book discusses methods beyond the initial cube design, exploring cube maintenance with partitions and designing effective aggregations, as well as options for synchronizing analytics solutions.
This book is stuffed with a number of practical techniques and tips and hence is a definite companion for developers, consultants and administrators to go deeper into the fast-enlarging BI space.
Were these reviews helpful?   Let us know

Customer Discussions

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

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

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category