Qlikview Training

Learning about the various QlikView products, understanding about the QlikView Desktop, Server, Access Point, Publisher, the Management Console and NPrinting reporting platform.

Hands-on Exercise – Practice QlikView Desktop, Server, Access Point, Publisher, the Management Console and NPrinting reporting platform.

Understanding the data warehouse architecture, the concept of dimensional model, fact tables and dimensions, learning about Star and Snow Flake schema, QlikView data model comparison to other data models, understanding the data source files.

Hands-on Exercise – Understanding the data warehouse architecture, the concept of dimensional model, fact tables and dimensions, learning about Star and Snow Flake schema, QlikView data model comparison to other data models, understanding the data source files.

Learning about loading data from various databases, generating script, loading of text files, delimited text files, loading data from multiple data sources, various types of data loads like incremental, binary, resident, buffer, preceding, mapping load types, understanding how to load inline-table, generic tables, media content and image inclusion, web page data loading, semantic load, various examples to simplify the concepts.

Hands-on Exercise – Load data from a database, Generat script, Load a delimited text file, Load data from excel file, Load inline table, generic tables, media content,Include image, Load a web page data

Learning to create tabs in the scripts, debugging of scripts, inclusion of variables and comments in the scripts.

Hands-on Exercise – Create tabs in the scripts, debug a script, Include variables and comments in the scripts.

Understanding the basic data model of QlikView, learning to work with the Table Viewer, the System Table and System fields.

Hands-on Exercise – Work with the Table Viewer, the System Table and System fields.

Introduction to the various data relationships – Join, Concatenation, Join, and the different options available in each.

Hands-on Exercise – Use Join, Concatenation

The rules of data modeling in QlikView, introduction to circular references, synthetic key tables, resolving synthetic keys and circular references.

Hands-on Exercise – Resolve synthetic keys and circular references

Understanding what is QVD file in QlikView, the way to create QVD file, the standard structure of a QVD file, its various components, the various types and uses of QVD files, learning what is optimized and unoptimized load.

Hands-on Exercise – Create QVD file

Creating a master calendar in QlikView, extracting the highest and lowest data, deploying scripts to create variables, working with arbitrary date ranges.

Hands-on Exercise – Create a master calendar in QlikView, Extract the highest and lowest data, Deploy scripts to create variables, Work with arbitrary date ranges

Understanding the various concepts of QlikView security, defining the access controls, levels of access, maintaining the access control database, section access addition and other concepts.

Hands-on Exercise – Create the access controls rules, Create different levels of access, Access and Edit the access control database

The various types of null values in QlikView and the different methods to handling them.
Sheets and Sheet Objects

Hands-on Exercise – Handle null values in QlikView

Working with QlikView sheets and sheet objects, learning about the sheet basics, cross tables, the data transformation in QlikView, transposing a physical table.

Hands-on Exercise – Perform a data transformation in QlikView, Transpose a physical table.

Understanding a list box, most basic sheet object, the various actions in List Box, its properties, the example of a list box.

Hands-on Exercise – Use a list box and assign actions to it

A sheet object that shows several fields simultaneously, learning to create a table box, sorting in table box, understanding table box formatting options, printing the data from table box, exporting to a text file.

Hands-on Exercise – Create a sheet object that shows several fields simultaneously, Create a table box, Sort data in table box, Format data in a table box, Print the data of table box, Export data to a text file.

Representation of value from multiple fields, learning to create a multibox, the various selection features, formatting and resizing of multiboxes.

Hands-on Exercise – Create a multibox, Select data using different criteria, Format and Resize a multiboxe

Working with text and button objects, learning to create them, formatting, resizing, copying and moving of text objects, understanding of action scripts in button and text objects.

Hands-on Exercise – Create text and button objects, Format, Resize, Copy and Move text objects, Run action scripts in button and text objects

Learning the basics of QlikView Charts, graphical representation of numerical data, various types of charts like bar, pie, grid, funnel, combo, learning to create charts, selections in charts and exporting of charts.

Hands-on Exercise – Plot charts like bar, pie, grid, funnel, combo, Make selections in charts and export charts

Introduction to multidimensional charts, setting up multiple expressions in straight table and pivot table, learning about straight table and pivot table, table box and deploying visual cues.

Hands-on Exercise – Plot multidimensional charts, Set up multiple expressions in straight table and pivot table, Deploy visual cues

Learning about Gauge Chart in QlikView, the various types of Gauges, understanding how to build Gauges, the various types of Gauge Charts.

Hands-on Exercise – Build Gauge chart in QlikView

Introduction to the other sheet objects like Statistics Box, Slider/Calendar Object, Current Selections Box, Bookmark Object, Container Object, and Input Box.

Hands-on Exercise – Create sheet objects like Statistics Box, Slider/Calendar Object, Current Selections Box, Bookmark Object, Container Object, and Input Box

The additional editing like settings of type legend, title, fast change chart type, text in chart and reference lines, caption settings and drilldown, cyclic functionality.

Hands-on Exercise – Set up type legend, title, captions

Learning about the various expressions like chart attribute, colour, working with calculated fields, labels, and dynamic text in text objects, calculated fields and dimensions in list boxes and charts.

Hands-on Exercise – Create chart attributes, Assign colour, Work with calculated fields,Create dynamic text in text objects