Make sure to check out Power View a little better. It's very intuitive and with a few clicks you can make a compelling dashboard.

If you have Excel 2013, PowerPivot and Power View run natively inside your Excel sheet, so you don't need SharePoint anymore!