qlik view ase 2009
DESCRIPTION
QlikiewTRANSCRIPT
![Page 1: Qlik View Ase 2009](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/1.jpg)
ANALIZA MULTIDIMENSIONALA
SIMPRE 2009
Academia de studii economice
![Page 2: Qlik View Ase 2009](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/2.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/3.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/4.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/5.jpg)
AQL Technology (vs OLAP)
Academia de studii economice
![Page 6: Qlik View Ase 2009](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/6.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/7.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/8.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/9.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/10.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/11.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/12.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/13.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/14.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/15.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/16.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/17.jpg)
Qlik View – deployment examples
Academia de studii economice
![Page 18: Qlik View Ase 2009](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/18.jpg)
Qlik View – deployment examples
Academia de studii economice
![Page 19: Qlik View Ase 2009](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/19.jpg)
Qlik View – deployment examples
Academia de studii economice
![Page 20: Qlik View Ase 2009](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/20.jpg)
Qlik View – deployment examples
Academia de studii economice
![Page 21: Qlik View Ase 2009](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/21.jpg)
Qlik View – deployment examples
Academia de studii economice
![Page 22: Qlik View Ase 2009](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/22.jpg)
Implementation process
Academia de studii economice
![Page 23: Qlik View Ase 2009](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/23.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/24.jpg)
Advanced Visual Design
Academia de studii economice
![Page 25: Qlik View Ase 2009](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/25.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/26.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/27.jpg)
Advanced Visual Design
Academia de studii economice
Cluttered
![Page 28: Qlik View Ase 2009](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/28.jpg)
Advanced Visual Design
Academia de studii economice
Too many colors
![Page 29: Qlik View Ase 2009](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/29.jpg)
Advanced Visual Design
Academia de studii economice
Inconsistency
![Page 30: Qlik View Ase 2009](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/30.jpg)
Advanced Visual Design
Academia de studii economice
Wrong Object Types
Line chart
Top Performers
Bar chart
![Page 31: Qlik View Ase 2009](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/31.jpg)
Advanced Visual Design
Academia de studii economice
Objects overlap
![Page 32: Qlik View Ase 2009](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/32.jpg)
Advanced Visual Design
Academia de studii economice
What is good design?
![Page 33: Qlik View Ase 2009](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/33.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/34.jpg)
Advanced Visual Design
Academia de studii economice
Uncluttered
![Page 35: Qlik View Ase 2009](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/35.jpg)
Advanced Visual Design
Academia de studii economice
Light colors
![Page 36: Qlik View Ase 2009](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/36.jpg)
Advanced Visual Design
Academia de studii economice
Consistency
Time Dimensions
Regular Selection Related
Body Charts
Minimized Icons
![Page 37: Qlik View Ase 2009](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/37.jpg)
Advanced Visual Design
Academia de studii economice
What is user friendly design?
![Page 38: Qlik View Ase 2009](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/38.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/39.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/40.jpg)
Advanced Visual Design
Academia de studii economice
Consistent positioning
![Page 41: Qlik View Ase 2009](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/41.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/42.jpg)
Advanced Visual Design
Academia de studii economice
Color blindness
![Page 43: Qlik View Ase 2009](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/43.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/44.jpg)
Advanced Visual Design
Academia de studii economice
Choices for chart types
![Page 45: Qlik View Ase 2009](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/45.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/46.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/47.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/48.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/49.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/50.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/51.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/52.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/53.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/54.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/55.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/56.jpg)
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](https://reader038.vdocumente.com/reader038/viewer/2022102705/55617ccbd8b42ade208b52ba/html5/thumbnails/57.jpg)
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