QlikView Certification Training Course Course

Module 1: Introduction to QlikView & BI Concepts

⏳ 1.5 hours

• Topics: BI fundamentals, QlikView architecture, workbook overview.

• Hands-on: Install QlikView Desktop and explore a sample dashboard.

Module 2: Data Modeling & Associative Engine

⏳ 2.5 hours

• Topics: 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

⏳ 3 hours

• Topics: 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

⏳ 3 hours

• Topics: Bar, line, pie charts, list boxes, pivot tables, container objects.

• Hands-on: Develop an interactive sales dashboard with multiple visuals.\

Module 5: Set Analysis & Advanced Expressions

⏳ 2 hours

• Topics: Set Analysis syntax, aggregation functions, variables.

• Hands-on: Create comparative metrics and dynamic KPIs using Set Analysis.

Module 6: Advanced Features: Macros, Triggers & Actions

⏳ 2 hours

• Topics: Automating tasks with macros, sheet triggers, button actions.

• Hands-on: Add buttons to reload data and trigger report exports.

Module 7: QlikView Server & Governance

⏳ 2.5 hours

• Topics: Server architecture, tasks, security rules, user access.

• Hands-on: Publish a document to QlikView Server and configure reload tasks.

Module 8: Capstone Project – End-to-End BI App

⏳ 3 hours

• Topics: Combine data modeling, scripting, and visualization into a cohesive app.

• Hands-on: Deliver a fully functional QlikView application with reload schedule.

Get certificate