Check out Power View, the flashy looking self-service BI dashboarding tool. Power View is available in SharePoint, but also in Excel 2013 (but the data needs to be in Excel). Power View works on top of SSAS.

With SSRS, you can also build decent reports and dashboards, but it takes some skill.

And yes, you can also build reports and dashboards in Excel. Admit it, it's the tool end users love 😀

If you are a bit skilled in it (and you don't need to be a developer for that), you can produce some awesome dashboards/graphs in Excel.

A nice book will be released soon: Dashboarding and Reporting with Power Pivot and Excel: How to Design and Create a Financial Dashboard with PowerPivot ?