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

Category: Ssas

12 Results

Introduction to SSAS Tabular Course Updates

Posted Feb 03, 2017 by Pragmatic Works

Do you want to learn more about creating Analysis Services Tabular models? Our course, Introduction to SSAS Tabular, will teach you all you need to know!

Three SSAS Dimension Design Best Practices

Posted Aug 07, 2015 by Dustin Ryan

Are you having issues with the performance and usability of your solution’s dimensions? In this blog, Pragmatic Works' Senior Business Intelligence Consultant Dustin Ryan covers three best practices that for improving performance of SSAS dimensions as well as common mistakes in dimension design. Additionally, he's discussing some common mistakes he sees users making with dimension design.

Performance Tuning SSAS Best Practices

Posted Jul 24, 2015 by Dustin Ryan

Looking to improve the performance of your SSAS solution? Dustin Ryan has you covered. In this post, he will discuss three best practices that you can follow to improve performance and management. Following these best practices will make a huge difference when dealing with large SSAS solutions.

Exploring Excel 2013 for BI: Show Explore

Posted Jul 16, 2015 by Steve Hughes

Welcome back to our informative series on Excel by Steve Hughes! In his first post, he conquered the Quick Explore feature. In this post, Steve will delve into the Show Explore feature. Join Steve as he shows you how you can drill into details using the Show Explore feature once you've connected your SSAS cube to Excel.

Exploring Excel 2013 for BI: Quick Explore

Posted Jul 02, 2015 by Steve Hughes

Excel is a powerful tool that is used by almost everyone is the business world. Because of its numerous capabilities, Excel has many functions that can often be confusing to users. In this new blog series Our resident expert, Steve Hughes, will cover a wide variety of Excel topics ranging from easy to complex. Steve will provide you tips and tricks he has discovered in his journey through Excel.

Quick Explore

So, you have connected Excel to your SSAS cube. You really wish you could cross drill easily in the product. If you have used PerformancePoint Services you know the process. Right click on the bar or cell and then choose the dimension to drill to using the information you clicked on as a starting point. You can now do this in Excel 2013 using Quick Explore. Here’s how to do it:

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.

Learn SSAS From the Ground-Up in Our Austin Workshop

Posted Feb 18, 2015 by Liz Hamilton

Starting February 24th, Chris Albrektson & Devin Knight will be teaching an intro to SQL Server Analysis Services (SSAS) workshop. This two full day event it will be packed with both Multi-Dimensional and Tabular/PowerPivot demos and exercises.

It will be an in person workshop at the Microsoft office in Austin, Texas. The workshop is on February 24th & 25th and is available for only $399.


Blog Comments

Need help with this topic? Ask the author below.

 

Subscribe to Blog Updates