Data model

[#1]

Hi,

Can any body tell me i have 15 tables in source like sl  regarding used for bi.

then hat ill be the steps to design datamodel should we go to load all source tables as storing into VD

or will u do apply map like functions directly onto the source .

if u go applymap function after loading the db table using applymap on qvd s what is the use e are already all the data is loaded into qlikview.

so what is general aproach let me know

regards

Mahesh t

[Anonymous]

Hi,

It depends on the need and the use case that your dashboard has. First try to answer the simple questions as to why you are building this dashboard, what is the use of this dashboard, who is the target audience of this dashboard, what is it that the users will extract out of this dashboard... and so on.. i agree that for a lot of questions like these, you will not have a straight forward answer, but try to have a complete understanding of what you are going to do with this data source that you have.

Also, check out the some resources on the data modelling perspective.

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

Creating a Data Model - YouTube

Get this book - QlikView 11 for Developers | Packt Publishing