Sumatra - Banking Intelligence

Business Intelligence in Banking

Acquiring meaningful BI in the banking sector from available channels is a challenge. Options are often limited to standardized paper reports, module-centric enquiries, a multitude of Excel spreadsheets or costly IT based implementations: none of which offer company-wide, straightforward, sustainable BI at low-cost. There is, however, an innovative BI tool which is proven to deliver all of the above.

Our portfolio now includes Sumatra, a Banking BI tool developed using QlikView. Unprecedented in its simplicity, QlikView is the fastest growing BI tool, narrowing the gap between business and IT.

Presentation Video

Profile of Sumatra

Sumatra offers banks using Midas a market-ready BI solution for use throughout the bank covering, among other features, Basel II & NPV analysis, reporting to multiple entities, back-office and call center support.

For products outside of Midas, it offers a universal template to support consolidation of data from multiple source systems.

The application runs on a QlikView engine, selected for its unprecedented flexibility, business-orientation and growth in the BI sector.

Whether the bank’s IT strategy is ‘best of breed’ or all-in-one, Sumatra aims to provide a single, consistent repository for extracting BI over the entire portfolio.

Profile of QlikView

QlikView capitalizes on new technologies placing it as a credible challenger to the leading market solutions (SAP/Business Objects, Oracle/Hyperion, IBM/Cognos, Microsoft). Ranked in the visionary quadrant by Gartner Research as well as being the only BI tool to be named champion by Aberdeen AXIS, both in 2009, the most significant advantages of QV over its competitors are cost, ease of implementation and accessibility.

  • Cost:
    The total implementation and operative costs of QV are estimated at less than 1/4th of alternative solutions.
  • Ease of implementation/sustainability:
    One of the guiding principles of QV is that it is designed to be implemented, customized and maintained by users in-house who are not required to be IT specialists.
  • Accessibility
    All selections and calculations are based on in memory data with minimal response times (data is compressed by an average factor of 10). The QlikView in-memory data can be updated continuously, enabling users to analyze the latest data.


QV offers effortless integration of data from multiple systems/databases via ODBC, with the possibility of integrating data from additional sources (.xls, .csv, .txt, .xml, etc…) not available in one of the core databases. Attributes can be derived from multiple criteria according to the bank’s own definitions.

The resulting application offers both customizable drill-down views in real time and user-defined snapshot reports over the integrated data model.

For additional information about QlikView, please visit http://www.qlikview.com

Target Benefits


  • Customization:

    Allocation of module-independent product groupings enabling analysis of all transactions & accounts, regardless of their origin, in a single view.
    Derivation of attributes from existing data and/or annexation of attributes from other sources resulting in a thorough and consistent representation to all parties.

  • Financial Transparency:

    Modeling of the general ledger from transaction & account details allowing customer or contract attributes to be analyzed across the balance sheet and profit & loss statement.
    Dynamic rendering of static balances: breakdown of positions to their constituent cash flows supporting Basel II and IFRS reporting.

  • Integration:

    Merging of transaction and/or accounting data from external systems.


For banks using Midas as the core system, it would be possible to organize an on site evaluation using your bank's data.

If you would like to take a look at the application yourself,
you can request a user profile, to access the tool directly through our web site:

vrSOL Client QV-Webserver: https://qvs.vrsol.net/