Datamodel design including requirement gathering

[qlikviewwizard]

Hi All,

Please advise best data model design from requirement gathering.

thanks in advance.

[Oleg_Troyansky]

this is quite an open question. What exactly are you looking for?

[qlikviewwizard]

how to start data model design?

[sagarkharpude]

To understand the Data model design first understand the Schema like Star/Snowflake schema. What is normalization and denormalization. There are lot of documents on the community you can go through it. 

[hariprasadqv · Accepted solution]

1.Study the data sources thoroughly .

2.Load required fields and tables only.

3.Rename the fields if required.

4.Take care about Circular loops, SCD and Synthetic keys(If required).

5.Apply Transformation where ever it is requires.

[prma7799]

Hi ,

Please check this it might be helpful to you.

Best Practices in Data Modeling.pdf

Thanks

PM

[amit_saini]

Hi,

See the attachment.

Thanks,
AS