Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
pra_kale
Creator III
Creator III

How To decide which Data Model should use

Hi,

I am very new to Qlik view and recently started development in it. Most development which I did so far are by bringing all data into one table (i.e Single Table Data Model) by Left joining or inner join. But when I saw the most complex development then I came to know all developers are used  Star Schema or Snowflake data models.

My main problem is I am not able to decide which Data Model I should use at the time of development..How to decide? Is their any specif way to take a decision on Data Model which suits our requirement ? which factors needs to take into consideration while choosing data model ?

Can any one help me in this..so I can take a decision at the time of development.

Thanks in advance.

5 Replies
robert_mika

Check this

Best Practices for Data Modelling

Star schema is always better that the snowflakes

qlikviewnovice
Specialist II
Specialist II

Hi Prasad,

Please find attached file.

Yes, Star Schema is always better than the Snow flake Schema. !

pra_kale
Creator III
Creator III
Author

Thank You Very Much..can I get any document which helps me in building Data Model.

pra_kale
Creator III
Creator III
Author

Thank You.

qlikviewnovice
Specialist II
Specialist II

Hi,

If you get answer please close this thread by giving helpful or mark correct answer