topic Best Practise For Data Modelling in QlikView

Best Practise For Data Modelling

suniljain — Sat, 24 Jul 2010 15:35:47 GMT

Hii, Everyone

Can any one tell me what are the best practices for data modelling ?.

Can you share any article regarding it . if you have .

Regards

Sunil Jain

Best Practise For Data Modelling

Mon, 29 Nov 2010 07:28:32 GMT

Hi Sunil,

You got any article for the same that you have been? If you got any please forward the same to me.

Best Practise For Data Modelling

suniljain — Tue, 30 Nov 2010 09:52:40 GMT

I donot get any article on same. But i get then I will share with all community user.

Best Practise For Data Modelling

suniljain — Tue, 30 Nov 2010 09:53:40 GMT

some books available on data modelling. I will confirm after referring it.

Best Practise For Data Modelling

Fri, 29 Apr 2011 09:29:09 GMT

Please send me the article regarding the data modelling in qlikview if you get any information please send it to me.

Thanks

Anand

Regards

Best Practise For Data Modelling

pat_agen — Fri, 29 Apr 2011 10:31:01 GMT

Hi Sunil,

Some "old" stuff but proved invaluable to me when starting out.

Ralph Kimball: The Data Warehouse Toolkit, editor Wiley.

He describes simply and with many examples how to build star schemas. His aim was to have thsi done in RDBMS' with sql but his modeling principles can be applied to anything. I only did OLAP before getting on to qv and for both the lessons are fine. read the book and you'll be dreaming about star schemas

the link is to a 2nd edition which I can't vouch for as I have the original and haven't seen the second one.

http://www.amazon.com/Data-Warehouse-Toolkit-Complete-Dimensional/dp/0471200247

Another great ressouce which was useful for me was Larry Greenfield's web site which covered many aspects of BI projects. At the time the buzzwords were Data Warehousing and that is the title of Larry's site now which gathers together essays many of which were written in the mid 90s. http://www.dwinfocenter.org/

The final ressource that I'd recommend are articles by Nigel Pendse. he used to write something called the OLAP report. His site was a pay for service but some of it was free. here we are getting furher away from data modeling but in all makes for a rounded approach to BI in general.

hope this helps