At our October lunch and learn I demonstrated a free Excel dashboard from Microsoft that could be connected to Dynamics GP. I told everyone I would upload so click here to download.
There are a few things to note, this dashboard was really the Microsoft team experimenting with Business Intelligent components of Excel 2013 and Dynamics GP data. You will need to configure it as shown here in the instructions tab which require some technical capabilities along with security.
Overall, it will open your eyes of what can be done with the tools you have and allow you to analyze business quickly, accurately, and without a bunch of work which is the key.