My today's posting is not only technical but a reminder to always think about what you provide when being tasked with something. Do not only technically solve something, make sure that it is logically viable. Imagine your superior comes to you and tasks you with the following. "We need to do a cohort retention analysis... Continue Reading →
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 →
