QlikView Overview - Misasom.org

colorfuleggnogSoftware and s/w Development

Feb 17, 2014 (3 years and 3 months ago)

101 views



QlikView Overview

Scott Smith

Practice Director

WIT, Inc.


September 13, 2012

Dated May 1, 2012.

About WIT


Offices in Troy, Michigan and Cleveland, Ohio


Founded in 1996


More than 200 Clients


QlikView Elite Reseller Partner Since 2009


QlikView
-
Certified Implementation Partner


Other Technology Partners:


SAP Business Objects


Microsoft


iDashboards

Dated May 1, 2012.

QlikTech


A New Kind of Software Company


U.S.
-
based company,

founded 1993 in Sweden


25,000 customers in

100 countries


1,400 global partners


1,100+ employees across

28 offices in 23 countries


NASDAQ: QLIK


Change Their World Grant
and Philanthropic Programs

Broad Base of 25,000 Customers

Dated May 1, 2012.

Michigan Customers

Dated May 1, 2012.

Growing Customer Base

Customer Growth

1,500

2,239

5,436

7,306

10,585

13,024

25,000

*Historical results not indicative of future results.


18,000

Dated May 1, 2012.

Mobile Devices

Search

Innovations Are Remaking Markets

BI

CRM

SIMPLICITY

SIMPLICITY

SIMPLICITY

SIMPLICITY

PageRank

Search

iPhone/iPad

SAAS
-
based

CRM

Business
Discovery

Dated May 1, 2012.

QlikTech Hits
Top 3

in Forbes Fast Tech 25

Dated May 1, 2012.

QlikView: Gartner 2012 BI

Magic Quadrant Leader


Data Discovery momentum
continues to accelerate


QlikTech only Data
Discovery vendor in leader
quadrant


Customers report strong
delivery of business
benefits


#1 in ease of use


Increased global and
enterprise adoption

Magic Quadrant for Business Intelligence Platforms:

February 2012

Dated May 1, 2012.

Business Discovery:

Business User
-
Driven BI

Insight

Everywhere

App Model

Remixability

and Reassembly

Social and

Collaborative

Mobility

Finance

HR

Sales

Marketing

IT

Production

Dated May 1, 2012.

The Evolving BI Landscape

STACK

VENDOR BI


Managed

reporting

END USER


Pre
-
calculated
dashboards

OPERATIONAL DATA SOURCES

IT DEPARTMENT

REPORT
-
CENTRIC ARCHITECTURE

(IT
-
driven, tightly controlled)

IT ROLE


Data preparation

and governance

+


Responsible for
building all the
analyses

Dated May 1, 2012.

The Evolving BI Landscape and IT’s Changing Role

STACK

VENDOR BI


Managed

reporting

IT ROLE


Data preparation
and governance

+


Enable

business
users

to
create

their

own

analyses

IT ROLE


Data preparation

and governance

+


Responsible for
building all the
analyses

END USER


Pre
-
calculated
dashboards

BUSINESS USER


Self
-
service
analysis


Create analysis

relevant to specific

business problems


Change analysis
on the fly


QLIKVIEW


Dynamic
dashboards


Search live data


Any device

OPERATIONAL DATA SOURCES

IT DEPARTMENT

REPORT
-
CENTRIC ARCHITECTURE

(IT
-
driven, tightly controlled)

BUSINESS DISCOVERY ARCHITECTURE

(Business user
-
driven, self
-
service)

EXCEL

SQL

SAP

ERP

ORACLE

SALESFORCE

DATA

WAREHOUSE

INFORMATICA

Finance

Marketing

Sales

Operations

Presentation

QLIKVIEW
WEBSERVER

BUSINESS DISCOVERY APPS

Application

QLIKVIEW

PUBLISHER

BUSINESS USERS

IT Admins

QVW; QVD files

Windows

Based

File Share

(Optional)

Custom connectors; ODBC;

OLEDB; QVX; XML

Third
-
Party

Integration:




Informatica



Dell



Boomi



Sybase



and many more…

Security
Integration:




Windows Server



Tivoli Software



IBM

OPERATIONAL DATA SOURCES

Data Access

QlikView Business Discovery Platform

QLIKVIEW

SERVER

Data / Business
Analysts Developers

QLIKVIEW
MANAGEMENT
CONSOLE

QLIKVIEW

DEVELOPER

Windows IIS

Dated May 1, 2012.

QlikView on Mobile:

The HTML5 Advantage


Delivers the same QlikView
experience across

mobile devices


The same analytic apps

work on all devices


Reduces IT’s support burden


Secure: Data is stored on

the server, not the device

Dated May 1, 2012.

Global Enterprise Deployments

Dated May 1, 2012.

QlikCommunity:

Strength In Numbers


Self
-
service BI requires

self
-
service support


Leverages the expertise of
81,000+ users


Vibrant, thriving online global forum
at community.qlikview.com


Most
-
visited and active user
community in the BI industry


Free apps and best practices


Significant QlikTech employee
participation

QlikCommunity

Membership

Through April 2012

81,000

Dated May 1, 2012.

What Makes QlikView Unique

Dated May 1, 2012.

QlikView’s Associative Experience Puts Users in Control

Region

State

Product

Sales

Person

IT Driven


Linear, pre
-
defined thinking


Insights missed in hidden data


Months to change


Data
-
centric

User Driven


User decides where to start


All data, always visible


Minutes to change


Insight driven

Traditional

Associative

Region

Product

State

Sales

Person

Dated May 1, 2012.

QlikView Shows You

What’s Associated


and Not

Selections: green

Unassociated: gray

Associated: white

Dated May 1, 2012.

QlikView’s Core Technology: The Basics

1.
Easily consolidates multiple data sources

2.
Loads all data into memory (millions of rows)

3.
Massive (10
-
to
-
1) data compression

4.
Enables real
-
time associative search and analysis

5.
Connectors to applications like SAP and
Salesforce.com

Dated May 1, 2012.

QlikView’s Core Technology:

The Secret Sauce


Maintains associations in the data automatically


Calculates aggregations on the fly as needed



Thank you!