chapter 1 - meet qlikview

4
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 Developers 2 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 Developers 3 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 Developers 4

Upload: eder-luis-pereira

Post on 17-Jul-2016

17 views

Category:

Documents


8 download

TRANSCRIPT

Page 1: Chapter 1 - Meet QlikView

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

Page 2: Chapter 1 - Meet QlikView

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

Page 3: Chapter 1 - Meet QlikView

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

Page 4: Chapter 1 - Meet QlikView

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