- Combo Offers (48)
- Big Data (48)
- Data Science (11)
- Business Intelligence (43)
- Salesforce (2)
- Cloud Computing (3)
- Mobile Development (2)
- Digital Marketing (5)
- DataBase (8)
- Programming (13)
- Testing (5)
- Project Management (9)
- Website Development (5)
Home / Business Intelligence / Qlikview Developer and Server Training
Qlikview Developer and Server Training (Free DWH & Erwin)
Our QlikView certification master 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, troubleshooting. Work on real world projects.
About Course
What you will learn in this Training Course?
- Understand the core architecture of QlikView
- Deploy various visualization and modeling techniques
- QlikView Objects like sheets, charts and list-boxes
- Study QlikView Server and how it works with Windows
- Server installation, maintenance, firewall and antivirus
- Distinction between Server and Publisher
- Learn about Load balancing, clustering, LUN and failover.
Who should take this Training Course?
- Software Developers, IT Architects, Analytics and Testing Professionals
- Business Intelligence and Reporting Professionals
- Graduates eager to build career in BI and data Visualization
What are the prerequisites for taking this Training Course?
Why should you take this Training Course?
Qlikview Course Content
Introduction to Qlikview
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.
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
Qlikview Server Course Content
QlikView Server Definition
Introduction to QlikView Server, its features and capabilities, understanding how it works with Windows, configuration and services.
Architecture & Scaling
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.
Licensing & Policies
Learning about QlikView licensing, managing and controlling the licensing group, the different ways to distribute licenses, restricting rights using NAMED CAL user.
Windows Authorization
QlikView Windows authorization, access rights to users, the rules to follow while assigning Windows authorization, managing the Windows authorization.
Installation Prerequisites
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.
Server Installation
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.
QMC & Configurations
Introduction to QlikView Management Console, main portal to configure and manage QlikView Server, application of license, managing licenses and services.
License Distribution & Policies
The QlikView license distribution and policy management, providing various rights to various user segments.
Service Management
Learning how to organize various QlikView folders, introduction to QlikView Distributed Services and QlikView Web Server.
Security Management
Learning about QlikView Security management, the security group policies, the external security architecture, license lease and masking of connection.
Document Management
Managing the QlikView documents, categories of distribution, securing the documents, collaboration and sharing of sessions, learning about CAL & DOC CAL.
Windows log & Problem sector
The various issues faced during working with Windows, administration and access denied issues, resolving the problems.
Servers & Publisher management
Understanding the features of QlikView Publisher, difference between the Server and the Publisher, Server and Publisher management.
Publisher Initialization
Learning how Publisher extends the capabilities of the Server, the distribution function of the Publisher, Publisher security group, access group section.
Publisher Document Management
Working with QlikView Publisher, understanding distribution, configuration of distribution group, task scheduling, looping and reducing, learning what is source document, dependencies.
Scaling up servers & performance optimization Techniques
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.
QlikView Clustering
Understanding the need for QlikView clustering, the architecture of clustering.
Use of cluster and environment
Understanding how to deploy clustering in a Windows environment, working with sandbox, LUN management and failover procedure.
Testing of document & recommendations
Working with various testing tools, the recommendations for scaling.
Trouble shooting
Monitoring, System Admin Apps, Firewall issue, Antivirus issue, Log file checking
Qlikview Projects
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
Qlikview Server Project
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.
Qlikview Server Training
Intellipaat provides 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 of QlikView charts, clusters and also testing and troubleshooting in QlikView.
The entire course material is completely in line with clearing the QlikView Developer Certification & QlikView System Administrator Certification Exams. You will be working on real time QlikView projects that have high relevance in the corporate world, step by step assignments and curriculum designed by industry experts.
Upon 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 latest version at no extra fees. Hence it is clearly a one-time investment.
Intellipaat basically offers the self-paced training and online instructor-led training. Apart from that we also provide corporate training for enterprises. All our trainers come with over 12 years of industry experience in relevant technologies and also they are subject matter experts working as consultants. You can check about the quality of our trainers in the sample videos provided.
If you have any queries you can contact our 24/7 dedicated support to raise a ticket. We provide you email support and solution to your queries. If the query is not resolved by email we can arrange for a one-on-one session with our trainers. The best part is that you can contact Intellipaat even after completion of training to get support and assistance. There is also no limit on the number of queries you can raise when it comes to doubt clearance and query resolution.
The Intellipaat self-paced training is for people who want to learn at their own leisurely pace. As part of this program we provide you with one-on-one sessions, doubt clearance over email, 24/7 Live Support, lifetime LMS and upgrade to the latest version at no extra cost. The prices of self-paced training can be 75% lesser than online training. While studying should you face any unexpected challenges then we shall arrange a Virtual LIVE session with the trainer.
We provide you with the opportunity to work on real world projects wherein you can apply your knowledge and skills that you acquired through our training. We have multiple projects that thoroughly test your skills and knowledge of various aspect and components making you perfectly industry-ready. These projects could be in exciting and challenging fields like banking, insurance, retail, social networking, ecommerce, marketing, sales, high technology and so on. The Intellipaat projects are equivalent to six months of relevant experience in the corporate world.
Yes, Intellipaat does provide you with placement assistance. We have tie-ups with 80+ organizations including Ericsson, Cisco, Cognizant, TCS, among others that are looking for skilled & quality professionals and we would be happy to assist you with the process of preparing yourself for the interview and the job.
Yes, if you would want to upgrade from the self-paced training to instructor-led training then you can easily do so by paying the difference of the fees amount and joining the next batch of classes which shall be separately notified to you.
Upon successful completion of training you have to take a set of quizzes, complete the projects and upon review and on scoring over 60% marks in the qualifying quiz the official Intellipaat verified certificate is awarded.The Intellipaat Certification is a seal of approval and is highly recognized in 80+ corporations around the world including many in the Fortune 500 list of companies.
This course is designed for clearing the two exams:
- QlikView System Administrator Certification
- QlikView Developer Certification
The entire training course content is in line with these certification programs and helps you clear it with ease and get the best jobs in the 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 scenario 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 respective certification exams and helps you score better marks in certification exam.
Intellipaat Course Completion Certification will be awarded on the completion of Project work (on expert review) and upon scoring of at least 60% marks in the quiz. Intellipaat certification is well recognized in top 80+ MNCs like Ericsson, Cisco, Cognizant, Sony, Mu Sigma, Saint-Gobain, Standard Chartered, TCS, Genpact, Hexaware, etc.
$360
You will get Lifetime access to high quality interactive tutorials along with life time access to complete Course Material .There will be 24/7 access to video tutorials with email support. If you stuck in any unexpected problem we will provide online interactive sessions with trainer for issue resolving.
We provide 24X7 support by email for issues or doubts clearance for Self-paced training.
In online Instructor led training, trainer will be available to help you out with your queries regarding the course. If required, the support team can also provide you live support by accessing your machine remotely. This ensures that all your doubts and problems faced during labs and project work are clarified round the clock.
Disclaimer
"PMI®", "PMP®" and "PMI-ACP®" are registered marks of the Project Management Institute, Inc.
The Open Group®, TOGAF® are trademarks of The Open Group.
The Swirl logoTM is a trade mark of AXELOS Limited.
ITIL® is a registered trade mark of AXELOS Limited.
PRINCE2® is a Registered Trade Mark of AXELOS Limited.
Certified ScrumMaster® (CSM) and Certified Scrum Trainer® (CST) are registered trademarks of SCRUM ALLIANCE®
Professional Scrum Master is a registered trademark of Scrum.org
Sales Offer
- To avail this offer, enroll before 27th April 2018.
- This offer cannot be combined with any other offer.
- This offer is valid on selected courses only.
- Please use coupon codes mentioned below to avail the offer
Nice course, Good content
This course provided complete in and out of QlikView development and administration enviornment. The entire session was highly interactive as the trainer had indepth knowledge of all aspects.
Support team was Awesome
Course was good, but what i liked the most was the support from Intellipaat team. they were amazing whenever I encoutered any problem. overall, a geat experience.