QlikView Training

Supreme IT learning  QlikView Training: BECOME JOB READY in Business Analytics world by learning how to create real-world Analytical Visualizations with the QlikView. You will also get an opportunity to work on industry based projects and become Qlikview Certified. Course Curriculum Introduction The QlikView training introduction module is presented to let you know that it […]

Supreme IT learning  QlikView Training: BECOME JOB READY in Business Analytics world by learning how to create real-world Analytical Visualizations with the QlikView. You will also get an opportunity to work on industry based projects and become Qlikview Certified.

Course Curriculum

Introduction

The QlikView training introduction module is presented to let you know that it is a flexible business intelligence platform, for turning data into knowledge.

What are QlikView Conventions

QlikView General conventions

Keyboard conventions and Regional settings

QlikView Basics

The basic Qlikview online training module, aims at familiarizing the QlikView environment to you, showing how to start off with QlikView, commonly used terminology includes server, bookmarks etc….

Starting QlikView

The QlikView Start Page

Opening a document

Saving a document in QlikView

Basic QlikView terminology

Closing a document in QlikView

Help Using Documents on a QlikView Server

Selections Stepping back or forward in the list of selections

Locking and unlocking selections

Searching values in Selection bookmarks in QlikView

Saving your work and Checking your work

 

Handling Sheets And Sheet Objects In QlikView

After having a good understanding of the QlikView basics, lets move on to the next level of knowing all about ‘sheets’.

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

By the end of this module, you will be able to 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

List Boxes And Statistics Boxes

This module introduces the list box and the statistics box in QlikView, how to add, copy, move, size and remove a list box, you’ll also modify its appearance and its way of displaying data.

Opening the QlikView document

Exploring the list box

Exploring statistics box in QlikView

Bar Charts And Pie Charts In QlikView

This module will start by giving you a general introduction of working with charts in QlikView; starting with creating a simple bar chart and finally turn it into a pie chart.

 

Introduction of Making selections in a chart, Changing chart types in QlikView

Creating a bar chart using the Quick Chart Wizard in QlikView

Creating a bar chart using the full chart wizard in QlikView

Removing a chart from QlikView

Changing a few QlikView chart properties

Cloning and detaching your chart

Turning the bar chart into a pie chart

QlikView Pivot Tables And Straight Tables

In this module, after adding a dimensions to an existing bar chart, you will now learn how to turn it into a pivot table and subsequently create a straight table in QlikView containing the same information.

Adding a dimension to bar chart in QlikView, Creating a straight table

More Chart Types In QlikView

This module introduces further more QlikView chart types, like line chart, combo chart, scatter chart, etc…

Creating a line chart

Adding an expression to a bar chart in QlikView

Turning the bar chart into a combo chart

Turning the combo chart into a scatter chart

Creating a scatter chart from scratch in QlikView

Creating a gauge chart in QlikView

Working with drill-down functionality in QlikView

Copying to Clipboard and printing

Working With Multi Boxes,Table Boxes And Input Boxes

By end of this module, 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 Buttons,Text Objects And Line/Arrow Objects

Buttons are used for carrying out commands in an easy way, or for exporting data. Learn much more about buttons, text object, line/ arrow objects in this module of QlikView

The QlikView text object

The line/arrow object

The button in QlikView

Explore Sliders, Current Selection Objects And Bookmarks

Learn the three additional types of sheet objects which can be used to make QlikView documents more user friendly, in this module.

The slider/calendar object (in slider mode)

Creating a Current Selections box in QlikView

Creating a bookmark object in QlikView

Saving, closing and exiting

QlikView Document Properties, User Preferences And Reload

At the end of this module, you will learn how to reload data from the data sources that contain the data shown in your QlikView document.

Creating a  QlikView Document

Setting QlikView Document

Properties,User Preferences & Reloading data into QlikView

Checking your work

Associating Data From Many Tables And Concatenating Tables

In this module, we will train you how to associate different tables that have fields in common or alternatively, even merge tables through concatenation.

QlikView Associations

Loading and associating a second table

Renaming fields in QlikView

Automatic concatenation in QlikView

Forced concatenation in QlikView

Working With QlikView Tables And QlikView Layout Themes

This module will acquaint you to the table structure, how to assign suitable table names while loading them and how to “extract” layout settings from an existing QlikView document to a theme file, and then apply the same settings to the new document.

Using the  QlikView Table Viewer

Labelling tables in the script

Improving the QlikView layout

Creating a theme in QlikView

Applying a theme in QlikView

Loading Additional Files

In this module, you will learn how to load a tab separated text file without field names. Moreover, you will get an introduction to loading files via the ODBC interface.

Loading a tab separated file without labels, Loading a file via OLE DB

Linking External Information to a QlikView Document

Besides associating and concatenating tables in QlikView that contain data, it is also possible to link information to field values in the data, we’ll see how to do that in this module.

Looking at an info table

Loading the info table in QlikView

Viewing the linked information

Embedding external info into QlikView

Displaying info in a text object

More About Associations

We’ll learn how system sheet is created in QlikView and its importance in this module.

Creating a QlikView system sheet

Using the QlikView system sheet

Creating a system table

Showing frequency in key fields

 

Exploring QlikView Load Inline, Field Groups and Cyclic Display

Using Load Inline, you can add data directly by entering it into QlikView, also the importance of using Field groups and cyclic display will be explained.

Adding a record with Load Inline

Adding a table with Load Inline

Field groups in QlikView

Cyclic display of expressions in QlikView

Loading Cross Tables

The procedure of loading cross tables, featuring a matrix of values between two orthogonal lists of header data will be demonstrated in this module of QlikView

Loading a cross table into QlikView

Loading a cross table with more than one regular column into QlikView

And-Mode in a List Box

This module features a list box set to ‘and-mode’, which you will use for regular selections as well as for not-selections.

Making an ‘and-selection’ in QlikView

Making a ‘not selection’ in QlikView

Characteristics of the ‘and table’ in QlikView

Explore Number Formats

This module deals with the basics of number interpretation and number formatting.

Handling and Interpretation of numeric data in QlikView

Formatting of data in QlikView

Working With Security Features

It is important that information is distributed only to those who have rights to see it. This module  refers to  security settings in QlikView that are built in the script of the document.

 

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

Practice Test & Interview Questions

Supreme IT learning  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.

 

QlikView training is specialized in creating visualizations, dashboards, and apps that answer most of the enterprise queries. The course puts more profound insights to help build own rich, guided analytics applications with a flexible and business-ready solution. Learning Outcomes / QlikView Course Objectives: QlikView Conventions Basic QlikView terminology Charts in QlikView Loading cross tables Working with Security Features Related Jobs and Positions in the Industry QlikView Training expertise in Business Analytics and explore knowledge on required real-world Analytical Visualizations. It mainly focuses on aiding perfect product knowledge, specifically regarding the addition and modification of objects such as gauges, charts, tables and other application objects.
As such there are no prerequisites for Qlik training. However, with many opportunities in the field, the following job roles will get benefited from this course: Designers BI analysts Software developers IT architects Reporting professionals Testing professionals Aspirants aiming for a career in the prospective field.
An in-depth knowledge of a QlikView project ensures all the critical components are well-covered. With this experience, you can increase your visibility and enhance your efficiency in drawing real connections among different components of QlikView. We will also provide the complete material with QlikView interview questions covering all the aspects of this project.

Be the first to add a review.

Please, login to leave a review
30-Day Money-Back Guarantee

Includes

Full lifetime access
Access on mobile and TV
Supreme IT Learning Enquiry Form!

We are glad that you preferred to contact Supreme IT Learning. Please fill our short form and one of our friendly team members will contact you back shortly.

X
Enquiry Form!