Qlik Sense Developer Training

Qlik Sense allows integrating different data sources and configuring the visualizations, allowing to follow a single discovery path through the data


  • This course will help you
    • Develop a Qlik Platform
    • Design Natural Analytics
    • Administrate Qlik Sense Server Cloud

6 Days

  • DW/BI Concepts
  • ER Modeling Concepts
  • Any scripting language exposure
  • Basic knowledge of cloud applications

1.a. Qlik Business Discovery

1.b. Qlik Project Methodology Framework

1.c. Qlik Project Plan

2.a. QlikSense Server Tokens

Chapter 3: Getting started with the data

3.a. The Relational Database Management Systems (RDBMS)

3.b. The Snowflake Schema

3.c. The Star Schema

3.d. Extracting data from databases, data files and Web Files

3.e Extracting data from Sharepoint sites and lists

3.f. The Data Model Viewer

4.a. Script Editor

4.b. Loading Data to Script Editor

4.c. Connecting to Databases

4.d. Basic Script Syntax

4.e. Basic Data Manipulation

4.f. Arranging Script: Comments and Tabs

4.g. Script Debugger

5.a. The Table Viewer

5.b. System Tables and System Fields

7.a. The File Wizard and Script Generation

7.c. The Qualify Statement

7.d. Key Fields

7.e. Count and Sum

7.f. Resident Load

7.g. Include Files

7.h. The Data Market

7.i. Managing Data Table Associations – Data Profiling

8.a. More About Synthetic keys

8.b. Composite Keys

8.c. Identifying and Eliminating Circular Reference

8.d. Loosely Coupled Tables

9.a. Date and Time Functions

9.b. Building the Master Calendar

9.c. Using Flags

9.d. Data and Date Islands

10.a. The Mapping Syntax

10.b. Cleaning up Structure

11.a. Joining Tables

11.b. Concatenation

11.c. From Snowflake to Star Schema

11.d. Aggregating Data

12.a. Link Tables and Concatenated Tables

12.b. Interval Match

12.c. Class

12.d. If Statement

12.e. Cross Tables

13.a. Set Analysis

13.b. Variables

13.c. Dollar-Sign Expansion

13.d. Aggr Function

13.e. Master Items

14.a. Tags

14.b. Comments

14.c. Rename

14.d. Null Functions

14.e. HidePrefix, HideSuffix

15.a. QVD File Format

15.b. Use in QVD Files

15.c. Store QVD

15.d. QVD File Script Functions

15.e. Building the Data Layer

16.a. Performance Tuning

16.b. Best Practises for File Optimization

Chapter 17: Discussing Qlik Framework and Solution

17.a. Installing Qlik Framework

17.b. Building Folder Structure

17.c. Best Practices