QLIK SENSE TRAINING
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.
Qlik Sense Training Curriculum
Qlik Training
Introduction:-
Introduction to BI Reporting
Difference between traditional BI reporting tools and Qlik reporting tool.
Unique features of Qlik
Qlik Architecture
Difference between QlikView and Qlik Sense
Data Modelling Concepts
Dimensions
Facts
SCDs
Star Schema
Snowflake Schema
Constellation Schema
Synthetic Keys
Circular Loops
Composite Keys
Link Table
Renaming Fields
Commenting Fields
Qualifier Statement
UnQualifier Statement
Join
Keep
Concatenate(Auto, Force, No)
Data Model Viewer
Selecting Tables & Fields
Previewing Data
Information Density
Subset Ratio
Key Fields
Where Exists()
Where Not Exists()
Data Load Editor
Types of Connections available
Creating Folder Connection
Connectors
Difference between OLEDB & ODBC
Load Types
Normal Load
Incremental Load(Insert, Update, Delete Scenarios)
Binary Load(Rules)
Resident Load(Group By clause)
Preceeding Load
Inline Load
Buffer Load
Bundle Info Load(QlikView)
Partial Reload(QlikView)
Creating QVDs by using STORE statement
Optimized Loads and techniques
LIB path
DROP TABLE Statement
DROP FIELD(S) Statement
Creating script variables by using SET & LET
Difference between SET & LET
#Include Statement
Functions
ApplyMap() with Mapping
CrossTable()
IntervalMatch()
Hierarchy()
Match(), MixMatch(), WildMatch()
Pick(), Peek(), Previous() and Nested Previous()
NullValue Handling
NullValue, IsNull(), NullAsValue
Above(), Below(), RowNo(), RecNo()
Difference between RowNo() & RecNo()
String Functions
SubField(), Index(), KeepChar(), PurgeChar(), Left(), Right(), Concat(), Len(), Trim(), Replace(), Upper(), Lower(), Capitalize()
Table Functions
NoOfFields(), NoOfRows(), NoOfTables() [Script&Chart Function]
Aggregation Functions
Sum(), Avg(), Min(), Max(), Count()
Date Functions
Date, Date#, Year(), Quarter(), Ceil(), Floor(), Month(), MonthName(), Week(), WeekDay(), Day(), Num(), Num#(), Mkdate(), IterNo() with While clause, Interval(), Today(), Now(), MonthStart(), YearStart(), QuarterStart(), WeekStart(), AddMonths()
Fabs()
Creating a Master Calendar and its uses
Creating Bucket Ranges by using nested if() condition
Section Access
Defining security at data level by using Section Access
Preparing the source data for Section Access
App Overview
Creating Sheets & Sheet Properties
Creating Objects or Charts & Object Properties
Filter Pane, Bar Chart, Line Chart, Combo Chart, Pie Chart, Gauge Chart, KPI, Text & Image, Table, Pivot Table
Difference between Table & Pivot Table
Scatter Plot, Treemap, Map
Custom or Extension Objects
Variable, Default Selections Extension etc
Getting 3rd party Extension Objects into Qlik
Master Items
Creating Dimensions(Single, DrillDown)
Creating Measures
Visualizations
Creating Variables in front end in Variable window
Difference between back end(script) and front end variables
Selections Tool
Selections Bar
App Options
Changing Thumbnails at app & sheet level
Bookmarks
How to create Bookmarks for saving selections
Set Analysis
What is Set Analysis ?
Identifiers, Operators and Modifiers
P() & E() element functions
Writing Set Analysis expressions
Rolling Expressions(Dynamically)
YTD, MTD, QTD, WTD expressions(Dynamically)
Using variables in Set Analysis expressions with $ sign expansion
Restricting specific and complete selections
Chart Functions
Class() for creating bucket ranges
AGGR()
Sum(), Avg(), Min(), Max(), Count()
Rank()
GetFieldSelections(), GetSelectedCount(), GetCurrentSelections()
ReloadTime()
Qlik Management Console(QMC)
Qlik Sense Admin Activities like Publishing the app in various Streams, Changing the owner of the app, Automate Reloads by Creating Schedule Triggers, Task Event Triggers, Assigning Token Access to users and developers, Creating Streams, Assigning Stream Access to users and developers
Advanced Topics
Difference between Qlik Sense 3.0, 3.2, September 2017, November 2017 and June 2018 versions
Dev Hub
Single Configurator
Extension Editor
Mashup Editor
QlikView Converter
Identifying Sheet Ids and Object Ids