Duration
4-5 days (40 hours)
Overview
A QlikView certification can enable businesses and individuals to present data in a visually appealing way to ensure better comprehension. This data analysis tool has transformed business intelligence for over 24000 organizations the world over, by consolidating and visually analyzing data in a simple and effective manner.
This workshop from KnowledgeHut gives you a structured approach to learning QlikView. Whether you are new to the tool or to data science as a subject, this well-defined course will help you pick up the functionality of Qlikview and use it to bring business benefits. Well formulated hands-on exercises will help you cement your knowledge about using advanced visualization techniques, data transformation, data integration, data processing and security.
Our training consists of
- Covers the basic and advanced visualization techniques on QlikView
- Learn, prepare and analyze your data with QlikView
- 40 hrs of Hands-on sessions on the front end and back end components of QlikView
- Case studies on QlikView data transformation and exploratory analysis
- Interactive and project-oriented lab sessions on QlikView
- 3 Real Time projects
Pre-requisites
There are no specific prerequisites for Data Visualisation with QlikView training, but possessing the following knowledge will surely give you an added advantage:
- Basic idea of programming languages
- Recommended to have familiarity with Databases, SQL, and Data WareHouse
- Basic understanding of Reporting and BI.
Learning from the Training
- Data Visualization Strategy
- QlikView
- Objects and Properties
- Advanced Visualization Ways
- Data Analysis
- Projects using QlikView
Course Outline
Data Visualization Strategy
Learning Objective: Learn about data exploration and visualization techniques. Get introduced to QVD and see how it works.
- Data exploration, visualization, and discovery
- Data teams and roles
- Agile development
- QlikView Deployment Framework
- Loading data from different sources in QlikView.
- Introduction to QVD and how does it work?
- What is Table Viewer?
Hands-on: Load data from sources to QlikView.
Objects and Properties
Learning Objective: Learn about objects and properties, chart objects and use of object container.
- Sheet object and Tab with their properties
- List Box, Multi-Box, Current Selection Box, Search Box
- Chart Objects and their properties
- Use of Object Container
- Expression writing and read about basic functions
Hands-on: Load data from different sources in Qlikview and create list box, multi-box; use object container.
Advanced Visualization Techniques
Learning Objective: Learn about conditional formatting in Qlikview and various visualization techniques.
- Conditional Formatting In Qlikview
- Gauge Chart, Thermometer and Waterfall chart
- Enable dimension and expression
- Adhoc Reporting in Qlikview
- Cyclic and drill groups
Hands-on: Implement conditional formatting in QlikView.
Data Transformation
Learning Objective: Learn to transform raw data using Cross Table, Inline Table and using other operations.
- Loading Cross Table
- Loading Inline Table
- Loading data from already stored data in Qlikview (Resident Load)
- Joins, Concatenation of tables
- Use of Mapping Tables
- Synthetic Keys and ways to remove it
- Incremental Load in Qlikview
- Partial Load
Hands-on: Implement various data transformation techniques using QlikView.
Advanced Expression
Learning Objective: Learn to build expressions using variables.
- Set Analysis
- Aggregate function
- Build expression using variables (Dollar expansion)
Hands-on: Implement advanced expressions using variables.
Security
Learning Objective: Learn to use Hidden Script.
- Hidden Script
- Section Access
Hands-on: Setup security using hidden script and sectional access.
Project on Data Visualization using Qlikview
Learning Objective: Learn data visualization and understand the applications as a Business Intelligence tool.
- Developing a project to visualize data using Qlikview
Hands-on: Develop a project using QlikView.
Programme scope, delivery arrangements and suitability are confirmed during enquiry.