topic Data modelling in QlikView! in QlikView

Data modelling in QlikView!

Tue, 13 Mar 2012 09:44:07 GMT

Hi All,

I just wanted know the how the data modelling works in QlikView. I heard that it recommends Star Schema and Snowflake Schema for better performance. I also heard that it can be own data model not necessarily the Star Schema and Snowflake Schema.

Can some one please share their knowledge on data modelling in qlikview?

Thanks,

Attitude

Data modelling in QlikView!

Tue, 13 Mar 2012 14:05:01 GMT

Hi All,

Can anyone share their knowledge on this please!

Thanks,

Attitude

Data modelling in QlikView!

sebastiandperei — Tue, 13 Mar 2012 15:41:03 GMT

Hi At.

In qlikview, the recommendations on the data modeling aren't every the same.

For example, for an aplication, Linked tables would be better than Concatenated Linked Tables. In other cases, would be exactly opposite.

There are general recommendations, like remember that distinct and short values takes more resources than no distinct but heavy ones. In qlikview, for example in most cases, the concatenation o joined of Header and Body tabler works better that mantain both tables.

There several parameters that you must take on mind, and your modeling job would follow your proority:

- Staging time

- Data storage space

- Portability of the aplication

- Performance of the dashboard

- Objetive of the dashboard (analisis, reports, viewing, etc)

Re: Data modelling in QlikView!

Wed, 14 Mar 2012 11:12:19 GMT

Thanks Sebestain! It was really helpful for me... I read somewhere that is recommends star schema and snow flake. Thats the reason I was asking this question.

Data modelling in QlikView!

sebastiandperei — Wed, 14 Mar 2012 12:42:11 GMT

I asked because i'm new in the forum, and i want to have answers!!!

In this case, i think that will useful for you someone that talks to you about those schemas...

Data modelling in QlikView!

suniljain — Wed, 14 Mar 2012 13:29:16 GMT

Data modelling in qlikview is depends on the what business process you want to incorporate.

if you know the business process . its not tough in qlikview to implement it.