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.

SQL Server Analysis Services 2012 Cube Development Cookbook

Baya Dewald, Paul Turley, Steve Hughes

3 customer reviews
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.
Packt Subscription
FREE
$9.99/m after trial
eBook
$25.20
RRP $35.99
Save 29%
Print + eBook
$59.99
RRP $59.99
What do I get with a Packt subscription?
  • Exclusive monthly discount - no contract
  • Unlimited access to entire Packt library of 6500+ eBooks and Videos
  • 120 new titles added every month, on new and emerging tech
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
$0.00
$25.20
$59.99
$0 p/m after trial
RRP $35.99
RRP $59.99
Subscription
eBook
Print + eBook
Start 10 Day Trial

Frequently bought together


SQL Server Analysis Services 2012 Cube Development Cookbook Book Cover
SQL Server Analysis Services 2012 Cube Development Cookbook
$ 35.99
$ 25.20
Expert Cube Development with SSAS Multidimensional Models Book Cover
Expert Cube Development with SSAS Multidimensional Models
$ 29.99
$ 21.00
Buy 2 for $35.00
Save $30.98
Add to Cart

Book Details

ISBN 139781849689809
Paperback340 pages

Book Description

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 users.

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.

Table of Contents

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

Authors

Table of Contents

Book Details

ISBN 139781849689809
Paperback340 pages
Read More
From 3 reviews

Read More Reviews

Recommended for You

Expert Cube Development with SSAS Multidimensional Models Book Cover
Expert Cube Development with SSAS Multidimensional Models
$ 29.99
$ 21.00
Learning SQL Server Reporting Services 2012 Book Cover
Learning SQL Server Reporting Services 2012
$ 32.99
$ 23.10
PowerPivot for Advanced Reporting and Dashboards Book Cover
PowerPivot for Advanced Reporting and Dashboards
$ 23.99
$ 16.80
AJAX and PHP: Building Responsive Web Applications Book Cover
AJAX and PHP: Building Responsive Web Applications
$ 20.99
$ 14.70
Responsive Web Design by Example : Beginner's Guide Book Cover
Responsive Web Design by Example : Beginner's Guide
$ 26.99
$ 18.90
Building Websites with VB.NET and DotNetNuke 3.0 Book Cover
Building Websites with VB.NET and DotNetNuke 3.0
$ 23.99
$ 16.80