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

Snapshot tables in Power BI

Creating snapshot table in BI is always a non-trivial task. In SQL Server 2012 and on creating snapshot tables is little more straightforward. Using the so-called window functions, the code is less verbose thus for the developer to write and more importantly, the operation is more efficient thus faster. Creating snapshot tables in SQL Server … Continue reading Snapshot tables in Power BI