QlikView Training

(3) 3 Ratings

Course Schedule

30

JUL

Mon - Sat

07:30 PM - 10:00 PM ( IST )

06

AUG

Mon - Fri

11:00 AM - 02:00 PM ( IST )

11

AUG

Sat - Sun

05:30 AM - 06:30 AM ( IST )


Total Learners

750 Learners


LMS Access

365 days

Course duration

30 days


Support

24/7 support

Can't find convenient schedule?

Our experts can help you find a batch that meets your needs

The Instructor for this course is from one of the Big5 Companies in the world.

Drop us a Query

I agree to the Training T&C

Modes of Training

Corporate Training

Live, Classroom Or Self Paced Training

Online Classroom

Attend our Instructor Led Online Virtual Classroom

Self Paced Training

Comprehensive Recorded Videos by Experts to learn at your own pace

Course Features

Live Instructor-led Classes

This isn't canned learning. Its dynamic, its interactive, its effective

Expert Educators

Only the best or they're out. We are constantly evaluating our trainers

24&7 Support

We never sleep. Need something answered at 3 am? No Problem

Flexible Schedule

You don't learn as per our calendar. We work according to yours

☰ Details

Course Curriculum

Introduction to QlikView

  • What is BI?
  • Introduction to Visualization
  • Different BI Tools
  • What is QlikView?
  • Features and components of QlikView
  • Architecture
  • Installation & Navigation
  • Data Ingestion
  • Report Interface
  • QVS, QVW and .log files
  • Sheet Objects
  • Dimensions and Expressions
  • Presentation/ Layout / Sort tabs

Data Model

  • QlikView Data File Types: QVD, QVX
  • System fields
  • Star schema
  • Synthetic Key Tables
  • Circular References & its causes
  • Ways to Resolve Synthetic Keys and Circular Reference
  • Using Qualify & unqualify
  • Link Table
  • Concatenation: Forced, Auto, No
  • Data Model optimization
  • Master Calendar

Data Transformation

  • Generating data in the QlikView Script
  • Different Type of Loads
  • Incremental load with QVD file
  • Column manipulation
  • Tables: Rotating, Straight and Pivot, Cross
  • Mapping Table
  • Security – Section Access and Control

Data Analysis

  • Set Analysis (Indirect Set Analysis, Identifiers, Modifiers & Operators)
  • What-if Analysis
  • Comparative Analysis
  • Dynamic Reporting or Ad-hoc Reporting.
  • Document Channing
  • How to select range of Dates
  • Information density Subset Ratio and Perfect Key
  • AND Mode
  • Document Analyzer
  • Exception Handling
  • Buffer load
  • Qlikview cals
  • Qlikview sap connector
  • Qlikview sales force connector
  • Macro
  • Geolocation
  • Web Connectors
  • Conditionally Enabling Dimensions

Handling Sheets And Sheet Objects In QlikView

  • Introduction to QlikView Sheets
  • Logical connections between QlikView sheets
  • Adding a QlikView sheet
  • Moving a QlikView sheet
  • Adding new sheet objects
  • Saving, closing and exiting in QlikView 

Loading Data Into QlikView

  • Load data from different data sources, also know-how to place restrictions while loading data into QlikView. 
  • Looking at a delimited text file in QlikView, 
  • Creating a new QlikView document
  • Loading a text file into QlikView 

Working With Multi Boxes,Table Boxes And Input Boxes

  • You will be able to show data in a very compact way in QlikView 
  • Also how input boxes can be used for interactive input of data.
  • QlikView multi box
  • QlikView table box using an input box.

Explore Sliders, Current Selection Objects And Bookmarks

  • The slider/calendar object (in slider mode)
  • Creating a Current Selections box in QlikView
  • Creating a bookmark object in QlikView
  • Saving, closing and exiting 


Associating Data From Many Tables And Concatenating Tables

  • QlikView Associations
  • Loading and associating a second table
  • Renaming fields in QlikView
  • Automatic concatenation in QlikView
  • Forced concatenation in QlikView 

Working With Security Features

  • Sections in the Script
  • QlikView Access levels
  • QlikView Security fields
  • Loading security tables in QlikView
  • Using the Security pages in QlikView
  • Opening a QlikView document with access restriction 

Course Description

What are the objectives of this Qlikview Certification Training?

  • Use multiple charts, tables, synthetic Key tables and resolve the synthetic keys and circular reference.
  • Understand data file types and incremental load.
  • Understand what is QlikView. How does it work? What makes it a useful tool in analytics domain?
  • Gain rich experience on generating data using QlikView scripts, working with sheet objects and creating dashboards.
  • Perform object field formatting.

Why should you go for this Qlikview Training?

  • QlikView is a Self-Service Business Intelligence, Data Visualization and Data Analytics tool.
  • With this humongous amount of data and real business implications, business organizations across the world have the need for an easy to use tool to analyze the data and derive actionable insights from it.
  • QlikView helps organizations to extract meaningful information and perform visualizations on the data. Many companies worldwide have truly transformed the way they uncover insights from data by using QlikView.


Who should go for this Qlikview Course?

  • Business Analysts
  • Business Intelligence Manager
  • Data Scientist
  • BI /ETL/DW Professionals
  • Statisticians and Analysts
  • Graduates aiming to build a career in Visualization & Analysis

FAQ

Do you have self paced training?

Yes, we offer self paced training

How do you provide training?

We offer three different modes of training. Instructor Led Live Training, Self Paced Training and Corporate Training

Do you offer any discounts?

Yes we offer discounts for group of 3 plus people.

Can I choose timings that suits my schedule?

Yes we are the only company where we work with students and offer flexible timings which fits your schedule

Who are the Instructors?

All our instructors are from MNC companies who have real time experience of more than 10 years.

Can I attend a demo session before joining?

Yes we offer a free demo session with the instructors. The trainer will answer all your queries and share the course agenda.

Course Reviews

Sruthi

All the training videos for the QlikView training have been created by industry professionals giving learners an edge in the real world and I have gained much knowledge from this QlikView Training.

Sneha

I was a beginner before taking this course but I learnt a lot of useful stuff about the scripting part of Qlikview. Thank you.

Shilpa

The course is very helpful for those who want to learn it from sratch. Liked it. Thanks