Architecture – Joyful Craftsmen – The Business Intelligence Agency

Azure Analysis Services – Processing Hot & Cold Data using Tabular model partitions

March 30, 2020

Architecture, Azure, SQL Server Central, SSAS, Tabular

Introduction Recently have been working on a “Proof of Concept” task where I wanted to test the capabilities of Azure Analysis Services Tabular model when loading data from different sources…

SSAS Tabular – Smart ProcessAdd

August 24, 2016

Roman Lánský

Architecture, SQL Server Central, SSAS, Tabular

Add Data to SSAS Tabular Hourly In order to add some data into SSAS Tabular model, you can basically follow two options to achieve this: Use Partitions Use Process ADD…

SSAS Tabular – Where to Put Your Calculated Columns

August 15, 2016

Roman Lánský

Architecture, Data Warehouse, Performance, SQL Server Central, SSAS, SSIS, Tabular

No Comments

There is a Problem During the implementation of SSAS Tabular model, you usually hit some point you think about, managing some calculation as calculated column. If possible, you should preferably…

MS SQL DW Clustered Column Store – Do it with surrogate keys?

June 20, 2016

Roman Lánský

Architecture, Data Warehouse, Database, SQL Server Central

No Comments

Introduction During the implementation of my last project, I came across a POC (Proof Of Concept) situation when we transferred data from source system to MS SQL Stage DB and…

Azure Analysis Services – Processing Hot & Cold Data using Tabular model partitions

SSAS Tabular – Smart ProcessAdd

SSAS Tabular – Where to Put Your Calculated Columns

MS SQL DW Clustered Column Store – Do it with surrogate keys?

About the Company

Partnership

Contacts