BI QLIK: Qlik Sense Data Modeling – Advanced

Content:
Schemes and creation of a data model Qlik Sense. Data architecture Basics of script creation. Loading tables from various files (Access, Excel, txt, xml, direct load …). Conflicts in model creation and their possible solutions. Data model Viewer Resident load. Load with the WHERE condition. Mapping Load. Load on a Load. Data model optimization. Variables MasterCalendar – work with dates Data Modeling best practices: flags drop store loading exchange rates from a web page loading the PivotTable. Categorization of values. Link Table and Concatenate Data transformation: incremental load missing data Minimize memory requirements. Loops Reload monitoring (Debug, Trace) Security Subroutines.

Target Group: This course is aimed at employees who have participated in the Data Manager – Self-service module or those with a basic experience with data modelling. This course teaches participants the basic elements of Qlik scripting language. No prior knowledge of scripting is needed. It is intended for future Qlik Sense developers or current ones who want to freshen up their skills. The course is built on a real-life scenario use-case and apart from scripting, it covers data model optimization methods, intro into basic security principles and data architecture. To perform data modelling in your day to day work, you will need Professional User license. The course only covers work in back-end of Qlik Sense.

This learning and development activity is based on approval. If you are interested in it, you must apply via the employee profile (My employee file) in myFox, in the Development section.