Qlik Sense Advanced Scripting

Course Overview

Audience

For anyone that has attended a first level Qlik Sense or QlikView data modelling or developer course, or understands the basic principles and Qlik data modelling.

Expectations

By the end of the course you should have a clear understanding of the advanced techniques so that you can apply them to your own implementations.

Equipment

To attend this course you will need to bring a laptop running Windows and have either Qlik Sense Desktop installed or have rights on your laptop to be able to connect to the room WiFi.

Course Outline

This course is spread over two days and looks into the following topics. All topics are presented in a course book also acting as a reference guide.

  • Internal data storage
  • Data cleansing methods
  • Direct Discovery
  • Dealing with hierarchies
  • Sampling data
  • Handling slowly changing dimensions
  • Solve with Link tables
  • Useful  loops
  • Conditional and dynamic script
  • String manipulation
  • Load and comparing data rows
  • Useful date and time functions
  • Derived fields
  • QVD architecture and Incremental loads
  • Importing external expressions
  • Generating rolling 12 month data
  • Additional advanced concepts

Course Dates

  • 8 Jan 2018
    Virtual Classroom - (9am - 4pm (Central America))
    6 available spaces
  • 22 Jan 2018
    Virtual Classroom - (9am - 4pm (Central Europe))
    5 available spaces

Have a question?

Get in touch, we're here to help.

H

Or call us

07552 111329
07798 551147