Browse

QlikView Training and Certification Course

The QlikView training by Intellipaat will help you to master QlikView data modeling, visualization, reports and dashboards. You will work on real-life projects in our QlikView course which is in line with QlikView Developer Certification exam conducted by Qlik.

Get Data Warehousing and ERwin course free with this course!

Key Features

  • Instructor Led Training : 24 Hrs
  • Self-paced Videos : 22 Hrs
  • Exercises & Project Work : 44 Hrs
  • Get Certified & Job Assistance
  • Flexible Schedule
  • Lifetime free upgrade
  • 24 x 7 Lifetime Support & Access

About QlikView 12 Training and Certification Course

This Intellipaat QlikView training course lets you master the QlikView software in order to derive business intelligence and discover visual insights. In this QlikView instructor-led online training, you will learn the skills needed for data interpretation, modeling, designing and deploying. You also get hands-on experience in QlikView applications.

What will you learn in this QlikView training?

  1. Implementing QlikView data modeling, visualization and reporting
  2. Creating QVD files in QlikView Desktop
  3. Steps of transformation
  4. Data and BI visualization with QlikView
  5. Creating different types of charts and integrating them in dashboard for analysis
  6. How Qlik reads data from various tables
  7. QlikView set analysis and how to implement it
  8. Chart-level and script-level Qlik functions
  9. QlikView Security and QlikView access points
  10. Developing a real-time project using QlikView
  11. Preparing for QlikView Developer Certification

Who should take up this QlikView online training course?

  • Designers, Business Intelligence Analysts and Reporting Professionals
  • Software Developers, IT Architects and Testing Professionals
  • Those eager to build a career in data visualization and discovery

What are the prerequisites for learning QlikView certification training?

You can take up this QlikView certification course without any prior skills.

Why you should learn QlikView online training?

  • Global Hadoop market to reach $84.6 billion in 2 years – Allied Market Research
  • Big Data and Analytics sales will reach $187 billion by 2019 – IDC Research
  • Qlik is among the Leaders quadrant in the Gartner Magic Quadrant for the sixth year – Gartner

QlikView is one of the most effective Business Intelligence software for analysis, data visualization and discovery tools available in the market today. It is being adopted by some of the biggest organizations in the world. Thus, professionals with QlikView skills and certifications are in much demand, and hence this Intellipaat QlikView tutorial provides you an opportunity to enter the hottest data visualization domain.

view more
Read Less

QlikView 12 Course Content

Introduction to Qlikview

Introduction to the concepts of Business Intelligence, learning about QlikView 12, the unique features of QlikView that make it the market leader, comparison to other BI tools, the complete overview and architecture of QlikView, studying the various file types and extensions.

Qlikview Products

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.

Introduction to Data and Scripting

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.

Loading Data From The DataBase

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

Structuring the Script

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.

Basic Data Model and Table Viewer

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.

Data Relationships

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

Hands-on Exercise – Use Join, Concatenation

Data Modelling Considerations

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

Qlikview Data (QVD) Files

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

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

Qlikview Security

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

Handling Null Values

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

Hands-on Exercise – Handle null values in QlikView

Sheets and Sheet Objects

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.

The List Box

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

The Table Box

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.

The Multi Box

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

The Button & Text Object

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

Charts

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

Multi Dimensional Charts, Pivot Tables

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

Gauges

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

The Other Sheet Objects

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

Additional Editing in The Layout

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

Uses Of Expressions

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

The Settings Menu

Learning about the settings menu in QlikView, the various options like user preferences, document properties and sheet properties.

Hands-on Exercise – Use settings menu in QlikView to set user preferences, document properties and sheet properties

Qlikview Functions

The various QlikView functions like ApplyMap, Lookup, Previous, Value List, Interval Match, Class, Value Loop, Peek, Pick, Match, Wild Match, Statistical Functions,Range Functions, etc.

Hands-on Exercise – Use functions ApplyMap, Lookup, Previous, Value List, Interval Match, Class, Value Loop, Peek, Pick, Match, Wild Match, Statistical Functions,Range Functions

Adhoc Reports and Bookmarks

Learning about ad hoc report creation and editing, introduction to QlikView bookmarks, the various types of bookmarks, creating and managing bookmarks.

Hands-on Exercise – Create ad hoc report, Edit the report, Create and manage bookmarks

Layout Themes

Understanding QlikView themes, creating, applying and working with dynamic themes.

Hands-on Exercise – Create, apply and work with dynamic themes

Extensions

Learning about QlikView extensions, visualizing of data with extensions, creating a simple HTML extension, HTML table, working with interactive extensions and external libraries with extensions.

Hands-on Exercise – Use QlikView extension for data visualization, Create a simple HTML extension, Work with interactive extensions

Set Analysis

Understanding set analysis, defining data values that are different from set definition, working with modifiers, identifiers, operators, example of expressions, indirect set analysis, YTD & MTD and rolling 12 months, various examples.

Hands-on Exercise – Work with modifiers, Identifiers, Operators, Expressions, Implement YTD & MTD and rolling 12 months

Alternate States

Understanding alternate states for performing comparative analysis on sets of multiple data items, working with market basket analysis, examples of various alternate states.

Hands-on Exercise – Perform comparative analysis on sets of multiple data items, Do market basket analysis

What-IF Analysis

Understanding what-if analysis in QlikView, working on creating variables, slider objects, assigning variables to sheet and slider objects.

Hands-on Exercise – Do what-if analysis in QlikView

Server Installation & Deployment

The process of installation, various types of licenses, types of CALS, learn to deploy the application on the server, working with server bookmarks, annotations.

Hands-on Exercise – Deploy an app on the server

view more
Read Less

QlikView Projects

What projects I will be working on this Qlikview training?

Project 1 – QlikView Dashboard creation using 3 principles of DAR

Industry : General

Problem Statement: How to successfully build QlikView applications using DAR

Topics : This project involves understanding the concepts of the QlikView Dashboard, Analysis, Reporting (DAR) methodology to creating and building of QlikView applications. This way you can reuse your earlier QlikView Worksheets with minimal changes thus saving you time and effort. You will have hands-on experience in designing the Dashboard, creating Analysis Page and ultimately develop the QlikView Reports with DAR implementation. You will learn about the business overview, deploying user-driven controls for data filters and reporting of specific details in this QlikView Dashboard project.

Highlight :

  • Getting high level overview with dashboard
  • Deploying QlikView analytics
  • Designing QlikView Reports.

Project 2 – Create a mini chart in QlikView application

Domain – Human Resource

Objective – To see the current values of salaries in one column and historical values in another cell in a mini chart that would contain a bar chart and a trend chart

Requirements :

  • Import data from an excel file using the Edit Script and Table Files options in QlikView
  • Configure properties of the table to select the columns to be shown in the chart
  • Display the data in a bar chart for current values of salaries
  • Display the historical values of salaries in another cell

Project 3

Domain – Healthcare

Objective – Visual Mapping between Vaccination rate and Measles outbreak

The description of the dataset is mentioned below

  • The data contains the vaccination records of each US state and the measles cases

Problem statement:

  • Plot measles outbreaks depending on the coverage of population
  • Plot measles infection cases before 1st dose, between 1st and 2nd dose and after the 2nd dose of measles vaccination
  • Plot the correlation between immunity when vaccination coverage is high within schools
  • Plot correlation between poor urban areas which were not vaccinated at high rate and other areas which were vaccinated properly
view more
Read Less Project

Sample QlikView Video Tutorials

view more
View Less Sample Videos

QlikView Certification

This training course is designed for clearing the QlikView Developer Certification exam conducted by Qlik. The entire course content is in line with the certification program and helps you clear the certification exam with ease and get the best jobs in top MNCs.

As part of this training, you will be working on real-time projects and assignments that have immense implications in the real-world industry scenarios, thus helping you fast-track your career effortlessly.

At the end of this training program, there will be a quiz that perfectly reflects the type of questions asked in the certification exam and helps you score better marks.

Intellipaat Course Completion Certificate will be awarded upon the completion of the project work (after the expert review) and upon scoring at least 60% marks in the quiz. Intellipaat certification is well recognized in top MNCs like Ericsson, Cisco, Cognizant, Sony, Wipro, Standard Chartered, TCS, Genpact, Tata Communication, etc.

view more
Read Less Certification

QlikView Training Review

view more
View Less Reviews Video
  1. Profile photo of joykumardas25 Joy kumar das 

    Awesome work, Intellipaat

    The learning material of the Intellipaat QlikView training was really worth it. There were large varieties of learning material, real-world examples, total interactivity in videos and more in this QlikView certification training. Awesome work, Intellipaat.

  2. Profile photo of seshadri.mandal Seshadri 

    Satisfied with training quality

    I have only positive words for the Intellipaat QlikView training support. Even if I put across the same query multiple times, they had patience to resolve it every time to my fullest satisfaction. Great job.

  3. Profile photo of robin dutta R dutta 

    Informative material

    This QlikView training course helped me in understanding this great Business Intelligence tool. The free tutorials and videos are extraordinary. I never knew that an online Business Intelligence training could be so comprehensive and easy to understand. Thanks, Intellipaat.

  4. Profile photo of Garima Modani Garima Modani 

    Amazing Videos

    I was just amazed at the quality of the video content in the Qlikview training and certification course from Intellipaat. It is beautifully segregated into logical blocks assisting learners grasp the subject in the best possible way. Thanks for the wonderful QlikView BI Reporting training.

  5. Profile photo of Tareg Alnaeem Tareg Alnaeem 

    Great QlikView Certification Course

    The Intellipaat online QlikView certification training is highly recommended since it makes learning so easy and enjoyable. The QlikView business analytics training course content is excellent and user-friendly.

  6. Khoa 

    Amazing Course

    The course is really nice and up to date...the course is awesome. :)

Frequently Asked Questions about Qlikview

Why should I learn QlikView from Intellipaat?

Intellipaat offers the most in-depth and comprehensive QlikView learning opportunity with the course content that is completely in line with the QlikView Developer Certification exam. QlikView is one of the best Business Intelligence platforms that delivers true self-service analytics and BI in order to drive business insights that are relevant, real-time and readily deployable.

You will be working on real-time QlikView projects and step-by-step assignments that have high relevance in the corporate world, and the course curriculum is designed by industry experts. Upon the completion of the training course, you can apply for some of the best jobs in top MNCs around the world at top salaries. Intellipaat offers lifetime access to videos, course materials, 24/7 support and course material upgrading to the latest version at no extra fee. Hence, it is clearly a one-time investment.

What are the different modes of training that Intellipaat provides?
At Intellipaat you can enroll either for the instructor-led online training or self-paced training. Apart from this Intellipaat also offers corporate training for organizations to upskill their workforce. All trainers at Intellipaat have 12+ years of relevant industry experience and they have been actively working as consultants in the same domain making them subject matter experts. Go through the sample videos to check the quality of the trainers.
Can I request for a support session if I need to better understand the topics?
Intellipaat is offering the 24/7 query resolution and you can raise a ticket with the dedicated support team anytime. You can avail the email support for all your queries. In the event of your query not getting resolved through email we can also arrange one-to-one sessions with the trainers. You would be glad to know that you can contact Intellipaat support even after completion of the training. We also do not put a limit on the number of tickets you can raise when it comes to query resolution and doubt clearance.
Can you explain the benefits of the Intellipaat self-paced training?
Intellipaat offers the self-paced training to those who want to learn at their own pace. This training also affords you the benefit of query resolution through email, one-on-one sessions with trainers, round the clock support and access to the learning modules or LMS for lifetime. Also you get the latest version of the course material at no added cost. The Intellipaat self-paced training is 75% lesser priced compared to the online instructor-led training. If you face any problems while learning we can always arrange a virtual live class with the trainers as well.
What kind of projects are included as part of the training?
Intellipaat is offering you the most updated, relevant and high value real-world projects as part of the training program. This way you can implement the learning that you have acquired in a real-world industry setup. All training comes with multiple projects that thoroughly test your skills, learning and practical knowledge thus making you completely industry-ready. You will work on highly exciting projects in the domains of high technology, ecommerce, marketing, sales, networking, banking, insurance, etc. Upon successful completion of the projects your skills will be considered equal to six months of rigorous industry experience.
Does Intellipaat offer job assistance?
Intellipaat actively provides placement assistance to all learners who have successfully completed the training. For this we are exclusively tied-up with over 80 top MNCs from around the world. This way you can be placed in outstanding organizations like Sony, Ericsson, TCS, Mu Sigma, Standard Chartered, Cognizant, Cisco, among other equally great enterprises. We also help you with the job interview and résumé preparation part as well.
Is it possible to switch from self-paced training to instructor-led training?
You can definitely make the switch from self-paced to online instructor-led training by simply paying the extra amount and joining the next batch of the training which shall be notified to you specifically.
How are Intellipaat verified certificates awarded?
Once you complete the Intellipaat training program along with all the real-world projects, quizzes and assignments and upon scoring at least 60% marks in the qualifying exam; you will be awarded the Intellipaat verified certification. This certificate is very well recognized in Intellipaat affiliate organizations which include over 80 top MNCs from around the world which are also part of the Fortune 500 list of companies.
Will The Job Assistance Program Guarantee Me A Job?
In our Job Assistance program we will be helping you land in your dream job by sharing your resume to potential recruiters and assisting you with resume building, preparing you for interview questions. Intellipaat training should not be regarded either as a job placement service or as a guarantee for employment as the entire employment process will take part between the learner and the recruiter companies directly and the final selection is always dependent on the recruiter.
view more
Read Less FAQ
Self-paced
$197
Lifetime Access and 24/7 Support
You have of in your cart.
Online Classroom
$500

$316

19

Oct
Sat & Sun
8 PM IST (GMT +5:30)

10

Nov
Sat & Sun
8 PM IST (GMT +5:30)

16

Nov
Sat & Sun
8 PM IST (GMT +5:30)

23

Nov
Sat & Sun
8 PM IST (GMT +5:30)
Drop Us a Query

Find QlikView Training in Other Regions

Bangalore, Melbourne, Chicago, Hyderabad, San Francisco, London, Toronto, New York, and India

Training in Cities: Bangalore, Hyderabad, Chennai, Delhi, Kolkata, UK, London, Chicago, San Francisco, Dallas, Washington, New York, Orlando, Boston

Training in Cities: Bangalore, Hyderabad, Chennai, Delhi, Kolkata, UK, London, Chicago, San Francisco, Dallas, Washington, New York, Orlando, Boston

Sign Up or Login to view the Free QlikView Training and Certification Course course.