Make no mistake, Microsoft is not about to throw their iconic programs, like Excel and Outlook, under the bus, even though SMBS and large enterprise move to today’s iterations of Dynamics ERP and CRM.
For one thing, the Dynamics platform is not, or never will be, a replacement for so-called legacy programs like the two aforementioned applications.
Consider the ‘intuitive’ design of Microsoft Dynamics GP 2015 online, and how it’s Business Intelligence (BI) capability seamlessly integrates Excel into the Dynamics s of using the ubiquitous spreadsheet.
Dynamics BI tool creates opportunities for wickedly spot-on decision- making; this, by interconnecting data within existing Excel sheets with Dynamics. The resulting analysis is displayed both “visually and contextually,” a noted in the Microsoft Dynamics University Winter 2014 magazine.
Sound complicated? Not at all, and that’s the beauty behind the implementation of Dynamics GP’s Analysis Cubes for Excel (ACE).
The highlights of the ACE feature, as noted on the ERPSoftware blog include:
- Pre-aggregated and focused data sets
- Slice and dice GP data on the fly
- Dashboard tool data source
- Spot trends and perform analysis that couldn’t easily be accomplished with other reporting options.
To further the notion that it’s ‘ok’ to still use Excel, but to a higher degree of insight, the Analysis Cube also provides…
- Access from outside of GP with Excel/PowerPivot and SQL reporting services
- Data Storyboarding when used with PowerView.
To put the power of BI to work in your departments today, contact us and as always, a Microsoft Certified trained-staff provides stands ready to answer questions.