Using elements of the Microsoft Business Intelligence (BI) Stack such as Power View and Power Pivot, the investment operations team created the Trading Metrics Dashboard. The dashboard seamlessly summarises several data feeds from disparate trading platforms into a single, easily digestible showcase for reporting the team’s KPIs to senior leadership.
Data table page:
Provides consolidated performance metrics in data table form by instrument and can be filtered by year or month.
Graphical interface showing the number of trades in each month, trade type, portfolio, currency, how many were confirmed late and with which counterparty.
Same as above but for FX. This is broken out separately for better visualisation of specific FX related trade activity.
Shows an aggregate time series of late trades and total trade volume to highlight trends.
Best practice and innovation
The most innovative aspect of this solution is that it involved no IT budget and was created by a single, non-developer analyst. By utilising the Microsoft BI Stack, other business users should be able to create their own custom solutions to problems that in the past would have needed substantial IT resources.
“Outside of this tool we also benchmark our different systems with other corporates. For instance, before implementing Misys, we benchmarked with several other corporates to determine if the platform would meet our needs. During the recent regulatory upheaval with EMIR and Dodd-Frank we heavily benchmarked with similar corporates to ensure best practice was being implemented everywhere possible,” explains Johnson.
“Our primary KPIs for this tool are late trades and trades confirmed via straight through processing (STP) in a system such as FXall or Misys. Both are measured relative to the total number of trades in a given month.
Over time we’ve picked up on several trends that have allowed us to make changes that have improved these KPIs,” adds Jayna Bundy, Group Treasury Manager, Treasury Capital Management.
“Since implementing the Trading Metrics Dashboard earlier this year we have completely done away with slide decks in our quarterly meetings with the treasurer. With this interface we can dive deep into the data for ad-hoc analysis in the meeting as needed. In fact, our meetings have become more about ad-hoc analysis than anything else. We’ll come prepared with a few talking points but the meeting will almost always deviate from the script.
As a result, these are now much more productive and engaging. Furthermore, the feedback from our audience has been remarkable to the point that we are now transitioning as many reports into this new format as possible,” concludes Bundy.