001-4694216464 contact@iconitinc.com

QlikView Online Course

Rating Score: 5.0/4 reviews

Integration certification course

Integration programs like Dell Boomi, QlikView, Tableau are some of the major programs that are heavily used in the industries. Learning these programs can help you land a job in your desired company. Special training is required to use such programs as these programs are cloud-based integration programs.

These integration programs help you develop and manage applications and dashboard rapidly. If you want to learn these courses, then you can go for our integration certification courses. In this course, we will help you learn about the cloud integration programs like Dell Boomi, QlikView, and Tableau.

All of the courses are included in a single course to help you save time and resources. The total course if of around 30 hours where an instructor will be teaching you in the videos. If you have any queries or doubts, then you can consult the personal trainer assigned to you for the course.

These cloud-based integration programs are very difficult to operate. This is the reason why special training is required to use these programs. After the completion of the program, you will have learned the basics as well as the applications of the integration software.

Apart from the courses, you will also be given a certificate upon the completion of the courses to show that you have mastered the programs and are ready to implement your skills in the real world. All you need to do is invest your 30 hours for this course and at the end, you will have learned how to use these programs effectively.

Qlikview Course Content

  • QLIKVIEW ENVIRONMENT

  • QlikView Desktop

  • QLIKVIEW DEVELOPMENT METHODOLOGY

  • Import/Export Sheet and Document Layouts as XML

  • Qlik Wholesale Trade (QWT) Project Plan

  • Project Plan Review

  • SAFE Methodology

  • DEPLOYMENT

  • QlikView Standalone

  • QlikView Server

  • QlikView Publisher

  • INTRODUCTION TO DATA AND SCRIPTING

  • Relational Databases

  • Other Data Structures

  • Comparing Database Structures to QlikView Data Structures

  • Data Structures in QlikView

  • Data Source Files

  • The QWT Primary Data Source

  • The QWT Secondary Data Files

  • Introduction to Scripting

  • BASIC SCRIPT SYNTAX

  • Syntax

  • LOADING DATA FROM THE DATABASE

  • Script Generation

  • Comments in the Script

  • Script Debugging

  • STRUCTURING THE SCRIPT

  • Creating Tabs in the Script

  • BASIC DATA MODEL AND TABLE VIEWER

  • The Table Viewer

  • The System Table

  • Document Properties: Tables page

  • BASIC DATA TRANSFORMATION

  • Load Statement

  • Renaming a Field

  • Script Expressions

  • Loading an XML File

  • Renaming Fields Using the Qualify Statement

  • Key Fields

  • Example Predicament

  • Loading a Field into a Table Multiple Times

  • Using a Record Counter on Key Fields

  • ADDING TEXT DATA

  • Script generation using the File Wizard

  • GENERATING DATA IN THE QLIKVIEW SCRIPT

  • Resident Load

  • Using Orders to determine Sales Person.

  • Include Time Functions: Creating a Calendar

  • Getting the Highest and Lowest Date from the Orders Table

  • Auto generate tables

  • Creating Variables in the Script

  • The Master Calendar

  • SCRIPTING CONSIDERATIONS

  • Synthetic Key Tables

  • Circular References

  • Causes of Circular References

  • Check the Numbers

  • QLIKVIEW DATA (QVD) FILES

  • QVD File Format

  • Use of QVD Files

  • Creating QVD Files

  • Manual Creation of a QVD File in the Script

  • Automatic Creation of a QVD File in the Script

  • QVD File Script Functions

  • REPORTING BUGS IN QLIKVIEW

  • ADDITIONAL INFORMATION

  • Reference Materials

  • Data types in QlikView

  • LAYOUT BASICS FOR DEVELOPERS

  • User Friendly Design

  • Natural Human Behavior

  • Chart and Object Choices in QlikView

  • Import/Export Sheet and Document Layouts

  • The Completed Script

  • Program versions

  • Text formats

  • DEVELOPER TOOLS

  • Troubleshooting

  • The Debugger

  • MAPPING TABLES

  • Mapping Quarters to the Orders table

  • MonthYear

  • Cleaning up the table structure

  • LOADING BUDGET DATA

  • Reading Cross Tables

  • ADVANCED SCRIPTING

  • Condition on a field in a table

  • Aggregating Data

  • Joining tables

  • Concatenation

  • Preceding Load on Preceding Load

  • ADVANCED CALCULATIONS IN SHEET OBJECTS

  • Set Analysis

  • Dollar-Sign Expansion

  • AGGR Function

  • SCRIPTING AND DATA MODELING CHALLENGES

  • Link Tables and Concatenated Tables

  • Calculating net change within a field

  • Functions InDate, Data & DateIslands

  • Aggr()

  • Class()

  • Dynamic Aggregation

  • IntervalMatch

  • DATA MODEL OPTIMIZATION

  • Performance Tuning

  • Best Practices for QlikView File Optimization

  • Creating Incremental Loads

  • DATA MODEL OPTIMIZATION

  • Performance Tuning

  • Best Practices for QlikView File Optimization

  • Creating Incremental Loads

  • DAILY AND TRANSACTION BALANCES

  • Overview

  • Balances at Specific Dates

  • Balances for Transactions (in/out)

  • QLIKVIEW SECURITY

  • Access control

  • Access levels

  • Access control database

  • Inherited access restrictions

  • Hidden script

  • Adding Section Access

  • Access control for certain commands

  • Further access control

  • Unattended Command Line Reload Considerations

  • Access restrictions on selected field values

  • Field value limitation in Section Access

  • ADVANCED DATABASE CONNECTIVITY

  • Custom Data

  • WORKSHOP

  • Scenario

  • Data Structure

Sorry, No video uploaded to this couse!

Enroll Duration Type
Enquire Now 30 Hours Live Online Course

Rate and review this course




Sukanya K

5 months ago

I appreciate Iconitink for the excellent delivery of this class. Iconitinc Everything is explained clearly and wonderfully. Thank you so much!


Naga Venkata Jagadish

3 months ago

Nice explanation Iconitinc, Great


Manju N

2 months ago

Your explanation was really good. I understood everything as a beginner. Thank you Iconitinc :-)


Manohar. G

2 months ago

Presentation is clear and easy to understand. Good job!

Request a call back