-
This is one of the few non-technical posts on this blog. Just skip it if you want to quickly come back to 100% BI-related topics. Last Saturday we run the SQL Saturday 454 in Turin. I was part of the… Read more
-
The 2015 is a special year for Italy, because the country hosts Expo 2015, which is the current Universal Exposition. For this reason, the Italian PASS chapter promotes a special edition of SQL Saturday, a free training event for SQL… Read more
-
DAX Patterns: Week-related calculations
Week-related calculations: Introduction
…or other patterns 454 or 544…. Watch now
-
Optimizing DAX Video Course
Optimizing common DAX constructs: Optimizing time intelligence calculations
…60.53 and then 17.454 of Storage Engine CPU… Watch now
-
In PowerPivot for Excel 2010 it is possible to import an Excel table in a PowerPivot data model by using the Linked Table feature. Excel 2013 expands this capability by Read more
-
When you install Analysis Services Denali, chances are that you create an instance for Tabular that is not the default instance for Analysis Services. When you try to create a Tabular project, you might get the following error: You cannot… Read more
-
In this article we perform a performance comparison between header/detail models and star schemas. Building a star schema might require a few ETL steps and some coding. Nonetheless, it is always the best modeling option. Read more
-
This article describes a reference Date table in DAX using a Power BI template. The same technique can be used in Analysis Services models. Download the latest version of the template in the Dax Date Template page. Read more
