Talk About Your Personal Journey OR Share a Technique – Either Way, it’s Time YOUR Voice is Heard Are you ready to see your name in lights? Hi folks! I know, I know… long time, no write. I’ve been busy,…
The first time you truly experience Power Pivot – not a demo, not some random public data set or someone else’s data – your own business data all lit up using Power Pivot. It is a transformative experience. And you know there is no turning back.
I remember that moment, I remember thinking this is HUGE, this gets BI in the hands of people who really need it. Power Pivot is surely is going to explode.
Sadly, it does not feel like that is happening 🙁
|a) Unaware. Have not heard of Power Pivot or Power BI|
|b) Aware but have not truly experienced the capabilities of Power Pivot|
|c) In Love with Power Pivot|
Note: Are there stages between b) and c)? Between experiencing Power Pivot and falling in love? Perhaps. But guided by the right hands that path should be really short 🙂
Unaware: Don’t know what they are missing
For the unaware group, I do my part; talking to anyone who would lend me an ear, about Power Pivot and Power BI at any event or gathering. But overall we would need to trust the higher powers 🙂 within Microsoft with that task. However I will make the offerings below to the powers that be:
– Power Pivot should be a free add-in for all versions of Excel 2013, just the way it is for Excel 2010. I feel it even makes good business sense for Microsoft. Power Pivot has the potential to attract a large user base and would solidly anchor Office and Office 365 in the rapidly changing world. These users can then be up sold services like Power BI.
– Power Pivot add-in should be easily discoverable. Both Power View and Power Map have buttons as part of the standard Excel ribbon, which can be used to easily activate these tools. Not so for Power Pivot.
It takes 8 mouse clicks to activate the add-in so you can launch Power Pivot.
File > Options > Add-Ins > Click Dropdown > COM Add-Ins > Go > Select ‘Microsoft Office Power Pivot for Excel 2013’ > Ok
As the first born in the Power BI suite, it is time for Power Pivot to claim it’s rightful place on the standard Excel ribbon and it would fit perfectly under the Data tab.
|Currently in Excel 2013||Desired in Excel 2013|
Note: There was a shift in Excel 2013 to weave in Power Pivot so closely with the tool (and call it Data Model) that potentially many users would not even need to learn or use the Power Pivot window. IMHO, that is just keeping people away from all the goodness and richness of Power Pivot. Let them come, let them explore and experience.
Aware but not in Love: Mind the Gap!
While I may feel helpless in making a dent in the Unaware group, I feel impassioned and even obligated to help the Aware but inexperienced group.
I have spoken to many Excel users and noticed that there is a gap between knowing about Power Pivot and actually trying it out yourself to experience its true power. There is a step there that many users simply cannot take. Being on the other side, it baffles me a bit. I feel like yelling “Hey, come on over, the grass IS greener on the other side!”
So we started this User Group…
…and, you know, it’s a real thing. We’ve got active chapters now in five US cities, a sense of “blueprint” for spreading it rapidly to many more cities worldwide, and nearly 700 members in the LinkedIn group. (What, you haven’t joined yet? Darth Formulus finds your lack of faith… disturbing. A problem easily remedied yes?)
But wouldn’t you know it. All you analytical types started asking “hey, what IS Modern Excel, exactly? What is considered ‘fair game’ to discuss at meetings?” “And what the heck is the point of this LinkedIn group – you’ve made virtually no announcements whatsoever.”
Ambiguity? That will never satisfy humans with Compulsive Data Crunching Disease. And I wouldn’t have it any other way. I thrive on this sort of thing.
As an aside, constantly being forced to be precise (by my peers) at Microsoft is one of the most formative and useful experiences of my life to date. My first 22 years on the planet had been fueled strictly by Instinctive Conviction – which in hindsight is merely another form of “coasting.” But I’ve since come to believe that if you cannot communicate your opinions effectively, not only will their impact be forever limited, but actually, even YOU don’t understand what you THINK you do. Sloppy communication often masks sloppy thinking. 22-year old Rob arrived in Redmond with an ample supply of both. It was as much fun as a multi-year waterboarding, but they straightened me out.
Excel 2007 Desktop is a BIG Dividing Line
All Right Music City! Let’s Go!(Click Image to Register) Please join us for the inaugural meeting of the Nashville Modern Excel User Group. Agenda: 1. Exclusive video intro from Rob Collie (former Microsoft engineering leader and founder of PowerPivotPro)…
1) Seattle User Group Kickoff Meeting Monday, February 10th, at Building 34 on Microsoft Main Campus That’s right, Seattle’s group is gonna meet at the Mothership itself – the building where I worked when I was working on Power Pivot,…
Monday, January 13, 2014 from 5:30 PM to 7:00 PM (EST) Microsoft Office -- Independence, OH6050 Oak Tree Blvd Independence, OH 44131 One Function to Rule Them All: CALCULATE is Your New Best Friend At this month’s meeting, Rob Collie…
Wednesday, January 15, 2014 from 6:30 PM to 8:00 PM (CST) Holiday Club4000 North Sheridan RoadChicago, IL 60613 Welcome to “New Excel” Please join us for the inaugural meeting of the Chicago “New Excel” User Group. Agenda: 1. Exclusive video…
An Obvious and Overdue Development In these early phases of jumpstarting the User Group, one of the things that’s become obvious is that we’d benefit from a social media discussion group. Rather than try to add one of our own…
“Are we there yet? Are we there yet? Are we there yet?”
Consider this a “Mailbag” Post
Hey, sportswriters do this all the time. They take emails out of their inbox and turn that into a full article. That’s not super appropriate for a blog like this, but I *am* getting three questions repeatedly:
- When is the Excel User Group starting up in my city?
- Is there a “webcast” option for watching the presentations in Cleveland and Atlanta?
- When is your new book, Power Pivot Alchemy being released?
Cleveland Date and Time: Monday, 11/11 from 5:30 – 7:00 PM Speaker: Tim Rodman from the Robbins Company Topic: Tales from the Trenches: The Robbins Company’s Excel Renaissance Click here for registration and more info Atlanta Date and Time: Thursday,…