QLIKVIEW Online Training

 >>  QLIKVIEW Online Training

QLIKVIEW Online Training


 (4.9) | 156 Ratings


Introduction


QLIKVIEW Online Training Details
Track Regular Track Weekend Track Fast Track
Course Duration 30 Hrs 8 Weekends 5 Days
Hours 1hr/day 2 Hours a day 6 Hours a day
Training Mode Online Classroom Online Classroom Online Classroom
Delivery Instructor Led-Live Instructor Led-Live Instructor Led-Live


Course Curriculum

QlikView 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

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

QlikView project

 

Exam & Certification

0

Course Review

(4.9)
5 stars
4 stars
3 stars
2 stars
1 stars

Course Curriculum

QlikView 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

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

QlikView project

 

    Click here for Help and Support: info@sacrostectservices.com     For Inquiry Call Us:   +91 996-629-7972(IND)

  +91 996-629-7972(IND)
X

Quick Enquiry

X

Business Enquiry