The client was operating a SaaS (Software-as-a-Service) business model and measured customer development based on change in expected revenue per customer.
Development of expected customer revenue was reported on a monthly basis and showed expectations on a 12-month time frame for approximately 40k modules among c. 5k customers. Subsequently, quite a substantial transformation had to be undertaken in order to identify change on customer level such as churn, increase in expected revenue, new customers etc.
We applied advanced data blending and transformation techniques in R, where customer data on module level was used as input combined with a mapping of modules at customer level. The output was a dataset indicating any change in expected revenues generated from a customer, making further analysis considerably more efficient.