Attend a Demo Session | Meet the Expert Who Can Kickstart Your Career in QlikView
Course Duration | 28 hrs | ||
---|---|---|---|
Live Projects | 2 | ||
Next Batch | 17 April, 2021 |
The QlikView training-introduction module is presented to let you know that it is a flexible business intelligence platform, for turning data into knowledge.
1 Introduction to Business Intelligence (BI)
What is Business Intelligence (BI)
Features of Business Intelligence (BI)
Traditional Business Intelligence(BI)
2 QlikView
Introduction
Features of QlikView
Pros and cons of QlikView
QlikView navigation
Concept of Association in QlikView
3 Data Warehouse Concepts
Concept of Facts and Dimension
The fact table and Dimension table
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)
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
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
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 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 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
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
Variable
What is Variable
Why it is used
Variable declaration
MTD & YTD Concepts
MTD
LMTD
YTD
LYTD
LYMTD
Conditional Expression
If …….Else statement
Nested If …….Else statement
SET Analysis
Introduction
Concept Of Set Analysis
SET Analysis
Use of Set Analysis
Syntax
Direct Set and Indirect Set
Tasks SET Analysis
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
Creating Data Model with Sample Data
Demonstration of Live Application
Optimized Load
Other Concepts
Task
Incremental Load Concept
Review of Data Model Preparation
Discussion on Functions
Other important functions with examples
Examples On Accumulation
Practice on charts
Set Analysis
Task
Section Access
NT NAME
USER ID
Actions on Objects
Triggers
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.
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
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.
Project Managers
Testing Professional
Business and Reporting professional
Software Developers and Architects
Graduates aiming to build a career in Visualization & Analysis.
Business Analyst.
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.
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.
Have More Questions
Contact usHave questions? We’ve got the answers. Get the details on how you can grow in this course.
Have More Questions. Reach our Support Team
Contact usSee 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
Attend a Demo Session | Meet the Expert Who Can Kickstart Your Career in QlikView
By providing us with your details, We wont spam your inbox.