qlik view ase 2009

57
ANALIZA MULTIDIMENSIONALA SIMPRE 2009 Academia de studii economice

Upload: alex-barbulescu

Post on 24-May-2015

438 views

Category:

Documents


2 download

DESCRIPTION

Qlikiew

TRANSCRIPT

Page 1: Qlik View   Ase 2009

ANALIZA MULTIDIMENSIONALA

SIMPRE 2009

Academia de studii economice

Page 2: Qlik View   Ase 2009

AGENDA

Academia de studii economice

Admin stuff

BI - BASICS

AQL Technology (vs OLAP)

QlikView – deployment examples

Implementation process

Advanced Visual Design

Page 3: Qlik View   Ase 2009

Admin stuff

Academia de studii economice

Alex Barbulescu

Asistant lecturer Phd.c.

3 intalniri - de la ora 18.00, sala 2001

17 – noi - Intro ppt

- Instalare locala QV

- demo QV – utilizare

- hands on - examples

19 – noi – QlikTech Romania,

QQinfo, Cotiso Hanganu

- hands on - examples

20 – noi – hands on

Page 4: Qlik View   Ase 2009

BI - BASICS

Academia de studii economice

Dimensiuni

Ierarhii

Măsuri

Hipercuburi

Intersecţii de date

Măsurile ca dimensiuni

Page 5: Qlik View   Ase 2009

AQL Technology (vs OLAP)

Academia de studii economice

Page 6: Qlik View   Ase 2009

AQL Technology (vs OLAP)

Academia de studii economice

Ce este AQL ?

AQL - Advanced Query Logic este o tehnologie

revoluţionară, care accesează informaţiile structurate din

surse variate într-un mod dinamic şi interactiv, propagând

selecţiile de analiză prin întreaga bază de date relaţională

înglobată.

Page 7: Qlik View   Ase 2009

AQL Technology (vs OLAP)

Academia de studii economice

Click !

Fiecare click este o interogare. Extrem de rapid, şi foarte flexibil.

Interfaţa utilizator

Selecţia se propagă prin baza de date relaţională.

AQL

Page 8: Qlik View   Ase 2009

AQL Technology (vs OLAP)

Academia de studii economice

Ce oferă AQL ?

Simplificarea procesului de conectare şi administrare a

structurilor de înmagazinare ale soluţiilor de business

intelligence

(NO DATA WAREHOUSE REQUIRED !)

Viteză remarcabilă de implementare

Viteză incredibilă de returnare a rapoartelor (secunde!)

Portabilitate (“Off-LAP”)

Uşurinţă în utilizare (analize la un “Qlik” distanţă)

Page 9: Qlik View   Ase 2009

AQL Technology (vs OLAP)

Academia de studii economice

Cui foloseşte AQL ?

Tuturor celor care vor răspunsuri instantanee la întrebările lor.

Tuturor celor care nu vor să devină experţi IT pentru a afla

informaţii relevante de la un sistem informatic

Tuturor celor pentru care timpul e critic

Tuturor celor care vor să verifice rapid corectitudinea informaţiilor

pe care le deţin

Tuturor celor care vor să ofere plusvaloare informaţională şi

transparenţă clienţilor sau partenerilor săi

Page 10: Qlik View   Ase 2009

AQL Technology (vs OLAP)

Academia de studii economice

Cine ofera?

QlikTech este o coporaţie suedeză care a dezvoltat această

tehnologie.

Produsul care înglobează această tehnologie se numeşte QlikView

In Romania prin parteneri.

Page 11: Qlik View   Ase 2009

AQL Technology (vs OLAP)

Academia de studii economice

OLAPRelaţional

Data Warehouse

Interogările SQL sunt generate grafic. Flexibil, dar neprietenos şi lent.

Interfaţă utilizator

Page 12: Qlik View   Ase 2009

AQL Technology (vs OLAP)

Academia de studii economice12

OLAPMultidimensional

Data Warehouse

Interfaţă utilizator

Hyper Cube

Construirea cubului. Multe date. Lent. Totul trebuie predefinit.

Fiecare click este o interogare. Rapid, dar inflexibil. Număr limitat de dimensiuni.

Page 13: Qlik View   Ase 2009

AQL Technology (vs OLAP)

Academia de studii economice

OLAPHibrid

Data Warehouse

Hyper Cube

Fiecare click este o interogare. Rapid, dar inflexibil. Număr limitat de dimensiuni.

Căutare “Drill-through” la nevoie. Încet şi neprietenos.

Interfaţă utilizator

Page 14: Qlik View   Ase 2009

AQL Technology (vs OLAP)

Academia de studii economice

AQL

Data Warehouse

Data Warehouse nu mai este neapărat necesar

Fişier QlikView

Baza de date relaţională este în fişier

Interfaţă utilizator

Page 15: Qlik View   Ase 2009

AQL Technology (vs OLAP)

Academia de studii economice

AQL

Sursa de date primare

Încarcă ...şi apoi poţi lucra off-line

Fişier QlikView

Interfaţă utilizator

Page 16: Qlik View   Ase 2009

AQL Technology (vs OLAP)

Academia de studii economice

Surse de date primare

Data Warehouse(Creşte dex3 – x10 – x100)

Fişiere QlikView (Scade de10x – 100x – 300 x)

Page 17: Qlik View   Ase 2009

Qlik View – deployment examples

Academia de studii economice

Page 18: Qlik View   Ase 2009

Qlik View – deployment examples

Academia de studii economice

Page 19: Qlik View   Ase 2009

Qlik View – deployment examples

Academia de studii economice

Page 20: Qlik View   Ase 2009

Qlik View – deployment examples

Academia de studii economice

Page 21: Qlik View   Ase 2009

Qlik View – deployment examples

Academia de studii economice

Page 22: Qlik View   Ase 2009

Implementation process

Academia de studii economice

Page 23: Qlik View   Ase 2009

Implementation process

Academia de studii economice

Put in place infrastructureIdentify most valuable/reasonable places to startIdentifiy existing data structuresIdentify & develop new data structures requiredDevelop scriptingDevelop analyzingDevelop reportingDevelop macrosContinuous learn

(iterative process !)

Page 24: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

Page 25: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

What is bad design?

What is good design?

What is user-friendly?

Overview

Chart type choices

Page 26: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

What is bad design in QlikView?

ClutteredToo many colors in oneDark colorsInconsistent object placementWrong choice in object typeObjects placed on top of each otherObjects placed off the screen

… etc

Page 27: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

Cluttered

Page 28: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

Too many colors

Page 29: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

Inconsistency

Page 30: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

Wrong Object Types

Line chart

Top Performers

Bar chart

Page 31: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

Objects overlap

Page 32: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

What is good design?

Page 33: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

What is good design in QlikView?

UnclutteredCrispAlignedLight color choicesConsistency with object placement in a sheet

… etc

Page 34: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

Uncluttered

Page 35: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

Light colors

Page 36: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

Consistency

Time Dimensions

Regular Selection Related

Body Charts

Minimized Icons

Page 37: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

What is user friendly design?

Page 38: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

What is user friendly in QlikView?

Easy to find what you are looking forRepeated objects (clear buttons) at the same position in every sheetClean layout in chartsHierarchy dimensions placed in orderColor choices for color-blind

… etc

Page 39: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

Create sheets to categorize the data/report

Always place Current Selection Box to keep track on what information you are looking at

Name charts wisely

Place proper selection objects in each sheet

KPI Sheet Transaction Sheet

Easy to find

Page 40: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

Consistent positioning

Page 41: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

Hierarchy Dimensions

2

3

4

5

1

4

3

2

5

1

Page 42: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

Color blindness

Page 43: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

ClutteredToo many colors in one

Dark colorsInconsistent object

placementWrong choice in object

typeObjects placed on top of

each otherObjects placed off the

screen

… etc

Uncluttered

Crisp

Light color choices

Consistency in object placement

Easy to find what you are looking for

Repeated objects (clear buttons) at the same position in every sheet

Clean layout in chartsHierarchy dimensions placed in

orderColor choices for color-blind

… etc

Overview

Page 44: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

Choices for chart types

Page 45: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

Choices for chart types

Graphic Chart Types

Table Chart Types

Bar Chart Line Chart Combo Chart Radar Chart Gauge Chart

Scatter Chart Grid Chart Pie Chart Block Chart

Straight Table Pivot Table

The question is…

When to use what?

Page 46: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

Bar Chart

Bar Chart

• Comparisons for similar measurements Actual vs. Budget money to money, quantity to quantity Amount over time time to time Top N categorized values (sales reps, customers etc) Avoid for $ and Qty

Page 47: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

Line Chart

Line Chart

• Measurement to follow its movements• Comparisons among items

Performance Trends Amount movements over time 2 dimension Comparisons Annual Comparisons over

months

Page 48: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

Combo Chart

Combo Chart

Comparisons for multi-measurements Two measurements Currency amount and quantity Amount and percentage Two axis Left-axis and right axis for measurements Two or more axis Split axis horizontally

Page 49: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

Radar Chart

• Comparisons of high level groups One or Two measurements Sales and Profit Avoid a dimension with many values

Radar Chart

Page 50: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

Gauge Chart

• Ratio of measurements Percentages Margin, Quota Achieved, YTD vs. Last

Year YTD Avoid actual amounts

Gauge Chart

Page 51: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

Scatter Chart

• Measurements act as dimensions (3D chart) 3D measurement chart Amounts, quantity and #

of customers Map chart Sales on geographical map

Scatter Chart

Page 52: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

Grid Chart

• 2 or 3 dimensions with a measurement Multi-cross dimensional measurements Amounts over regional and product over time

Grid Chart

Page 53: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

Pie Chart

• Visual distribution measurements What contributes how to the whole Regional

Sales Yes / No analysis

Pie Chart

Page 54: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

Block Chart

• Distribution measurements with multi-dimensions What contributes how to the whole and within each

segments Sales contribution per state per region

Block Chart

Page 55: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

Straight Table

• One dimension with multiple measurements KPI Overview Cycle group dimension with Sales,

Qty, Margin Sort in any columns (No grouping)

Straight Table

Page 56: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

Pivot Table• Multi-dimensions with one or more measurements Grouping of dimensions Product sales by item Dimension across the table Annual sales by months Variance calculation

using before( ) No repetition of the same values (grouped) No end-user sort by double-click

Pivot Table

Page 57: Qlik View   Ase 2009

Advanced Visual Design

Academia de studii economice

Which graphical chart would you choose?

when you have dollar amount and quantity…when you have actual amount and budget amount…when you display top performers…when you display the ratio (%) of dollar amounts by top performers…when you display the trend line over time…

Straight table or Pivot table?

when you have a dimension and multiple expressions…when you have multiple dimensions…

Combo chart

Bar chart

Bar chart

Pie chartLine chart

Straight table

Pivot table