Camel Case Column Renaming – The new Way in #PowerBI #PowerQuery

A new splitter function has been discovered in Power Query (by Chris Webb and also others probably) which is not in the highlight notes of the February 2019 PBI release, but it is a very nice addition - Splitting Text By Character Transition. So, I had an adequate use case some time ago when I didn't … Continue reading Camel Case Column Renaming – The new Way in #PowerBI #PowerQuery

Customer Retention / Churn Analysis

Sometimes in Customer Analysis we need to calculate the projected customer number. And the projected customer churn. In the demo dataset we have the given number of new customers and the retention factor for every year that customers stay with the company (by buying items, renewing subscriptions, etc.). The retention factor is the percent of … Continue reading Customer Retention / Churn Analysis