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,330 reads
In the ninth level of this stairway, learn how to add security to the tabular model.
2022-06-22 (first published: 2020-03-11)
7,709 reads
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,235 reads
2020-10-28 (first published: 2020-10-14)
4,980 reads
In this level of the stairway, learn about multiple dates in fact table
2020-06-10
4,789 reads
In this eighth step of the SSAS Tabular Stairway start to expand the model beyond one fact table.
2019-10-09
14,050 reads
The recent blog post on PASS.org announces that Microsoft has renewed its sponsorship of SQLSaturday events. They are even, at the own discretion, sponsor individual events with more money...
2019-08-03
19 reads
In this sixth level of the SSAS Tabular stairway, learn how to create meaningful measures.
2019-05-01
4,301 reads
The fifth article in the SQL Server Analysis Services Tabular Model has been released on SQLServerCentral.com. Please start at the...
2019-02-03
164 reads
The fifth article in the SQL Server Analysis Services Tabular Model has been released on SQLServerCentral.com. Please start at the beginning article before reading this one in order to...
2019-02-03
26 reads
By DataOnWheels
Hey folks, fun personal post today. A few weeks ago, I got married! My...
In June this year I took redundancy from the company I’d worked at for...
By Steve Jones
I posted that I was thinking about the AdventOfCode this year, but wasn’t sure...
Comments posted to this topic are about the item Backing Up Master
Comments posted to this topic are about the item Window Function Basics - PARTITION...
Comments posted to this topic are about the item Focus on Growth in Your...
Ask SSC