skip to Main Content

Data Nirvana: Power Pivot, OData, and Acumatica ERP

Guest Post By: Tim Rodman

There is finally an ERP product that gets it, that embraces Power Pivot, Power BI, and the more than 800 million users of Microsoft Excel.

“What Power Pivot did to Excel, Acumatica is doing to the world of ERP”.

Acumatica recently announced the ability to securely connect to Acumatica ERP data through OData

This is huge. It’s as if two worlds are colliding, creating a good kind of explosion.

2015-05-31_02-38-40

You: “So, wait a second, what is ERP?”

Me: “Great question, I should probably back up for a minute.”

What is ERP

ERP stands for Enterprise Resource Planning and it is the computer system that ties all of the departments in your organization together.

If you work with Power Pivot, there is a very good chance that you also work with ERP data.
SAP, Oracle, Microsoft Dynamics, Infor, Epicor, Sage, and NetSuite are all examples of ERP systems.

Many of the ERP systems in companies today are very old and very ugly. The problem is that they are expensive to replace so they continue to exist through a patchwork of duct tape fixes that have been cobbled together over the years.

However, ERP systems contain a virtual Fort Knox of data that can lead to incredible insights if analyzed correctly (with Power Pivot of course).

The ERP Problem

Read the Rest