Cours QlikView - Developer II
Objectif
This course complements Developer I. Developer II is a mixture of demonstrations and hands-on exercises focusing on advanced scripting and more complex data modeling issues. The course concludes with a new business case for students to practice their new found skills in building a QlikView document from scratch based on Key Performance Indicators (KPIs).
Pré-requis
Developer I
Contenu
Course Outline
- The script debugger and troubleshooting
- How to add text data and how to generate other data from within the QlikView load script
- Definition of Mapping tables; data structure clean-up and optimization
- More scripting: aggregate data, table joins, concatenation, functions, interval match and other scripting capabilities and tools
- Set Analysis and AGGR Function.
- Data model optimization and performance tuning and how to create incremental loads
-QlikView document level security
- Advanced database connectivity
- Case study: student hands-on
Learning Objectives
- Understand QlikView scripting: how to load data into QlikView, connecting to data sources
- Resolve data structure issues using QlikView tools
- Compare data over time using Set Analysis
- Build advanced expressions
- Troubleshoot with the debugger
? Build a QlikView document based on the case study
Langue du cours
FR
Durée
2 jour(s)
Prix
1500.- CHF
Nos cours collectifs
Aucune session programmée
