QlikView Certification Training

QlikView Certification Training will help you become an expert in Data Visualization with QlikView. Along the course, you will be transforming data into interactive charts and graphs using QlikView features like dashboards, system table, incremental load and object formatting.

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
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
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
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
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
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

QlikView Training and Certification is specifically designed for professionals who wants to learn QlikView for Business Intelligence and to bring visual insights to the data. This training covers all the concepts of QlikView such as Data Interpretation, Designing, Modelling and then dives into advance features such as analyzing the data, discovering the hidden data and generating interactive graphs and charts

After completing this course, you should be able to:

  • Understand what is QlikView. How does it work? What makes it a useful tool in analytics domain?
  • Learn to edit scripts
  • Gain rich experience on generating data using QlikView scripts, working with sheet objects and creating dashboards
  • Use multiple charts, tables, synthetic Key tables and resolve the synthetic keys and circular reference
  • Understand data file types and incremental load
  • Perform object field formatting
  • Perform set, indirect and what if analysis
Month End Offer - Flat 20% Off + 20% Cashback  
+
WhatsApp us