topic Re: Best practices for Data Modeling in QlikView

Best practices for Data Modeling

hariprasadqv — Wed, 10 Jun 2015 09:36:06 GMT

Hi All,

so far i have done data modeling like below

1.Loading All the tables into QV App

2.Removing Sythetic keys,Circular References and garbage fields.

3.and Other transfermations.

Apart from this I'm expecting other Best practices for Data Model designing

Thanks

Wed, 10 Jun 2015 09:40:39 GMT

Hi..

Go through this PDF may this will help you..

hariprasadqv — Wed, 10 Jun 2015 09:54:52 GMT

I think this is more of generic document from QlikTech.Eventhough it is addressing good DM designing.

I'm actully expecting best approch or way for DM design.

Thanks

*DM-Data Model

Mon, 15 Jun 2015 07:27:07 GMT

What is the question?

SreeniJD — Fri, 23 Oct 2015 09:08:26 GMT

See this document..

Sreeni

miguelbraga — Fri, 23 Oct 2015 09:25:03 GMT

You can also do this steps:

Check the quality issue of your data. Many values may be in a incoerent format, for example: there might be some values that need to be precieved like a number and they are precieved like a text;
Choose the best data model that fits in your solution. See the image bellow:
Organize your script logically naming tabs with the same name as the table that you LOAD/make in that tab. This really helps you to STORE the tables in qvd's files to use this in your final solution;
Choose wisely what is your level in a n-tier Data Arquitecture so that you can decide wish is the best approach when scripting.

Hope these 4 steps can give you a better and summarize way to understand the basics of best practice in Data Modeling

Regards,