Price Disparity Analytics
Driving
Revenue
Uplift
We addressed a data set of over 100 million rows: leading to a €50mm annualised revenue uplift
The transaction banking arm of a global Universal Bank, was looking to drive revenue growth by assessing pricing disparity across their cash management client base.
Industry: Investment Banking
Challenges
The cash management business had a large global footprint but no single data model to control the numerous products and pricing points, resulting in a highly fragmented billing and charging landscape.
Pricing schedules could be complex with rebates, bundled products, incremental and tiered based prices.
We needed to extract, normalise and merge data from 35+ global billing and charging systems to support the revenue disparity exercise.
In addition, we constructed a robust methodology to link together clients across different locations to ensure a robust client hierarchy was used in the disparity analysis.
Data Solution
Price Disparity Analysis Methodology
Using the normalised transactional records from each of the global billing and charging systems, we re-priced 100m+ transactions to validate the pricing methodologies applied and to identify revenue leakage; this data was then enriched with client and product hierarchies.
Products were identified for analysis and were initially put into volume buckets where appropriate.
Volume Buckets
Products were identified for analysis and were initially put into volume buckets where appropriate.
For each volume bucket a 50th and 75th percentile price was calculated and fed back to the business in a pricing workshop.
Target Prices
Harmonisation
Outputs
A highly successful piece of data analytics delivering enhanced divisional profitability
The development of a robust set of capping logic at both the overall client and client-product level resulted in an extremely low level of client attrition.
The programme was highly successful generating an uplift of €50m of additional revenue on an annualised basis.
The use of minimum revenue limits allowed the cash management business to further improve profitability.