Advanced Topics in Design and Development (Qlik Sense)
Are you ready to take your skills to the next level? Advanced Topics in Design and Development is a specialized course that discusses advanced technical concepts including applying expressions and functions, writing data load scripts, and data modeling strategies. It provides hands-on examples and demonstrates how these concepts can be applied to various business cases.
In English (online from Vilnius to the Baltics)
Lecturer: Milda Vitalyte, Qlik architect, Infotrust (Lithuania)
Class Type and Duration: Instructor-led, 2 days
Price per participant for 2 days: EUR 700
Invoice from Infotrust, UAB (Lithuania)
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.
- Business Analysts
- Data Architects
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.
- Advanced set analysis
- Comparative analysis
- Advanced calculations
- Advanced transformations in script
- Incremental loads and QVDs
- Debugging and troubleshooting