Module 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 Qlik Sense
- Qlik Sense Architecture
Module 2: Starting Qlik Sense
- 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
Module 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
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
Module 5: Manage Data
- Adding data from files and databases
- Loading data with the data load script
- Data Connections
- Various type of Data loads
- Profile Data with Qlik Sense
- Troubleshooting
Module 6: Creating a Data Model
- Qlik Sense Data Architecture
- Creating Star and Snowflake schema
- Use of Joins, Keeps, Concatenate etc..
- Understanding QVD layer
- Working on synthetic keys and circular references.
Module 7: Advanced Data Modelling
- Qlik Sense Star Schema
- Link Table
- Dimensions Table
- Master Calendar
- Optimizing data models
- Best Practices of Data Modelling
Module 8: Collaborate in QlikSense
- Data Storytelling
- Publishing
- Exporting and Printing
- Advanced Scripting and Chart Functions
- Qlik Tips and Techniques
Module 9: Introduction to Google Workspace
- Learning about Qlik Sense App and security features
- Providing Qlik Sense access to user sets
- Qlik Sense Security rules Code