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)
6,999 reads
In this fifth level of the SSAS Tabular stairway, learn how to clean up dimensions.
2024-10-24 (first published: 2019-01-28)
5,044 reads
In this sixth level of the SSAS Tabular stairway, learn how to create meaningful measures.
2024-10-24 (first published: 2019-05-01)
4,539 reads
In this first level of the SSAS Tabular stairway, learn how to implement and format a date dimension.
2024-10-09 (first published: 2018-09-12)
10,535 reads
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,662 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)
8,406 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,796 reads
2020-10-28 (first published: 2020-10-14)
5,895 reads
In this level of the stairway, learn about multiple dates in fact table
2020-06-10
5,364 reads
In this eighth step of the SSAS Tabular Stairway start to expand the model beyond one fact table.
2019-10-09
15,313 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers