Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewwizard
Master II
Master II

Datamodel design including requirement gathering

Hi All,

Please advise best data model design from requirement gathering.

thanks in advance.

1 Solution

Accepted Solutions
hariprasadqv
Creator III
Creator III

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.

View solution in original post

6 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

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

qlikviewwizard
Master II
Master II
Author

how to start data model design?

sagarkharpude
Creator III
Creator III

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
Creator III
Creator III

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
Master III
Master III

Hi ,

Please check this it might be helpful to you.

Best Practices in Data Modeling.pdf

Thanks

PM

amit_saini
Master III
Master III

Hi,

See the attachment.

Thanks,
AS