Product benchmarking of leading banking business intelligence platform providers by Sutherland Global Services

Business Intelligence (BI) Software in the Banking Sector September 21, 2012

Disclaimer This document is the proprietary and exclusive property of Sutherland Global Services except as otherwise indicated. No part of this document, in whole or in part, may be reproduced, stored, transmitted, or used for design purposes without the prior written permission of Sutherland Global Services. The information contained in this document is subject to change without notice. The information in this document is for information purposes only. Sutherland Global Services® disclaims all warranties, express or limited, including, but not limited, to the implied warranties of merchantability and fitness for a particular purpose, except as provided for in a separate software license agreement. All confidential or proprietary information contained in Sutherland’s response shall at all times be and remain the sole and exclusive property of Sutherland Global Services, Inc.

© SutherlandGlobal Global Services All rights reserved. Privileged and confidential information ofGlobal Sutherland Global © 2012 2010 Sutherland Services Inc.,Inc., All rights reserved. Privileged and confidential information of Sutherland Services Inc. Services Inc.

www.sutherlandglobal.com

Outline

BI in Banking Industry

Banking BI by Regions

Competitive Landscape Overview

Product Benchmarking

Competitorâ&#x20AC;&#x2122;s Profile

www.sutherlandglobal.com June 6, 2013

Outline

BI in Banking Industry

Banking BI by Region

Competitive Landscape Overview

Product Benchmarking

Competitorâ&#x20AC;&#x2122;s Profile

www.sutherlandglobal.com June 6, 2013

BI vendors differ from each other on channel strategy, target segment and depth of product suites Depth of BI Product Suites

Vendor

BI Platforms

Analytic Applications and Performance Management

Share of SMB in BI Revenue, 2010 CPM Suites

QlikTech

MicroStrategy

IBM

SAP

Oracle

Key Observations •

•

MicroStrategy relies largely on its direct sales channel for its revenues. Direct sales account for 84% of the total revenues generated in its BI platform business QlikTech targets small or midsize business (SMBs) aggressively, although it is gradually moving targeting largeenterprise with direct sales

Megavendors are present in all segments of BI, while QlikTech and MicroStrategy focus only on BI platforms

QlikTech

65%

SAP

23%

IBM

14%

Oracle

14%

MicroStrategy

13% 0%

20%

40%

60%

80%

Share of Direct Sales in BI Revenue, 2010 MicroStrategy

84%

IBM

73%

SAP

73%

QlikTech

55%

Oracle

55% 0%

20%

40%

60%

80%

100%

www.sutherlandglobal.com June 6, 2013

BI vendors drive majority of their revenues from the Americas BI Revenues of Major Vendors by Geography, 2010 Americas

31%

61% 63% 35.0%

EMEA

55.0%

44.0%

64%

31% 28%

Asia/Pacific

10.0% 12.0% 8% 9% 10%

20%

30%

IBM

SAP

40% QlikTech

50%

60%

70%

MicroStrategy

80%

90%

100%

Oracle

Key Observations •

BI vendors’ revenue is skewed towards the Americas, which contributed more than half of their BI revenues

•

SAP dominates in the EMEA, while IBM and Oracle hold relatively stronger positions in the Americas

•

QlikTech gets the major portion of its revenue from the EMEA, whereas it lags behind its peers in the Americas

•

SAP’s BI platform revenue seems to be well-diversified; it get 44% of revenues from the Americas and the EMEA and rest from the APAC

•

The revenue share of the Asia/Pacific region for the BI vendors around 9%, reflecting unpenetrated and underdeveloped BI market

www.sutherlandglobal.com June 6, 2013

Megavendors such as SAP, IBM and Oracle offer multiple BI tools, where specialists such as QlikTech offers a single but customizable product

SAP • SAP BusinessObjects BI 4.0 • SAP BusinessObjects Web

Intelligence • SAP BusinessObjects Analysis •

• • • • • • • • • •

• •

for OLAP SAP BusinessObjects Analysis for Office SAP BusinessObjects Desktop Intelligence SAP BusinessObjects Explorer SAP BusinessObjects Dashboards SAP BusinessObjects Edge BI and older versions SAP Crystal Reports SAP Crystal Reports for Enterprise crystalreports.com SAP Crystal Dashboard and Presentation Design SAP BusinessObjects BI OnDemand SAP BusinessObjects BI OnDemand for salesforce.com, SAP BusinessObjects Predictive Workbench, and SAP Business Warehouse (BW) tools, such as Visual Composer, Web Application Designer, Business Explorer Analyzer, Business Explorer Web Analyzer, InfoCubes and BI Accelerator.

IBM • IBM Cognos Business • • • • • • • • • • • •

Intelligence IBM Cognos TM1 IBM Cognos Express, IBM Cognos Analytic Applications IBM Cognos Consumer Insight IBM SPSS Modeler IBM SPSS Statistics IBM SPSS Decision Management IBM SPSS Data Collection IBM Cognos Business Viewpoint IBM Cognos Planning IBM Cognos Financial Statement Reporting IBM Cognos Controller

Oracle

MicroStrategy

QlikTech

• OBIEE 11g and older BI Server,

• MicroStrategy 9.2.1 (including

• QlikView 11 and older versions.

• • • • • • •

• • • • • • • •

Performance Scorecard, Business Intelligence Standard Edition and Standard Edition One, Business Intelligence Publisher Express BI Discoverer Reports OLAP and Data Mining Options (part of the Database) BI Disconnected Analytics, System 9 BI+ and older versions, Essbase, Brio, Interactive Reporting, SQR Production Reporting, Enterprise Analytics Hyperion Hub Performance Suite Dashboard Scorecard, Metrics Builder Performance Scorecards Foundation Services Scenario, Real-Time Decisions OBI Applications and Exalytics (launched in October 2011).

Intelligence Server, Distribution Services, OLAP Services, Report Services, Desktop, Web, Web Universal Edition, Office, Architect, BI Developer Kit, Mobile, Enterprise Manager, Object Manager, Command Manager, Integrity Manager, Visual Insight [included with MicroStrategy Report Services], and enterprise and personal cloud offerings)

www.sutherlandglobal.com June 6, 2013

Outline

BI in Banking Industry

Banking BI by Region

Competitive Landscape Overview

Product Benchmarking

Competitorâ&#x20AC;&#x2122;s Profile

www.sutherlandglobal.com June 6, 2013

BI vendors provide BI tools with some pre-built banking specific functionalities, and also provide opportunity to banks to customized as per their needs

Product Benchmarking â&#x20AC;&#x201C; Banking Specific Features Features

SAP

Oracle

Microstrategy

QlikTech

IBM

Sutherland

Payment and Transaction Transactions (Loan management, deposits management, etc)

Yes

Business-Defined Alerts

Yes

Yes Yes

Yes

Performance Measurement Rales and margin performance by customer, channel, product line, branch ,region or division

Yes

Planning, Forecasting and Budgeting

Yes

Complaint Levels

Yes

Risk Management Risk Analysis (e.g. asset liability, Fraud, etc.)

Yes

Credit Risk Analysis

Yes

Compliance Ready Data for Regulatory Reporting

Yes

Credit Risk management

Yes

Marketing and Promotion Customer Analysis

Yes

Cross-sell and Up-sell

Yes

What if Analysis

Yes

www.sutherlandglobal.com June 6, 2013

BI vendors provide good MS Office integration, except QlikView

Reporting Features

SAP

Oracle

Microstrategy

QlikTech

IBM

Sutherland

Formatted Reports

Yes

Multi-lingual

Yes

Offline Availability of Reports

Yes

Spatial Visualization

Yes

Multi-Device Common Interface

Yes

Yes Yes - IBM Cognos 10 heavily integrates with the Microsoft Office product family

Yes

Limited, The QlikView Microsoft Of integration is limited to exporting individual sheet objects to Excel. QlikView users can drag-and-drop charts from the desktop QlikView client into Microsoft Office document

MS Office Integration

Yes (LiveOffice Plug-in)

Yes

www.sutherlandglobal.com June 6, 2013

MicroStrategy considered to be a better option compared to its pears Ad hoc Query and Analysis Features

SAP

Oracle

Microstrategy

QlikTech

IBM

Ad-hoc analysis

Yes

Yes - Hyperion Visual Explorer enables ad hoc analysis and "what if" modeling for exploration of operational and financial data

Yes, Visual Insight. It only accesses one data source at a time and displays one visualization per page

Yes

Yes (Insight)

Yes

Visual Analysis

Enterprise dimension management

Yes

Yes - QlikView Enterprise Management Console into its own systems management

Interactive Analysis

Yes

Predictive modeling and data mining

Yes

Real-time analytical support

Yes

Limited

Yes

Social intelligence

Yes

Scalability of Data

Yes

Limited, dependent on RAM Size

Yes

Sutherland

www.sutherlandglobal.com June 6, 2013

QlikView is perceived as the best vendor for interactive dashboard Dashboard Features

SAP

Oracle

Microstrategy

QlikTech

IBM

Pixel Perfect Reporting

Yes

It runs un against a cached cube or data warehouse and are viewed through either a HTML/AJAX, Flash, or native mobile interface)

It runs against a server-based inmemory database and viewed via a Web/AJAX or desktop interface.

Yes

Filters in MicroStrategy constrain views of data to support drill down and drill across navigation

They expose relationships among all elements displayed on a dashboard screen

Yes

Dimensional

Vertically interactive (via its dimensional data structure.)

Horizontally interactive (via its associative model of data)

Dimensional

Data Source

Filters

Data Modelling

Yes

Dimensional

Sutherland

http://www.b-eye-network.com/blogs/eckerson/archives/2012/05/more_on_microst.php

www.sutherlandglobal.com June 6, 2013

Megavendors score well on metadata management scorecard whereas MicroStrategy has an edge on mobile platform Scorecard Features

SAP

Oracle

Microstrategy

QlikTech

IBM

Scoreboard

Yes

Metrics Management

Yes

Sutherland

Mobile and Cloud

Features Mobile Reporting SaaS

SAP

Oracle

Microstrategy

QlikTech

IBM

Sutherland

Yes (Blackberry)

Yes

Yes – All

Yes – iPhone, Android

Yes - Blackberry

Yes

Metadata Management Features

Metadata Management

SAP

Oracle

Microstrategy

QlikTech

IBM

Strong

Strong- Oracle's BI metadata management provides out-of-thebox functionality for: multiple userspecified views of metadata items, change propagation, inference from physical data structures

Strong - Reusable metadata is easier to maintain requiring less redundancy, end users have more self-service capabilities that offload work from the IT staff, it provides a comprehensive suite of administrative tools requiring fewer IT administrator

Poor, Developers are forced to create redundant metadata objects as the metadata objects they create cannot be reused across multiple reports, causing unnecessary development and maintenance efforts.

Strong

Sutherland

www.sutherlandglobal.com June 6, 2013

Other miscellaneous features Other feature and functionalities Features

SAP

Oracle

Microstrategy

QlikTech

IBM

Architecture

OLAP

ROLAP

In-memory

OLAP

In-memory

SAP HANA

Exalytics In-Memory Machine

Yes

On location

Yes

Capture snapshots of their selections

Yes

Rapid Deployment

Yes

Rule-based Work-Flow

Yes

Yes - Dynamic MultiLevel Caching

Yes - automatic caching at multiple levels

Yes

Camera, GPS (Mobile Tech. Leveraging)

Yes

Data Security Management Rights

Yes

Microsoft Office Integration

Yes

Server-Based Reporting

Yes

Web-integrated

Yes

Sources from Internal Data

Yes

Sources from External Data

Yes

Ajax/JavaScript API

Yes

Scalability

Yes

Extensible by Internal IT team

Yes

Multi-level Caching

Sutherland

www.sutherlandglobal.com June 6, 2013

Thank You