How to make a perfect data model.

[#1]

Hello Everyone,

I am making a datamodel in qlikview, i want to know whether it is a perfect data model or not,

what all the things we need to take care while making it,

and please tell me whether the sync problem can create problem during datamodelling.

[bbi_mba_76]

Hi,

you could have a look at

Quick Tips #7 - Data Model

Best Practices for Data Modelling

Qlik Tips: Rules for creating a Key/Link Table in QlikView

[ngulliver]

Hi, Poornima.

Have a look at Steve Dark's blog about Data Modelling:

http://www.quickintelligence.co.uk/perfect-your-qlikview-data-model/

Cheers,

Neil

[#4]

Hi Poornima;

Try to work with models like "star schema" or "snowflake", and you will have more models acceptable by QlikView.

[ngulliver]

Hi, Poornima.

There is a Data Profiler on the community which can help with your data modelling by giving you a quick breakdown of all the fields. Add it to a separate tab on your app and it may give you additional insight into your data model.

http://community.qlik.com/message/415942#415942

Regards,

Neil