Summary

We've looked at one of the best methods for getting data for our dashboard. We've deployed, secured, run, and built Excel reports. Now that we've thoroughly explored one of the best ways to get real-time data out of Dynamics GP 2016 and into Microsoft Excel, let's start looking at how to use this information as the foundation for a dashboard.

In the next chapter, we will start to build our dashboard using one of the fundamental building blocks—the pivot tables.