EncartaLabs

QlikView Developer

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 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 covering topics such as data modeling, synthetic keys and how to use the script editor, the QlikView Developer Essentials training course will prepare you to take your QlikView applications to the next level. The course concludes with a business case where you can practice your skills in building a QlikView application from the beginning using identified key performance indicators.

QlikView Developer - Advanced training course discusses advanced technical concepts including: applying expressions and functions, writing data load script, and data modeling strategies. It provides hands-on examples and demonstrates how these concepts can be applied to various business cases.

By attending QlikView Developer - Essentials workshop, attendees will learn to:

  • Create a data model in QlikView
  • Build a QlikView application
  • Resolve data structure issues
  • Access the Debugger
  • Define the advanced uses of the script editor
  • Use Transformative Functions in the script
  • Discuss Synthetic Keys

By attending QlikView Developer - Advanced workshop, attendees will learn:

  • Implement front-end solutions with advanced Qlik expressions and calculations.
  • Perform advanced set analysis operations, using advanced search expressions and element functions.
  • Perform comparative analysis using alternate states.
  • Use advanced Qlik functions and visualizations to perform Pareto (ABC), Basket, and Monte Carlo analyses.
  • Explain inter-record functions and manual accumulations.
  • Apply clustering and classification techniques to perform sales analysis
  • Use advanced Qlik scripting techniques to resolve data load issues.
  • Use loops and nested loops to load and analyze multiple files.
  • Apply multiple Load prefixes in various analysis case examples.
  • Transform the data model by applying subroutines to allow script reusability.
  • Create multiple QVD layers.
  • Optimize the data load process by applying incremental loads.
  • Explain and apply debug processes.
  • Use system error variables for debugging purposes.
  • Discuss advanced technical concepts and solutions in real life scenarios.

For QlikView Developer - Essentials

  • Attend Qlikview Designer course or possess equivalent knowledge
  • Attend Understanding Data Principles course or possess equivalent knowledge

For QlikView Developer - Advanced

  • Fundamental knowledge of the Qlik products (QlikView or Qlik Sense) and their related concepts.
  • Basic understanding of the Qlik script, Qlik expressions, and functions.
  • Attend the business analyst and/or data architect core courses.
  • Proficient with building applications, creating dashboards, and performing basic ETL transformations using the data load script.
  • At least six months experience working with Qlik as a business analyst or data architect

  • Business Analysts
  • Data Architects

COURSE AGENDA

QlikView Developer - Essentials
(Duration : 3 Days)

1

Qlikview Development Methodology

2

Deployment

  • QlikView Desktop, Server and Publisher
3

Connect, select and load

  • 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
4

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
5

Synthetic Keys

6

Basic Data Model And Table Viewer

7

Adding Text Data

  • The File Wizard
  • Your Excel Files
  • Script generation using the File Wizard
8

Basic Data Transformation

  • Load Statement
  • Renaming a Field
  • Script Expressions
  • Loading an XML File
  • The Qualify Statement, Key Fields, Count and Sum
9

Generating Data In The Qlikview Script

  • Resident Load
  • The Where Exists Clause
10

Scripting Considerations

  • More about Synthetic Keys
  • Synthetic Key Tables
  • Composite Keys
  • Circular References
  • Loosely Coupled Tables
  • Eliminating Circular Reference
11

Master Calendar

  • Date and Time
  • The Master Calendar
  • Using Flags
  • Data & Date Islands
12

Mapping Tables

  • Mapping Tables
  • Cleaning up the Table Structure
  • Preceding Load on Preceding Load
13

Data Model Optimization

  • How to Create QlikView Data Models
  • Joining tables
  • Concatenation
  • From Snow Flake to Star Scheme
  • Merged Facts Table
  • Aggregating Data
14

Scripting And Data Modeling Challenges

  • Link Tables and Concatenated Tables
  • Calculating Net Change within a Field
  • Dynamic Aggregation
15

Loading Budget Data

  • Cross Tables and Input field
16

Advanced Calculations In Sheet Objects

  • Dimension Limits
  • Perform comparative analysis using Alternate
  • States
  • Set Analysis
  • Dollar-Sign Expansion & Aggr Function
17

Meta Data

  • Tags, Comments & Renaming
  • Null functions
  • HidePrefix & HideSuffix
18

Qlikview Data (Qvd) Files

  • QVD File Format and its use
  • Creating QVD Files
  • Store Statement
  • Manual Creation of a QVD File in the Script
19

Performance Optimization

  • Performance Tuning
  • Best Practices for QlikView File Optimization
20

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
QlikView Developer - Advanced
(Duration : 3 Days)

1

Using Qlikview

  • Starting QlikView
  • Basic Layout and Navigation
2

Sheets And Sheet Objects

  • Sheet Basics
  • Sheet Objects
3

Loading Data Into Qlikview

  • Script editing
  • Edit Script Toolbar
  • Edit Script Menu Commands
  • Statements Area
4

Creating The Script

  • Script generation
  • Creating a connection to the database
  • Reading tables into QlikView
5

Scripting Considerations And Data Modeling

  • Reading the QWT MDB
  • Synthetic key tables
  • Circular references
  • Causes of circular references
  • Loosely Coupled Tables
6

Loading An Xml File

  • Loading a text file in XML Format
  • Renaming fields using the Qualify statement
7

Generating Data In The Qlikview Script

  • Resident Load
  • Inline tables
  • Auto generate tables
8

Mapping Tables

  • Mapping Quarters to the Orders table
  • Month Year
  • Cleaning up the table structure
9

Qlikview Data (Qvd) Files

10

Qlikview Securities

11

Advanced Set Analyses

12

Comparative Analyses

13

Advanced calculations

14

Advanced transformations in script

15

Incremental loads and QVDs

16

Debugging and troubleshooting

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top