QlikView Architecture and Installation - QlikView Tutorial - Session 01
In this session you will learn about QlikView Architecture and Installation.
Qlikview Architecture
--------------------------------
Source Systems
Qlikview Desktop
Qlikview Server
Qlikview Publisher
Qlikview Accesspoint
Qlikview Clients
.qvw (Qlikview Worksheet)
Source Systems
----------------------
We can load Data from almost all types of Data Sources like all ODBC/OLEDB Supported Data Sources , Relational Databases like Oracle,SQLSERVER,MySQL,DB2,Access etc..., Text,Excel,CSV Files etc... and SAP,Salesforce systems etc...
Qlikview Desktop
--------------------------
We can Develop one complete Qlikview Document(.qvw)
We can fulfill the Roles of Qlikview Developer and Qlikview Designer
Roles of Qlikview Developer
----------------------------------------
Qlikview Developer Takes care of Data Model Part
Loading Tables from Different types of Data Sources
Creating QVD Files
Doing Transformations
Implementing Joins
Resolving issues like Circular Reference and Synthetic Keys
Roles of Qlikview Designer
----------------------------------------
Qlikview Designer Takes care of Visualization Part
Adding Bar Charts,Pie Charts etc...
Implementing SET Analysis, What-if Analysis etc...
Qlikview Server
-----------------------
Store all the Qlikview Documents
Reload all the Qlikview Documents
Qlikview Publisher
----------------------------
It also has the ability to Reload all the Qlikview Documents
It takes care of the Document Security
Data Reduction and Data Distribution parts
Based User Login Credentials Data will be reduced and distributed
Qlikview Accesspoint
------------------------------
It is the portal for the End Users to access their Documents/Dashboards
Qlikview Clients
------------------------
Web Browsers like IE,Firefox,chrome etc...
Mobile Devices like iPhone,Android and Blackberry Devices etc...
PDFs
Installed EXE(Qlikview Desktop)
Qlikview Folder Structure
-------------------------------------
Scripts
Resources
QVDMakers (or) QVDGenerators
QVD
Data Model
Application
Scripts
---------
It contains all the included scripts
Resources
---------------
It contains all the resources useful to develop the Qlikview Application like Text,Excel,CSV Files, Configuration Files, Images etc...
QVDMakers
-----------------
It contains a Qlikview Document
We will write Logic for Loading Tables and creating QVD Files
QVD
------
It contains all the QVD Files generated by QVDMakers Script
Data Model
----------------
It also contains a Qlikview Document
We will Logic upto Data Model or Developer part
Loading QVD Files, Doing Transformations, Implementing Joins and Resolving issues like Circular Reference and Synthetic Keys etc...
Application
----------------
It Contains final Qlikview Document
We will Load Data Model Document by making use of Binary Load
We will prepare Visualizations like adding Bar Charts, Pie Charts etc...
Installation
--------------
Go to Qlik.com
Click on Free Downloads
Qlikview Personal Edition
Fill the Registration Form
Get Qlikview Personal Edition
Select the version 32,64, windows 8
Access User License Agreement
Download Now