topic Re: How to make a perfect data model. in QlikView

How to make a perfect data model.

Tue, 08 Oct 2013 07:29:12 GMT

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.

Re: How to make a perfect data model.

bbi_mba_76 — Tue, 08 Oct 2013 07:43:18 GMT

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

Re: How to make a perfect data model.

ngulliver — Tue, 08 Oct 2013 07:45:11 GMT

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

Re: How to make a perfect data model.

Tue, 08 Oct 2013 11:36:44 GMT

Hi Poornima;

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

Re: How to make a perfect data model.

ngulliver — Thu, 07 Nov 2013 09:24:26 GMT

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