CertAchiever

QlikView Certification Training

contact us: +918882136965

Instructor-led live online classes

Weekday Classes | Weekend Classes |

QlikView Certification Training

$270

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.

Training Features

Instructor-led Sessions

Both Weekdays and Weekend batches are available.

Real-Life Case Studies

During the sessions you will be working on the case studies provided by the trainer.

Lifetime Access

You will get the life time access of training material including videos & study guides..

Assignments

Each class will be followed by practical assignments to practice the concepts covered in class

24 x 7 Expert Support

We have a lifetime 24x7 online support team to resolve all your technical queries,through a ticket based tracking system..

Certification

Towards the end of the course, you will be awarded with Training competition certification based on you performance.

Course Curriculum

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 Covered

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

Downloading and Installing QlikView, Creating a List Box

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 Covered

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

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

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 Covered

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

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

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 Covered

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

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 Covered

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

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

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 Covered

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

What-If Analysis, Comparative & Set Analysis

FAQ's

You will never miss a lecture at CertAchiever! You can choose either of the two options:

View the recorded session of the class available in your LMS.

·You can attend the missed session, in any other live batch."

We have limited number of participants in a live session to maintain the Quality Standards. So, unfortunately participation in a live class without enrollment is not possible. However, you can go through the sample class recording and it would give you a clear insight about how are the classes conducted, quality of instructors and the level of interaction in the class.

You can give us a CALL at +918882136965 (IN) OR email at admin@certachiever.com

Certification

Once your training will complete, you will be awarded with training completion certification from the Trainer.