We are increasingly experiencing Qlik users approaching us because their Qlik-based BI solution is not performing satisfactorily. The issues vary and can include:
 

 >  Complaints from the company's Qlik users about poor user performance.

 >  High operating costs of the Qlik solution: Every desired change requires expensive             consultant hours.

 >  Slow reload of apps.

 >  Server error messages.

 >  Lost connection to the server or file server.
​

End users are not concerned about the cause of the problems; they simply want a quick solution. There is no easy answer to what causes performance problems. Often, the problems vary, and it is necessary to delve into them to find the right solution. But where should one start?
 

How did we end up in this situation?
 

It is rare to experience performance problems from the beginning when implementing a Qlik solution. It is something that occurs over time. Sometimes, the cause is starting with a small-scale solution that grows over time, and the setup can no longer handle the demands posed by the solution and its daily use.
 

A BI solution is constantly evolving to adapt to the company's needs. Therefore, it is important to create room for it to grow at an early stage. One of the reasons for this problem is that BI is often not a strategic management decision but rather a bottom-up decision, where a small-scale BI solution is installed to test if there is interest in the organization.
 

There are two different types of solutions to this problem. One involves server setup, such as the amount of RAM and the number of CPUs, while the other is more process-oriented and focuses on how the Qlik solution has been developed and structured. It is always important to follow Qlik's recommendations regarding hardware architecture, but the correct or best solution is not always just increasing RAM or CPUs. It is equally important to look at how the Qlik solution has been developed. It is our responsibility as consultants to help our clients build a solution that can grow over time. Therefore, at Capana, we follow the Best Practice for developing data models and structuring Qlik data.
 

What is Best Practice?
 

After working with Qlik technology for more than 15 years, Capana has gained extensive experience in Best Practice for developing Qlik-based BI. Best practice makes the Qlik solution more efficient and cost-effective for the customer.