1. Qlikview Developer Training
• OLTP Vs OLAP
• In-memory vs in-database analytics
• Big Data Analytics o Qlikview and Tableau
• Installing Qlikview
• Qlikview UI
• Loading Data to Qlikview o MS EXCEL/ACCESS
o HADOOP
o SQLSERVER/ORACLE
• Introduction to Scripting
• Types of Loading into Qlikview o Buffer load
o Binary load
o Incremental load
o Resident Load
• Data Model
o Star schema vs Single Table
o Understanding how qlikvew stores data – Architecture
o Joins – Left/Right ; Keep Left , Keep Right
o Concatenate vs Joins
o Qualify statement
o QVD – Internals
o QVX vs QVD vs QVS
|
• Data Model Advanced o Synthetic Keys
o Circular Loops
o Linked Table
o Cross table
o Mapping Tables
o Master Calendar
• UI Design
o Charts/Pivots
o Using external plugins like geoMap, wordcloud
• Advance UI
o Set Analysis
o Slowly Changing Dimension
o Aggregate functions
• Security
o Section Access
• Qlikvew Development and Deployment– Real time
• Qlikview Server and Publisher – Concepts
• QlikSense Overview
|
