Introduction

Keen Technologies Qlik Sense Training makes you an expert in using Qlik Sense and grasp complete knowledge in executing its functionalities. Learn the concepts of Visualizations, Creating and Managing a Data Model and overview of Qlik Sense Security…etc.

Course Content

1. 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

2. Starting QlikSense

• 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

3. 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

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

5. 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

6. 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.

7. Advanced Data Modelling

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

8. Collaborate In Qlik Sense

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

9. Qlik Sense Security

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