Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
For interview purposes, how should this question be answered. My understanding about best practice is that the overall performance should be maximized by optimizing the data model. That is by perfecting the data model not just in form but in function too. Form as in the fact table should be at the center linked with dimension tables surrounded by it (if it is a star schema). Function as in: it should be free from synthetic keys, avoid circular reference by using foreign keys, use joins wherever applicable, applymaps are even better, use resident load.. precalculate values to save processing times, Apply incremental load, use QVD data format ...the list goes on. So all these actions lead to making the performance of Qlikview efficient and reducing the consumption of resources. And this is what i gather about Qlikview best practices. So best practices is all about performance and efficiency or is there some thing else. Please comment/correct/advice on my take.
Many Thanks.
I think u have covered end to end ,pls go ahead
best practice
commercial or professional procedures that are accepted or prescribed as being correct or most effective
I personally would respond with a question, "what type of best practices do you mean?" Scripting? Visuals? Performance? Architecture? All of the above?
Scripting can be as simple as using naming conventions
Do's and Don'ts of visuals, architecture, expressions etc...
Hi, John.
I think Felim makes a good point. I am involved in drafting best practices which include not just optimisation and architecture but also visual consistency between tabs and applications, no massive company logos occupying primary real estate on the dashboard and version control within the script.
Regards,
Neil