Qlik Sense Online Training Content
This Qlik sense course offers topic-based and hands-on learning on data management, transformation, modelling, and visualizations. Our Qlik Sense Online Training includes optimization techniques, advanced script functions, and advanced new features and visualizations. We ensure learners receive the most industry-relevant training and acquire the in-demand job skills needed in the Data Science Job market.
Introduction to BI-Qlik Sense
- What is Business Intelligence (BI)?
- Features of Business Intelligence (BI)
Data warehouse concepts
- Concept of Facts and Dimension
- Fact table and Dimension table
- Star Schema and Snowflake Schema
Qlik Sense
- Introduction
- Features of Qliksense
- Pros and cons of Qliksense
- Concept of Association in Qliksense
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
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
Incremental Load
- Introduction
- Use
- Insert Only, Insert Update, Insert Update and Delete
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
