SQL Server Analysis Services 2012 Cube Development Cookbook

If you prefer the instructional approach to a lot of theory, this cookbook is for you. It takes you straight into building data cubes through hands-on recipes, helping you get to grips with SQL Server Analysis Services fast.

Key Features

• Develop Business Intelligence solutions using a multi-dimensional model as well as a tabular model
• Explore cube maintenance with partitions and design effective aggregations, as well as analyzing options for scaling analytics solutions
• Includes recipes for administering, securing, monitoring, and troubleshooting Analysis Services solutions

Book Description

What you will learn

• Design commonly encountered dimensions
• Extend your cubes to include advanced features such as actions, translations, and key performance indicators
• Maintain cubes by adding/removing data using partitions
• Administer Analysis Services instance
• Scale out your solution by synchronizing cube data
• Build tabular model solutions

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.