Qlikview

QLIKVIEW COURSE CONTENT

Who is QlikTech ?

What is QlikView ?

QlikView Enterprise

What is Dash Board & Analysis?

SHORT INTRODUCTION TO DATA STRUCTURES

Relational databases (OLTP)

Other data structures (OLAP, MOLAP, HOLAP, and ROLAP)

A SHORT INTRODUCTION TO DATA WAREHOUSING

Fundamentals of ETL

What is the utility of De-normalize data structure in Data warehousing

Star Schema

Snow Flake Schema

QLIKVIEW DATA STRUCTURES

Why QlikView is Compare with ETL

Comparing Database structures (OLTP & OLAP) to QlikView data structures

Data structures in QlikView (AQL).

Sample Application walkthrough of QlikView.

Objectivity of Relevant search records (Gray area & White area in Dimension)

Why Click & View (QlikView), why it is Multidimensional

Why it’s called In-memory BI Tool

Thorough Architecture of QlikView (including Multiple Data Source & AJAX Client)

LOADING DATA INTO QLIKVIEW

Script editing

Edit Script Toolbar

Edit Script Menu Commands

Statements Area

Edit Script Tool Pane

Syntax

Renaming a Field

 DATA SOURCE FILES

The QWT (Access File example) primary data source

The QWT (Access File example with QVD Conversion) secondary data files

CREATING THE SCRIPT

Script generation

Creating a connection to the database

Reading tables into QlikView

EXERCISES

Script Debugging

STRUCTURING THE SCRIPT

Creating tabs in the script

DATA STRUCTURE OF THE LOADED DATA

The Table Viewer

System fields

The system table

Document Properties: Tables page

SCRIPTING CONSIDERATIONS

Synthetic key tables

Circular references

Causes of circular references

Loosely Coupled Tables

ADDING TEXT DATA

Employees

Offices

 LOADING AN XML FILE

Loading a text file in XML Format

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

Does the chart really show what I want it to?

EXERCISES

GENERATING DATA IN THE QLIKVIEW SCRIPT

Resident Load

Creating data using Load Inline and Auto generate

Inline tables

Auto generate tables

MAPPING TABLES

Mapping Quarters to the Orders table

Month Year

Cleaning up the table structure

CREATING A CALENDAR

Getting the Highest and Lowest date from the Orders table

Creating variables in the script

Creating the Master Calendar

INCLUDE

READING BUDGET INTO QLIKVIEW

Reading Cross Tables

QLIKVIEW DATA (QVD) FILES

QVD file format

Use of QVD files

Creating QVD files

Automatic Creation of a QVD file in the script

QLIKVIEW SECURITY

Access control

Access levels

Access control database

Hidden script

Adding Section Access

DATA TYPES IN QLIKVIEW

Data storage in QlikView

Data containing information on data type

Data without information on data type

Dates and times

THE FINAL SCRIPT

ADVANCED SCRIPTING

Condition on a field in a table

Aggregating Data in Script (Resident Load and Group Function, Order By etc)

Joining tables (Left, Right, Inner, Outer Joins)

Concatenation

USING QLIKVIEW 10.0 SR-3 PERSONAL EDITION

Starting QlikView

Basic Layout and Navigation

SHEETS AND SHEET OBJECTS

Sheet Basics

Sheet Objects

Exercise – Creating Your Workspace

THE LIST BOX

Introduction

Creating a List Box

List Box in Action

Properties of the List Box

Exercise – List Boxes

THE TABLE BOX

Introduction

Creating a Table Box

Selections in Table Boxes

Sorting in Table Boxes

More Table Box formatting options

Printing data from a table box

Exporting data from a table box to a text file

Exercises

THE MULTI BOX

Introduction

Selections in Multi Boxes

Creating a Multi Box

Resizing Multi Boxes

Formatting Multi Boxes

Exercises

THE TEXT OBJECT

Introduction

Creating Text Objects

Formatting, Resizing, Copying and Moving Text Objects

CHARTS

Chart Basics

Creating a Chart

Selections in Charts

Changing the Chart Properties for Existing Charts

Common Chart Types

A Note About Mathematical Expressions

Exporting charts

References in charts

Exercises

MULTI DIMENSIONAL CHARTS, PIVOT TABLES

Straight Table with Multiple Expressions

Pivot Tables with Multiple Dimensions

Grouped bar charts

More about Pivot Tables and Straight Tables

Using a Dropdown Selection List

Using Visual Cues

Summary – Comparing Tables

Exercises

GAUGES

Why Use a Gauge Chart?

Types of Gauges

Building Gauges

Exercises

BUTTONS

Buttons in QlikView

Creating and Formatting a Button

Shortcut Buttons

Launch/Export-Buttons

Edit Macro (on the fly Grouping/Sheet Enabled Disabled)

Exercises

THE OTHER SHEET OBJECTS

The Statistics Box

The Current Selections Box

The Slider/Calendar Object

The Input Box

The Bookmark Object

ADDITIONAL EDITING IN THE LAYOUT

Title Settings

Fast Change Chart Type

Legend Settings

Reference Lines / Text in Chart

Advanced Caption Settings

Using Layout Themes

Exercises

OTHER USES OF EXPRESSIONS

Calculated Labels and Dynamic Text in Text Objects

Conditional Functions

Chart Attribute Expressions

Color Expressions

Calculated Fields in List Boxes

Calculated Dimensions in Charts

THE SETTINGS MENU

User Preferences

Document Properties

Sheet Properties

THE QLIKVIEW SCRIPT: DESKTOP DATA

Limited Scripting in QlikView Professional

Loading Data into QlikView

What data can QlikView read?

Structure of the Data Repository

The Edit Script Dialog

Executing the script

Loading files with the Table File Wizard

Renaming Fields while Loading

REPORTS AND BOOKMARKS

Introduction – Reports

QlikView Report Types

Managing Reports

Creating and editing reports

Introduction – Bookmarks

Bookmark Types

Managing Bookmarks

Creating Bookmarks

Set Analysis

Server Installation & Deployment

Installation

CALS details (Document & Named ).

Deploy the application in server

Access point settings

NTFS Mode file access

DMS mode file access

Exercises