Stairway to SSAS Tabular

SSAS (SQL Server Analysis Services) is available in two modes, tabular and multidimensional. The new tabular model is easier for those companies who are not already invested in the traditional, multidimensional model. In this stairway, Thomas LeBlanc will teach you how to create tabular models used for reports and dashboards.

• Stairway to SSAS Tabular Level 1: Why use Analysis Services

  In this first level of the SSAS Tabular stairway, learn the benefits of implementing an SSAS solution.

• Stairway to SSAS Tabular Level 2: Installing the Components

  In this level of the Stairway to SSAS Tabular you will learn how to install the platform and tools.

• Stairway to SSAS Tabular Level 3: Creating a Tabular Project

  This article shows you how to create an Analysis Services Tabular Model project, import data from World Wide Importers database, create a measure and analyze in Excel.

• Stairway to SSAS Tabular Level 4: Implementing Date Dimensions

  In this first level of the SSAS Tabular stairway, learn how to implement and format a date dimension.

• Stairway to SSAS Tabular Level 5: Cleaning up Dimensions

  In this fifth level of the SSAS Tabular stairway, learn how to clean up dimensions.

• Stairway to SSAS Tabular Level 6: Creating Meaningful Measures

  In this sixth level of the SSAS Tabular stairway, learn how to create meaningful measures.

• Stairway to SSAS Tabular Level 7: Time Intelligence

  Time Intelligence is a common methodology in Dimensional Modeling that allows for calculations of measures based on relative dates. These include “To-Date” measures like Year to Date or Quarter to Date as well as Previous Period comparisons. Once these are created within a model, other DAX functions can be used for metrics like Year over […]

• Stairway to SSAS Tabular Level 8: Multiple Fact Tables and Perspectives

  In this eighth step of the SSAS Tabular Stairway start to expand the model beyond one fact table.

• Stairway to SSAS Tabular Level 9: Security and Roles

  In the ninth level of this stairway, learn how to add security to the tabular model.

• Stairway to SSAS Tabular Level 10: Multiple Dates in Fact Table

  In this level of the stairway, learn about multiple dates in fact table

• Stairway to SSAS Tabular Level 11: Partitioning

  In this next level, we cover partitioning for SSAS.