As usual, I'm behind the technology times. I found these free how-to videos that were posted online a year ago. I should have been watching these a long time ago. For the past year and a half on the previous project I was using Oracle database. Now I'm working on a new project where we're using SQL Server 2008 Analysis and Reporting Services. So far it's been very cool. These videos have been helpful in drilling down into the details. I hope you find them useful.
SQL Server 2008 How-To Videos