QlikView Training | Learn QlikView, Business Intelligence & Data Visualization Tool

QlikView Training Course Description

QlikView lets you search & explore vast amounts of data. The best part is you cannot be preconceived notions of how data should be related, but can finally understand how it truly is related. Analyze, reveal, collaborate and act. 

This QlikView course covers all the concepts of Qlikview tools like Data Interpretation, Designing, Modeling and then dives into advanced features of QlikView like Analyzing the data, Discovering the hidden data and generating attractive graphs and charts.

QlikView Training Course Learning Outcomes

  • Apply various visualization and modeling techniques 
  • Implement Qlikview features like In-memory, associate, and Decision-making
  • Perform Data Analysis
  • Access the multiple charts/tables/objects for Dashboard analysis 
  • Work on a real life Project, implementing data into image for Dashboard

QlikView Training - Suggested Audience

This QlikView course is aimed at professionals who want to learn Dashboard techniques by using Qlikview. Suggested attendees based on our past programs are:
  • Analytics Professionals 
  • ETL/DW Professionals 
  • Project Managers 
  • Testing Professionals 
  • BI Professionals
  • Business & Reporting professionals
  • Software Developers 
  • Software Architects 

QlikView Course Duration

  • Open-House F2F (Public): 3/4 days
  • In-House F2F (Private): 3/4 days, for commercials please send us an email with group size to hello@pincorps.com

QlikView Training Prerequisites

  • There are no such pre-requisites for this course.
  • Knowledge of file type, SQL, DWH, RDBMS would be beneficial.

QlikView training course outline includes:

1. Qlikview Intro
  • Introduction to QlikView
  • What is Visualization
  • Components of Qlikview
  • Create Connection
  • Create Dashboard Report
  • Report Interface
  • Sheet Object-List BOX

2. Script - Code
  • Script Editing
  • Edit Script Toolbar
  • Edit Script Menu Commands
  • Statements Area
  • Edit Script Tool Pane
  • Syntax
  • Creating tabs in the script
  • Renaming a Field
  • Chart Object- Bar Chart
  • Sheet Object- TABLE Box

3. Script - Relation
  • The Table Viewer
  • System Fields
  • The System Table
  • Join, Keep & Concatenation
  • Types of Join, Keep & Concatenation, When to use & Which Type
  • Chart Object-Line Chart
  • Sheet Object-Multi Box

4. Script - Loop & Field Handle
  • Synthetic Key Tables
  • Circular References
  • Causes of Circular References
  • Ways to Resolve Synthetic Keys and Circular Reference
  • Text Files, Excel Files, CSV Files Chart Object- Combo Chart Sheet Object- Input Box.

5. Script - Load Type & System Table
  • Generating Data in the Qlikview Script
  • Cross Tables
  • Mapping Tables
  • Different Types of Loads
  • Chart Object - Pie Chart
  • Sheet Object - Buttons
  • Sheet Object - Current Selections Box

6. Script - Incremental Load & Files
  • QlikView Data Files Types
  • Incremental load
  • Incremental load with qvd file
  • Creating a Calendar
  • Sheet Object - Radar Chart
  • Sheet Object - Scatter Chart
  • Sheet Object - Text Box

7. Object/Field Formatting
  • Number Format
  • Aggregation & Nested level
  • Calculated Formula
  • Field Groups
  • Sheet Object - Grid Chart
  • Sheet Object - Block Chart
  • Sheet Object - line/arrow

8. Data Analysis
  • Set Analysis
  • Indirect Set Analysis
  • What-if Analysis
  • Set vs Let
  • Sheet Object-Mekko Chart
  • Sheet Object - Gauge Chart
  • Sheet Object - Slider/Calendar Box
Keny White

Professor

Keny White is Professor of the Department of Computer Science at Boston University, where he has been since 2004. He also currently serves as Chief Scientist of Guavus, Inc. During 2003-2004 he was a Visiting Associate Professor at the Laboratoire d'Infomatique de Paris VI (LIP6). He received a B.S. from Cornell University in 1992, and an M.S. from the State University of New York at Buffalo.

Bachelor

After working as a software developer and contractor for over 8 years for a whole bunch of companies including ABX, Proit, SACC and AT&T in the US, He decided to work full-time as a private software trainer. He received his Ph.D. in Computer Science from the University of Rochester in 2001. "What I teach varies from beginner to advanced and from what I have seen, anybody can learn and grow from my courses".

Reviews

Average Rating

5
1 rating

Detailed Rating

5 stars
1
4 stars
0
3 stars
0
2 stars
0
1 star
0

    This is great

    I really love the course editor in LearnPress. It is never easier when creating courses, lessons, quizzes with this one. It's the most useful LMS WordPress plugin I have ever used. Thank a lot! Testing quiz is funny, I like the sorting choice question type most.