- December 15-16 (2 full working days: 8:30-16:30; 2 coffee breaks)
- English language
- Price per participant for 2 days: EUR 1120
- On-site. Location: Spaces Bulevardi, Bulevardi 21, entrace Albertinkatu 25, Helsinki, Finland
- Lecturer: Milda Vitalyte-Masaite, Qlik architect, The Infotrust
- E-material will be accesible 6 month after the trainings on Qlik education portal
- Confirmation of attendance document will be provided by The Infotrust
- Prepayment will be needed (an invoice from The Infotrust Oy). For other payment terms, kindly contact l.kriukeliene@theinfotrust.com
Trainings structure&timing:
8:30 – 10:00 trainings
10:00 – 10:15 coffee break (provided by organizers)
10:15 – 12:00 trainings
12:00 – 13:00 lunch time (lunch is not included into the price)
13:00 – 14:30 trainings
14:30 – 14:45 coffee break (provided by organizers)
14:45 – 16:30 tranings
Payment: Invoice from The Infotrust Oy – prepayment will be needed (re. other payment terms prefered kindly write l.kriukeliene@theinfotrust.com)
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 1120
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)
