Qlik Sense and QlikView Trainings
In BPX, we offer a wide range of QlikView and Qlik Sense trainings at various levels.
Our trainings are conducted in the form of workshops based on case studies. Participants take an active part in the training. They receive information about the functioning of the application in the test environment.
We offer dedicated trainings for organizations that already have a Qlik Sense or QlikView team of programmers, but want to further develop the skills of their employees. Our trainers together with the client prepare a list of topics that will strengthen (in the best way) the competences of employees, and then conduct training at the client’s headquarters or at the BPX’s headquarters.
We offer the following basic trainings:
Qlik Sense/ QlikView Administrator
Training that provides information about the Qlik Sense/QlikView Enterprise architecture and prepares for free management of the platform. During the course, participants will learn about management interfaces, technical components of the installation, and data access security system.
-
Benefits for the participant: after completion of the training, the participant will be able to manage the QS and QV.
-
For whom? Server administrators
-
Form of training: stationary training at the client’s headquarters
-
Training method: lectures and workshops based on the real experience of our trainers, case studies
-
Duration: 1 day
-
Number of participants: minimum: 3 persons – maximum: 12 persons
Qlik Sense/QlikView Developer
Training on how to create data models for the Qlik Sense platform. During the course, participants learn to effectively use the components available in the program in order to create interactive applications, develop applications and create data transformations from the script level. The training also includes knowledge about the creation of replacement keys and Qlik Sense documents.
-
Benefits for the participant: After completion of the training, the participant will be able to create and develop interactive data models
-
For whom? QS and QV designers, IT specialists and administrators, developers, programmers
-
Form of training: stationary training at the client’s headquarters
-
Training method: original combination of lectures, exercises and practical workshops
-
Duration: 2 days
-
Number of participants: minimum: 3 persons – maximum: 6 persons
Qlik Sense/QlikView Designer
Training that enables participants to gain knowledge about Qlik Sense data models. During the course, participants learn how to create interface layouts and dynamic connections between components. Moreover, they have the ability to design their own Qlik Sense applications. The training explains the basic applications of Qlik Sense sheets and familiarizes participants with the methods of effective organization of information.
- Benefits for the participant: after completion of the training, the participant will be able to design his own QS/QV applications.
-
For whom? QS and QV designers, business users, analysts and controllers, daily consumers of reports
-
Form of the training: stationary training at the client’s headquarters
-
Training method: lectures, exercises and practical workshops
-
Duration: 1 day
-
Number of participants: minimum: 3 persons – maximum: 12 persons
Nprinting
Training devoted to designing static versions of reports on the basis of dynamic Qlik applications. During the course, participants learn how to efficiently and easily use the collected data for automatic reporting to a large number of recipients.
-
Benefits for the participant: after completion of the training, the participant will become familiar with the installation and administration of the Nprinting application, as well as he will be able to create and publish reports intended for a large number of recipients
-
For whom? QS designers, IT specialists and administrators, developers, programmers, business users, controllers
-
Form of the training: stationary training at the client’s headquarters
-
Training method: lectures, exercises and practical workshops
-
Duration: 1 day
-
Number of participants: minimum: 3 persons – maximum: 6 persons
For participants, who are ready to become familiar with more advanced capabilities of Qlik Sense and QlikView, we also offer extensive training, which includes:
Optimization
Introduction to optimization
-
How does Qlik store data?
-
Basic techniques of optimization
Optimization of the script and phrases
- Optimization of keys and dates
- Synthetic and composite keys
- Connection of tables, shortening the model – Mapping and Join
- Identification and movement of fields with low cardinality
Impact of optimization on the calculation of charts
- Connection of tables and shortening the model
- Dual function, optimization of numbers
- Flagging of conditions for calculation of phrases
- Impact of data sorting on performance
Advanced script
Incremental loading
Data modeling
-
Query calculation level in QlikView
-
Missing values in the fact table
-
Missing values in the dimension table
-
Creation of a hierarchy
-
SCD – Slowly Changing Dimensions
-
Many tables of facts in the model
-
Names of fields
Good practices of visualization and writing the script