Module Link: http://drupal.org/project/views

• Who: Technical and non-technical users depending on how deep you wish to go
• What: The views module allows you to query information from your database and displaying it in configurable formats without knowing any SQL (Structured Query Language).
• When: Use this module when you need to pull out information (more than one node) and display it to a user.
• Where: You can find it under the Site Building section of the admin back end.
• Why: While some may see this as a nice to have module, I see it as required. Even though I write SQL day in and day out this module makes my life so much easier, I don't have to create crazy joins or even touch SQL if I don't want to. Some of my non-technical clients even use this interface to add various fields to the output!

Theme song "i dunno" by grapes.