Qlik Sense Online Training

 >>  Qlik Sense Online Training

Qlik Sense Online Training


 (4.8) | 750 Ratings


Introduction


Qlik Sense Online Training Details
Track Regular Track Weekend Track Fast Track
Course Duration 30 Hrs 8 Weekends 5 Days
Hours 1hr/day 2 Hours a day 6 Hours a day
Training Mode Online Classroom Online Classroom Online Classroom
Delivery Instructor Led-Live Instructor Led-Live Instructor Led-Live


Course Curriculum

Qlik Sense Online Training Introduction

  • Qlik Sense Introduction & Installation
  • What is QlikSense?
  • Comparing Qlik Sense Desktop with Qlik Sense
  • Installing Qlik Sense Desktop
  • How Qlik Sense varies from QlikView?
  • Starting with QlikSense Desktop
  • Opening an app with QlikSense
  • QlikSense Architecture

Starting QlikSense

  • Navigating in the user interface
  • Data Manager
  • Data Load Editor
  • Data Model Viewer
  • Interacting with the user interface
  • Creating apps and Visualizations
  • Structuring an app with Sheets

Designing Visualizations

  • Different type of Visualizations
  • Dimensions and Measures in a CHART
  • When to use and What Chart to Use
  • Selections in a Visualization
  • Settings and Properties of each Visualization

Using Expressions In Visualization

  • Expressions , Functions and Variables
  • Working with Expression Editor
  • Using Functions in Charts
  • Using Variables in Expressions
  • Set Analysis and Set Expressions
  • Working with Master Items

Manage Data

  • Adding data from files and databases
  • Loading data with the data load script
  • Data Connections
  • Various types of Data loads
  • Profile Data with QlikSense
  • Troubleshooting

 Creating A Data Model

  • Qlik Sense Data Architecture
  • Creating Star and Snowflake schemas
  • Use of Joins, Keeps, Concatenate etc..
  • Understanding QVD layer
  • Working on synthetic keys and circular references.

Advanced Data Modelling

  • Qlik Sense Star Schema
  • Link Table
  • Dimensions Table
  • Master Calendar
  • Optimizing data models
  • Best Practices of Data Modelling

Collaborate In Qlik Sense

  • Data Storytelling
  • Publishing
  • Exporting and Printing
  • Advanced Scripting and Chart Functions
  • Qlik Tips and Techniques

Qlik Sense Security

  • Learning about Qlik Sense App and its security features
  • Providing Qlik Sense access to user sets
  • Qlik Sense Security rule code

 Practice Test & Interview Questions

Loads

  • Inline Load
  • Preceding load and Preload
  • Resident load
  • Partial Reload (add, ADD only)
  • Mapping load
  • Buffer load
  • Generic load
  • Cross table
  • Info load
  • Apply map ()
  • Lookup ()
  • Binary load
  • Incremental Load

Script Functions

  • Intervalmatch ()
  • Year, Month, Day, Quarter, Hour, Minute, Second
  • DATE, DATE#, TIMESTAMP, TIMESTAMP#
  • Num, Num#
  • Peek ()
  • SET, LET- Variables
  • Variable overview
  • $ (sign expansion)

Extension Handling

QlikSense project

Exam & Certification

0

Course Review

(4.8)
5 stars
4 stars
3 stars
2 stars
1 stars

Course Curriculum

Qlik Sense Online Training Introduction

  • Qlik Sense Introduction & Installation
  • What is QlikSense?
  • Comparing Qlik Sense Desktop with Qlik Sense
  • Installing Qlik Sense Desktop
  • How Qlik Sense varies from QlikView?
  • Starting with QlikSense Desktop
  • Opening an app with QlikSense
  • QlikSense Architecture

Starting QlikSense

  • Navigating in the user interface
  • Data Manager
  • Data Load Editor
  • Data Model Viewer
  • Interacting with the user interface
  • Creating apps and Visualizations
  • Structuring an app with Sheets

Designing Visualizations

  • Different type of Visualizations
  • Dimensions and Measures in a CHART
  • When to use and What Chart to Use
  • Selections in a Visualization
  • Settings and Properties of each Visualization

Using Expressions In Visualization

  • Expressions , Functions and Variables
  • Working with Expression Editor
  • Using Functions in Charts
  • Using Variables in Expressions
  • Set Analysis and Set Expressions
  • Working with Master Items

Manage Data

  • Adding data from files and databases
  • Loading data with the data load script
  • Data Connections
  • Various types of Data loads
  • Profile Data with QlikSense
  • Troubleshooting

 Creating A Data Model

  • Qlik Sense Data Architecture
  • Creating Star and Snowflake schemas
  • Use of Joins, Keeps, Concatenate etc..
  • Understanding QVD layer
  • Working on synthetic keys and circular references.

Advanced Data Modelling

  • Qlik Sense Star Schema
  • Link Table
  • Dimensions Table
  • Master Calendar
  • Optimizing data models
  • Best Practices of Data Modelling

Collaborate In Qlik Sense

  • Data Storytelling
  • Publishing
  • Exporting and Printing
  • Advanced Scripting and Chart Functions
  • Qlik Tips and Techniques

Qlik Sense Security

  • Learning about Qlik Sense App and its security features
  • Providing Qlik Sense access to user sets
  • Qlik Sense Security rule code

 Practice Test & Interview Questions

Loads

  • Inline Load
  • Preceding load and Preload
  • Resident load
  • Partial Reload (add, ADD only)
  • Mapping load
  • Buffer load
  • Generic load
  • Cross table
  • Info load
  • Apply map ()
  • Lookup ()
  • Binary load
  • Incremental Load

Script Functions

  • Intervalmatch ()
  • Year, Month, Day, Quarter, Hour, Minute, Second
  • DATE, DATE#, TIMESTAMP, TIMESTAMP#
  • Num, Num#
  • Peek ()
  • SET, LET- Variables
  • Variable overview
  • $ (sign expansion)

Extension Handling

QlikSense project

    Click here for Help and Support: info@sacrostectservices.com     For Inquiry Call Us:   +91 996-629-7972(IND)

  +91 996-629-7972(IND)
X

Quick Enquiry

X

Business Enquiry