Capital Optimisation: Enterprise Level Dashboarding

Solution

• Fully automated dashboarding solution with key functionality allowing for holistic oversight of key balance sheet, risk and capital data

Banking area

• Capital

• Risk 

• Enterprise Management (Steerco/Exco)

Skill sets 

• Microsoft Power BI 

• Microsoft SQL 

• Database design

Insights

• It is pivotal that the proof of concept is designed with consultation with relevant business areas and consideration for the data architecture and standards of the bank. This will minimise redesign when the solution is implemented.

Overview

As part of the wider Capital Optimisation programme, the implementation of a dashboard solution allowed for enterprise level management teams to have access to and oversight of key financial and risk metrics at group and business unit levels. To implement the solution, Monocle worked together with the client to design an efficient data flow and data staging layer for optimal dashboard reporting. This allowed for the seamless automated flow of data from a 'golden source' to the dashboard which was completed, designed and build by Monocle in a Power BI environment. In delivering this automated solution, manual and legacy reporting become obsolete, saving valuable man hours and reducing the operational risks around manual intervention and reporting. With key balance sheet metrics such as loans and deposits, as well as key risk data including Net RWAs and its constituents, in both an actual and forecasted view – users are easily able to monitor and identify areas of performance and distress.

Results

• Completely automated dashboarding solution

• Enterprise level data with cluster drill-down functionality

• Flash (Forecasted) Reporting for RWAs

Key skills required

• Technical skills with SQL and Power BI

• Knowledge of data flow and database optimisation techniques 

• People and interpersonal skills to engage with Exco level clients 

• Soft skills including adaptability, stakeholder management, requirements gathering and expectation management