For your optimal
For your optimal
Qlik Sense Entry
Qlik Sense Entry
Designer
Designer
Design dashboards
Learn how to design the best Qlik Sense interface, quickly and easily.
Data Architect
Data Architect
Create data models
Learn how to create optimal data models according to best practices.
Fast Track
Fast Track
Fast and compact
A fast track to loading and displaying data with Qlik Sense.
Qlik Sense
Qlik Sense
Designer
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.
More about Qlik Sense
More about Qlik Sense
Designer Training
Designer Training
What you will learn in Qlik Sense Training
What you will learn in Qlik Sense Training
Designer Training
Designer Training
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.
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 using the green-white-grey principle.
This is the most important basis in a Qlik Senseanalysis and we will go through it very carefully using many small exercises to try it out.
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 Senseanalysis and we will go through it very carefully using many small exercises to try it out.
Intellegent 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.
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 trainingIn 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, which you then expand into a complete over the course of the training. over the course of the training.
You will learn about the different objects and how to use them in the analysis.
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, which you then expand into a complete over the course of the training. 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 Designer 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.
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.
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.
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.
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 KPls.
You will create two buttons for this and use them to show and hide a KPI.
Storytelling
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
Qlik Sense
Data Architect
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.
More about Qlik Sense
More about Qlik Sense
Data Modelling
Data Modelling
What you will learn in Qlik Sense Training
What you will learn in Qlik Sense Training
Data Architect
Data Architect
Basics
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
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
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 avoidsynthetic keys and when exactly which method is the right one.
This prevents your app from becoming slow and sluggishData Model
Qlik Sense Data Architect training
Even if it seems so unimpressive and simple, the DataModel 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 ofyour 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
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 scriptneatly.
To do this, you will get to know the sections and comments that will help you to structure your scriptclearly.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 sourcesand 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 systemsand 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.
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 systemsand 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 ofdata 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 calculationsand 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 practiceOptimal 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 differencesQlik Sense workflows
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 workwith Qlik Sense and you will learn about the permissions behind them.Section Access
The last topic will be Section Access, which is always implemented at the very end in practice.
Section Access controls, among other things, access tothe 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 itand how to integrate it into your Qlik Sense data modelQlik Sense
Qlik Sense
Fast Track
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 exercisesso 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.
More about Qlik Sense
More about Qlik Sense
Fast Track
Fast Track
What you will learn in Qlik Sense Training
What you will learn in Qlik Sense Training
Fast Track
Fast Track
Navigation
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 Senseanswers using the green-white-grey principle.
This is the most important basis in a Qlik Senseanalysis 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 analysisLoad data
Qlik Sense Fast Track training
Your new Qlik Sense app needs to be populated withdata first, this is the foundation for your analysis.
You will learn about the Data Manager and its graphicalinterface, that will help you load the data and link thetables correctly.
You will also learn how to create calculated fields and automatically transform the loaded dataStorytelling
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.
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.
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.
Qlik Sense Training FAQ
Qlik Sense Training FAQ
General
General
Qlik Sense Training FAQ
Qlik Sense Training FAQ
Designer
Designer
Qlik Sense Training FAQ
Qlik Sense Training FAQ
Data Architect
Data Architect
Qlik Sense Training FAQ
Qlik Sense Training FAQ
Quick Starter
Quick Starter
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 right now: +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.