Build a Refreshable Excel 2013 Dashboard with Dynamics GP Data: Part 4 of a 5 part series
In previous posts, we have talked about the benefits of Business Intelligence, created a report with Jet Express for Dynamics GP and analyzed Dynamics GP sales data using Market Basket Analysis to help increase sales. Today we will be connecting our Excel 2013 spreadsheet to a SQL view to create a dynamic refreshable Sales Dashboard. So let’s jump right in and get started building our Sales Dashboard.