QlikView Certification Training Course Syllabus
Full curriculum breakdown — modules, lessons, estimated time, and outcomes.
Overview: This QlikView Certification Training Course provides a comprehensive, hands-on introduction to QlikView and the broader business intelligence (BI) workflow. Spanning approximately 18 hours, the course guides learners from foundational BI concepts through data modeling, scripting, visualization, and server deployment. Each module combines theoretical knowledge with practical exercises, culminating in a capstone project where you build and deploy a complete BI application. Designed for beginners, the course ensures you gain real-world skills applicable in data-driven industries.
Module 1: Introduction to QlikView & BI Concepts
Estimated time: 1.5 hours
- BI fundamentals
- QlikView architecture
- Workbook overview
- Hands-on: Install QlikView Desktop and explore a sample dashboard
Module 2: Data Modeling & Associative Engine
Estimated time: 2.5 hours
- Associative data model
- Synthetic keys
- Star schema vs. snowflake
- Hands-on: Build a sample data model and resolve synthetic key issues
Module 3: Scripting & Data Loading
Estimated time: 3 hours
- Load script syntax
- Data sources (Excel, SQL, CSV)
- Incremental load
- Hands-on: Write scripts to load and transform data from multiple tables
Module 4: Charts, Objects & Layout
Estimated time: 3 hours
- Bar, line, pie charts
- List boxes and pivot tables
- Container objects
- Hands-on: Develop an interactive sales dashboard with multiple visuals
Module 5: Set Analysis & Advanced Expressions
Estimated time: 2 hours
- Set Analysis syntax
- Aggregation functions
- Variables
- Hands-on: Create comparative metrics and dynamic KPIs using Set Analysis
Module 6: Advanced Features: Macros, Triggers & Actions
Estimated time: 2 hours
- Automating tasks with macros
- Sheet triggers
- Button actions
- Hands-on: Add buttons to reload data and trigger report exports
Module 7: QlikView Server & Governance
Estimated time: 2.5 hours
- Server architecture
- Tasks and reload scheduling
- Security rules and user access
- Hands-on: Publish a document to QlikView Server and configure reload tasks
Module 8: Capstone Project – End-to-End BI App
Estimated time: 3 hours
- Combine data modeling, scripting, and visualization into a cohesive app
- Develop a fully functional QlikView application
- Implement a reload schedule and deploy the solution
Prerequisites
- Familiarity with basic data concepts
- Basic understanding of databases and SQL
- Access to a Windows machine for QlikView installation
What You'll Be Able to Do After
- Navigate the QlikView interface and apply core BI concepts
- Design and optimize associative data models
- Write and debug load scripts for ETL from multiple sources
- Create interactive dashboards with charts, tables, and dynamic objects
- Deploy QlikView applications on server with proper security and scheduling