QlikView Expressor Bill Kehoe Chief Architect and Product Manager, QlikView Marc Huijbregts Solution Architect, QlikView
Legal Disclaimer This Presentation contains forward-looking statements, including, but not limited to, statements regarding the value and effectiveness of QlikTech's products, the introduction of product enhancements or additional products and QlikTech's growth, expansion and market leadership, that involve risks, uncertainties, assumptions and other factors which, if they do not materialize or prove correct, could cause QlikTech's results to differ materially from those expressed or implied by such forward-looking statements. All statements, other than statements of historical fact, are statements 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," and similar words. QlikTech intends all such forwardlooking statements to be covered by the safe harbor provisions for forward-looking statements contained in Section 21E of the Exchange Act and the Private Securities Litigation Reform Act 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 and retain existing customers; our ability to effectively sell, service and support our products; our ability to manage our international operations; our ability to compete effectively; our ability to develop and introduce new products and add-ons or enhancements to existing products; our ability to continue to promote and maintain our brand in a cost-effective manner; our ability to manage growth; our ability to attract and retain key personnel; the scope and validity of intellectual property rights applicable to our products; adverse economic conditions in general and adverse economic conditions specifically affecting the markets in which we operate; and other risks more fully described in QlikTech's publicly available filings with the Securities and Exchange Commission. Past performance is not necessarily indicative of future results. The forward-looking statements included in this presentation represent QlikTech's views as of the date of this presentation. QlikTech anticipates that subsequent events and developments will cause its views to change. QlikTech undertakes no intention or obligation to update or revise any forward-looking statements, whether as a result of new information, future events or otherwise. These forward-looking statements should not be relied upon as 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. Individual statements appearing in this Presentation are intended to be read in conjunction with and in the context of the complete SEC Information documents in which they appear, rather than as stand-alone statements. © 2013 Qlik Technologies Inc. All rights reserved. QlikTech and QlikView are trademarks or registered trademarks of Qlik Technologies Inc. or its subsidiaries in the U.S. and other countries. Other company names, product names and company logos mentioned herein are the trademarks, or registered trademarks of their owners.
Agenda • Business Case for Governance • Using Governance Dashboard to Gain Insight • Building a reusable data layer with QlikView Expressor • Demo • Q&A
Business Case for Governance
Business user simplicity, IT complexity
Land ERP Excel Land
Oracle SQL SFDC
IT DEPARTMENT
Land
SAP
BUSINESS USER
DW OPERATIONAL DATA SOURCES
Land
QLIKVIEW
Business user & IT simplicity
1. QlikView Governance Dashboard 3. QlikView ERP ITExcel data or compliance specialists identifies IT DEPARTMENT QlikView application developer opportunities to unify data sources and createleverages common data definition to quickly take common metric definitions Oracle advantage of centrally managed data SQL SFDC
QLIKVIEW EXPRESSOR
SAP BUSINESS USER
DW
2. QlikView Expressor OPERATIONAL DATA SOURCES
IT data specialist creates centrally managed dataflow, with common metric definitions QLIKVIEW GOVERNANCE DASHBOARD
QLIKVIEW
Using Governance Dashboard to Gain Insight
QlikView Governance Dashboard – What is it? • A QlikView Application – Presentation layer – Interactive visual discovery of the QV deployment
• Application Governance – Application Usage (who, when) – App Data lineage – Expression labeling consistency – App Tables, Fields, Objects – Find Field Usage Across All Apps
• Server and Publisher Usage – User activity – Concurrent sessions – Session heat map – License Usage
QlikView Governance Dashboard: Effective and Efficient • Provides visibility into QlikView Deployments: Data lineage, impact analysis and server statistics Sheet objects, expressions, data sources and file details
• Helps answer critical questions: Metrics about QlikView apps across the deployment What data is or is not being used and by which apps? Which expressions/labels are being used the most?
• Leads to actions that enable: A single common and reusable definition of the data A disciplined approach to provisioning data for QV apps Expanded use of QlikView across the enterprise
QlikView Governance Dashboard
Governance Dashboard Availability • Download from: – market.qlikview.com – download.qlikview.com
• Easy-to-use Installer, No License required • Most Downloaded Product on QlikMarket • What Customers and Partners Are Saying: I like it! Easy to configure and light-years ahead of other Metadata examples... All in all, a great move forward. I'm happy this is now available and will be testing it on different customer deployments. We have installed your product… which works perfectly! It helps improve our view of processes, logs, usage on our QlikView deployment
Building a reusable and manageable data layer with QlikView Expressor
Information Delivery Begins With Data Integration
Data
Conform/Model
Powerful Data Discovery
Data Preparation and Management via QlikView Scripting
What if?
Data Preparation using a Visual Dataflow
Feature
Extensible Connectivity
High-Performance, Stream Processing (not limited by available RAM) Semantic Field Mapping
Expressor Advantages • • • • • •
Flat Files Relational Databases (ODBC) Salesforce.com, Excel Teradata Parallel Transport Extension SDK Cloud REST / SOAP
• Patented architecture • Read, process and write data in parallel • Designed to meet tight data processing time constraints
• Common definition and vocabulary for all data • Stored as reusable metadata • Holistic and consistent view of your data • Data Lineage and Impact Analysis
Business Rule Abstraction and Reuse
• Business logic captured as reusable rules • Apply rules to individual metadata attributes • Promote separation of concern and team collaboration • Faster time-to-value
Data Quality Operations
• Built-in data quality layer for name, address, and email cleansing maintains user-defined validation, constraint, and error handling rules
Account_Number
IT
Business User
Semantic Data Lineage
Na me
Na me Em ail
Em ail Addres s
Addres s
Presentation
QlikView Expressor Integrated Architecture
Application
BUSINESS DISCOVERY APPS
QLIKVIEW SERVER
BUSINESS USERS
QVW & QVD files
QLIKVIEW PUBLISHER
Deployments with Embedded QVWs
QLIKVIEW DEVELOPER
Data Access
QLIKVIEW EXPRESSOR ENGINE
QLIKVIEW EXPRESSOR METADATA
EXCEL
SQL
SAP
ERP
ORACLE
OPERATIONAL DATA SOURCES
QLIKVIEW EXPRESSOR DESKTOP
SALESFORCE
How to Use QVE in and Enterprise Environment
QlikView Expressor Product Components Component
Function
License
Desktop
Graphically create and manage data access and transformation logic for QlikView and other data output targets such as Salesforce, Excel, text files and databases.
Free, Standard, Enterprise
Store, share and version control all model components.
Standard, Enterprise
Engine
Execution engine component available in the Standard and Enterprise editions for executing QlikView Expressor dataflows deployed to a server.
Standard, Enterprise
QlikView Expressor Connector
Launch the QlikView Expressor Engine during reload of a QlikView script to load the resulting data and model into your QlikView applications.
Free, Standard, Enterprise
Repository
QlikView Expressor License Options Edition
Desktop
License Option
Free
Restriction • Interactive execution of dataflow restricted to desktop only • No version control repository
Standard (Desktop, Engine, Repository)
See Price List
Processing restricted to 8 cores
Enterprise (Desktop, Engine, Repository)
See Price List
No core restrictions
Why Semantic Models? Enhance… • • • • •
Communication between Technical and Business Users Re-Use of Pre-defined Model Components Design Flexibility Consistency and Adherence to Best Practices Repeatability & Governance
Reduce… • Redundancy • Time to Value (Development, Maintenance & Deployment)
QlikView Expressor Semantic Type & Mapping Business Domain
Finance
Sales
Marketing
Customer A
ACCT_NO
account
account_num
Id
varchar(12)
varchar(10)
integer
varchar(12)
SQL Server
Teradata
Flat File
Salesforce
or customer or partner …
Technical Environment
Semantic Framework
Account_Number String, Min Length = 10, Max Length = 12
Leverage Your Existing QlikView Metadata • Create QlikView Schemas from QVW, QVD and QVX files • Generate Semantic Models from your Existing QlikView models • Map back to new data sources and take full advantage of your existing QlikView models
QlikView Expressor Engine • Patented parallel partitioning technology delivers high performance using hybrid multi-thread / multi-process data pipelining topology • Optimal Throughput • Not limited to what can fit in memory
Scalable Performance • QlikView Expressor Engine can achieve near linear scalability as more hardware (and data) is added • Add cores to increase or maintain optimal performance according to handle your data volume variations
QlikView Expressor Connector • Included in all Editions • Augment QlikView Scripts with Data from Deployed Expressor Dataflows • Interactive Testing of Scripts with Desktop (free) License • Automated Execution (e.g. via Publisher) Requires Standard or Enterprise License
QVE Connector
What’s New in QlikView Expressor v3.9 & v3.10 • Enhanced Artifact Search Where Used / Uses Impact Analysis
• Attribute Name and Type Mapping Assist • Multi-Transform Operator • Extension SDK • MongoDB Connectivity • Datascript Debugging • Publish Deployment Packages
QV Expressor: Where We Are Heading? • QVD Read and Write Operators • Enhance Integration with QMC • Globalization
Demo
Q&A
Q&A
Thank you!