QlikView

Trainings



Wenn Du durchstarten willst, 
findest Du hier die richtigen Trainings.

Training unverbindlich anfragen

Für Deinen optimalen

QlikView Einstieg

 


​Designer

Dashboard design

Learn how to design an optimal QlikView user interface.

Explore



​Data Architect

Create data models

Learn how to create optimal data models according to best practices.

Explore



​Fast Track

Lightning fast and compact

A quick start on how to load and visualise data with QlikView.

Explore




Dashboards gestalten

QlikView

Designer


If you want to design dashboards and optimal analysis interfaces in QlikView, this is your training.

Even if you want to create data models, you should start with this training to know how your analysts design the user interface and work with QlikView.

We begin with basic operations and then create a new QlikView application for a sales analysis.

Load the required data from an Excel spreadsheet and learn how to create a simple data model using the Script Editor.

Then you create several worksheets according to the best practices and learn about variables and Set Analysis.

This training is the ideal introduction to UI design with QlikView.


Dieses Training unverbindlich anfragen

Mehr zum QlikView

Oberflächen Training

Content

Pricing

Dates

FAQ

Questions

Das lernst Du im QlikView Training

Oberflächen

Navigation

QlikView Designer training

In this training, we start with a demo application in which you learn how to navigate easily between the various worksheets.

You will learn how to open a ready-to-use application as an analyst and how to best use the many QlikView functions.

Selections

QlikView Designer training

Using selections, you ask a question and QlikView answers with the green-white-grey principle.

This is the most important basis in analysis and we will discuss it in detail and test it with many small exercises.

Search for values

QlikView Designer training

In addition to the selections, you can search specifically for data and its correlations in QlikView.

Again, we will review this by doing small exercises and you will learn how to find information and immediately to see the relationship of the data to each other.

woman in white shirt using smartphone

Create a new application

QlikView Designer training

In this scenario-based training you are given the challenge to create a sales analysis for a fictitious company. They want to take a closer look at the sales and especially the margins in QlikView.

To do this, you will create a completely new application, 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.

Matrix movie still

Load data

QlikView Designer training

Your new application must first be filled with data, which is the basis for your daily analysis.

You will get to know the QlikView Script Editor and the wizards that help you load the data.

You will also learn how to create calculated fields and automatically transform the loaded data.

white and black concrete building

A good design

QlikView Designer training

Before we start creating a new QlikView interface, you will learn the basics of good data visualisation.

We will look at how our brain processes information and how your data should therefore be presented.

We then transfer these principles onto your new QlikView application.

Sales analysis

QlikView Designer training

After the data is loaded, you start building the QlikView interface for sales analysis.

You will create different worksheets and each one will use different charts or perhaps previously used charts but in a new variation.

With each worksheet, new things are added, so your knowledge is constantly expanded and you learn about different options.

Alternate States

QlikView Designer training

The analysts often want to start unusual analyses and therefore need a lot of flexibility in the QlikView application.

Using QlikView Alternate States, your analysts can compare any number of different data sets and contrast the results.

You will get to know two variations that give your analysts all the possibilities to compare selections.

two cacti on orange and black pots

Set Analysis

QlikView Designer training

One of the most important functionalities in QlikView is Set Analysis.

There will hardly be a KPI in your company you can calculate without it. It ensures that you can create year-over-year comparisons or ask QlikView: Which customer bought product A, but never product B?

We will create a dynamic YoY comparison and a chart that only looks at the YTD period.

brown cardboard box on white table

Variables

QlikView Designer training

Next, you will learn about the use of variables in QlikView: 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 learn how to show and hide objects and KPI's with them.

To do this, you will create buttons and use them to show and hide objects.

person writing on brown wooden table near white ceramic mug

QlikView Desktop

QlikView Designer training

To create a new application you need the QlikView Desktop. You will get to know it in detail in this training.

You will learn how to use it and how to borrow a licence from QlikView Server.

We will also look at the most important settings in your QlikView Desktop and the difference between the Personal Edition and the Desktop Edition.

This is the sign you've been looking for neon signage

Best Practices

QlikView Designer training

After your analysis is done, let's talk about a very important point:

What are the best practices for QlikView?

You will learn how to best design your QlikView applications to ensure optimal speed and what you should pay attention to to avoid unnecessary load on your QlikView server.


Trainings-Termine


Right here

Preise für das QlikView Training

Oberflächen

Classroom

1.500,-

€ per participant plus VAT.
  • Duration: 2 days
  • Certified trainer
  • In the classroom in Hamburg
  • Virtual training environment
  • German/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/English training material
  • Recommended: Headset and 2 monitors
  • 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/English training material
  • Up to 10 participants per day
  • Plus travel expenses for the trainer

Daten modellieren

QlikView

Data Architect


In this training you will learn how to quickly and easily model complex data models in QlikView using data from various data sources.

Databases, local files such as Excel and text files are all covered in this detailed training.

In many hands-on exercises you will try out all the techniques and learn in which situation you should use which technique. To achieve this, we contribute our experience from our QlikView 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 which you will control with Section Access. This way you ensure that everyone only sees the data they are allowed to see.

Like the QlikView Designer training, this is based on a real-life scenario. You have the task of creating a data model for a sales analysis and need to combine, transform and aggregate the data from very different systems and then make it available to the QlikView designers.


Dieses Training unverbindlich anfragen

Mehr zum QlikView

Daten-Architekt Training

Content

Pricing

Dates

FAQ

Questions

Das lernst Du im QlikView Training

Daten-Architekt

Basics

QlikView Data Architect training

In this training we start with the basics of data modelling in QlikView.

We talk about the role concept, the splitting of apps, the DAR principle and about a suitable requirements document.

So everything you should consider right at the beginning of your project.

black framed eyeglasses on top of white printing paper

Script editor

QlikView Data Architect training

You will get to know the Script Editor by creating your own script to load, transform and aggregate the data.

The powerful Script Editor in QlikView can do a lot and you will learn all the basics and important techniques for data modelling during the training as we extend the script piece by piece.

silver and gold round coins

Synthetic Keys

QlikView Data Architect training

As you load the first tables, fields and data into your new QlikView application, 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 to avoid Synthetic Keys and when exactly which method is the right one.

This prevents your application from becoming slow and sluggish.

white plastic wire puzzle with black background

The table structure

QlikView Data Architect training

Even if it seems so inconspicuous and simple, the Table Structure view is one of the most important tools in your QlikView application, because here you get an immense amount of important information about your data model's structure 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.

brown wooden letter blocks on white surface

Structure scripts

QlikView Data Architect training

Who likes to work in an untidy workshop?

Probably nobody. You have to search for everything because nothing is where it belongs. Everything is all over the place.

This can happen to you quickly in a QlikView script, so you will learn how to structure and organise your script neatly.

To do this, you will learn about tabs and comments, which will help you to structure your script clearly.

white and black light fixture

Data sources

QlikView Data Architect training

Whatever data you want to load into your application, you need a connection to the data source - you will learn about this in this training.

QlikView can tap into a lot of different data sources and load the data - for this, of course, QlikView must communicate correctly with the data source.

We will load data from a database and various files, including Excel, text and XML files.

three pupas

Transform data

QlikView 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, QlikView loads the data across systems and in each system the data is stored differently again.

In this training you will learn the basic techniques of data transformation in QlikView and when to use which method.

Aggregate data

QlikView Data Architect training

In addition to transformation, aggregation of data is sometimes an important tool.

Even though QlikView mostly does the aggregation of data on the surface, sometimes aggregation has to be done when the data is loaded.

You will learn which situations require aggregation and how you can best implement them in your QlikView script.
This includes the aggregation of data as well as the necessary pre-calculations of some KPIs.

rice terraces

Multilayer loading

QlikView Data Architect training

Similar to a data warehouse (DWH), it makes sense to load data in multiple layers into QlikView.

There is a layer for extracting the data, a layer for transforming and aggregating it and then there is the distribution of the data to all QlikView applications.

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 QVD files that are at the core of this practice.

Optimum performance

QlikView Data Architect training

A very important topic is the best practices for optimal performance in your QlikView applications - and as a Data Architect you can contribute a lot to this.

You learn what you should pay attention to and how you can avoid performance problems with optimal data models and loading processes.

Since QlikView uses in-memory technology, some things are different from what you might be used to with relational databases. We will go into these differences.

man writing on white board

Developer workflows

QlikView Data Architect training

Your application is ready - now what?

You will learn what a development workflow in QlikView can look like and how to publish applications to the Access Point.

If you pay attention to a few important things in the workflows, you can be sure there will be no problems in the production environment.

You will also learn how to further develop and then republish productive QlikView applications.

person holding black and white card

Section Access

QlikView Data Architect training

Our last topic will be Section Access, which in practice is always implemented at the very end.

The Section Access controls, among other things, access to the application, but above all who is allowed to see which data in the QlikView application.

If not all analysts are allowed to see all data of the application, but only a part of it, depending on the user, this is exactly what Section Access controls.

You learn how Section Access works, how to plan it and how to integrate it into your data model.