slide1 n.
Skip this Video
Download Presentation
A Fundamental Difference

Loading in 2 Seconds...

play fullscreen
1 / 21

A Fundamental Difference - PowerPoint PPT Presentation

  • Uploaded on

A Fundamental Difference. A Fundamental Difference. WHERE [Fiscal Year] = 2004 AND ([Fiscal Month] = ‘Apr’ OR [Fiscal Month] = ‘May’ OR [Fiscal Month] = ‘Jun’) AND [Division Name] = ‘Domestic’ AND ([Region Name] = ‘Northeast’ OR [Region Name] = ‘Southern’)

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'A Fundamental Difference' - stacie

Download Now An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
a fundamental difference1
A Fundamental Difference
  • WHERE [Fiscal Year] = 2004
  • AND ([Fiscal Month] = ‘Apr’ OR [Fiscal Month] = ‘May’ OR [Fiscal Month] = ‘Jun’)
  • AND [Division Name] = ‘Domestic’
  • AND ([Region Name] = ‘Northeast’ OR [Region Name] = ‘Southern’)
  • AND ([Product Type Desc] = ‘Breakfast Foods’ OR ([Product Type Desc] = ‘Dairy’ OR [Product Type Desc] = ‘Eggs’)
associative in memory technology
Associative In-Memory Technology

Large datasets

Many users

Fast queries

No load on operational systems

Freedom in selecting measures/dimensions

Infinite drill-down/around


“Sex and Sizzle”

Data queried in memory

Aggregates calculated as clicked

Visually Interactive UI

In Memory Analysis Feature:


Leverages 64-bit/multi-core Hardware Platform

start small
Start Small

Average implementation time1:

17 months in total; 5 months to deploy the first usable analytic application

Mean annual expenditure on BI software2:

$1.1 million for companies with >1,000 employees

Project success rate1:

31% success rate, at best

Meeting needs - right data to right person2:

Only 36% are confident that reports and dashboards deliver the right data, to the right person, at the right time

Implementation Time for BI Initiative1

1 DM Review & IDC Business Intelligence Survey, October 2006, 2004

(Material on implementation time not available in 2006 survey)

2 InfoWorld & IDC Business Intelligence Survey, October 2007

a fundamental difference2
A Fundamental Difference

Thought Driven

Flexible & Easy

Start Small

our mission
Our Mission

Simplifying Analysis For Everyone

performance challenges in banking
Performance Challenges in Banking

Expand Share of Wallet in Customer Portfolio

“Increased emphasis on revenue generation goals through nimbler product development and innovation, expansion into new geographies, and improved and actionable customer insight.”

Customer Acquisition & Retention

“Address economic slowdown and intense competition by retaining market share and adjusting to new demographics (such as larger senior population and migratory consumers.”

“Address new opportunities in emerging economies (such as the new mass affluent, small businesses, and the unbanked).”

Manage Risk Exposure

“Appropriately manage risk exposure across multiple fronts with regards to market risk, compliance, security and privacy.”

Streamline Back Office Operational Processes

“Adopt lean production and high-performance strategies of manufacturers to streamline customer interaction and transaction processes.”

qlikview for retail and investment banking
QlikView for Retail and Investment Banking
  • Product Development and IT
  • Product Portfolio Analysis
  • Product / Project Management
  • Product Performance by Market Segment
  • System Performance Controlling
  • Infrastructure Planning / Sizing
  • Executive
  • Balanced Scorecard
  • Performance Management
  • Predictive Analysis
  • What-if Analysis
  • Activity-Based Management
  • Asset / Wealth Management
  • Assets / Cash Distribution
  • Portfolio Analysis & Performance
  • Manager Performance
  • What-if Analysis
  • LOB – FI, Derivatives, Equity
  • Market Data Services
  • Market Price Monitoring – Current/Historical
  • Heat Map & Exposure
  • LOB Portfolio Analysis & Transactions
  • Performance – Margins, Commissions
  • Finance & HR
  • Financial Consolidation Reporting
  • P&L Analysis by LOB / Branch
  • IFRS / GAAP Accounting Compliance
  • Sustainability Reporting
  • Workforce and Benefits Analysis
  • Customer Management
  • Targets, Fees/Assets, Commissions
  • Customer Portfolio Analysis (Heat Map)
  • Customer Segmentation, Value & Profiling
  • Customer Cross-sell and Up-sell; MCIF
  • Marketing Campaign Performance



  • Risk Management & Compliance
  • Credit risk
  • Market risk
  • Operational risk
  • Compliance – Basel II, SEPA, KYC, AML, USA Patriot Act, HIPAA
  • Payment / Transaction Processing
  • Clearing, Settlement, and Reconciliation:
    • Payments (SWIFT, ACH, BACS, EDI)
    • ATM / Credit / Debit Card Transactions
  • Mortgages / Loan Processing
  • Anti-Money Laundering / Fraud Identification


select qlikview customers in banking
Select QlikView Customers in Banking
  • More Than 200 Banks Are Leveraging QlikView
unbelievably fast implementations
(Unbelievably) Fast Implementations

4 weeks implemented

3 weeks implemented




12 weeks implemented

8 weeks implemented

Large Wealth Management


2 weeks implemented

4 weeks implemented

Large Retail Banking Company

15 days implemented

7 weeks implemented


Investment Bank

delivering high performance for large data volumes
Delivering High Performance for Large Data Volumes

Cross Industry


15 – 20 TB of data or 2 billion records analyzed on doctors, patients and diagnoses

Couple terabytes of data analyzed

Large Investment

Banking Company

Large Wealth Management


200 GB of data or 140 million records analyzed on claims data with compression to 500MB

200 million records analyzed

56 million transactions analyzed with compression of 90%

4 millions customers analyzed across demographics for marketing campaigns

Large Retail

Banking Company

12 million patients with interaction records analyzed

Large data volumes analyzed on fixed income trades

Large Investment

Banking Company

5.5 million records integrated, cleansed and analyzed

Millions of customer records analyzed

5 million records pulled from multiple data sources

Millions of records analyzed

Large Investment

Banking Company

5 million records pulled from multiple data sources

5 million records analyzed

supporting large scale end user deployments
Supporting Large Scale End User Deployments

Cross Industry


600 users growing to 1,000 by year end 2007

24,600 users at Laredo (USA) Independent School District

Large Investment

Banking Company

11,000+ users at 3M

500 users

Large Financing


Large Investment

Banking Company

11,000+ users at Pfizer

500 users

11,000+ users at Sanofi-Aventis

200 users at LRP

10,000+ users at AMS (Sweden)

200 users at Nedbank

4,500+ users at Bristol-Myers Squibb

Large Investment

Banking Company

100 users growing to 500 users in the fall of 2007

about qliktech
About QlikTech
  • Heritage
  • Founded in 1993 in Sweden
  • R&D located in Lund, Sweden
  • Granted patents on in-memory associative technology
  • Eight major QlikView product releases
  • QlikView 8 released in 2007
  • Lead investors – Accel Partners and JVP
  • Board
  • Paul Wahl, former COO Siebel and CEO SAP America
  • Alex Ott, JVP, former President Siebel North America
  • Bruce Golden, Accel, former Executive at Sun, Illustra and Informix
  • Claes Bjork, former CEO Skanska
  • Måns Hultman, Chairman & CEO QlikTech
  • Organization
  • Management Team:
    • Former executives from SAP, Siebel, Oracle, PA Consulting, Mactive, Intentia
  • ~300 employees across 15 offices in 6 countries
  • More than 300 partners
  • Headquartered in US (Radnor, PA)
  • Results
  • Leading provider of next generation BI solutions
  • Fastest growing BI software company in the world for two years running (2005 – 2006) according to IDC
  • Profitable, annual revenue growth of ~80%
  • 6,125 customers in 76 countries
  • Adding 12.5 new customers every day
  • 276,000 live users
industry recognition awards
Industry Recognition & Awards

Broad Software Industry Recognition

Red Herring 100 Award Winner

Named a Winner of Red Herring 100 Spring 2007 Award given to the top 100 private technology companies based in North America driving innovation.

Sand Hill Group Innovation Showcase Winner

Selected as one of 25 companies in the Innovation Showcase at the Software 2007 conference. Recognized in the Fast Track category for the company’s significant market traction.

BI Software Industry Recognition

Gartner Group Recognition as ‘Visionary BI Provider’

Predicts predominance of ‘In-Memory’ BI solutions for 70% of Fortune 1000.

Recognized as a ‘Visionary’ in Gartner Group’s annual Magic Quadrant (2007).

IDC Recognition as ‘Fastest Growing BI Company’

Acknowledged as the fastest growing BI software company in the world for two years in a row (2005 - 2006) with profitable, annual revenue growth rates of ~80%.

Solution & Customer Recognition

Morgan Stanley CTO Summit Innovation Award

Recognized by Morgan Stanley as a leading technology innovator at its 2007 CTO Summit. Technologies are acknowledged for their impact on the marketplace and within Morgan Stanley.

CTO Summit Innovation Award

Gartner Group Best Midmarket Solution Software Award

Named QlikView as the IT Executives’ choice for ‘Best Midmarket Solution Software’ at Gartner Midsize Enterprise Summit 2007 in Atlanta.

FierceHealthIT - Top Healthcare IT Innovator Award

Named one of ten top innovators delivering disruptive technologies to the healthcare IT industry in 2007 according to FiereHealthIT.

The Computerworld Honors Program Laureate Award

Awarded for the Sahlgrenska University Hospital case study for the use of IT to benefit society. Recognized in the Business and Related Services category in 2007. Nominated by Morgan Stanley.

qlikview leads next generation bi
QlikView Leads Next Generation BI

●QlikTech (Jan 2006)

“70% of Global 1000 organizations will load detailed data into memory

as the primary method to optimize BI application performance and flexibility.

With in-memory technology, users can freely explore detailed data

in an unfettered manner without the limitations of a cube.” 1

Gartner Group Magic Quadrant

Business Intelligence Platforms 2007

  • Vision:
  • Performance: “[QlikView’s] technical advantages using an in-memory data model, automated data integration and a graphical analytical environment have attracted customers looking for both ease of use and highly scalable functionality.” 2
  • Architecture: “Beyond the performance capabilities, QlikTech has some unique architectural and contractual aspects. For example, by simultaneously ‘doing the inner and the outer join,’ QlikView makes it very easy for users to see both the query results and the non-query results. This functionality can be useful when performing analysis of the data, in particular when spotting outliers.” 2
  • Execution:
  • Growth: “QlikTech executed very well in 2006, increasing its revenue by 80% and significantly expanding its customer base to over 5,400 organizations.” 2
  • References: “Ironically, QlikTech — one of the smaller vendors evaluated in the Magic Quadrant — is able to show the most references, analyzing hundreds of millions of rows of data with good query performance.” 2

1Kurt Schlegel among others, “BI Applications Benefit From In-Memory Technology Improvements”, published 2 October 2006, pages 2-3

2 Kurt Schlegel among others, “Magic Quadrant for Business Intelligence Platforms, 1Q07”, published 26 January 2007, page 13

providing an integrated approach
Providing An Integrated Approach









Traditional BI Stack

User Interface, Dashboards, Scorecards, Reports

  • User Interface
  • Chart and Report Engine
  • Analysis Engine
  • Data Compression
  • Integration

Lots of tools

Multiple vendors

IT driven

Months to change

High Cost

One tool

One vendor

End user driven

Minutes to change

Low Cost

OLAP, Query and

Reporting tools

Data Marts

Data Warehouse

Integration Layer (ETL)

simplifying analysis for everyone
Simplifying Analysis for Everyone

Everyone Else

“Fast Implementation”





“Low Cost”


  • QlikView New Rules
  • Fast Implementation… Customers are live in less than 30 days, and most in a week
  • Easy to Use… End users require no training and enjoy “qliking” through the application
  • Powerful… Near instant response time on data volumes as high as a billion records across thousands of users
  • Flexible… Allows unlimited dimensions and measures and can be modified in seconds
  • Integrated… Dashboards, analysis and reporting in a single solution and on a single architecture
  • Low Cost… Less costly, shorter implementations result in fast return on investment
  • Risk-Free… Fully-functional free trial download, and a seeing-is-believing experience

QlikView Value Proposition: 1/4 the Time, 1/2 the Cost, 2x the Value

what would you say if
What Would You Say If…
  • You could deploy a complete Business Analysis system—

…typically in just 2-3 weeks?

  • You could build and deploy new applications—

…in just days or weeks?

  • You could have unlimited multi-dimensional access to your data—

…using point-and-click, easy-to-use applications?

  • You could access a billion records—

…in seconds?

  • You didn’t have to build a data warehouse—

…at all?

What if all of this was actually possible?