ERP Business Intelligence: Review of Microsoft Dynamics Reporting Tools & Capabilities

Visit Website View Our Posts

Turnkey Gets Technical Blog Series - BI #3


In the previous Turnkey Technologies BI Blog, we defined BVDs (BI Value Differentiators) and identified Analysis Cubes for Excel (ACE) as a low cost bolt-on BI system for GP with re-usable calculated measures for analyzing and discovering unique decision information.

In addition to ACE, there are other commonly used Dynamics reporting tools that you have likely heard of or already own. Here’s an informal review of some widely-adopted Dynamics Connected Reporting Tools & Capabilities:


Dynamics Reporting Tools - Value Table


Analytics effectiveness depends on prioritization of one or more of the above important factors. Most Dynamics GP owners have items 1, 2, 3 & 4. The world has item #5 PowerPivot via free add-in to Excel 2010 or activation within Professional Plus versions of Excel 2013. Those with SSRS-integrated Sharepoint or with Excel 2013 also have #6 (PowerView) and other Power BI tools.

So today’s blog tells us very succinctly… “Identify low-cost options and make a plan to use what you have”.

BI puts the right information in the hands of the people who use it for decision and business action, but you need to know the capabilities of tools you may already own (or can deploy at a low cost) to take advantage. Identification & prioritization within a defined action plan are critical steps.


If you have any questions or would like to learn more, contact us today:


Contact Turnkey Technologies Inc. (button)


By Turnkey Technologies, Inc. – Microsoft Gold Certified Dynamics ERP & Dynamics CRM Partner of Missouri, Illinois, Oklahoma and North Texas.

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Show Buttons
Hide Buttons