QlikView Developer - Essentials

Have Queries? Ask us +91 72592 22234

Course Overview


Knowledge of the data model, creation of the proper data connections and scripting fundamentals are critical to creating QlikView applications that provide your organization with powerful business discovery tools. QlikView Developer Course provides you with an opportunity to learn by doing through a series of lectures and hands on exercises focused on developing QlikView applications. Beginning with the QlikView environment and ending with an introduction to advanced interface design, this course will prepare you to take your QlikView applications to the next level. QlikView training course concludes with a new business case where you can practice your skills in building a QlikView application from the beginning using identified key performance indicators.

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

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

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

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

Customer Reviews


Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.
-Waseem

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.
-Tanmoy

...more
Share:

For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

Looking for a Training for

Myself

My Team/Organization

I agree to be contacted over mail or phone

or
Call us at: +91 7259222234