Collections Connect Rate in DAX

Collections Connect Rate (CCR) is one of the first Key Performance Indicators that needs to be implemented within the Collections departments. It measures the number of outbound calls that succeeded in connecting to a valid phone number over the total number of outbound calls.Naturally, a healthy Collections process requires…

Decision Trees : Part 2

To understand in a better way what the two formulas described in the previous post mean really let's build a practical use case: building simple rules to determine whether an account will be recovered.…

Aging Accounts Receivable in DAX

When your collection teams are working old accounts receivable and catching with current billing, things can quickly get overwhelming. Sure the accounts balance is an important priority criterion but you also need also track other features and prioritise your efforts based on that.…

Analytics for Accounts Receivable

Account Receivable Collection is probably one of the most data-intensive fields. Collection Agents handle data along the way of managing their Debt portfolio.…

Dynamic, Customised Pricing using AI

Pricing is one of the most important exercises in Marketing, it’s the final validation of the value of products to the customers.We might succeed brilliantly in the acquisition process of customers,…

Thoughts about GDPR

The General Data Protection Regulation (GDPR) (Regulation (EU) 2016/679) stands for the regulation by which the European Parliament, the Council of the European Union and…

Decision Trees : Part 1

Who said we cannot build Decision Trees in Excel? probably you didn't, but I bet you thought it was. This post will be the first in a series…