QlikView Certification Training

Ace in analytics, deliver the best of Business Intelligence with QlikView training

Enroll Now View Curriculum

Key Highlights

  • 18 Hours of Live Instructor-led Classes
  • 6 sessions of 3 hours each on Weekends
  • Live Project on Real-life Case Studies
  • Practical Assignments
  • Lifetime Access to Learning Management System
  • 24x7 Expert Support
  • Course Completion Certificate
  • Online Forum for Discussions

Course Price

$349.00 $700.00

Contact Us

1866-216-7898

(Toll Free)

Available Courses Delivery

This course is available in the following formats:

Course Overview

QlikView is a Business Intelligence (BI) platform that turns data into meaningful insights. The course fortifies analytical aptitude of the trainee and helps create interactive graphs and charts to suggest beneficial decisions. This course includes concepts on Data Interpretation, Modelling, Designing, Data Analysis, and extraction of hidden data.

Course Objectives

  • Understand the basics of QlikView, and explore its functions and features
  • Learn how to edit scripts
  • Use QlikView scripts to generate data, create dashboards, and work with sheet objects
  • Learn about Synthetic Keys, Synthetic Key tables, multiple charts, and circular reference
  • Get acquainted with different data types and incremental load
  • Learn and perform object field formatting, set analysis, indirect analysis, and what-if analysis

Career Benefits

  • Business Intelligence connoisseurs are in high demand across the industries
  • Better remuneration
  • Become a better manager by using QlikView?s business insights
  • Get hired by top companies
  • Handle complex BI projects better
  • Advance your analytics career

Prerequisites

  • None

Who should take up?

  • Freshers interested in Business Intelligence
  • Business Intelligence Executives
  • Data Scientists
  • Business Analysts
  • BI/ETL/DW Professional
  • Business Intelligence Manager
  • Statisticians and Analysts

Course Content

  • What is BI?
  • Introduction to Visualization
  • Different BI Tools
  • What is QlikView?
  • Features and components of QlikView
  • Architecture
  • Installation & Navigation
  • Data Ingestion
  • Report Interface
  • QVS, QVW and .log files
  • Sheet Objects
  • Dimensions and Expressions
  • Presentation/ Layout / Sort tabs
  • Need of Scripting
  • What is Scripting?
  • Script Toolbar
  • Script Menu Commands
  • QlikView Variables (Set,Let) and Fields
  • Creating tabs in the script
  • Adding Sheet Objects
  • Inline table
  • Function in QlikView (Sum, Avg, Count, Date, etc)
  • Joins: Inner, Left, Right and Outer
  • Understanding Keep command
  • QlikView Data File Types: QVD, QVX
  • System fields
  • Star schema
  • Synthetic Key Tables
  • Circular References & its causes
  • Ways to Resolve Synthetic Keys and Circular Reference
  • Using Qualify & unqualify
  • Link Table
  • Concatenation: Forced, Auto, No
  • Data Model optimization
  • Master Calendar
  • Generating data in the QlikView Script
  • Different Type of Loads
  • Incremental load with QVD file
  • Column manipulation
  • Tables: Rotating, Straight and Pivot, Cross
  • Mapping Table
  • Security ? Section Access and Control
  • Sheet Objects: Slider Text Box, Calendar Box, Current Selections Box
  • QlikView Advance Functions: Apply map, match, Peek, pick, lookup,exist, not exist, AGGR , rank, rangesum, class, date and date#, Valuelist
  • Chart object menu
  • Visualization Charts: Bar chart, line, combo, radar, scatter, grid, pie, funnel, block, gauge, mekko
  • Chart Formatting
  • Information density Subset Ratio and Perfect Key
  • Triggers
  • Alternate State
  • QlikView Management console: Server, Publisher
  • Set Analysis (Indirect Set Analysis, Identifiers, Modifiers & Operators)
  • What-if Analysis
  • Comparative Analysis
  • Dynamic Reporting or Ad-hoc Reporting.
  • Document Channing
  • How to select range of Dates
  • Information density Subset Ratio and Perfect Key
  • AND Mode
  • Document Analyzer
  • Exception Handling
  • Buffer load
  • Qlikview cals
  • Qlikview sap connector
  • Qlikview Salesforce connector
  • Macro
  • Geolocation
  • Web Connectors
  • Conditionally Enabling Dimensions

SEARCHING FOR THE RIGHT COURSE?

Upskill counselors can help you pick the suitable program

CALL US NOW 1866-216-7898

Schedule a call.


IN DEMAND & POPULAR TRAINING COURSES

Popular Courses