Our best selling
Our best selling
Qlik Sense Trainings
Qlik Sense Trainings
These trainings contain everything you need to start building your first apps.
Designer
Qlik Sense Training
Learn how to create amazing and engaging visualizations for your data.
With this training, you will be able to create your own dashboards and visualize your data based on the Qlik Best Practices.
Data-Architect
Qlik Sense Training
In the role of the Qlik Sense Data Architect, you will load data from various data sources like databases and files, and compose a flexible data model with all the different data. You also learn how to transform and aggregate your data.
Fast Track
Qlik Sense Training
In the role of the Qlik Sense Data Architect, you will load data from various data sources like databases and files, and compose a flexible data model with all the different data. You also learn how to transform and aggregate your data.
Qlik Sense
Designer Training
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.
This is what you will learn in our
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 and how to familiarise yourself with all Qlik Sense settings
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.
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, which you then expand into a complete sales analysis.
You will learn about the different objects and how to use them in the analysis.
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.
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 KPl's.
You will create two buttons for this and use them to show and hide a KPI.
With selections you ask a question and Qlik Sense answers using the green-white-grey principle.
It's basically a good way to filter data.
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.
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.
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.
Another brilliant thing about Qlik Sense is 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.
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.
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.
One of the most important functionalities in Qlik Sense is Set Analysis.
There will hardly be a key figure in your company that you can calculate without it.
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.
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 avoid unnecessary load on your Qlik Sense server.
Pricing for the
Qlik Sense Designer Training
| Duration: | 2 days |
| Trainer: | Certified |
| Hands-On: | Virtual training environment |
| Location: | Hamburg, Germany |
| Course Material: | German or english |
| Capacity: | Up to 8 students |
| Travel costs.: | Not included |
| Duration: | 2 days |
| Trainer: | Certified |
| Hands-On: | Virtual training environment |
| Location: | Online via Internet |
| Course Material: | German or english |
| Capacity: | Up to 8 students |
| Travel costs.: | Not included |
| Duration: | 2 days |
| Trainer: | Certified |
| Hands-On: | Virtual training environment |
| Location: | At your company |
| Course Material: | German or english |
| Capacity: | Up to 10 students |
| Travel costs: | Not included |
FAQ
Qlik Sense Designer Training
Qlik Sense
Data Architect Training
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 15 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.
This is what you will learn in our
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.
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.
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.
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 will 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.
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.
Who likes to work in an untidy workshop?
Probably nobody. You have to look for everything because nothing is where it belongs. There will hardly be a key figure in your company that you can calculate without it.
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.
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.
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.
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.
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.
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 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.
Pricing for the
Qlik Sense Data Architect Training
| Duration: | 3 days |
| Trainer: | Certified |
| Hands-On: | Virtual training environment |
| Location: | Hamburg, Germany |
| Language | German and English |
| Course Material: | German or english |
| Capacity: | Up to 8 students |
| Travel costs.: | Not included |
| Duration: | 3 days |
| Trainer: | Certified |
| Hands-On: | Virtual training environment |
| Language | German and English |
| Location: | Online via Internet |
| Course Material: | German or english |
| Capacity: | Up to 8 students |
| Travel costs.: | Not included |
| Duration: | 3 days |
| Trainer: | Certified |
| Hands-On: | Virtual training environment |
| Language | German and English |
| Location: | At your company |
| Course Material: | German or english |
| Capacity: | Up to 10 students |
| Travel costs: | Not included |
FAQ
Qlik Sense Data Architect Training
Qlik Sense
Fast Track Training
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.
This is what you will learn in our
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.
All setting and ways to navigate through a Qlik Sense app will be covered.
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
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.
You will find mighty insights with Selections.
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.
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
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.
Pricing for the
Qlik Sense Fast Track Training
| Duration: | 1 day |
| Trainer: | Certified |
| Hands-On: | Virtual training environment |
| Location: | Hamburg, Germany |
| Course Material: | German or english |
| Capacity: | Up to 8 students |
| Travel costs.: | Not included |
| Duration: | 1 day |
| Trainer: | Certified |
| Hands-On: | Virtual training environment |
| Location: | Online via Internet |
| Course Material: | German or english |
| Capacity: | Up to 8 students |
| Travel costs.: | Not included |
| Duration: | 1 day |
| Trainer: | Certified |
| Hands-On: | Virtual training environment |
| Location: | At your company |
| Course Material: | German or english |
| Capacity: | Up to 10 students |
| Travel costs: | Not included |
FAQ
Qlik Sense Fast Track Training
These are your
Qlik Sense Training Benefits
We look forward to meeting you!
We look forward to meeting you!
Send us your contact details and we will contact you as soon as possible.
Or schedule a free online meeting with us:
Or call us: +49 40 60946300
Quotation and invoicing
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 order the training and pay by invoice. The only important thing is that the invoice is paid by the start of the training.
Other questions
Other questions
We are also happy to answer any questions you may have about the training content.
Maybe you would like a customised training or workshop based on your data?
We are very flexible - feel free to contact us.
Contact us now!
Rest assured, your data is safe with us. We respect your privacy and will only use your information to communicate with you about your inquiry or project. Your trust is important to us, and we're committed to delivering exceptional service while safeguarding your information.
