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)
5,881 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,318 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,178 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,168 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,726 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,483 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)
19,958 reads
2020-10-28 (first published: 2020-10-14)
6,017 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,447 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
15,475 reads
Blogs
How to Learn SQL Without Quitting Your Day Job
Juggling meetings, deadlines, and family? Yeah, learning SQL might seem like climbing Mount Everest...
SQL Server 2025
By Vinay Thakur
Microsoft announced on November 2024 a preview for SQL Server 2025 another major release...
Advice I Like: Apologies
By Steve Jones
How to apologize: quickly, specifically, sincerely. Don’t ruin an apology with an excuse –...
Forums
SQL Clustered Resource in online pending for about 3-5 mins before coming online
Hello! SQL Clustered resource used to come online during manual or automatic failover in...
SQL Query to use in MS SSRS server to give you your report structure.
Code that can be used in order to create dashboard or SSRS report on...
Temp table security
So, I have an interesting situation that I need a double-check on. One of...
Question of the Day
Escaping Like I
I have this data in a SQL Server 2022 table:
PlayerIDPlayerNamePlayerStatus 1The \%ChampActive 2The ChampActive 3The_ChampionActive 4The__ChampionActive 5The\_ChampActiveHow many rows are returned by this code in SQL Server 2022?
select PlayerName from player where playername like 'The\_C%' escape '\'See possible answers