Contact: [email protected] / 828-708-7631
Course: QlikView
Duration: 25-30 hours
Highlights of our training:

Real time Industry Experienced Trainer.

Interactive Training session using web conferencing tool

Normal track, weekend and fast track classes according to convenience

Student will be provided session recording capability to record each session

We provide Training Material, Exercises and Real Time Examples

Resume preparation and Certification Guidance

We will provide class and demo sessions at student flexible timings.

In training case studies and real time scenarios covered.
Overview of QlikView Content


Data warehouse Concepts
o
Basics of Data Warehousing
o
OLTP and OLAP systems
o
Data Warehousing Architecture
o
Dimension and Fact Tables
o
Star Schema and Snowflake Schema
Introduction to QlikView
o
Traditional BI and QlikView
o
QlikView In-memory Analysis
o
Sample QlikView Demo Application
o
What is Dashboard and Analysis?
o
QlikView Flavors
o
QlikView Architecture
o
QlikView Components

QlikView Desktop Developer

QlikView Server

QlikView Publisher

QlikView Access Protocol
o
Downloading and Installing of QlikView Software
o
QlikView Data Sources
Contact: [email protected] / 828-708-7631




Scripting
o
Script menu commands
o
Edit script Toolbar/Editor
o
System Variables
o
Data Extraction(Various sources)
o
Script Editing
o
Renaming of fields
o
Executing script
o
Debugging, Tracing and trouble shooting
o
Data Modeling
o
Types of data modeling
o
Storing data into QVD files.
Calendar
o
Generation of calendar
o
Date and Time functions
Functions and Expressions
o
QlikView Functions
o
Expressions
o
Joins
o
Keep (left and right)
o
Aggregation of data at script
o
Concatenation
o
Variables
o
SET and LET
Interacting with QlikView Objects
o
List Box
o
Multi Box
o
Table Box
o
Current selection Box
o
Text Object
o
Calendar/Slider Object
o
Input Box
o
Line/Arrow Object
o
Button
o
Statistics Box
o
Bookmark Object
o
Search Object
o
System Table
Contact: [email protected] / 828-708-7631




Interacting with QlikView Objects with All Properties(Charts)
o
Bar Chart
o
Line Chart
o
Combo Chart
o
Radar Chart
o
Mekko Chart
o
Grid Chart
o
Scatter Chart
o
Pie Chart
o
Funnel Chart
o
Block Chart
o
Straight Table
o
Pivot Table
o
Container Box
Interacting with QlikView Objects(Charts II)
o
General - Calculation Condition
o
Error Message
o
Fast Change
o
Trellis Chart
o
Expression – Mini Chart
o
Accumulation/No Accumulate
o
Trend Lines
Interacting with QlikView Script
o
Mapping Load
o
Binary Load
o
Exists
o
Synthetic Key
o
Loop/Circular Reference
o
Cyclic and Drilldown Groups
o
Expression Grouping
o
Joins in QlikView
Set Analysis
o
What is Set Analysis and Alternate States?
o
Why and how do we use it?
o
Identifiers, Operators and Modifiers
o
Examples
Contact: [email protected] / 828-708-7631






Interacting with QlikView
o
Sheet Properties
o
Document Properties
o
Conditional Display of Object and Sheet
o
Triggers
o
Hidden Script
o
Preceding Load
o
Load Inline Data
o
Indicators
o
Incremental Load
o
Interval Match
Security
o
What is security?
o
Type of Implementation
o
Security based on User ID
o
Security based on NTNAME
Type of Licenses
o
Names CALS
o
Document CALS
o
Session CALS
o
Usage CALS
Creation of Demo Application
o
What is BRD?
o
Technical Specifications
o
Creation of Dashboard and Reports
o
Implementation of security
Access of Application
o
Access by Access point
o
Access by QlikView Developer
QlikView Best Practices