Benefits of having a Data Model before the presentation layer?

[shyamcharan]

Hi Experts,

I have worked on a qlikview design model where I have three different layers as mentioned before in all the QlikView solutions.

I have listed out the benefits as I can think. I appreciate if anyone add more to it.

QVD Layer:

This layer can be straight data dump from the DW

Data Model Layer:

Most of the transformations can be done here reducing the effort on QVW layer

Most of the complex calculations can be done here reducing the effort on the Chart/Tabular engines

One Data Model can be used by multiple Dashboards hence reducing the effort in creating individual Data Models for different dashboards

Easy to maintain the changes. Requires less time in implementing the changes that effect multiple dashboards.

When working in team or group scenarios, this type of division allows different layers of the application to be worked on simultaneously and independently of each other

Dashboard Layer:

This is final presentation layer

Better to push complex calculations to the Data Model Layer.

Thanks in advance,

Shyam.

[qlikviewwizard]

Hi Shyamcharan,

If you want to share your knowledge or valuable documents, please go to this link shyamcharan

and write/upload your documents.Lot of folks will discuss and share their opinions.

Hope this will help.

[evan_kurowski]

When working in team or group scenarios, this type of division allows different layers of the application to be worked on simultaneously and independently of each other.

[shyamcharan]

Thanks. I have added a document with the same.

Once I consolidate all the benefits will update the document and close this discussion.

[shyamcharan]

Thanks Evan, I have added your point to the list on top.