September 9, 2014
by Rob Collie
Power BI, Definition #1: An “Umbrella” Term for all of the “Power *” Tools
(Click for Full-Size Version)
An Overdue Treatment
I’ve posted before about Power Pivot vs. Power View and then later I added Power Query and other technologies to the explanation, but I’ve never just straight-on tackled the question of “What is Power BI?” So let’s get that off the list…
…And clean up my prior visuals while we are at it. (Can you believe that Power Query doesn’t have an icon/logo yet? Well, boom – I just gave it one. You’re welcome, Microsoft – although really it was just from one of the buttons already in PQ.)
Unofficial Definition = “Umbrella Term for the ‘Power *’ Tools”
#1, Power BI is an “umbrella” term that is used to describe all of the various “Power” data tools that Microsoft offers us. This is NOT the definition that you will typically hear from Microsoft, but colloquially, when someone says “Power BI,” there’s a good chance this is what they mean.
Official Definition = “The Cloud Publish & Manage Service from MS”
But I think Microsoft would say, more officially, that Power BI is their paid cloud service for publishing, sharing, managing, and consuming the results of those tools pictured above.
For instance, Microsoft sales reps today are measured, in part, by their customers’ adoption of precisely that online subscription service. They are NOT measured by how many of their customers are simply using the “free” desktop tools included in the Power BI “umbrella” term.
Read the rest of this entry »
December 14, 2012
Connection Cloud is Offering to Buy You a Copy of My Book, Click Image for More Info
The cloud data connection service I talked about and demo’d in yesterday’s post is offering to buy a copy of the book for anyone who sign up with Connection Cloud by January 15th.
A flattering gesture on their part, this is definitely a first for me
Excel Pros – the world is waking up to our importance.
December 13, 2012
Cloud Data Like SalesForce Available to PowerPivot as if it Were in a Local Database:
My Long Wish for a “Data Highway” Gets Closer Every Day
(Click for the Webinar Featuring Yours Truly on YouTube)
Flashback 2001: The “Data Highway” Concept
Back at Microsoft in 2001 when I was working on what eventually became Excel 2003, I pitched a vision that I called “Data Highway.” (OK, not an original name considering the Information Superhighway thing coined by Internet inventor Al Gore, but invention is smart and theft is genius, or something like that.)
The idea behind Data Highway was simple: all relevant data made available to the most popular tools (cough cough Excel), in a convenient and refreshable format. No manual gruntwork required to “fetch” data in other words – saving your brain for actual thinking.
There were three elements to the pitch:
- A common internet protocol for exchanging data.
- “Teaching” Excel, Access, and other tools to consume any data source exposed via that protocol.
- A marketplace for data where providers like Dun and Bradstreet could sell data to be piped straight into Excel.
Well the protocol flopped and our VP killed the marketplace idea before it got off the ground. Having good ideas isn’t enough – you can’t be too early, and you also need to execute better than we did.
Fast Forward to Today
Here we are at the end of 2012, and we have all three elements available in different (but robust and real) forms:
Read the rest of this entry »