topic Re: Create datamodeling in QlikView

Create datamodeling

sreeni_qvd — Wed, 12 Mar 2014 08:27:08 GMT

Hi All,

Please find the attached data source and create data modeling and explain to this was correct data modeling.

Thanks&Regards:

Sreeni

Re: Create datamodeling

datanibbler — Wed, 12 Mar 2014 08:32:55 GMT

Hi Sreeni,

I'm sorry, but I do not quite understand, are you asking for help with anything? If yes, what is your requirement?

Best regards,

DataNibbler

Re: Create datamodeling

sreeni_qvd — Wed, 12 Mar 2014 08:44:17 GMT

Hi DataNibbler,

I gave sample data, I created one QVW for data modeling, PFA and let me this is correct or not.

Regards

Sreeni

Re: Create datamodeling

sreeni_qvd — Wed, 12 Mar 2014 08:48:06 GMT

Hi,

PFA , Please let me this was correct data modeling or not.

PFA data source.

Re: Create datamodeling

datanibbler — Wed, 12 Mar 2014 08:53:59 GMT

Hi Sreeni,

yes, you created a document, I had a look at that. Maybe you could instead attach your qvw to this discussion? That would make it somewhat easier.

Well, your data_model looks good enough to me - the "ideal" recommended star-shape or snowflake-shape cannot always be kept - yours would probably categorize as a "snowflake-shape" as you have one primary central table (which most of your data_tables are linked to) and one "secondary central table", from which there are links to several data_tables.

The important things about the data_model are:

- Avoid synthetic keys (you haven't got any at the moment)

- Avoid loose tables (circular references)

- Avoid "data islands" (tables which are not linked to any others) as these are extremely resource-heavy.

=> The tool of choice (to force and to break QlikView's automatic links) is renaming (the >as< option)

=> Also important is the quality of keys. You can read up on "information density" and such, but as a rule of thumb

- "perfect key" and "primary key" means a key is sufficient to uniquely identify every single record

=> That should always be the case in masterdata_tables

HTH

Best regards,

DataNibbler

P.S.: The bottom line, if there was any, might be: If your data_model works for you, it's fine for the moment. You'll get ideas to make it even better and slimmer as you go along.

Re: Create datamodeling

sreeni_qvd — Wed, 12 Mar 2014 09:01:18 GMT

Thank you.