data model best practises

[#1]

what are the best practices should be followed while designing qlikview data model

[marcus_sommer]

You might be starting here: Get started with developing qlik datamodels.

- Marcus

[krishnacbe]

Hi,

Below are few Best Practices

1. Avoid Synthetic Keys & Circular loops

2. Try to build Star Schema to increase the performance

3. Use QVDs to load more faster

4. Optimize the load.

I too agree with Marcus for details information

[#4]

Hi,

Please go through this document. It might helpful to you.

Thanks!!

Br,
Habib Shaik.

[Vegar]

I think this is a good read by richard.pearce60. It will help  your understand .

https://qlikcentral.com/2014/08/19/the-optimal-qlikview-data-structure/

[#6]

what are the commonly used script level operations involved during data modeling, i know join , concatenate and applymap

[marcus_sommer]

I will always depend to the concrete load/transforming-task which kind of script-operations will be more suitable to your requirements - there is no global rule: A perfect datamodel?

- Marcus

[#8]

what are commonly used transformations while designing data model

[cheburashka]

Hi vibhu,

I've created some QvM - Qlikview Modules that I use to help me do validations like KeyChecks, interactions between selections in one table and another, etc.

Maybe you'll find them useful.

,KR Koen

PS: Don't forget to mark answers as helpful and correct.