Qlik Sense is a self-service data analytics tool that enables you to create your own visualizations and application, thereby not restricting you to pre-made charts and visuals. It enables you to extend your analytical capabilities and helps you perform business functions much more proficiently. Qlik Sense is a modern, user-friendly data visualization and business intelligence (BI) platform that empowers users to explore and analyze data, create interactive dashboards and reports, and make data-driven decisions. Its associative data model, self-service capabilities, and focus on data discovery make it a popular choice among businesses looking to extract insights from their data. The training’s modern curriculum is curated to comply with the requirements to crack the Qlik Sense Data Architect and Qlik Sense Business Analyst exams.

Course Objectives:

In this course, you will learn to:

• Understand how to create apps and Visualization using Qlik Sense
• Create data load scripts
• Work on Specific Requirements of Customers
• Design Advanced Data Visualizations and Complex Data Models
• Work and collaborate with different Data Sources
• Concepts of Qlik Sense tool and data loading
• Plan and Design Data Modeling
• Learn Advanced Modeling, setting variables and analyzing them
• Qlik Sense Desktop
• Manage, Monitor and Configure Qlik Sense using QMC
• Qlik Sense Security Features and Apps
• Constructing Qlik Sense Master Library

Course content

Introduction to BI-Qlik Sense

• What is Business Intelligence (BI)?
• Features of Business Intelligence (BI)

Qlik Sense

• Introduction
• Pros and cons of Qlik Sense
• Concept of Association in Qlik Sense

Qlik Sense Features

• Drag-and-drop visualization, Qlik Data indexing engine
• Data Dimensions relationships
• Connect to multiple data sources
• Creating your own dashboards, data visualization
• Visual Analytics, ease of collaboration

Data warehouse concepts

• Concept of Facts and Dimension
• Fact table and Dimension table
• Star Schema and Snowflake Schema

Starting of Qlik Sense (QS)

• Installation
• How to start the Qlik Sense (QS)
• Qlik Sense navigation
• App Overview – Introduction
• Data Manager – Introduction
• Data Model Viewer – Introduction
• Data Load Editor – Introduction
• Open Hub- Introduction

Qlik Sense Types

• Comparing Qlik Sense Desktop, Cloud and Enterprise

App Overview

• Title, Description
• Settings
• Bookmarks
• Stories

Data Manager

• Adding a new data table
• Connecting a New Data source
• Loading the data from the source
• Loading from Web File
• Manual Entry
• File Locations

Editing the table

• Changing the Field Types
• Assessing table field data
• Cross Tab- Unpivot
• Calculated Fields (Add field)

Data Load Editor

• Data connections
• Debug
• Loading and Storing the Data
• QVD files
• Create QVD files
• Reading Data from QVD files

Filters and Group by in Qlik Sense

• Where clause
• And\Or Options
• Conditions to write Group By
• Sample Group By

Filters and Group by in Qlik Sense

• Where clause
• And\Or Options
• Conditions to write Group By
• Sample Group By

Joins

• Introduction to Joins
• Left, Right, Inner, Outer

Data Model Viewer

• Source Table View
• Internal Table View
• Preview of Table
• Subset Ratio
• Information Density

Sheet Properties

Fields 

Charts

• Filter Pane
• Bar
• Line
• Combo
• Pivot
• Table
• Text & Image
• KPI
• Gauge
• Waterfall
• Histogram
• Tree map
• Distribution Plot
• Scatter
• Pie
• Map

Master Items

• Master Dimension
• Master Measure
• Master Visualization
• Alternate States

Synthetic Key & Circular Reference

• What is synthetic key
• How the synthetic key generates
• Remove Synthetic key
• What is Circular Reference
• How to remove Circular Reference
• How to use Joins in Qlik Sense

Master Calendar

• Calendar Creation
• Purpose
• Date and Time Functions

Variable 

• What is variable
• Use
• SET and LET

MTD & YTD Concepts

Conditional Expression

• If… Else…
• Nested If….

SET Analysis

• Introduction
• Concept of SET Analysis
• Use
• Syntax
• Direct and Indirect SET

Data Model 

• Concatenation
• Types of Concatenation
• Resident Load
• Inline Load
• Creating Data Model with sample data

Optimized & Non-optimized load 

• Concept of Optimization
• Apply Map
• Keep

Incremental Load

• Introduction
• Use
• Insert Only, Insert Update, Insert Update and Delete

Section Access 

• Concept of Section Access
• Why Section Access is necessary
• Types (NTNAME and USER ID)
• Document Level
• Data Level

Dev Hub

• Introduction
• Extension Editor
• Qlik View Converter
• Mashup Intro

Extensions

• Understanding Qlik Sense extension
• Working with it, the various templates in Qlik Sense Extension, testing of it
• Making Hello World dynamic
• Learning how it works and adding a preview image

Security

• The various security aspects of Qlik Sense
• Content security, security rules
• The various components of security rules
• Understanding data reductions and dynamic data reductions
• User access workflow

To see the full course content Download now