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 Ravensstuart.ravens@ovum.com19 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 level of responseAnalysing performance Provide an audit trail for regulatoryreporting58
Emergency responseExample – Flooding in EnglandBuilding resilience in toinfrastructure Reduce the potential impact ofhazard scenariosRisk modelling Quantify and prioritise investmentto mitigate riskStakeholder reporting Providing complete information tosupport shareholder value, brandreputation & customer satisfaction60
Network PerformanceExample – UK Mobile operationsHow do we reducecustomer churn in highvalue customers? Track high customer usage andreinforce networkHow do we optimisenetwork capacity? Use real time coverage analysis tomobilise resourcesStakeholders questioningfuture levels of investment Visually report on projects,investment and benefits.61
What happens next? GIS turns big data into information Information enables better strategic and operational decisionmaking See the detail, find your way!62
Example QlikView applications in Energy and UtilitiesKit Mundy – Director – Differentia ConsultingDean Ansermoz – Solutions Architect - QlikTech
Differentia ConsultingQlikView Elite Solution Provider Independent consulting firm, specialising in ERP and BI (QlikView) ex KPMG Consulting Leading QlikView partner in the UK (#1in the UK in 2011, #2 in 2010) Providing a full service for QlikView– Consulting / applications development– Software licences– Training (Certified QlikView training partner)– Applications and technical support– Technical architecture / hardware sizing Currently working with a number of leading companies in the energy andutilities sector
QlikView solutionsR&D and ITExecutive Product Portfolio Analysis Product / Project Management System Performance Controlling Service Level Reporting Infrastructure Planning / Sizing Balanced Scorecard Performance Management Predictive Analysis What-if Analysis Activity-Based ManagementFinance & HRSales, Marketing, Service & Web Financial Consolidation Reporting P&L Analysis by Division / Business Unit IFRS / GAAP / SOX Compliance Risk Management & Sustainability Report Workforce and Benefits Analysis Sales Planning Analysis Customer Analysis Campaign Performance Analysis Product Profitability / Price Waterfall Contact Center / SR PerformanceOperationsSupply Chain Production Planning & Scheduling Production Management Quality Management Six Sigma / Process Analysis Plant / Equipment Maintenance Analysis Demand Planning Procurement Analysis Supplier Performance Inventory and Warehouse Management Logistics & Fulfillment AnalysisDashboardAnalysisReporting
example QlikView applications Asset Management Regulatory reporting Customer Service Debt Management
Applications of QlikView within Utilities Organisations Contact Centre Analytics - Customer Service / Complaints / OutboundSales Unbilled Analysis Metering Sales Analytics Campaign Analytics Commercial Finance Decay Modelling/Campaign Analysis Bad Debt Reporting Health & Safety Energy Trading Project Costing Finance / HR Asset Maintenance / Workforce Planning
Implementation approachKit Mundy – Director – Differentia Consulting
.fast time to valueQlikViewApproachProjectVision / GoalPhased Approach Enables Value quickly delivered to organization Reduced time to market of applications Ability to react to changing business needs Maintain involvement, commitment andadoption by business and ITTraditional BIApproach“Big Bang” Mitigation of project riskTime
OneView ationDeliverySelection ExercisePlan projectInstall HardwareSIBProduce Project BriefInstall SoftwareBusiness CaseProduce EnterpriseArchitecture DocumentDevelop ApplicationsApplication DeveloperKnowledge TransferDeploy ApplicationsSize HardwareProject Proposal/SOWProject Sign OffDefine Corporate UIStandardsData QualityGovernanceSupportMonitor liveenvironmentResolve openissuesUser Acceptance TestingOn GoingReviewProduce Operational ProceduresChange ControlIssue Management
application deliveryBusiness Request1Deployment62JustificationApplication Delivery Value is quickly delivered to the organisation End users have continuous involvement Financial and resource controls are put in place3User Acceptance 5Testing4Approval
.fast time to value within a ationDeliveryProjectVision Support/ Goal16235416235416235Time4Data QualityGovernanceChange ControlIssue Management
Lunch
Smart metering application using QlikView- integrated with ESRI UK ArcGISKit Mundy – Director – Differentia ConsultingAlasdair Hind – Presales Consultant – ESRI UKAndrea Traverso – Director – KT Labs
Smart Metering demo Integration between QlikView and ArcGIS, delivered in conjunctionwith Differentia Consulting Utilises the KliqMap extension object from KT Labs Objective is to demonstrate the power of combining QlikViewbusiness discovery with ArcGIS geographic information to createlocation intelligence This allows you to map multiple layers of geographic informationand properties from ArcGIS based on selections made from withinQlikView
solution architectureArcGIS onlineBusinessUsersWeb serverQlikViewApps serverArcGIS serverKliqMapExtension ObjectArcGIS databaseData sources
Death per pump: 64.2Crapulation: 4Dirty Water?: 477
Sep 19, 2012 · QlikView SAP Connector . SAP BW SAP ERP Query Architecture SQL Connector Connector Report Connector OLAP ConnectorInfo DSO Connector ew es OLAP BAPI DSO BAPI Report openSQL SAP Query DSO BExObjects Query Cube DB openSQL ew es Info
