Online | Self-Paced | Corporate
QlikView Training
Tekslate is widely known for providing the most comprehensive and industry-relevant QlikView certification training course all over the world. As part of this training, you will master the core as well as implied concepts of QlikView, its products, relationships, scripting, deploying, designing, and many other concepts. After the course completion, you will achieve proficiency in deriving the analytics and insights.
Curriculum
A complete index of
job-ready skills curated
to meet the industrial need.
Explore.
Dataware House Concepts
4 Schemas
Star Schema
Snowflake Schema
5 Starting of QlikView(QV)
Installation of Qlikview
How to start the QlikView (QV)
Script Edit ( Cntrl +E)
Reload (Cntrl +R)
Loading Data from files
Creation of QVD file
Load and Store of QVD file in QlikView(QV)
QVD introduction & Joins
7 QVD Files
Purpose
Create QVD files
Reading Data from QVD files
8 Joins in Qlikview(QV)
How to use joins in QlikView(QV)
Left, Right, Inner, Outer
DSN Creation - ODBC\OLEDB
10 Concept of DSN
What is DSN
How to create the DSN
ODBC and OLEDB
Loading Data from Database
Loading Data from QVDs
11 Staging Structure (Architecture)
What is staging
What is Folder Structure
Why it is necessary
Standard folder Structure
Qlikview Objects
Objects in QlikView(QV)
What is Object
Types of Objects
Properties of Objects
Discussion on List Box object
Discussion on Statistics Box object
Discussion on Multi-Box object
Discussion on Current Selection Box Object
Input Box Object
Button
Text Object
Line/Arrow
Slider/ Calendar
Bookmark Object
Search Object
Container Object
Charts - Qlikview
Charts in QlikView(QV)
Introduction
Chart Properties
Bar Chart
Line Chart
Combo Chart
Radar Chart
Scatter Chart
Grid Chart
Pie Chart
Funnel Chart
Block Chart
Gauge Chart
Pivot Table
Stright Table
Qlikview Navigation - Examples
QlikView Application Samples
Look up different QlikView Applications
Dashboard
Synthetic Key
What is Synthetic Key
How the Synthetic Key generated
How to remove the Synthetic Key
What is Circular Reference
How to remove Circular Reference
Edit Script Dialog
SET and LET statement
Table Viewer
Master Calendar
Master Calendar
Calendar Creation
Purpose of Calendar
Date and Time function
Concept of Autogenerate() function
Tasks
Date() and Date#()
Display Fiscal Year
Display Today()
Display Week number
Display Week name
Display Months
Display Years
Display Quarter
Display Fiscal Month Number
Display Fiscal Month Name
Display Fiscal Quarter
Variables
Variable
What is Variable
Why it is used
Variable declaration
MTD & YTD Concepts
MTD
LMTD
YTD
LYTD
LYMTD
If Condition vs SET Analysis
Conditional Expression
If …….Else statement
Nested If …….Else statement
SET Analysis
Introduction
Concept Of Set Analysis
SET Analysis
SET Analysis
Use of Set Analysis
Syntax
Direct Set and Indirect Set
Tasks SET Analysis
Data Mode
Data Model Introduction
Revising on Joins
Concatenation
Concatenation Types
Loading Data from a Previously Loaded table (Resident)
Data Model Preparation
Creating a Data Model with Sample Data
Data Model Preparation
Data Model Preparation
Creating Data Model with Sample Data
Optimization
Demonstration of Live Application
Optimized Load
Other Concepts
Task
Incremental Load
Incremental Load Concept
Functions in Qlikview
Review of Data Model Preparation
Discussion on Functions
Other important functions with examples
Examples On Accumulation
Practice on charts
Scenarios in Qlikview
Set Analysis
Task
Section Access
Section Access
NT NAME
USER ID
Actions and Triggers
Actions on Objects
Triggers
Project Explanation
Practice Test & Interview Questions
Tekslate offers advanced QlikView interview questions and answers along with QlikView resume samples. Take a free sample practice test before appearing in the certification to improve your chances of scoring high.
We have made a tailored curriculum covering the latest industry-ready concepts to serve every individual’s learning desires.
We bring you the best learning experience by delivering all our training sessions practical. Following are the few use cases we shall discuss during the training.
1. What are the QlikView Training course objectives?
Upon the course completion, the student will be able to:
Implement QlikView Data modeling , visualization, and Qlikviewrporting
Learn how to create a qvd file in QlikviewDesktop
Learn the basic steps of transformation
Learn about data and BI visualization
Create different types of charts and integrate them in dashboard for analysis
Learn how Qlik reads data from various tables
Understand Qlikviewset analysis and how to implement it in QlikView
Understand chart level functions and script level Qlik function?
Know QlikView Security and Qlikview access point?
Develop a real-time project using Qlikview and prepare yourself for Qlikview certification
2. Why should you learn QlikView?
QlikView is the on-demand technology with numerous job opportunities for Certified QlikView professionals across the Globe.
Many MNCs are recruiting QlikView practitioners across the world.
The average salary of a “QlikView” professional is $124,061/year.
3. Who should attend QlikView training?
Project Managers
Testing Professional
Business and Reporting professional
Software Developers and Architects
Graduates aiming to build a career in Visualization & Analysis.
Business Analyst.
4. What are the prerequisites for learning QlikView training?
As there no prerequisites for this course. Anyone who is having enthusiasm for learning this course can attend this training. Having a basic knowledge of SQL, DWH, RDBMS will be beneficial.
5. What projects are included in this QlikView training course?
We will provide two real-time projects under the guidance of a professional trainer, who will help you in acquiring in-depth knowledge on all the concepts involved in these projects.
We got solutions for everyone looking for an AWS Architect course. Opt in for your convenient upgrade option, and we will guide you through.
Duration |
One-on-one Session |
Support |
Resources |
Time |
Fee |
Live Online. |
28 Hours |
Yes |
24x7 |
Additional tips from the trainer |
30 July 2024, 07:00 AM 03 August 2024, 08:00 AM |
Self-Paced |
28 Hours |
No |
Weekdays & Working Hours |
Accessible through LMS |
At your convenience |
Schedules Doesn't Suit You ?
Our Team can set up a batch at your convinient time.
Customized training options
Tailored curriculum to fit your project needs.
Practical exposure is assured.
We have got everything covered for any IT upgrade for your organization. We are one click away.
Have questions? We’ve got the answers. Get the details on how you can grow in this course.
1. Who are the trainers?
2. What if I miss a class?
3. How will I execute the practical?
See if this course is a fit for you by joining us for an online info session. You’ll meet our team, get an overview of the curriculum and course objectives, and learn about the benefits of being a student at Tekslate
1/15