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

A large, complex data picture

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.

Complex Pricing Schedules

Pricing schedules could be complex with rebates, bundled products, incremental and tiered based prices.

Complex Systems

We needed to extract, normalise and merge data from 35+ global billing and charging systems to support the revenue disparity exercise.

Location Linking

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

Target prices were determined from the pricing workshop, these new target prices were applied to the historical transactions; having already confirmed the pricing structures we could calculate the new revenue based on the target prices

Harmonisation

Different checks, capping and harmonisation processes were implemented to modulate the uplift.

Outputs

Outputs were then generated by client for new and old pricing for review by the business.

Benefits

A highly successful piece of data analytics delivering enhanced divisional profitability

Related Data Solutions

In Client Analytics