QlikView QlikSense

 Why take QlikView / QlikSense Training?

QlikView is a Self-Service Business Intelligence, Data Visualization and Data Analytics tool.

With this humongous amount of data and real business implications, business organizations across the world have the need for an easy to use tool to analyze the data and derive actionable insights from it.

QlikView helps organizations to extract meaningful information and perform visualizations on the data. Many companies worldwide have truly transformed the way they uncover insights from data by using QlikView.

 

Training Syllabus

  •       Introduction to QlikView
  •       Scripting
  •       Data Model
  •       Data Transformation
  •       Charts & Advanced Functions
  •       Data Analysis

 

Module 1: Introduction to QlikView

Learning Objectives: In this module, you will get an overview of BI Tools and you will be introduced to QlikView. Further you will learn about its features and architecture. 

Topics:

  • 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

Hands On/Demo:

  • Downloading and Installing QlikView
  • Creating a List Box

 

Module 2: Scripting

Learning Objectives: In this module, you will learn the need and different features of scripting. You will learn about script toolbar, adding/editing tabs, variables, fields, joins and keep.

Topics:

  • 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

Hands On/Demo:

  • Edit Script
  • QlikView Operations: Concatenate, If statement
  • Create variables, Inline load, Functions and Joins

 

Module 3: Data Model

Learning Objectives: In this module, you will learn about different QV data file types and ways to resolve the synthetic keys and circular reference. 

Topics:

  • 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

 Hands On/Demo:

  • Star Schema, Synthetic key, Circular reference
  • Concatenation, Qualify & Unqualify

 

Module 4: Data Transformation

Learning Objectives: In this module, you will learn how to modify the existing data to a new data format. You will learn about different types of loads and tables.

Topics:

  • 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

 

Hands On/Demo:

  • Preceding load, Resident load & Incremental Load
  • Rotating, Pivot, Cross & Mapping Tables
  • Security with Section Access

Module 5: Charts & Advanced Functions

Learning Objectives: In this module, you will learn to visualize the data in QlikView. You will also be able to add various advanced functions in the report.

Topics:

  • 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

 

Hands On/Demo:

  • Advanced QV functions
  • QlikView visualization charts: Bar, line, Combo, Radar, Scatter, Pie, Grid, Funnel & Mekko
  • Chart Functions

Module 6: Data Analysis

Learning Objectives: In this module, you will learn to analyze the data using set, indirect, and what-if analysis. You will also be learning about some advanced QV operations.

Topics:

  • 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 sales force connector
  • Macro
  • Geolocation
  • Web Connectors
  • Conditionally Enabling Dimensions

Hands On/Demo:

  • What-If Analysis, Comparative & Set Analysis

           

Instructor-led live online classes

OFFER ! Pay an 'Early Bird' deposit now and save 10% on the final price!

Early Bird Offer

  • 13

    Jun

    Sat-Sun (45 hours)

    10:00 AM - 11:30AM

    • 40% off

      25,000

    15,000
40% Off till 12-Jun
  • 20

    Jun

    Sat-Sun (45 hours)

    2:00 PM - 4:00 PM(IST)

    • 40% off

      25,000

    15,000
40% Off till 12-Jun
  • 16

    Jun

    Tue, Wed, Fri (45 hours)

    9:30 AM - 11:00 PM(IST)

    • 40% off

      25,000

    15,000
40% Off till 12-Jun
  • 23

    Jun

    Tue, Wed, Fri (45 hours)

    6:00 PM - 7:30 AM(IST)

    • 40% off

      25,000

    15,000
40% Off till 12-Jun

Live Classes

On-time scheduled virtual classes with limited trainer-student ratio.

Expert Trainers

Best industry experts with years of online training experience.

Tailored Course

Based on your expertise and goals we design course for you.

Flexible Schedule

Learn at your schedule , time zone and convenience.

Get Certified

Receive a certificate to confirm the level of your skills in a professional context.

×

Get A Quote

Please fill your details. Fields marked with mandatory are mandatory

(Allowed types : PDF, DOC, XLS, JPEG, GIF, PNG )

Privacy Policy : We hate SPAM and promise to keep your email address safe.