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

Tales from the Trenches: My personal experience with Power Update (by Tim Rodman)

Guest Post by Tim Rodman, currently blogging about reporting in Acumatica ERP @ www.AcumaticaReports.com

***Update #1:  a Free Version of Power Update is now available.  More info here.

***Update #2:  There is now a forum for Power Update questions, located here.

Intro from Rob: I’m what you might call a “gift horse optimist” – strongly positive outlook, but when the hoped-for thing finally arrives, I find myself closely inspecting it, testing it, before I trust it enough to advocate it to others.  I went through this same process with Power Pivot itself – I “saw” its gamechanging power in 2010, but it was a full eighteen months before I finally dropped all disclaimers and just started calling it far better – period – than anything we’ve had before.”

Similarly, I’ve long known that Power Update would be a MAJOR win for us in the Power Pivot and Power BI communities.  But I am willing to advocate it now only because I’ve watched others – like Scott, and Tim below – use it successfully, in production environments, in recent months.  (Also see my post last week “introducing” Power Update in case you missed it).

Take it away, Tim…

I first found out about Power Update two months ago via a LinkedIn post by Christian Floyd.

It took me a while to realize that he wasn’t talking about a theoretical future idea, but an actual product, something that exists today. Click the picture below to see the entirety of my foolishness. It wasn’t until I talked to him directly that I realized what Power Update really was and I was immediately interested.

image

He got me a beta version of Power Update and I began testing it at the company I work for: a manufacturing company in Cleveland, OH called The Robbins Company.

Our Background

We started using Power Pivot at The Robbins Company back in 2013 and I wrote about our experience on this blog (click here).

Read the Rest

Self Serve BI Adoption: the Relative Roles of People, Technology, the Business, and IT

Guest Post by Tim Rodman, currently blogging about Acumatica ERP @ www.PerpetualAcumaticaLearner.com

Self-Service BI and Power Pivot Barriers To Entry
They may take our lives, but they’ll never take our freedom Self-Service BI and Power Pivot.

Brief Intro from Rob:  Tim has a great “backstory.”  He found out about Power Pivot in the “usual” way – via a completely random coincidence.  I taught a private class to a firm here in town a couple years back, and one of the attendees (a guy named Andy) lived a few houses down the street from Tim.  Sitting outside at a summer barbecue, Andy mentioned Power Pivot to Tim, Tim said “what’s that?” and six months later Tim was a speaker at our Modern Excel User group.  I think he has some very interesting things to say here – very introspective and honest.  Worth a read for everyone.

Take it away Tim…

I’ve been thinking lately about Self-Service BI and barriers to entry. Now, when it comes to Self-Service BI, much of the focus is on the technology. Do you want to go with Microsoft, Tableau, something else? It seems to me like most of the content on the subject of Self-Service BI is focused on comparing the different technology offerings. I personally don’t know much about the gory details related to the technology behind these products, but I do think that too much attention is given to the technology and not enough attention is given to the people.

In my opinion, PEOPLE are the biggest barrier to entering the Self-Service BI age, not technology.  Note: for the purposes of this post, I’m going to focus on Power Pivot since this is appearing on a Power Pivot blog.

Read the Rest