Qlik Sense: Introduction & Installation

  • What is QlikSense?
  • Comparing Qlik Sense Desktop with Qlik Sense
  • Installing Qlik Sense Desktop
  • How Qlik Sense varies from QlikView?
  • Starting with QlikSense Desktop
  • Opening an app with QlikSense
  • QlikSense Architecture

Starting QlikSen

  • Navigating in the user interface
  • Data Manager
  • Data Load Editor
  • Data Model Viewer
  • Interacting with the user interface
  • Creating apps and Visualizations
  • Structuring an app with Sheets

Designing Visualizations

  • Different type of Visualizations
  • Dimensions and Measures in a CHART
  • When to use and What Chart to Use
  • Selections in a Visualization
  • Settings and Properties of each Visualization

Module 4 – Using Expressions in Visualization

  • Expressions, Functions and Variables
  • Working with Expression Editor
  • Using Functions in Charts
  • Using Variables in Expressions
  • Set Analysis and Set Expressions
  • Working with Master Items

Manage Data

  • Adding data from files and databases
  • Loading data with the data load script
  • Data Connections
  • Various types of Data loads
  • Profile Data with QlikSense
  • Troubleshooting

Creating a Data Model

  • Qlik Sense Data Architecture
  • Creating Star and Snowflake schemas
  • Use of Joins, Keeps, Concatenate etc..
  • Understanding QVD layer
  • Working on synthetic keys and circular references.

Advanced Data Modelling

  • Qlik Sense Star Schema
  • Link Table
  • Dimensions Table
  • Master Calendar
  • Optimizing data models
  • Best Practices of Data Modelling

Collaborate in QlikSense

  • Data Storytelling
  • Publishing
  • Exporting and Printing
  • Advanced Scripting and Chart Functions
  • Qlik Tips and Techniques

Qlik Sense Security

  • Learning about Qlik Sense App and its security features
  • Providing Qlik Sense access to user sets
  • Qlik Sense Security rule code