Gartner Research

Is SQL Server Analysis Services the Tool for Your OLAP and Data Mining?

Published: 07 July 2011

ID: G00211526

Analyst(s): Nancy McQuillen

Summary

Microsoft SQL Server Analysis Services (SSAS) is a platform for enterprise online analytical processing (OLAP) based on multidimensional data cubes. It also offers guided data mining tools for non-statisticians. The OLAP cube technology is mature, widely adopted, and likely to remain popular in the SQL Server database management system (DBMS) user base. But organizations should expect some evolutionary pain as Microsoft turns its attention toward delivery of new in-memory tools and a new business intelligence semantic model (BISM) in the next release.

Table Of Contents

Summary of Findings

Analysis

  • SSAS Overview
    • SSAS Architecture
    • The Role of SSAS vs. PowerPivot
  • SSAS OLAP
    • OLAP Storage Modes
    • Enterprise Management Features
    • BI Maturity for SSAS OLAP
    • Cube Size, Performance, and Scalability
  • SSAS Data Mining
  • GUI Tools
  • Standards, Interfaces, and Openness
  • SSAS Integration With Microsoft Products
    • Excel
    • Reporting Services
    • SharePoint
    • Selecting SSAS Client Tools
  • Microsoft BI Road Map: Future Release Plans
    • Choosing Classic or New SSAS
  • Strengths
  • Weaknesses

The Details

  • OLAP Storage Modes
    • MOLAP vs. ROLAP Trade-Offs
    • SSAS Options Between MOLAP and ROLAP
  • UDM
  • SSAS Data Mining
  • SSAS Access Standards
  • Excel SSAS Integration
  • Reporting Services SSAS Integration
  • SharePoint SSAS Integration
  • Analysis Services Road Map: Future Release Plans
    • Business Intelligence Semantic Model
    • Improvements to UDM
    • VertiPaq Engine
    • Microsoft Guidance
  • SSAS Case Studies at Microsoft

Recommended Reading

Notes

©2019 Gartner, Inc. and/or its affiliates. All rights reserved. Gartner is a registered trademark of Gartner, Inc. and its affiliates. This publication may not be reproduced or distributed in any form without Gartner’s prior written permission. It consists of the opinions of Gartner’s research organization, which should not be construed as statements of fact. While the information contained in this publication has been obtained from sources believed to be reliable, Gartner disclaims all warranties as to the accuracy, completeness or adequacy of such information. Although Gartner research may address legal and financial issues, Gartner does not provide legal or investment advice and its research should not be construed or used as such. Your access and use of this publication are governed by Gartner’s Usage Policy. Gartner prides itself on its reputation for independence and objectivity. Its research is produced independently by its research organization without input or influence from any third party. For further information, see Guiding Principles on Independence and Objectivity.

Already have a Gartner Account?

Become a client

Learn how to access this content as a Gartner client.