Design analysis services with multidimensional models with Packt's riveting new book and eBook!

February 2014 | Enterprise

Packt is proud to present its latest publication, Expert Cube Development with SSAS Multidimensional Models, by Chris Webb, Alberto Ferrari, and Marco Russo. This book is an easy-to-follow guide full of hands-on examples of real-world Analysis Services cube development tasks. The print book is 402 pages long and is priced at $49.99 while the eBook at $23.99.

About the authors:

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, and is a regular speaker at conferences. He was a recipient of Microsoft’s Most Valuable Professional award for his work in the SQL Server community.

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, where they publish whitepapers and articles about SQL Server technology. He co-authored the “SqlBI Methodology”, which can be found on the SqlBI site.

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 SQLBI Methodology with Alberto Ferrari. Marco is also a founder of SQLBI.

Microsoft's SQL Server Analysis Services 2012 Multidimensional is an OLAP server that allows end users to analyze large amounts of business data quickly and easily, using a variety of tools including Excel, and to create their own reports without IT involvement. It is part of the Microsoft SQL Server suite of tools and has been used widely on Business Intelligence projects for the last 15 years; it is now the most commonly used OLAP server in the world.

Expert Cube Development with SSAS Multidimensional Models will teach the readers tips and tricks for cube design from some of the most experienced Analysis Services experts in the world. Topics covered include designing dimensions and cubes, implementing common MDX calculations, security, and performance tuning.

The book goes through the whole life cycle of Analysis Services cube development, from how data warehouse design affects cubes, through cube and dimension design, to performance tuning and monitoring. Some previous experience of Analysis Services is assumed; the focus is on best practices and design patterns. The book starts off with a discussion of data warehouse design and how it relates to Analysis Services. Following on from that, best practices relating to Analysis Services cube and dimension design are covered, including topics such as optimizing dimension attribute relationships and handling fact tables that contain data at different granularities.

Next, the book looks at using MDX to implement common business calculations, and then moves on to more advanced problems like currency conversion calculations and creating a date tool dimensions. Finally, security, performance tuning, automation of administrative tasks, and monitoring usage and performance each get their own chapter and subjects such as dynamic security roles, using Profiler to diagnose query performance problems, and automating partition creation are also dealt with.

The following are the chapters in the book:

Chapter 1: Designing the Data Warehouse for Analysis Services

Chapter 2: Building Basic Dimensions and Cubes

Chapter 3: Designing More Complex Dimensions

Chapter 4: Measures and Measure Groups

Chapter 5: Handling Transactional-level Data

Chapter 6: Adding Calculations to the Cube

Chapter 7: Adding Currency Conversion

Chapter 8: Query Performance Tuning

Chapter 9: Securing the Cube

Chapter 10: Going in Production

Chapter 11: Monitoring Cube Performance and Usage

Expert Cube Development with SSAS Multidimensional Models
Design SQL Server Analysis Services cubes, dimensions, and calculations from the experts!

For more information, please visit:

Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software