Qlik Sense Training

BY
Mindmajix Technologies

Mode

Online

Fees

₹ 10000 12500

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study, Virtual Classroom
Mode of Delivery Video and Text Based
Frequency of Classes Weekdays, Weekends

Course and certificate fees

Fees information
₹ 10,000  ₹12,500

The fees for course Qlik Sense Training is -

HeadOriginal PriceDiscounted Price
Self-Paced Videos
Rs. 12500Rs. 10000
Live Instructor-Led
Rs. 26073Rs. 20859
certificate availability

Yes

certificate providing authority

Mindmajix Technologies

The syllabus

Introduction to BI-Qlik Sense

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

Qlik Sense

  • Introduction
  • Features of Qliksense
  • Pros and cons of Qliksense
  • Concept of Association in Qliksense

Data warehouse concepts

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

Starting of Qliksense (QS)

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

Qliksense Types

  • Comparing Qliksense 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 Qliksense

  • 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

Joins in Qliksense

  • How to use Joins in Qliksense

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
  • Qlikview Converter
  • Mashup Intro

Practice Test & Interview Questions

Instructors

Mr Bhagat
Instructor
Freelancer

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books