topic Re: Datamodel design including requirement gathering in QlikView

Datamodel design including requirement gathering

qlikviewwizard — Fri, 20 Mar 2015 02:14:00 GMT

Hi All,

Please advise best data model design from requirement gathering.

thanks in advance.

Re: Datamodel design including requirement gathering

Oleg_Troyansky — Fri, 20 Mar 2015 02:17:06 GMT

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

Re: Datamodel design including requirement gathering

qlikviewwizard — Fri, 20 Mar 2015 02:46:18 GMT

how to start data model design?

Re: Datamodel design including requirement gathering

sagarkharpude — Fri, 20 Mar 2015 03:53:53 GMT

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.

Re: Datamodel design including requirement gathering

hariprasadqv — Fri, 20 Mar 2015 03:57:51 GMT

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.

Re: Datamodel design including requirement gathering

prma7799 — Fri, 20 Mar 2015 05:26:04 GMT

Hi ,

Please check this it might be helpful to you.

Best Practices in Data Modeling.pdf

Thanks

Re: Datamodel design including requirement gathering

amit_saini — Fri, 20 Mar 2015 05:32:08 GMT

Hi,

See the attachment.

Thanks,
AS