Operational process data visualisation
The FX trading division of a European Investment Bank was looking to enhance the efficiency of the operational processes supporting their business line
Clarifying complexity
CPRA had conducted a data analysis exercise to gain insights into operational efficiency opportunities.
Three months’ of data saw datasets with more than 90 million rows. We had to use non traditional tools to bring clarity and insight into such data.
The complexity of the underlying operational processes needed to be clearly communicated to stakeholders from operational team leads up to senior management levels.
Designing the optimal MIS solution
The client already had data dashboards but they had become unwieldy and needed to be throttled back so they could run.
CPRA’s combination of modern data analysis tools that then fed data visualisation software was a more efficient and manageable process.
The Dynamic Dashboard
The ability of modern dashboards to cut data across multiple dimensions simultaneously and hone into an area of interest helps to find the patterns across
Heat maps allowed us to see the user groups, desks and timestamps where more issues occurred and then follow the chain up to the initial data fault.
Our “Hirst” diagram allowed us to easily identify calendar errors.
Histograms cut across different time stamps and trade types identified pathological time intervals.
Reaping the benefits of MIS
The distribution of the dashboarding to all stakeholders allowed all parties from across the FX operations hierarchy to have a common view of performance across the process flow. This single source of truth allowed all stakeholders to track historic performance of operational process data in a highly granular manner. Senior stakeholders could also track the effectiveness of process improvement spend by monitoring the historical time series and looking for improvements in the parts of the process remediated.