Data Chef ETL Battles. Customer Transactions: Money vs. Loyalty.

In this workflow we convert raw customer transactions, i.e. contract registrations, into money measures on the one hand and loyalty features on the other. The idea is to move from a list of transactions to one or a few numbers describing an aspect of the customer activity. Here we have chosen money and loyalty. Money as total amount of money paid by customer or as amount paid per year. Loyalty as # of days under contract or as loyalty ratio (= # effective days / total number of days till now).

External resources

• Data Chef ETL Battles. What can be prepared with today’s data?