Transcription

Utilities QlikTalkEsri UK, QlikTech& Differentia Consulting

Legal DisclaimerThis Presentation contains forward-looking statements, including, but not limited to, statements regarding the valueand effectiveness of QlikTech's products, the introduction of product enhancements or additional products andQlikTech's growth, expansion and market leadership, that involve risks, uncertainties, assumptions and other factorswhich, if they do not materialize or prove correct, could cause QlikTech's results to differ materially from thoseexpressed or implied by such forward-looking statements. All statements, other than statements of historical fact, arestatements that could be deemed forward-looking statements, including statements containing the words "predicts,""plan," "expects," "anticipates," "believes," "goal," "target," "estimate," "potential," "may", "will," "might," "could," andsimilar words. QlikTech intends all such forward-looking statements to be covered by the safe harbor provisions forforward-looking statements contained in Section 21E of the Exchange Act and the Private Securities Litigation ReformAct of 1995. Actual results may differ materially from those projected in such statements due to various factors,including but not limited to: risks and uncertainties inherent in our business; our ability to attract new customers andretain existing customers; our ability to effectively sell, service and support our products; our ability to manage ourinternational operations; our ability to compete effectively; our ability to develop and introduce new products and addons or enhancements to existing products; our ability to continue to promote and maintain our brand in a cost-effectivemanner; our ability to manage growth; our ability to attract and retain key personnel; the scope and validity ofintellectual property rights applicable to our products; adverse economic conditions in general and adverse economicconditions specifically affecting the markets in which we operate; and other risks more fully described in QlikTech'spublicly available filings with the Securities and Exchange Commission. Past performance is not necessarily indicativeof future results. The forward-looking statements included in this presentation represent QlikTech's views as of thedate of this presentation. QlikTech anticipates that subsequent events and developments will cause its views tochange. QlikTech undertakes no intention or obligation to update or revise any forward-looking statements, whetheras a result of new information, future events or otherwise. These forward-looking statements should not be relied uponas representing QlikTech's views as of any date subsequent to the date of this presentation.This Presentation should be read in conjunction with QlikTech's periodic reports filed with the SEC (SEC Information),including the disclosures therein of certain factors which may affect QlikTech’s future performance. Individualstatements appearing in this Presentation are intended to be read in conjunction with and in the context of thecomplete SEC Information documents in which they appear, rather than as stand-alone statements. 2012 Qlik Technologies Inc. All rights reserved. QlikTech and QlikView are trademarks or registered trademarks ofQlik Technologies Inc. or its subsidiaries in the U.S. and other countries. Other company names, product names andcompany logos mentioned herein are the trademarks, or registered trademarks of their owners.

Agenda09:30am: Registration open10:00am: Arrivals and Networking10:30am: Welcome and Introduction - Kevin Doughty, Esri UKand Tom Truman, QlikView11:00am Introduction to QlikView and Business DiscoveryMark Rodell – Senior Enterprise Architect QlikTech UK11:30am: Refreshment Break11:45am: Keynote: The Role of IT in the Utility of the FutureStuart Ravens, Ovum

Agenda12:15pm: Location-based DashboardsKevin Doughty, Esri UK12:30pm: Differentia Consulting - A BusinessDiscovery Approach - Kit Mundy, Differentia Consulting1:00pm: Networking Lunch1.45pm: Integration examples with QlikView and EsriArcGIS - Alasdair Hind Utilities Industry Lead - Technical2:30pm: Q&A2:45pm: End

A New Kind of Software Company U.S.-based company,founded 1993 in Sweden 26,000 customers in100 countries 1,400 global partners 1,300 employees across28 offices in 23 countries No. 1 fastest-growing enterprisetechnology company (ZDNet) NASDAQ: QLIK Change Their World Grant andPhilanthropic Programs QlikTech Hits Top 3in Forbes Fast Tech 25Broad Base of 26,000 Customers

existing QlikView energy and utilities customers

Esri UK Introductory SlidesKevin Doughty – Head of Business, Utilities- Esri UK

Esri Esri Inc Founded 1969 - HQ in Redlands, California Operating in 220 countries - 1,500,000 licences across 350,000 client sites 730 million revenue - 100 million annualR&D The ArcGIS Platform Esri UK Founded 1978 – HQ Aylesbury, officesthroughout UK, and Ireland 50 million revenue, UK specific products Core dev team in Edinburgh Key market’s – Utilities, Government,Defence, Commercial

Introduction to QlikView and Business DiscoveryMark Rodell – Senior Enterprise ArchitectQlikTech UK

Innovations are Remaking hMobile TYBusinessDiscovery

The Empowered ConsumerSocial NetworkingAppsMobilitySearchThe EmpoweredConsumer

Business Discovery:Business User-Driven BIApp ModelRemixabilityand ReassemblySocial ProductionMarketingSalesHR

What Makes QlikView Different Associative experience Speed-of-thought analysis Rapid time to value User-centric interactivity Access to relevant business data— from anywhere

making the complex simple consolidate informationrapidly from any data source search data withGoogle-like ease visualize data withstate-of-the art graphics

associative search puts users in sPersonStateProductSalesPersonIT Driven Linear, pre-defined thinking Insights missed in hidden data Months to change Data-centricProductUser Driven Follows the user All data, always visible Minutes to change Insight driven

QlikViewArchitecture Overview– Whiteboard

QlikViewServerQlikViewDeveloper AJAX Plug-in MobileQlikViewPublisher

QlikViewServerQlikViewDeveloper AJAX Plug-in MobileSourceDocumentsQVD and QVW filesQlikViewPublisher

Front EndQlikViewServerSourceDocumentsQVD and QVW filesQlikViewPublisherBack EndQlikViewDeveloper AJAX Plug-in Mobile

AJAX Plug-in tsQVD and QVW files ODBC OLEDB CustomQlikViewPublisherBack EndData Access LayerPresentation LayerApplication LayerFront EndWeb Service(QlikView or IIS)

AJAX Plug-in tsQVD and QVW files ODBC OLEDB CustomQlikViewPublisherBack EndData Access LayerPresentation LayerApplication LayerFront EndWeb Service(QlikView or IIS)

QlikViewSAP Connector

ArchitectureQVC 5.6QueryConnectorABAPDBReportopenSQLQlikViewRFC nectorExtractorSQL C ModulesSAP QlikViewDesktop / Server / PublisherSAP ERPQVDQVDQVDQVD

Coffee Break

The role of IT in the utility of the futureStuart Ravens – Principal Analyst– Ovum

The role of IT in the Utility ofthe FutureHow location intelligence enables improved performanceStuart [email protected] September 201226 Copyright Ovum. All rights reserved. Ovum is a subsidiary of Informa plc.

The utility of the future is an analytical utility27 Unprecedented industry pressures An exponential growth in data volumes All this data can be referenced geographically There’s a natural convergence of GIS and analytics Copyright Ovum. All rights reserved. Ovum is an Informa business.

The European workforce is agingSource: Eurostat28 Copyright Ovum. All rights reserved. Ovum is an Informa business.

Electricity distribution losses in Europe and NAmerica are driving smart grid investmentSource: EIA29 Copyright Ovum. All rights reserved. Ovum is an Informa business.

The decarbonisation of the energy value chain hashuge direct implications for electricity and gas, andindirect ones for waterSource: IEA Energy Technology Perspectives 201030 Copyright Ovum. All rights reserved. Ovum is an Informa business.

The Blue Map scenario relies on a number ofassumptions31 C-intensity of energy use falls 64% CO2 from power emissions falls 76% Nuclear accounts for 24% Renewables account for 48% of generation Building emissions cut by 66% Share of petroleum in transport falls to 50% 80% of LDV sales are PHEVs, EVs or fuel cell Copyright Ovum. All rights reserved. Ovum is an Informa business.

The old centralized distribution model 32 Copyright Ovum. All rights reserved. Ovum is an Informa business.

will look more like this (to varying degrees)33 Copyright Ovum. All rights reserved. Ovum is an Informa business.

Smart grid is still at an early stage (SGMM v4 due September 2012)Source: Smart Grid Maturity Model 201134 Copyright Ovum. All rights reserved. Ovum is an Informa business.

but is fast maturingSource: IEA Smart Grids Roadmap, 201135 Copyright Ovum. All rights reserved. Ovum is an Informa business.

Smart home data provide tantalizing opportunities36 Copyright Ovum. All rights reserved. Ovum is an Informa business.

Smart meters rely on incredibly complex data flows37 Copyright Ovum. All rights reserved. Ovum is an Informa business.

Smart grid functionality is more amorphous CustomerpremiserelatedfunctionsNetwork-related functions38Flow controlAutomatedislanding andreconnectionDynamiccapabilityratingCustomerpeak sheddingAutomatedfeederswitchingReal time loadmeasurement& Wide areamonitoringand controlFault currentlimitingReal time anceEnhanced imisation Copyright Ovum. All rights reserved. Ovum is an Informa business.

and based largely on analyticsPrevent a problem before it occursSpeed time to resolution when somethingdoes occurOperational datacollectionNon-operationaldata collectionDemand responseRealtime conditionmonitoringEvent diagnosticsData analyticsEvent detection ndition-basedcrew dispatchFunctionality delivers numerous smart grid goalsDirect feedbackElectric vehicleintegrationPeak loadmanagement39RenewableintegrationEnergy efficiencyReduced linelosses Copyright Ovum. All rights reserved. Ovum is an Informa business.

Although analytics is not restricted to smart grid; itextends across the entire value chain40 Copyright Ovum. All rights reserved. Ovum is an Informa business.

The siloed nature of utilities is a barrier to enterprisewide analytics; smart grid challenges the ETL-basedmodel41 Copyright Ovum. All rights reserved. Ovum is an Informa business.

Analytics became realtime in Ausgrid’s DM&C project42 Copyright Ovum. All rights reserved. Ovum is an Informa business.

All this data can be visualized geographically; ananalytical utility forces a convergence of GIS andanalytics43 Copyright Ovum. All rights reserved. Ovum is an Informa business.

Expect a second wave of better, scalable, GISenabled mobile applications 44 Hardware developments Device proliferation Consumerisation of applications Vendor investments in assets PAS55 SIM Copyright Ovum. All rights reserved. Ovum is an Informa business.

like this tablet based app, which uses the ArcGISAPI for Android45 Copyright Ovum. All rights reserved. Ovum is an Informa business.

There are a number of barriers to overcome for autility to act on this intelligence System scalability Is ‘infinite scalability’ possible? Disparate system architecture Poor system interoperability Multiple ODS/data marts Legacy systemsData strategy and governance Data quality managementMetadata managementMaster data managementAudit complianceSecurityCultural barriers IT vs OT46 Copyright Ovum. All rights reserved. Ovum is an Informa business.

DisclaimerAll Rights Reserved.No part of this publication may be reproduced, stored in a retrieval system ortransmitted in any form by any means, electronic, mechanical, photocopying,recording or otherwise, without the prior permission of the publisher, Ovum(an Informa business).The facts of this report are believed to be correct at the time of publication butcannot be guaranteed. Please note that the findings, conclusions andrecommendations that Ovum delivers will be based on information gathered ingood faith from both primary and secondary sources, whose accuracy we are notalways in a position to guarantee. As such Ovum can accept no liability whateverfor actions taken based on any information that may subsequently prove to beincorrect.47 Copyright Ovum. All rights reserved. Ovum is an Informa business.

Location Based DashboardsKevin Doughty – Head of Business, Utilities, Esri UK

Location based dashboardsEsri and QlikTech QlikTalkKevin Doughty19 September 2012

Are women better than men atnavigating?Which way am I looking?50

First Generation – Location Intelligence51

Trends Big Data (Smart Grids, Smart metering etc – the three V’sReal time GIS – SCADA, Weather.The Cloud – new ways to deployMobile – efficiency, accessIntegration - efficiencyUsability - efficiency

Case Studies – Location Dashboards

Customer ServiceImproved customerengagement The incidents are displayed on themap and colour coded according toincident type, the reference is alsodisplayedEfficient deployment ofresources Appropriate lev