QlikView Developer Training 15 – 17 March 2016

This 3-day classroom session covers scripting, data source integration, and advanced GUI development. This module requires a basic working knowledge of databases and SQL.
Knowledge of data modelling, database connections and scripting fundamentals are critical if you want to create great QlikView applications. QlikView Developer provides you with an opportunity to learn by going through a series of lectures and hands-on exercises focused on developing QlikView documents. The Developer course will prepare you to take your QlikView documents to the next level.

Learning Objectives

By the end of this course, you will be able to:

  • Create a data model in QlikView
  • Build your own QlikView scripts
  • Adding Budgets
  • Resolve data structure issues
  • Access the Debugger
  • Understand advanced QlikView script functions for data manipulation
  • Build your own professional looking dashboards

We are here to help you learn. We do this by creating an environment that is positive, friendly and collaborative while ensuring all aspects of the developer training are covered.

The course will most likely be held at our premises on the North Shore and will be between 9:00am to 5:00pm at a cost of $2,500.00 plus GST per person for the three-day course. You will need to bring your own laptop.

  • 32 bit or preferably 64 bit Windows
  • 4GB of RAM or more
  • Admin rights on the machine
  • MS Access installed (preferably but we can work around it, please let us know if you don't have MS Access)

Venue:
Unit 17
33 Apollo Drive
Rosedale
Auckland
New Zealand

Please fill in the form below as an expression of interest as soon as possible if you would consider attending and we will contact you within one working day.
Once we have contacted you and confirmed, you will be invoiced for the attendee fee which will be non-refundable.

Your Name (required)

Title (required)

Company (required)

Email (required)

Phone (required)

If you have any further questions or would like more information regarding course content, please don’t hesitate to contact us.

 

Training Options

QlikView Training – End Users

Basic QlikView training for normal users. This course is often tailor-made to the client's unique QlikView application(s) and is normally held on site at customer's premises. Covers things like making selections, creation of bookmarks, printing and export. The documentation is based on your applications plus some standard examples.

This course covers all the needs of a QlikView end user.

  • Open QlikView documents
  • Refresh data
  • Introduction of QlikView objects
  • How to navigate through your application
  • List Box
  • Multi Box
  • Charts
  • Current selections (filters)
  • Selecting Data using filters
  • Search for data
  • Locking selections
  • Hierarchies and cycle groups
  • Sort
  • Bookmarks
  • Exporting data to excel
  • Printing of reports
  • Exercises

QlikView Training – Power User

This classroom course is intended for developers and "power users" in QlikView. To follow the course you need little or no prior experience with QlikView. The primary focus of the course is the toolbox of various sheet objects that are used for building the layout/user interface. We will begin by learning the basic functionality in a sample layout and then gradually start modifying and adding to it.

The course is intended as a solid introduction to QlikView, but those who intend to take the Developer, i.e. the general course for developers in QlikView, at a later occasion, may also benefit from it.

When you have finished the course, you should be proficient in the following areas:

  • How to use QlikView for searching information and generating reports.
  • How to design your own QlikView documents, complete with list boxes, tables, charts and any other sheet objects.
  • How to copy layout styles within and between documents.

QlikView Training – Developer

This three-day classroom course is recommended for power users, developers and IT staff that will be developing new or enhancing or maintaining existing QlikView applications. The session covers scripting, data source integration, and advanced GUI development. This module requires a basic working knowledge of databases and SQL.

Schedule

Course times daily: 
9:00am to 5:00pm.

Content daily outline

Day 1

  • QlikView Introduction
  • Versions
  • Installation
  • Project Plan
  • Data Sources
  • Star Schema
  • Smart Structure
  • User Settings
  • Document Settings
  • Script Editor
  • Syntax
  • SQL vs QlikView
  • Preceding Load
  • Connect
  • Linking Tables
  • How to "drive" QlikView
  • Correct interpretation of QlikView
  • Selecting data
  • Clearing selections
  • Search
  • Bookmarks
  • Bookmark Objects
  • Print
  • Export Data
  • Debugger
  • Logfiles
  • Dimensions
  • Create System Tab
  • System Fields
  • Synthetic Keys – how to avoid
  • Loops
  • Autonumber function
  • Loading data from Excel files
  • Loading data from XML files
  • Key Fields

Day 2

  • Mapping loads
  • Cleaning up table structure
  • Listbox Expression
  • Extended listbox functionality
  • QVD Exports
  • Front End best practices
  • Table Box
  • Charts
  • Calendar
  • Transformation of data using QlikView functions
  • Variables
  • Container Objects
  • Fiscal periods
  • Resident loads
  • Where function
  • Different ways of joining tables
  • Inline loading
  • Autogenerate

Day 3

  • Buttons
  • Macros
  • Loading Budgets
  • Cross tables
  • Input fields
  • Security
  • Sorting in charts
  • Selecting in charts
  • Cycle Groups
  • Drop down select in charts
  • Pivot tables
  • Reports
  • Set Analysis
  • Trouble-Shooting
  • Advanced scripting

QlikView Training – Customised

Customised training is offered to meet the needs of customers whose requirements may not fall into one of the 3 other main courses we provide.

This could be refresher training for power users who need an update or even an advanced developer session for those who have been working with QlikView for a while and are ready to learn more complex functionality.

Another example of customised training would be learning to administrate QlikView Server, including installation of all components and understanding and maintaining the QlikView Server in your environment.

The content is really up to you - our customised training service gives you the ability to have covered just what you need to know in a time-efficient way.