Qlik Sense Certification Training

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

✔ Introduction to BI-Qlik Sense
✔ What is Business Intelligence (BI)?
✔ Features of Business Intelligence (BI)

✔ Concept of Facts and Dimension
✔ The fact table and Dimension table
✔ Star Schema and Snowflake Schema

✔ 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

✔ Comparing Qliksense Desktop, Cloud, and Enterprise

✔ Title, Description
✔ Settings
✔ Bookmarks
✔ Stories

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

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

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

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

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

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

✔ Filter Pane
✔ Bar
✔ Line
✔ Combo
✔ Pivot
✔ Table
✔ Text & Image
✔ KPI
✔ Gauge
✔ Waterfall
✔ Histogram
✔ Treemap
✔ Distribution Plot
✔ Scatter
✔ Pie
✔ Map

✔ Master Dimension
✔ Master Measure
✔ Master Visualization
✔ Alternate States

✔ What is synthetic key
✔ How the synthetic key generates
✔ Remove the Synthetic key
✔ What is Circular Reference
✔ How to remove Circular Reference

✔ How to use Joins in Qliksense

✔ Calendar Creation
✔ Purpose
✔ Date and Time Functions

✔ What is variable
✔ Use
✔ SET and LET

✔ If… Else…
✔ Nested If….

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

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

✔ Concept of Optimization
✔ Apply Map
✔ Keep

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

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

✔ Introduction
✔ Extension Editor
✔ Qlikview Converter
✔ Mashup Intro