- May 13-14, 2025, 9:00-17:00 | 2 full working days
- In Latvian language
- Online via MS Teams (no recording for certified trainings is allowed): a link will be sent to all registered participants
- Lecturer: Uldis Putnins, Qlik architect, The Infotrust
- Price per participant for 2 days: EUR 840
- Invoice from The Infotrust, UAB (Lithuania) – prepayment will be needed (re. other payment terms prefered kindly write l.kriukeliene@theinfotrust.com)
- E-material will be accesible 6 month after the trainings on Qlik education portal
- Confirmation of attendance document will be provided by The Infotrust
Description
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.
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
- Business Analysts
- Data Architects
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
Price per participant for 2 days: EUR 840
By registering, You confirm that You have read and agreed to Privacy policy & The Infotrust statement.
Qlik Sense Advanced Topics in Design and Development (pdf)
