chapter 1 - meet qlikview
TRANSCRIPT
Session 1:“Meet
QlikView”Miguel García
Barry Harmsen
1
This document is the property of Miguel García and Barry Harmsen. Any reproduction of this document in part or in whole is strictly prohibited.
QlikView is a registered trademark of Qlik Technologies Inc. or its subsidiaries in the United States, other countries or both.
Session goals
� Learn about QlikView from an end-user perspective;
� Learn about the technical components of QlikView;
� Introduce the case that this course uses.
QlikView 11 for Developers2
What you will learn
� What is QlikView?
� How to explore data with QlikView;
� The technology and components behind QlikView;
� HighCloud Airlines, and why QlikView might be just the tool they need.
QlikView 11 for Developers3
What is QlikView?A Business Intelligence (BI) tool created by QlikTech.
Business Intelligence, according to Gartner:
An umbrella term that includes the application, infrastructure and tools, and best practices that enable access to and analysis of information to improve and optimize decisions and performance.
QlikView 11 for Developers4
Traditional Business Intelligence
� Very much IT-driven;
� Works well for predefined, static reports;
� Users experience long lead times when new questions arrive that cannot be answered with the standard reports.
QlikView 11 for Developers5
Business Discovery
QlikTech aims t put tools into the hands of business users, allowing them to become self-sufficient.
Termed Data Discovery by Gartner, QlikTech refers to this as Business Discovery.
QlikView 11 for Developers6
Traditional BI vs Business Discovery
Traditional
IT: responsible for data preparation, governance and building all the analyses.
End user: pre-calculated reports and dashboards.
QlikView 11 for Developers7
Business Discovery
IT: responsible for data preparation and governance. Help enable users create their own analyses
User: self-service analysis, create and change on the fly to target specific business challenges.
QlikView vs traditional tools
Associative user experience
QlikView 11 for Developers8
QlikView vs traditional tools� Technology: QlikView uses an in-memory
data model, allowing for fast response times and a smooth user experience; more about this later.
� Adoption path: traditional BI is often implemented top-down, QlikView often sees a bottom-up, “land and expand”, spread throughout an organization.
QlikView 11 for Developers9
Exploring data with QlikView
Exercise 1: (pages 13 – 22)
Install QlikView (http://www.qlikview.com/download)
Explore the Movies Database application.
QlikView 11 for Developers10
Technology behind QlikViewQlikView utilizes an in-memory database, which is orders of magnitude faster than disk-based systems.
Helped by two factors:
� Cheap memory and the advancement of 64 bit processors;
� Clever compression algorithms.
QlikView 11 for Developers11
Data flows
QlikView 11 for Developers12
When QlikView use expands
QlikView 11 for Developers13
Meet HighCloud Airlines
� HighCloud is a European airline;
� Need to expand their market;
� Want to analyze the American market.
� Course follows HighCloud as their use and knowledge of QlikView expands.
QlikView 11 for Developers14
Summary
In this session we learned:
� QlikView is a BI solution that’s different from traditional offerings;
� How to use QlikView as an end-user;
� What the technological componentsbehind QlikView are;
� The case of this course: HighCloud Airlines.
QlikView 11 for Developers15