Working with Content Query Webpart, you should be good at XSLT, Showing only roll-up data from site collection and with complex view, nightmares when you want to integrate with with javascript plugins.