I heard Datamicron's Performa is a good tool for such things. It doesn't depend on SharePoint, it is standalone application, and connects to SSAS cubes and PPivot as well. No coding is required. everything is done with drag and drop, they have BI Reports, which is simple drag-and-drop based on cube. For dashbaording they have dashboard designer which is very easy to use, again no coding required, dashbaords can be seen in browsers. It can integrate SSRS pages in itself, and you have good control over drillthrough etc...