Browse

QlikView Developer and Server Training (Free Data Warehousing and ERwin Course)

Our QlikView certification masters’ program lets you gain proficiency in QlikView Developer and Server. We provide the best online training classes to help you learn QlikView Desktop, applications, installation, configuration, reports, administration, cluster, testing and troubleshooting. As part of this training, you will be working on real-world projects.

Free Data Warehousing and ERwin course

Key Features

34 Hrs Self-paced Videos
68 Hrs Project work & Exercises
Certification and Job Assistance
Flexible Schedule
Lifetime Free Upgrade
24 x 7 Lifetime Support & Access

QlikView Developer and Server Training Overview

You can be proficient in all concepts of QlikView concerning the Desktop and Server Administration through this comprehensive combo training course in QlikView. This has been specifically created to cater to the industry needs. Some of the topics included in this combo course are QlikView Desktop, QlikView Application, QlikView Server, working with scripts, charts, QlikView Cluster, testing and troubleshooting.

What will you learn in this training course?

  1. Core architecture of QlikView
  2. Deploying various visualization and modeling techniques
  3. QlikView Objects like sheets, charts and list boxes
  4. QlikView Server and how it works with Windows
  5. Server installation, maintenance, firewall and antivirus
  6. Distinction between Server and Publisher
  7. Load balancing, clustering, LUN and failover
  • Software Developers, IT Architects, Analytics and Testing Professionals
  • Business Intelligence and Reporting Professionals
  • Graduates eager to build a career in BI and Data Visualization

A basic knowledge of the working of SQL is an added advantage for taking up this course but not mandatory.

QlikView is in the Leaders quadrant in the Gartner Magic Quadrant, and this combo training course will equip you with all skills needed to implement QlikView on any system and deploy it for creating great data visualization. This shall provide you ample opportunities for working in top companies on the QlikView Desktop application and deploying data discovery tools. This can help you rise in your career for sure.

View More

Talk To Us

Course Fees

Self Paced Training

  • 34 Hrs e-learning videos
  • Lifetime Free Upgrade
  • 24 x 7 Lifetime Support & Access
$360
$0

Corporate Training

  • Customized Learning
  • Enterprise grade learning management system (LMS)
  • 24x7 support
  • Strong Reporting

Course Content

QlikView Course Content

Introduction to Qlikview preview videos

Introduction to the concepts of Business Intelligence, learning about QlikView, 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.

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.

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

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

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

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

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

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

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

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

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

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

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

Qlikview Server Course Content

Introduction to QlikView Server, its features and capabilities, understanding how it works with Windows, configuration and services.

Introduction to QlikView Architecture, working with Microsoft IIS, learning how to decide on the Server size, factors to consider before going in for scaling the Server.

Learning about QlikView licensing, managing and controlling the licensing group, the different ways to distribute licenses, restricting rights using NAMED CAL user.

QlikView Windows authorization, access rights to users, the rules to follow while assigning Windows authorization, managing the Windows authorization.

Learning about the various prerequisites for QlikView installation, the ports to enable to communicate with QlikView licensing server, things not to pre-install in QlikView Server, managing the firewall and antivirus.

The set-up for Server installation, the detailed process of Server installation, learning to distribute the QlikView components in various Server boxes, the components that are available upon installation, QlikView Server licensing.

Introduction to QlikView Management Console, main portal to configure and manage QlikView Server, application of license, managing licenses and services.

The QlikView license distribution and policy management, providing various rights to various user segments.

Learning how to organize various QlikView folders, introduction to QlikView Distributed Services and QlikView Web Server.

Learning about QlikView Security management, the security group policies, the external security architecture, license lease and masking of connection.

Managing the QlikView documents, categories of distribution, securing the documents, collaboration and sharing of sessions, learning about CAL & DOC CAL.

The various issues faced during working with Windows, administration and access denied issues, resolving the problems.

Understanding the features of QlikView Publisher, difference between the Server and the Publisher, Server and Publisher management.

Learning how Publisher extends the capabilities of the Server, the distribution function of the Publisher, Publisher security group, access group section.

Working with QlikView Publisher, understanding distribution, configuration of distribution group, task scheduling, looping and reducing, learning what is source document, dependencies.

Understanding the concept of hyper-threading, deploying various optimization techniques for scaling server performance, testing of documents, dependencies, using source library XMLs and log files.

Understanding the need for QlikView clustering, the architecture of clustering.

Understanding how to deploy clustering in a Windows environment, working with sandbox, LUN management and failover procedure.

Working with various testing tools, the recommendations for scaling.

Monitoring, System Admin Apps, Firewall issue, Antivirus issue, Log file checking.

View More

Free Career Counselling

QlikView Developer and Server Projects

What projects I will be working on this Qlikview training?

Project : 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

Project – Publisher

Topics – This project is involved with working on the QlikView Publisher. You will learn about creating tasks using the QlikView Publisher the most common of which include the distribution, loop & reduce or external tasks. As part of the project you will gain hands-on experience in QlikView job scheduling and distribution and also QlikView file distribution. Learn about the strength of QlikView Publisher in providing a centralized control when it comes to managing QlikView files. You will have complete freedom when it comes to reloading and distributing of files and also scheduling it for access via email and intranet.

View More

QlikView Developer and Server Certification

This course is designed for clearing two exams:

  • QlikView System Administrator Certification
  • QlikView Developer Certification

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 quizzes that perfectly reflect the type of questions asked in the certification exams and help 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.

Our Alumni works at top 3000+ companies

client-desktop client-mobile

QlikView Developer and Server Training Review

 course-reviews

Mr Yoga

 course-reviews

John Chioles

 course-reviews

Ritesh

 course-reviews

Dileep & Ajay

 course-reviews

Sagar

 course-reviews

Ashok

Harry Poul

Sr. Business Intelligence Analyst

This course provided complete in and out of QlikView Development and Administration environment. The entire session was highly interactive as the trainer had in-depth knowledge of all aspects.

R Dutta

Senior Software Engineer at HCL Technologies

Course was good, but what I liked the most was the support I got from Intellipaat. The team was amazing, whenever I encountered any problem. Overall, a great experience!

Frequently Asked Questions on QlikView Developer and Server

Why should I learn QlikView Developer and Server from Intellipaat?

Intellipaat provides an industry-leading training in QlikView Developer and Server that is much sought-after in the corporate world. QlikView is a powerful BI tool, and this training equips you with the best of Desktop and Server training in QlikView. You will gain full proficiency in working with QlikView administration, application, deploying QlikView charts and clusters and also testing and troubleshooting in QlikView.

The entire course material is completely in line with clearing QlikView Developer Certification and QlikView System Administrator Certification exams. 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.

At Intellipaat, you can enroll in either 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, which has made them subject matter experts. Go through the sample videos to check the quality of our trainers.

Intellipaat is offering the 24/7 query resolution, and you can raise a ticket with the dedicated support team at anytime. You can avail of the email support for all your queries. If your query does not get resolved through email, we can also arrange one-on-one sessions with our trainers.

You would be glad to know that you can contact Intellipaat support even after the completion of the training. We also do not put a limit on the number of tickets you can raise for query resolution and doubt clearance.

Intellipaat offers self-paced training to those who want to learn at their own pace. This training also gives you the benefits of query resolution through email, live sessions with trainers, round-the-clock support, and access to the learning modules on LMS for a lifetime. Also, you get the latest version of the course material at no added cost.

Intellipaat’s self-paced training is 75 percent 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.

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 real-world industry setup. All training comes with multiple projects that thoroughly test your skills, learning, and practical knowledge, 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. After completing the projects successfully, your skills will be equal to 6 months of rigorous industry experience.

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 such as Sony, Ericsson, TCS, Mu Sigma, Standard Chartered, Cognizant, and Cisco, among other equally great enterprises. We also help you with the job interview and résumé preparation as well.

You can definitely make the switch from self-paced training to online instructor-led training by simply paying the extra amount. You can join the very next batch, which will be duly notified to you.

Once you complete Intellipaat’s training program, working on real-world projects, quizzes, and assignments and scoring at least 60 percent marks in the qualifying exam, you will be awarded Intellipaat’s course completion certificate. This certificate is very well recognized in Intellipaat-affiliated organizations, including over 80 top MNCs from around the world and some of the Fortune 500companies.

Apparently, no. Our job assistance program is aimed at helping you land in your dream job. It offers a potential opportunity for you to explore various competitive openings in the corporate world and find a well-paid job, matching your profile. The final decision on hiring will always be based on your performance in the interview and the requirements of the recruiter.

View More

Talk to us

Recommended Courses

Select Currency