Best Practise For Data Modelling

[suniljain]

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

[#2]

Hi Sunil,

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

[suniljain]

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

[suniljain]

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

[#5]

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

Thanks

Anand

Regards

[pat_agen]

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