A new whitepaper has been published on MSDN:
Analyzing SharePoint Usage
This whitepaper covers in detail the process of using LogParser to deeply analyse the logs produced by SharePoint.
Some of the topics covered include:
A lot of this information applies to any web application, not just SharePoint sites.