<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=931099456970389&amp;ev=PageView&amp;noscript=1">

Posts by Alan Faulkner

SSAS Multidimensional or SSAS Tabular?

Posted Mar 22, 2017 by Alan Faulkner

Determining whether multidimensional or tabular is the optimal solution for your organization is a key step when working with SQL Server Analysis Services 2012/2014/2016. During last week’s free webinar, our Senior Consultant Alan Faulkner introduced the common pitfalls with each solution and how to avoid them. He also highlighted new features of SQL Server Analysis Services 2016 and how they play a role in deciding the best solution to use.

SSAS Tabular vs. SSAS Multidimensional - Business Logic

Posted May 29, 2015 by Alan Faulkner

Introduction

In Part I of the SSAS Tabular vs. SSAS Multidimensional – Which One Do I Choose? series, we began to set the stage for looking at 5 high level considerations to answer this question. In Part II, we explored the Scalability and Performance considerations between the two technologies. In  Part III, we explored the characteristics of the data and the model required to deliver the analytics and reporting required. In this installment, we will cover how to extend the capabilities and characteristics of your data model through the use of business logic.

SSAS Tabular vs. SSAS Multidimensional – Part III – Complex Business Problems

Posted May 12, 2015 by Alan Faulkner

Introduction

In Part I of the SSAS Tabular vs. SSAS Multidimensional series, we began to set the stage for looking at 5 high level considerations to help determine which you should choose to use. In Part II, we explored the Scalability and Performance considerations between the two technologies. In this post, we'll contemplate the Complex Business Problem aspects by comparing and contrasting SSAS Tabular and SSAS Multidimensional in terms of characteristics of the data, the model required to deliver the analytics and the reporting required.

SSAS Multidimensional vs Tabular - Part 2

Posted Apr 07, 2015 by Alan Faulkner

Introduction

In Part I of the SSAS Tabular vs. SSAS Multidimensional – Which One Do I Choose? series, we began to set the stage for looking at 5 high level considerations to answer this question. The considerations are:

  1. Scalability
  2. Performance
  3. Time to Develop
  4. Complex Business Problems
  5. Learning Curve

In this post, we will contemplate the Scalability and Performance aspects by comparing and contrasting SSAS Tabular and SSAS Multidimensional in these areas.

SSAS Multidimensional vs Tabular - Part 1

Posted Mar 27, 2015 by Alan Faulkner

Have you been or are you currently working on a project where you are trying to determine which flavor of Analysis Services (Tabular or Multidimensional) you should have used or should use? Recently, I was doing a presentation on SSAS Multidimensional best practices and following the presentation one of the attendees asked a very good question, “When it comes to SSAS Tabular versus SSAS Multidimensional how do I know which one to choose?” We discussed some of the various aspects of each one, but during the conversation I realized I needed to put a presentation and ultimately a blog post together on this topic.

Subscribe to Blog Updates