Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
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
MVP & Luminary
MVP & Luminary

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

Master II
Master II

how to start data model design?

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. 

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

Master III
Master III

Hi ,

Please check this it might be helpful to you.

Best Practices in Data Modeling.pdf

Thanks

PM

Master III
Master III

Hi,

See the attachment.

Thanks,
AS