Objectives
Eligibility
Course Outline
Qlik Sense helps you do more with data. Easily combine any data sources, no matter how large or complex, into a single view. Qlik’s Associative Engine indexes and understands the relationships between all the values in your data, both related and unrelated, so you can explore in any direction your intuition takes you and quickly spot hidden insights. There are no pre-aggregated data models or predefined queries to limit discovery. And with powerful AI to assist analysis and accelerate analytics creation, anyone can ask new questions without waiting on data experts to get answers.

With Qlik Sense, everyone can make smarter, more informed decisions, together. No matter how small or large your team, easily share insights and work collaboratively in powerful ways:

Stay connected with a unified hub: Find and publish analytics and apps to a centralized hub, both on-premise and in the cloud.

Collaborate securely: Create and share libraries of data, analytics and visualizations, to drive business innovation together.

Create interactive stories: Build guided stories using analytics, with links to live analysis to facilitate discussion. You can also export to popular file formats.
Excel
Any Databse Knowledge
Basic Mathamatics and Statistics
R Programming for Advance Analytics
• Introduction
• QlikSense Introduction & Installation
• What is QlikSense?
• Comparing QlikSense Desktop with QlikSense
• Installing QlikSense Desktop
• How QlikSense varies from QlikView?
• Starting with QlikSense Desktop
• Opening an app with QlikSense
• QlikSense Architecture
• 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
• 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
• 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
• QlikSense 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
• QlikSense 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
• Qliksense Tips and Techniques
• QlikSense Security
• Learning about QlikSense App and its security features
• Providing QlikSense access to user sets
• QlikSense Security rule code

• QlikSense Admin and Security
• QlikSense Admin course content
• Managing a QlikSense site
• Manage licenses
• Manage access types
• Configure nodes
• Manage data connections
• Manage content security (by security rules)
• Manage tasks and triggers
• Synchronize users
• Navigating in the QMC
• Keyboard shortcuts in QMC
• UI icons and symbols
• The QMC start page
• Resource overview page
• Resource edit page
• Searching and filtering in the QMC
• QMC resources overview
• Apps
• Content libraries
• Data connections
• Analytic connections
• App objects
• Streams
• Tasks
• Users
• Audit
• Security rules
• Custom properties
• License management
• Extensions
• Tags
• On-demand apps
• User directory connectors
• Monitoring apps
• Nodes
• Engines
• Printing
• Proxies
• Virtual proxies
• Schedulers
• Repositories
• Distribution policies
• Load balancing rules
• Certificates
• Service certificates
• Managing QMC resources
• Managing licenses
• Managing apps
• Managing on-demand apps
• Managing streams
• Managing data connections and extensions
• Managing users
• Managing tasks and triggers
• Managing nodes and services
• Using custom properties
• Using tags
• Configuring Qlik Sense
• Default configuration
• Configuring security
• Configuring load balancing rules