Quartlery year over year comparison when one QRT isn’t fully done yet

Month on Month, Quarter on Quarter or Year on Year comparisons are an absolute standard in many analysis and/or dashboards. Recently the question came up how to do a quarter on quarter analysis on a yearly basis (that is, compare Q1 to Q1) when the current quarter is not yet finished. Understandably, the user wanted … Continue reading Quartlery year over year comparison when one QRT isn’t fully done yet

A quickie on renaming and aliases

In many cases your data source will provide you with rather technical column names, be it dimension or measures. Or, you are usually fine with the naming but for a specific table or chart you just need that slightly changed name label to make it even clearer for your audience. Now what usually you would … Continue reading A quickie on renaming and aliases