What are good resources on data modelling for business intelligence?
I recommend the Data Warehousing Toolkit by Ralph Kimball.  This is a solid book on dimensional modeling and provides many "soup to nuts" case studies.