preloader
DataGeeks
DataGeeks

Qlik Sense Developer

Qlik Sense Developer (2 days)

With this training, it is aimed that users can access different data sources and create a data model using Qlik and SQL script language, load data related to this model and manage this model. Precondition: Persons who have knowledge of database structure and SQL query language should attend this training.

Qlik Sense Developer

  • Creating a Database Connection
  • Introduction to the Qlik Sense scripting language
  • Combination of SQL and Qlik Sense scripts
  • Creating table links
  • Reusing the table in memory(Resident)
  • Join Operations (Inner,Outer..)
  • Using Nested Load(Preceeding Load)
  • IF function (Conditional Operations)
  • Is null function
  • Using ‘where exists’
  • Qualify (Automatic change of column names)
  • Multi-key creation and Management of Syn Tables
  • Convert tables to vertical with the Crosstable command
  • Joining with the Mapping command
  • Concatenate Table Data
  • Drop Tables
  • Adding a Calendar Table
  • Peek command
  • Creating a Loop (While, for next)
  • Managing Debug Mode
  • Limited Load (Limited Load)
  • Creation and Management of QVD files
  • Incremental Load Only (Incremental Load)
  • Data Based Restriction to User (Section Access