Stairway to SSAS Tabular Level 6: Creating Meaningful Measures
In this sixth level of the SSAS Tabular stairway, learn how to create meaningful measures.
2025-01-01 (first published: 2019-05-01)
6,061 reads
Thomas LeBlanc
- Interests: #SQLFamily
Stairway to SSAS Tabular Level 5: Cleaning up Dimensions
In this fifth level of the SSAS Tabular stairway, learn how to clean up dimensions.
2024-12-25 (first published: 2019-01-28)
7,511 reads
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.
2024-12-04 (first published: 2018-09-12)
11,551 reads
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.
2024-11-06 (first published: 2018-07-30)
7,452 reads
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 […]
2022-10-24 (first published: 2019-07-10)
5,974 reads
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.
2022-06-22 (first published: 2020-03-11)
8,950 reads
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.
2021-10-06 (first published: 2018-07-11)
20,255 reads
2020-10-28 (first published: 2020-10-14)
6,523 reads
Stairway to SSAS Tabular Level 10: Multiple Dates in Fact Table
In this level of the stairway, learn about multiple dates in fact table
2020-06-10
5,681 reads
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.
2019-10-09
16,209 reads
Blogs
AI in SQL Server vs PostgreSQL: Vector Search, Embeddings, and RAG Compared
Both SQL Server and PostgreSQL are moving fast into AI territory — and if...
Monday Monitor Tips: AI Alert Analysis
By Steve Jones
We keep adding new AI capabilities to Redgate Monitor, where it makes sense. Check...
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
Forums
Install SQL Scripts via GUI Wizard
Hallo all! My problem is this: I have quite a bunch of TSQL scripts...
Would You Retire Rather Than ...
Comments posted to this topic are about the item Would You Retire Rather Than...
Vector Search in SQL Server 2025: Storing Embeddings, Querying Them, and What to Watch Out For
Comments posted to this topic are about the item Vector Search in SQL Server...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers