Introduction to QlikView
- QlikVIew: Course Introduction
- Course Syllabus
- QlikView Overview
- Introduction to Relational Database
- Data Files
- Dimensions and Measures
- Introduction to QlikView
Introduction to Scripting
- Install QlikView Desktop
- Introduction to Scripting
- Connect to the Database
- Script Syntax and Data Load
- Load Fact Tables
- Introduction to Scripting
Data Modeling Basics
- Understanding data model
- Synthetic Keys
- Remove Synthetic Key from the Data Model
- Data load from an Excel file
- Load a table from an Excel file
- Load data from XML file
- How to resolve circular loops and synthetic keys
- Data Modeling Basics
Generating Data in the Script
- How to generate data in the script
- Generating data in the script using Resident load
- Master Calendar
- Master Calendar Script
- Improved Master Calendar Script
- Mapping tables
- Add Mapping tables and Preceding load to the script
- Generating data in the script
Data Model Optimization
- Joins vs Concatenate
- Join or Concatenate tables
- Optimize data model
- Create star schema
- Data Model Optimization
Data Model Challenges
- Cross tables
- Load data from Cross table
- Link tables
- Create a Link table
- Data Model Challenges
Scripting Considerations
- Slowly Changing Dimensions
- IntervalMatch function
- Introduction to Set Analysis
- Set Analysis Basics
- Set Analysis Basics - QVW
- Power of Set Analysis Part I
- Power of Set Analysis Part II
- AGGR function
- QlikView Data Files(QVD)
- Load data from QVD
- Metadata
- Add metadata
- Scripting Considerations
Security
- Introduction to document security
- Add Section Access
- Security
- Summary
QlikView Scripting: Tips and Tricks
- QlikView Script Syntax: 3 Pitfalls to Avoid
- QlikView Substring Functions
- QlikView Set analysis Cheat Sheet
- Optimize Your QlikView Application Using Document Analyzer
