Best practices document

[Anonymous]

Hi team,

Any best practices document for qlik sense..Please share..expected in details

thanks

[lorenzoconforti]

An approach I usually take is to have dashboards to handle specifically the ETL part; you load data from your various sources, you manipulate them in Qlik (scripting is pretty good) and then you save the resulting tables as QVDs

You then develop your front end Qlik applications which will feed from the same centralised QVDs generated at the step above; if you need to change your underlying data structure you change it only in one place and you keep your visualisation dashboards lean

[qlikdeveloper9999]

I have come across a solution following this approach. I am not sure whether this is the optimal and one of the best approaches to follow.

I believe that this approach works for small number of reports but I can't see it scale up. Maintenance can quickly become a nightmare.

 Why data modeling has to be done in qlik? I understand that the engine is optimised but I can't say that it follows the typical enterprise data warehousing principles and methodologies.

 Thanks alot for your time and comments. I am still trying to find an ideal/best approach.

[lorenzoconforti]

You can do data modeling outside, it really depends on your data sources, how many you have and what kind of dashboards you're planning to develop. If you have a data warehouse where ETL has already been performed and the data is ready to be consumed, all the better. You still need to pull the data and you might want to do it once and make it available to all your Qlik dashboards 

Keep in mind that, depending on the complexity of the dashboards you want to develop, you might still need to do some ETL in Qlik.

I've worked on projects where most of the ETL was done in Qlik and others where data was pretty much ready. We don't live in an ideal world and I found I had to adapt to different scenarios

Bear in mind it's pretty common to have ETL engines with BI applications like Alteryx, Tableau Prep, Power BI with Power Query