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
by Matt Allington Today I am sharing a trick that I have used a number of times for clients – it allows you to use simple VBA to jump from one pivot table to another, and when you arrive at…
***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.
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.
We started using Power Pivot at The Robbins Company back in 2013 and I wrote about our experience on this blog (click here).