Zoe Helps Me Answer a Long-Simmering Question This summer we welcomed Zoe Stein (an Industrial Engineering major from Georgia Tech) to the team for a summer internship. Which is super exciting just in general – Data wasn’t really “a thing”…
Awhile back I recorded a podcast with John Michaloudis from MyExcelOnline and it went live today. Fun chat, lots of excitement. In my podcast with John Michaloudis, we talk about all of the “beautiful accidents” which led me to where…
Guess Which One Grows Your Career (or Company) More? (Hint: It’s the One on the Right) (But Individual Excellence is a Prerequisite for Org-Wide Impact) “Cuz we need a little, Con-tro-versy…” -Marshall Mathers Last week’s post on learning DAX…
In First Impressions, Power Query Steals the Show Let’s say I have ten minutes with an “uninitiated” Excel pro – someone who slings VLOOKUP and Pivots all the time, but has no idea that Power Pivot and Power Query exist. …
Our Story (that Began in 2010!) Hits an Inflection Point Buckle up folks, this is a longish post – but if you find the topic even HALF as interesting as I do, it will be worth your time to read. …
For Much of Last Week, Our Power Pivot & Power BI Book Topped the Spreadsheet Category on Amazon (Think about it: more people learning about DAX than learning about VLOOKUP or SUMIF is a MAJOR development!) Awareness That’s Been a…
"Do we use Power Pivot or Power Query?" – I get this question all the time when teaching Power BI classes. (Note: This applies in Excel as well as Power BI Desktop world. Even though in PBI Desktop the tools…
A long time coming… The Finalized 8-Page “Reference Card V2” – Download it for Free Below Yes, this took me forever. I first posted about it more than six months ago. It took a lot of effort, for sure, but…
Post by Rob Collie
A Recent Trip to the Hospital Highlighted the Folly of The Way Things Work
That Oh So Sneaky “Adoption Problem”
I spend a lot of time talking to software vendors. One vendor specifically of course, whose name rhymes with “Bike Row Loft.” But all software vendors share one basic habit, which is that they’re constantly asking, “How do we get more customers to BUY our tools?”
But I also spend a lot of time talking to their customers. And while the vendors expect their customers’ most pressing question to be “which software tools do I buy,” the reality I see is FAR different.
Buying software is just the FIRST step down a very difficult road. You choose the software from Vendor X, announce the decision to your organization, send Vendor X a check… and that’s the starting gun.
Yeah, Vendor X sees that as the END of the story. And so do their competitors, Vendor Y and Vendor Z, who slink away defeated. But you, the purchaser of the tools, well, your story is just beginning isn’t it?
Now you have to get your PEOPLE to start USING the new tools. And to KEEP using them. I’ve discovered that this is by FAR a much bigger problem than choosing the tool.
“The New Operating Room Sucks, Who Designs These Things?”
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”.
This is huge. It’s as if two worlds are colliding, creating a good kind of explosion.
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