The Microsoft BI team have put together a great site on Technet, that has end-to-end guidance on how to implement BI solutions in your organizations. Additional scenarios will be added regularly, so add this site to your favourites and keep on visiting frequently. You can also leave comments on the topics you are looking for guidance on. The guidance covers the products that make up the Microsoft BI solution – Excel, SQL Server, SharePoint, Visio, Project Server.