Qlik Sense
Trainings
Wenn Du durchstarten willst,
findest Du hier die richtigen Trainings.
Training unverbindlich anfragen
Für Deinen optimalen
Qlik Sense Einstieg
Dashboards gestalten
Qlik Sense
Designer
If you want to design dashboards and optimal analytics UI's in Qlik Sense, this is your training.
Even if you want to create data models, you should start with this training so you know how your analysts design the UI and use Qlik Sense.
We begin by covering the basic handling and then create a new Qlik Sense app for a sales analysis.
The data you need is loaded from an Excel spreadsheet using the graphical user interface of the Data Manager.
Then you create several worksheets according to the best practices and learn about variables and Set Analysis.
This training is the ideal start to UI design with Qlik Sense.
Das lernst Du im Qlik Sense Training
Designer
Navigation
Qlik Sense
Designer training
In this training we start with a demo app where you learn how to navigate between the individual worksheets and sections.
You will learn how to open and use a published app as an analyst and how to make the best use of the Qlik Sense functions.
Selections
Qlik Sense
Designer training
With selections you ask a question and Qlik Sense answers with the green-white-grey principle.
This is the most important principle in the analysis and we will discuss it in detail and try it out with lots of small exercises.
Intelligent search
Qlik Sense
Designer training
In addition to the selections, you can use the intelligent search in Qlik Sense to search specifically for data and its correlations.
We will also cover this with small tasks which will teach you how to find information and immediately see how the data relates to each other.
You will use a demo app to learn how to navigate between the individual worksheets and sections.
Create an app
Qlik Sense
Designer training
In this scenario-based training you are given the task of creating a sales analysis for a fictitious company. The objective is to take a closer look at the turnover and especially the margins.
To do this, you will create a completely new Qlik Sense app, which you will then expand into a full analysis over the course of the training.
You will learn about the different objects and how to use them in analysis.
Load data
Qlik Sense
Designer training
Your new Qlik Sense app needs to be populated with data first, this is the foundation for any analysis.
You will learn about the Data Manager and its graphical interface, that will help you load the data and link the tables correctly.
You will also learn how to create calculated fields and automatically transform the loaded data.
Master Items
Qlik Sense
Designer training
Once all the data is loaded, you will be introduced to the Qlik Sense Master Items.
You will create Master Dimensions and Measures for your analysts, which can be used in the adhoc analysis via drag & drop.
This way you ensure that all analysts use the correct KPIs and simplify their daily work.
Sales analysis
Qlik Sense
Designer training
After the data has been loaded and the Master Items are ready, you start building the actual Qlik Sense sales analysis.
You will create different worksheets and each one will use different charts or perhaps previously used charts, just in a new variation.
With each worksheet, new things are added, so your knowledge is constantly expanded.
Alternate states
Qlik Sense
Designer training
Analysts often want to start unusual analyses and therefore need a lot of flexibility in the Qlik Sense app.
Using Alternative States, your analysts can compare any number of different data sets and contrast the results.
You will encounter two variations that will give your analysts all the possibilities to compare selections.
Set Analysis
Qlik Sense
Designer training
One of the most important functionalities in Qlik Sense is Set Analysis.
Es wird kaum eine Kennzahl in Deinem Unternehmen geben, die Du ohne ihn berechnen kannst.
It makes sure you can do year-on-year comparisons or ask Qlik Sense: Which customer has bought product A but never product B?
We will create a dynamic YoY comparison and a chart that only looks at the YTD period.
Variables
Qlik Sense
Designer training
Next, you will learn how to use Qlik Sense variables. What they can do, how to create them and how to use them in your analysis.
We will create a what-if analysis and you will also learn how to use them to show and hide objects and KPIs.
You will create two buttons for this and use them to show and hide a KPI.
Storytelling
Qlik Sense
Designer training
Another brilliant thing about Qlik Sense is the storytelling.
You will learn how to create a story and present exactly the part of your analysis that is your focus in the next meeting.
You will also learn how to send a story as a PowerPoint or PDF after the meeting.
Best Practices
Qlik Sense
Designer training
Once your analysis is done, let's talk about a very important point: what are the best practices for Qlik Sense?
You will learn how to optimally design your Qlik Sense apps to ensure optimal speed and what you should pay attention to to avoid unnecessary workloads on your Qlik Sense server.
Preise für das Qlik Sense Training
Designer
Classroom
1.500,-
€ per participant plus VAT.- Duration: 2 days
- Certified trainer
- Classroom in Hamburg
- Virtual training environment
- German or English training material
- Max. 8 participants per day
- Travel/accommodation not included
Online
1.300,-
€ per participant plus VAT.-
Duration: 2 days
-
Certified trainer
- Online participation
- Virtual training environment
- German or English training material
- Recommended: Headset and 2 displays
- Required: Good internet connection
Individual
8.990,-
€ per training plus VAT.- Duration: 2 days
- Certified trainer
- On site at your company
- Virtual training environment
- German or English training material
- Up to 10 participants per day
- Plus travel expenses for the trainer
Daten modellieren
Qlik Sense
Data Architect
In this training you will learn how to use Qlik Sense to quickly and easily model complex data models using data from various data sources.
Databases, local files such as Excel and text files, are all covered in this in-depth training.
In many hands-on exercises you try out all the techniques and learn in which situation you should use which technique. We contribute our experience from our customer projects over the last 14 years.
You will also learn the best practices for optimal performance and, of course, the permissions on the data you control with Section Access. This way you ensure that everyone only sees the data they are allowed to see.
Like the Designer training, this course is based on a real-life scenario. You are tasked with creating a data model for a sales analysis and need to combine, transform, aggregate and then provide the data from very different systems to the Qlik Sense designers.
Das lernst Du im Qlik Sense Training
Daten-Architekt
Basics
Qlik Sense Data Architect training
In this training we start with the basics of data modelling in Qlik Sense.
We talk about the role concept, the breakdown of the apps, the DAR principle and a suitable requirements document.
So everything you should consider right at the beginning of your project.
Hub and Data Editor
Qlik Sense Data Architect training
You will learn about the hub and the Data Editor, where you will create the script to load, transform and aggregate the data.
The powerful Data Editor in Qlik Sense can do a lot and you will learn all the basics and important data modelling techniques during the training as we develop the script piece by piece.
Synthetic Keys
Qlik Sense
Data Architect training
As you load the first tables, fields and data into your new Qlik Sense app, you quickly stumble across the Synthetic Keys.
They're yuck and you'll learn why you should avoid them at all costs.
You learn about different methods, how to avoid synthetic keys and when exactly which method is the right one.
This prevents your app from becoming slow and sluggish.
Data model
Qlik Sense
Data Architect training
Even if it seems so unimpressive and simple, the Data Model view is one of the most important tools in your Qlik Sense app, because it gives you an immense amount of important information about the structure of your data model and the integrity of your data.
When a new table is loaded, the first thing we do is check the data model and you learn how to interpret the important information correctly.
Structuring scripts
Qlik Sense
Data Architect training
Who likes to work in an untidy workshop?
Wahrscheinlich niemand. Alles muss man suchen, weil nichts dort ist, wo es hingehört. Alles ist kreuz und quer durcheinander.
This can easily happen to you in a Qlik Sense script, so you will learn how to structure and organise your script neatly.
To do this, you will get to know the sections and comments that will help you to structure your script clearly.
Data connections
Qlik Sense
Data Architect training
Whatever data you want to load with your script, you need a data connection - you will learn about this in this training.
Qlik Sense can tap into a lot of different data sources and load the data - for this, of course, Qlik Sense needs to communicate correctly with the data source.
We will load data from a database and various files, including Excel, text and XML files.
Transforming data
Qlik Sense
Data Architect training
A very important technique when loading data is transformation.
The data is almost never stored in the data source in the way it is needed for the analysis.
In addition, Qlik Sense loads the data across systems and in each system the data is stored differently.
In this training you will learn the basic techniques of data transformation in Qlik Sense and when to use which method.
Aggregations
Qlik Sense
Data Architect training
Besides transformation, aggregation of data is sometimes an important tool.
Although Qlik Sense ideally does the aggregation of data on the surface to ensure maximum flexibility in analysis, it may sometimes be necessary to apply aggregation as soon as the data is loaded.
You will learn in which situations aggregation is necessary and how you can best implement it in the Qlik Sense script to calculate KPIs or compress the data.
Multilayer loading
Qlik Sense
Data Architect training
Similar to a data warehouse (DWH), loading data into Qlik Sense in multiple layers is a good idea.
There is a layer for extracting data, a layer for transformation and aggregation, and finally the distribution to all apps.
This is to avoid erroneous data, duplicate calculations and unnecessary loading times.
In this training you will learn the best practices and how to create an optimal data flow. You will also learn about the Qlik Sense QVD files that are at the core of this practice.
Optimal performance
Qlik Sense
Data Architect training
A very important topic is the best practices for optimal performance on your Qlik Sense server - and as a data architect you can contribute a lot to this.
You learn how to avoid performance problems with optimal data models and loading processes and what you should pay attention to.
Since Qlik Sense uses in-memory technology, some things are different from what you might be used to with relational databases. We will go into these differences.
Qlik Sense workflows
Qlik Sense
Data Architect training
Your app is ready - now what?
You will learn about the development workflow in Qlik Sense and how to publish apps into streams.
Also, how to continue developing published apps and then republish them.
These workflows can help you optimise your daily work with Qlik Sense and you will learn about the permissions behind them.
Section Access
Qlik Sense
Data Architect training
The last topic will be Section Access, which is always implemented at the very end in practice.
Section Access controls, among other things, access to the app, but most importantly, who is allowed to see what data in a Qlik Sense app.
When not all analysts are allowed to see all of the app's data, but only part of it, depending on the user, this is precisely what Section Access controls.
You will learn how Section Access works, how to plan it and how to integrate it into your Qlik Sense data model.
Preise für das Qlik Sense Training
Daten-Architekt
Classroom
2.250,-
€ per participant plus VAT.- Duration: 3 days
- Certified trainer
- Classroom in Hamburg
- Virtual training environment
- German or English training material
- Max. 8 participants per day
- Travel/accommodation not included
Online
1.950,-
€ per participant plus VAT.-
Duration: 3 days
-
Certified trainer
- Online participation
- Virtual training environment
- German or English training material
- Recommended: Headset and 2 displays
- Required: Good internet connection
Individual
13.985,-
€ per training plus VAT.- Duration: 3 days
- Certified trainer
- On site at your company
- Virtual training environment
- German or English training material
- Up to 10 participants per day
- Plus travel expenses for the trainer
Schnell einsteigen
Qlik Sense
Fast Track
Are you short on time and want to get started with Qlik Sense quickly?
Then this compact quick-start training is just right for you. It is highly compressed and does not go into depth like our Designer training. But you will learn how to create an optimal Qlik Sense interface quickly and easily.
To do this, you load simple sales data from an Excel spreadsheet and then immediately start building a dashboard.
The entire training is very practical and includes many hands-on exercises so that you can quickly create your own dashboards. If you find that you want to go deeper, you can upgrade to the Qlik Sense Designer training and learn about the more complex topics.
Das lernst Du im Qlik Sense Training
Schnelleinsteiger
Navigation
Qlik Sense Fast Track training
In this training we start with a demo app where you learn how to navigate between the individual worksheets and sections.
You will learn how to open and use a published app as an analyst and how to make the most of the Qlik Sense features.
Selections
Qlik Sense Fast Track training
With selections you ask a question and Qlik Sense answers using the green-white-grey principle.
This is the most important basis in a Qlik Sense analysis and we will go through it very carefully using many small exercises to try it out.
Create an app
Qlik Sense Fast Track training
In this scenario-based training you are given the task of creating a sales analysis for a fictitious company. The objective is to take a closer look at the turnover and especially the margins.
To do this, you create a completely new Qlik Sense app, which you then expand into a complete analysis over the course of the training.
You will learn about the different objects and how to use them in the analysis.
Load data
Qlik Sense Fast Track training
Your new Qlik Sense app needs to be populated with data first, this is the foundation for your analysis.
You will learn about the Data Manager and its graphical interface, that will help you load the data and link the tables correctly.
You will also learn how to create calculated fields and automatically transform the loaded data.
Storytelling
Qlik Sense Fast Track training
Another brilliant thing about Qlik Sense is the Storytelling.
You will learn how to create a story and present exactly the part of your analysis that is in focus in the next meeting.
You will also learn how to send a story as a PowerPoint or PDF after the meeting.
Best Practices
Qlik Sense Fast Track training
After your analysis is done, let's talk about a very important point: what are the best practices for Qlik Sense?
You will learn how to optimally design your Qlik Sense apps so that they are as fast as possible and what you should pay attention to to avoid unnecessary load on your Qlik Sense server.
Preise für das Qlik Sense Training
Schnelleinsteiger
Classroom
750,-
€ per participant plus VAT.- Duration: 1 day
- Certified trainer
- Classroom in Hamburg
- Virtual training environment
- German or English training material
- Max. 8 participants per day
- Travel/accommodation not included
Online
650,-
€ per participant plus VAT.-
Duration: 1 day
-
Certified trainer
- Online participation
- Virtual training environment
- German or English training material
- Recommended: Headset and 2 displays
- Required: Good internet connection
Individual
4.995,-
€ per training plus VAT.- Duration: 1 day
- Certified trainer
- On site at your company
- Virtual training environment
- German or English training material
- Up to 10 participants per day
- Plus travel expenses for the trainer
Course documentation in German or English
All accompanying course materials, as well as the trainings themselves, are in German or English, of course.
This allows you to concentrate fully on the content of the training.
Virtual training environment
You get access to our virtual training environment where everything is prepared for your practical exercises.
You don't have to worry about anything.
Real scenario
All trainings are based on a real-life scenario, as it often happens in everyday practice.
This way you learn all the steps, from planning to the finished result.
Certified trainers
Our trainers are not only certified on all Qlik products, but also as Qlik trainers.
We are a training partner and have been delivering the official Qlik trainings since 2008.
80% hands-on exercises
In order for you to quickly learn how to use the Qlik software, our trainings include many hands-on exercises, all of which are explained to you step by step.
Task book
In addition to the course material in which everything is explained in detail with screenshots, you will receive an activity booklet with all exercises for reference.
On site training
The classic on-site training can take place in our classroom in Hamburg, or at your location in a suitable training room with internet.
Online/Hybrid Trainings
Online: All trainings can also take place online. Our technology is state of the art and it is just like an on-site training, but online.
Hybrid: While some participants are sitting in the classroom, others can easily participate online.
Häufige
Fragen
Here you will find the most frequently asked questions about our trainings and the answer by clicking on the question.
Qlik Sense Training FAQ
Allgemein
Yes, that is exactly the aim of our trainings.
We'll create a new app and you'll learn step by step how best to proceed and what to look out for.
As our trainings are all based on a realistic scenario, you will learn how to create your own apps with Qlik Sense in real life.
Yes, definitely. After the training you can download them or your trainer will do it for you and send them to you online.
You can also download all the training files from the RSG Academy and use them in your own Qlik Sense environment.
For online training and individual training: Yes.
If you come to our classroom in Hamburg, you can either use your own laptop or we will be happy to provide you with one of our training laptops.
There are regular dates for our trainings, which you can find here: Dates.
You can make an individual appointment with the trainer for the individual training, but it is best to do this in good time so that everything can be planned accordingly.
Our training room is located in the south of Hamburg, in Hamburg-Harburg harbour.
You will find a detailed descriptionhere.
You can ask your trainer any questions you have even after the training session. It is best to use the comments in the training documents under the individual training sessions.
Maybe someone else had the same question before and you can already find the answer in the comments.
Your trainer will be informed by email when a new comment is entered and will reply as soon as possible.
You can pay for the training on account if your company is located in the DACH area.
After placing your order, we will send you an invoice, which must be paid by the start of the training.
Use our contact form below and we will send you a quote for the approval process in your company. You can then order the offer directly online.
If you want to do both trainings, i.e. Qlik Sense Designer and Qlik Sense Data Architect, we recommend that you start with Qlik Sense Designer.
This way, you first learn the interface design in order to understand more easily how an optimal Qlik Sense data model should be structured.
Qlik Sense Training FAQ
Designer
The QlikSense Designer Training lasts 2 days, directly following each other.
Even though the content of the training is quite extensive, 2 days is perfectly sufficient, after all Qlik Sense is designed to be simple and fast.
No previous experience is required for the Qlik Sense Designer training.
We start from scratch and show you everything step by step.
If you can operate a mouse and type the word "Hefeweizen" on a keyboard in under 2 minutes, you have met all the requirements. :-)
Yes, you will create a completely new app in Qlik Sense Designer Training and load the required training data into it.
Since this training focuses on UI design, you will use the graphical wizard to load the data - the Data Manager.
All data comes from an Excel spreadsheet and has a simple structure.
If you want to learn how to create complex data models and transform and aggregate the data, our QlikSense Data Architect training is the perfect fit for you.
The details about the Data Architect Training can be found on this page a little further up.
Qlik Sense Training FAQ
Daten-Architekt
Our Qlik Sense Data Architect training lasts 3 days, directly following each other.
Even though the content of the training is quite extensive, 3 days is perfectly sufficient, after all Qlik Sense is designed to be simple and fast.
No previous experience is required for our QlikSense Data Architect training.
We start from scratch and show you everything step by step.
However, it is definitely helpful if you fundamentally understand the topics of IT.
For example, it is helpful if you know how a relational database stores data and if you can write a simple SQL command.
Yes, that is exactly the focus of this training. You will hardly do anything on the surface, at most to validate the loaded data.
For interface design, you should take a look at our QlikSense Designer Training. You will find the Qlik Sense Fast Track training further up on this page.
In this training we will also not use the graphical wizard to load the data, but the Data Editor, where you will directly create the script commands.
We deal very intensively with the different data sources and the methods for shaping the data model, such as transformations and aggregations.
You will also learn about multi-layer data loading and the so-called QVD generators.
This is not mandatory, but we highly recommend it.
In recent years, it has been shown time and again that it is much easier for the Qlik Sense data architect if they know how to work on the Qlik Sense UI.
Qlik Sense Training FAQ
Schnelleinsteiger
Our Qlik Sense Quick Start training lasts 1 day only.
It is very condensed to give you a quick introduction to Qlik Sense.
No previous experience is required.
Yes, but in a very compressed form. We load simple data from an Excel table with the GUI data manager.
If you want to get into cross-system data modelling, you should check out our Qlik Sense Data Architect training.
Details of the Qlik Sense Fast Track training can be found further up on this page.
No, this condensed training is the short form of the Qlik Sense Designer Training and therefore does not cover all the topics that are included in the Designer Training.
If you want to go deeper into Qlik Sense interface design, you should check out our Qlik Sense Designer Training.
Details of the Qlik Sense Fast Track training can be found further up on this page.
Do you have
questions?
We are happy to arrange an appointment for you: no strings attached.
Online-Termin vereinbaren
We are looking forward to meeting you!
If you are interested in a specific training or have general or completely different questions, just write to us or schedule an online session with us and discuss your questions face-to-face.
Or call us: +49 40 60946300
Quotation and invoicing
If you need a quote for your company, you can tick it off directly in the contact form - we will send it to you promptly.
Your company can then commission the training and pay by invoice. The only important thing is that the invoice is paid by the start of the training.