Login

Register

Login

Register

Login

Register

Qlik View Course

Qlik View is a business discovery platform that provides self-service BI for all business users in organizations.

Qlik View Training Course Details

Qlik View Training Course Introduction

Qlik View is a business discovery platform that provides self-service BI for all business users in organizations.

With Qlik View you can analyze data and use your data discoveries to support decision making. Qlik View lets you ask and answer your own questions and follow your own paths to insight.
Qlik View enables you and your colleagues to reach decisions collaboratively.

At the core of Qlik View is our patented software engine, which generates new views of data on the fly.

QlikView compresses data and holds it in memory, where it is available for immediate exploration by multiple users.

For data sets too large to fit in memory, Qlik View connects directly to the data source.
Qlik View delivers an associative experience across all the data used for analysis, regardless of where it is stored.

You can start anywhere and go anywhere; and are not limited to pre-defined drill paths or pre-configured dashboards.

QlikView Training 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 Basics Qlikview online training module, aims at familiarizing the QlikView environment to you, showing how to start off with QlikView, commonly used terminology, server, bookmarks etc….
• Starting QlikView
• The QlikView Start Page
• Opening a document
• Saving a document in QlikView
• Basic QlikView terminology

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 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 modify its appearance and its way of displaying data.
• Opening the QlikView document
• Explore 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 working with charts in QlikView; starting with creating a simple bar chart and finally turn it into a pie chart.
• Introduction Making selections in a chart Changing chart types in QlikView using a fast type change icon
• 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 Turning a bar chart into a multi-dimensional pivot table 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

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 module of QlikView Training 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
• tenating 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.

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

Want to have a course urgently or on Fast track. We can arrange you for a specialised training aimed only for you. Please get in touch with us with your requirements by mail or just fill in the Batch Enquiry form. We will get in touch with you with the slot times and other details with in 24 hours

For Priority Training contact below
  • eITCafe: trainings@eitcafe.com
  • India: 040 6678 6677
  • US: 630-636-0198

Support services

We know how hard it can be to find and keep a job when there are so many other things to worry about. Our support team is here to help break down the barriers which are blocking your road to employment.
If you are a Working Chance candidate, please don’t hesitate to ask for advice or support on any issues which are affecting your chances of finding a job.
For further information, please email jobsupport@eitcafe.com our Support and Training Manager.

Job Preparation

• Assistance with learning job seeking skills
• Resume creation
• Master application completion
• Dressing for success
• Job interview preparation

Job Development

• Assistance with completing applications online or in person
• Job development online, on foot, networking events, job fairs and established employer relationships to locate available positions in your job goal
• Job leads and information on attending hiring events
• Follow-ups on applications placed to request interviews.

Set analysis in qlikview ?

Used for set of groups .. mostly used in arrgeted function like sum (year) used    sales of current year VS last year.

Difference between keep and joins ?

Left Keep and Left join gives the same output. The only difference is that Left Keep keeps the Table separate in Data Model, whereas Left join merges the Tables that are joined.

What is Incremental Load in qlikview?

As BI apps are expected to deal with larger and larger amounts of data the amount of time that it takes to retrieve that data becomes a serious issue.  This could be due to shear volume of data or the need for frequent refreshes. Either way, you do not want to be pulling all of the data all of the time. What you want to be able to do is just pull the data that has changed, append to that the data that you stored away previously and then get back to the business of analyzing.  This will reduce load on the source database, the network infrastructure and your QlikView server.

what is Set and let in QlikView and difference between it?

SET or a LET statement is often usedTo define the variable. The SET statement is used when you want a variableto hold the string or numeric value that is to the right of the Equal (=) sign.

The LET statement is used when you need to evaluate what is to the right of the Equal sign

e.g

set myVar=5*2   the result is “5*2″

Let myVar=5*2   the result is “10″

Explain QlikView Resident Load?

Create a new logical table in QlikView, based on a previously loaded (resident) table.

Key Features

Overview of Course and Learning analytic’s

teacher-75x75

Learn from Certified and Expert Trainers

Customized Course as per your requirement

24/7 online support for the course learners

High Quality E-learning Content for learning

videos

Access to the Recorded Sessions and classes

Flexible Course timing and Payment terms

Live Practical Oriented Approach for learners

Course Curriculam

Qlikview Course Module

This course compliments the learning in QlikView dashboards. The QlikView training content is a mixture of demonstrations and hands on exercises of many QlikView components.

The QlikView designer takes the students to the next level, focussing on the user interface design and delivers a more detailed knowledge on layout, design, best practices and reports.

The QlikView training focuses on providing good product knowledge, especially adding and modifying objects such as gauges, multidimensional charts, tables and other application objects.

Duration: 45 Days

Support: 24x7

Video: Yes

QLIKLVIEW Certified Professional