Qlikview Online Training - Demo On 21 @ 6Am Ist

[vlstrainings]

Hi all,

 

We are providing online training on Qlikview – Data visualization. Demo is on 21st @ 6AM (IST)

 

If anyone interested please contact us.

 

E-mail: [email protected]

 

Phone: +91-7899339936

 

Course Content:

QLIKVIEW DEVELOPMENT METHODOLOGY

DEPLOYMENT

·         QlikView Desktop, Server and Publisher

INTRODUCTION TO DATA AND SCRIPTING

·         QlikView’s QVD File and format

·         Comparing Database

·         Structures to QlikView

·         Data Structures Data Structures in QlikView

·         QlikView Data Modeling

·         Introduction to Scripting

·         The QWT Project Data, Primary & Secondary Data Source

LOADING DATA FROM THE DATABASE

·         Script Generation

·         Comments in the Script

·         The Create Select Statement Dialog

·         Creating Tabs in the Script

·         Script Debugging

·         The Script Execution Log File

SYNTHETIC KEYS

BASIC DATA MODEL AND TABLE VIEWER

ADDING TEXT DATA

·         The File Wizard

·         Your Excel Files

·         Script generation using the File Wizard

BASIC DATA TRANSFORMATION

·         Load Statement

·         Renaming a Field

·         Script Expressions

·         Loading an XML File

·         The Qualify Statement, Key Fields, Count and Sum

GENERATING DATA IN THE QLIKVIEW SCRIPT

·         Resident Load

·         The Where Exists Clause

·         SCRIPTING CONSIDERATIONS

·         More about Synthetic Keys

·         Synthetic Key Tables

·         Composite Keys

·         Circular References

·         Loosely Coupled Tables

·         Eliminating Circular Reference

MASTER CALENDAR

·         Date and Time

·         The Master Calendar

·         Using Flags

·         Data & Date Islands

MAPPING TABLES

·         Mapping Tables

·         Cleaning up the Table Structure

·         Preceding Load on Preceding Load

·         DATA MODEL OPTIMIZATION

·         How to Create QlikView Data Models

·         Joining tables

·         Concatenation

·         From Snow Flake to Star Scheme

·         Merged Facts Table

·         Aggregating Data

SCRIPTING AND DATA MODELING CHALLENGES

·         Link Tables and Concatenated Tables

·         Calculating Net Change within a Field

·         Dynamic Aggregation

LOADING BUDGET DATA

·         Cross Tables and Input field

ADVANCED CALCULATIONS IN SHEET OBJECTS

·         Dimension Limits

·         Perform comparative analysis using Alternate

·         States

·         Set Analysis

·         Dollar-Sign Expansion & Aggr Function

META DATA

·         Tags, Comments & Renaming

·         Null functions

·         HidePrefix & HideSuffix

QLIKVIEW DATA (QVD) FILES

·         QVD File Format and its use

·         Creating QVD Files

·         Store Statement

·         Manual Creation of a QVD File in the Script

PERFORMANCE OPTIMIZATION

·         Performance Tuning

·         Best Practices for QlikView File Optimization

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

[vlstrainings]

Hi all,

 

We are providing online training on Qlikview – Data visualization. Demo is on 21st @ 6AM (IST)

 

If anyone interested please contact us.

 

E-mail: [email protected]

 

Phone: +91-7899339936