Qlik Sense Advanced Topics in Design and Development (in English)

Skills Learned

• Implement front-end solutions with advanced Qlik expressions and calculations.
• Perform advanced set analysis operations, using advanced search expressions and element functions.
• Perform comparative analysis using alternate states.
• Use advanced Qlik functions and visualizations to perform Pareto (ABC), Basket, and Monte Carlo analyses.
• Explain inter-record functions and manual accumulations.
• Apply clustering and classification techniques to perform sales analysis Use advanced Qlik scripting techniques to resolve data load issues.
• Use loops and nested loops to load and analyze multiple files.
• Apply multiple Load prefixes in various analysis case examples.
• Transform the data model by applying subroutines to allow script reusability.
• Create multiple QVD layers.
• Optimize the data load process by applying incremental loads.
• Explain and apply debug processes.
• Use system error variables for debugging purposes.
• Discuss advanced technical concepts and solutions in real-life scenarios.

Audience

Course Prerequisites

Fundamental knowledge of the Qlik products (QlikView or Qlik Sense) and their related concepts.
Basic understanding of the Qlik script, Qlik expressions, and functions.
It is recommended that the students have also attended the business analyst and/or data architect core courses. Proficient with building applications, creating dashboards, and performing basic ETL transformations using the data load script.
At least six months of experience working with Qlik as a business analyst or data architect.

Course Outline

• Advanced set analysis
• Comparative analysis
• Advanced calculations
• Advanced transformations in script
• Incremental loads and QVDs
• Debugging and troubleshooting