Courses » Datawarehouse Online Training » QlikView Online Training

 

QlikView Online Training

 

Traditional BI tools vs Qlikview

In-Memory technology

Architecture of Qlikview

QLIKVIEW ENVIRONMENT

QlikView Desktop

QLIKVIEW DEVELOPMENT METHODOLOGIES

Import/Export Sheet and Document Layouts as XML

Qlik Wholesale Trade (QWT) Project Plan

Project Plan Review

SAFE Methodology

DEPLOYMENTS

QlikView Standalone

QlikView Server

QlikView Publisher

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

BASIC DATA TRANSFORMATION

Load Statement

Renaming a Field

Script Expressions

Loading an XML File

Renaming Fields Using the Qualify Statement

Key Fields

Example Predicament

How Does this Affect You?

Loading a Field into a Table Multiple Times

Using a Record Counter on Key Fields

Is it Correct?

ADDING TEXT DATA

Employees

Offices

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

Autogenerate 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

APPENDIX: LAYOUT BASICS FOR DEVELOPERS

User Friendly Design

Natural Human Behavior

Chart and Object Choices in QlikView

Import/Export Sheet and Document Layouts

APPENDIX: The Completed Script