QlikView – this is how it works!

You have a variety of systems where data terms like customer, product etc. are defined and the system contains these definitions as well as transactions. These systems can be business systems, excel files and any eventual web pages.

QlikView creates a layer of Transformers where we import selected parts of the data from the systems. The data is stored according to the same nomenclature as in the source system. Transformers are sometimes designated as “Connectors”, comparable to QlikTech’s product SAP Connector. Climber has Transformers for most systems on the market.

The next layer is Informers. Here, we convert data from being system-specific to being company-specific. Terms and definitions are homogenised e.g. simply put, a customer is a customer. So now we can understand if the business transactions that were booked in the CRM system have been invoiced. You can also calculate profitability, bonuses and more. Climber has experience from creating Informers for most industries.

Finally, we want to make sure that a person can see data as useful information. This is done by connecting to the last layer; Front End. Usually, these front-end components are role-specific. An analyst would like to see “everything” while the director may only want to see Dashboards. Here too we have many different variations of front-ends to choose from. The value of a QlikView solution is a direct function of the level of use. That is why we place great importance in the design of the user interface and have many good examples of what works and what does not work.

Here you can read more about how we work with QlikView Climber!