Resuming from Last Week Last week’s post left off here: most BI still relies on the storage layer (SQL or its many cousins) to be the brain, and storage layers are terrible brains because they were designed for storage, not…
Post by Rob Collie
The Models We Build in Power Pivot are the Prime Movers. Visualization is “Just” Where the Information (Output of the Model) Meets the Humans.
A Comment Plucked Straight from My Brain!
Avi’s post last week was deliberately thought-provoking (and to some, perhaps outright provoking, heh heh). It drew a lot of views, shares, tweets, and comments.
My favorite comment, by far, was this one by Andrew. Here’s a slightly condensed version of it:
“Five years from now, I envision a time when awesome visualization tools and incredible and beautiful charts are common and very cheap. Everyone will have those and they will be easy to make. What will still be rare is what Power Pivot does and the role that it plays along with Power Query. The real action is in prepping data and turning it into information that can be visualized… not the actual visualizations. Unfortunately, so many get lost amid a sea of pretty bars on maps and dynamic spider webs…
It’s the model stupid! It’s the ease of crunching numbers and aggregating millions of rows on the fly! It’s the simplicity of turning trash data into sparkling clean information and not having to go through red tape clogged and extremely expensive departments to do it – do it yourself!…
Hear hear, Andrew! Salute! We park our cars in the same garage, as the movie producer said to Christian Slater in True Romance. As I’ve said before, even the phrase “let’s look at the data” sets us up for failure.
Visualization: NOT Unimportant. Just Easier to Replace!
Just Like Light Bulbs: Crucial, But MUCH Easier to Replace than the Wiring.
In short, my observations today come down to these three things:
- RVOE: Replacement Value Over Excel. Excel is essentially free, and is incredibly under-rated as a viz tool. If you measure any Viz tool’s true value through this lens, it’s much harder to justify the price of most of them.
- It’s Relatively Easy for Software Firms to Build a Viz Tool. Compared to modeling and calc engines like Power Pivot, at least. And Power Pivot is the best such engine on the market. So, I think it’s sensible to start with Power Pivot as your core “commitment,” and then pick your viz layer – there are many available, and many more to come as time goes on.
- Don’t buy a “full stack” Analytics Tool Just Because of its Viz capabilities. This is kinda the corrolary to #2, but it also helps us understand why certain “Viz” tools are so stinking expensive.
- My parting thoughts on the ways in which Viz tools ARE important.
A dream you have, will come true
(courtesy Fortune Cookie Message).
Sooner or later there are going to be legions of Power Pivot developers – yes I call them developers; these are our Excel Superheroes charged up on Power Pivot. No longer creating workbooks, these are BI applications in all respects. The pace is hard to predict, but revolution is coming. Already in my short stint at PowerPivotPro I have been heartened to work with folks from California to Germany who are discovering Power Pivot and it’s amazing powers (Can we make this a drinking game, every time I use the word ‘power’, everyone downs a shot). If you are still sitting on the Excel fence, sign up for our next Webinar and Cross the Gap from Excel to Power Pivot.
Back to Tableau…
Power BI can power Tableau
Tableau is a great tool. I can only claim a 101 level familiarity, but I have seen enough to know that it is a very promising tool. At it’s heart Tableau is and will be a data visualization company. Which is terrific, it is better to do one thing and do it well (Sigh! Microsoft)
Although at one point Tableau had filled gaps in data collection, modeling and shaping; by now Power BI toolset (Power Pivot and Power Query specifically) have done that and more! The biggest overlap still, is with Power View (and it’s upcoming cousin Power BI Dashboard).
But I say, if Office can play well with Dropbox, in spite of Onedrive…
Power Pivot and Power Query can play great with Tableau, in spite of Power View.
This Picture is a Hint. An Admittedly Annoying Hint That Hounds me on Facebook.
“OK, way to make it super-obvious, Rob. It’s Tableau, right?”
Actually, no. It’s not Tableau. And the Tableau advertisement above basically proves my point.
By far, the biggest “competitor” to Power Pivot is… Excel itself.
In other words, lack of awareness that Power Pivot even EXISTS is still the biggest “competitor” to Power Pivot today.
The Tableau marketing department is smart. They know that “normal” Excel is their chief competitor. And they know that “normal” Excel has some frustrating weaknesses when it comes to data analysis.
So they go right for the throat. I salute and admire their savvy. Which brings me to a movie quote.