Welcome to the Exact Product Blog

On this blog we will cover stories from all around the Exact ecosystem.

PowerPivot dashboards in Controlled Release

Written by Michiel Dorjee on . Posted in Exact Globe

In a world where entrepreneurs, managers and other stakeholders (both users and non-users of Exact) want to have a choice in how, when and where they want to have information about their business, Exact offers a new possibility to have insight in how to keep track of day-to-day-business-progress via PowerPivot.

We have chosen PowerPivot, an add-on for Microsoft Excel from version (Office) 2010, to use the reports in an environment that is familiar. The PowerPivot add-on is a free download from Microsoft and allows users to work with extremely large data sets.  PowerPivot is not available as a free add-on for MS Excel 2013. In that version it is only available in the licence Office Professional Plus.

In the last period we have created views on important tables in Exact Globe Next. Based on these views, we have built a Manufacturing, Purchase, Revenue and Stock report. The next good thing is that we offer these reports for free!

Two examples:

rapport_1         rapport_2

In the latest commercial release 406, the administrator has to execute a SQL script on the Globe database and change the data source of the PowerPivot sheet to connect to the Exact Globe Next database. As of product update 407, which is expected by the end of this year, the views will be automatically executed when the product update is installed.

At the moment we are looking for customers who want to work with these reports. We provide the reports through a Controlled Release program. If you are interested, please contact Justus van Hoegee (via justus.van.hoegee@exact.com) or me via phone (+31) 15 711 50 00 or via a reply on this blog.

Tags: , , , , , , , ,

Leave a comment