Qlik Sense

What are the objectives and learning outcomes of this course?

Qlik Sense is an ultimate business analytics tool. It enables efficient self-service analytics that can be easily deployed via interactive and personalized dashboards, data visualization, and insightful reports. From this course, you get a clear picture of Qlik Sense Introduction & Installation

Starting QlikSense

Designing Visualizations

Creating a Data Model

Collaborate in Qlik Sense

Qlik Sense Security

Related Jobs and Positions in the Industry

QlikSense Training Course introduces the concepts of Visualizations, Creating and Managing a Data Model and overview of Qlik Sense Security. All these concepts make you an expert in using Qlik Sense and grasp complete knowledge in executing its functionalities.

Who should do this course?

As such there are no prerequisites for learning QlikSense. However, with a number of opportunities in the field, the following job roles will get benefited from this course:

Business users

Data analysts

Testing professionals

Reporting professionals

IT architects

Aspirants aiming for a career in the prospective field.

What projects are included in this course?

An in-depth knowledge of a QlikSense project ensures all the critical components are well-covered. With this knowledge, you can increase your visibility and enhance your efficiency in drawing real connections among different components of QlikSense. We will also provide the complete material covering all the aspects of this project.

Qlik Sense Course Content

Qlik Sense Introduction & Installation

How Qlik Sense varies from QlikView? Need for self-service business intelligence/business analytics tools, Qlik Sense data discovery, intuitive tool for dynamic dashboards and personalized reports, installation of Qlik Sense & Qlik Sense Desktop.

Hands-on Exercise – Install Qlik Sense & Qlik Sense Desktop

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.

Hands-on Exercise-Install Qlik Sense & Qlik Sense Desktop

Qlik Sense Data Model

Understand Data Modeling, best practices, turning data columns into rows, converting data rows into fields, hierarchical level data loading, loading new or updated data from database, using a common field to combine data from two tables, handling data inconsistencies.

Hands-on Exercise – Turn data columns into rows,Convert data rows into fields, Load the data in hierarchical level, Load new or updated data from database, Use a common field to combine data from two tables

Creating a Data Model

Qlik Sense Data Architecture, understanding QVD layer, converting QlikView files to Qlik Sense files, working on synthetic keys and circular references.

Hands-on Exercise – Convert QlikView files to Qlik Sense files, Resolve synthetic keys and circular references

Advanced Data Modeling

Qlik Sense Star Schema, Link Table, Dimensions Table, Master Calendar, QVD files, optimizing data modeling.

Hands-on Exercise – Create a Qlik Sense Star Schema, Create Link Table, Dimensions Table, Master Calendar, QVD files

Qlik Sense Enterprise

Qlik Sense Enterprise class tools, Qlik Sense custom app, embedding visuals, rapid development, powerful open APIs, enterprise-class architecture, Big Data integration, enterprise security and elastic scaling.

Qlik Sense Visualization

Learning about Qlik Sense Visualization tools, Chart & Map creation, rich data storytelling, sharing analysis visually with compelling Visualizations.

Hands-on Exercise – Create Chart & Map , Create a story around dataset, Share analysis

Set Analysis

Understanding Set Analysis in Qlik Sense, the various parts of a set expression like Identifiers, Operators, Modifiers and Comparative Analysis.

Hands-on Exercise – Do Set Analysis in Qlik Sense, Use set expression like Identifiers, Operators, Modifiers and Comparative Analysis

Advance Set Analysis

Learning about set analysis which is a way of defining a set of data values different from normal set, deploying comparison sets, Point in Time analysis.

Hands-on Exercise – Deploy comparison sets, Perform Point-in-Time analysis

Hands-on Exercise – Do Set Analysis in Qlik Sense, Use set expression like Identifiers, Operators, Modifiers and Comparative Analysis

Qlik Sense Charts

Introduction to the various charts in Qlik Sense like Line Chart, Bar Chart, Pie Chart, Table Chart, Pie Chart, Pivot Table Chart, the characteristics of various charts.

Hands-on Exercise – Plot charts in Qlik Sense like Line Chart, Bar Chart, Pie Chart, Table Chart, Pie Chart, Pivot Table Chart

Hands-on Exercise – Do Set Analysis in Qlik Sense, Use set expression like Identifiers, Operators, Modifiers and Comparative Analysis

Advance Charts

Understanding what is KPI Chart, Gauge Chart, Map Chart, Scatter Plots Chart, Map Chart/Geo Map.

Hands-on Exercise – Plot KPI Chart, Gauge Chart, Map Chart, Scatter Plots Chart, Map Chart/Geo Map.

Hands-on Exercise – Do Set Analysis in Qlik Sense, Use set expression like Identifiers, Operators, Modifiers and Comparative Analysis

Master Library

Introduction to the Qlik Sense Master Library, its benefits, distinct features and user-friendly applications.

Hands-on Exercise – Explore and use Qlik Sense Master Library

Qlik Sense Storytelling

Understanding how to do storytelling in Qlik Sense, the creation of storytelling, story playback.

 Hands-on Exercise – Use storytelling feature of Qlik Sense, Create a story, Playback the story

Mashups

Understanding Mashups in Qlik Sense, creating a single graphical interface from more than one sources, deploying the Mashups flowchart, testing of Mashups, the various Mashup scenarios like Simple and Normal.

Hands-on Exercise – Create a single graphical interface from more than one sources, Deploy the Mashups flowchart, Test Mashups

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 preview image.

Hands-on Exercise – Work with Qlik Sense extension, Use a template in Qlik Sense Extension and test it, Make Hello World dynamic, Add 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.

Hands-on Exercise – Create security rules in Qlik Sense, understanding data reductions and dynamic data reductions, user access workflow

Qlik Sense Project

Project 1

Objective – This project involves working with the Qlik Sense dashboard that displays the sales details whether order wise or year wise, customer wise sales, product wise sales and so on, doing comparative analysis, rolling 6 months analysis that should be display the trend of sales, placing the worksheets in a user story and publishing.

Project 2

Domain – Data Analytics

Objective – To see the current values of salaries in one column and historical values in another cell in a chart that would contain a bar chart and a trend chart