To anyone interested in getting started with Business Intelligence, here is a series of screencasts that introduce you to the various Microsoft software and how they fit together:

http://channel9.msdn.com/tags/Business+Intelligence/