Dan Peltier gives us a look at Microsoft Dynamics GP 2013 R2 Sales and Purchasing Dashboards with Office 365
Microsoft Dynamics GP 2013 R2 Sales and Purchasing Dashboards with Office 365 – Dynamics GP Support and Services Blog
Sales, Purchasing & InventoryReporting & BIExcel & OfficeGP 2013
Archived post from 2014. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.