Intermediate · 30 min · 4 steps
Turning a long payment list into a day-by-day table of channels
Pooja Hegde, Payments Analytics Lead at CRED Pay
It is Wednesday, 9:00 AM. Pooja Hegde is the payments analytics lead at CRED Pay, which handles over Rs 1,400 crore a month in shop payments, credit card bill payments and person-to-person transfers for well-off Indian customers. She arrives at the treasury meeting in Bengaluru. Each way of paying (UPI, card, netbanking, wallet) has different fees and different settlement times.
The question
How do we turn a long list of payments into a table with one row for each day and one column for each payment channel, and work out each channel's share?
- Conditional aggregation
- CASE WHEN
- Pivoting
- Cross-tabulation
The rest of this case study is locked
The data, every step with its code and result, and the final answer open with a pass. A few case studies stay free so you can see how they work.