It has been posting interesting articles about Data View Web Part (DVWP).
I know a great deal about Data View Web Part and there are numerous solutions I posted here which were created with it (Blog archive SharePoint Lists and Libraries, Outlook Style KPIs).
We can use Data View Web Part to pull data from subsites
We can use Data View Web Part to aggregate data from more than one list
For more details check her post, or attend one of the online workshops about DVWP at End User SharePoint.
Advantage: This is very important for Windows SharePoint Services users since you do not have Content Query Web Part in WSS. By using DVWP you might be able to aggregate and present information in very interesting ways.
Problem: Although DVWP can aggregate data from subsites you would have to pre-configure all the sources. In case you add a new site you will need to ad it to your data sources. (I presume it might not perform very well when multiple sources are used).
Conclusion: No matter how hard you learn, when it comes to SharePoint, there is always something new to learn. Keep your eyes open!