In-Person Class in Philly, Oct 21-22!

September 2, 2014

Post by Rob Collie

How recent students have described the class

image

Our July Class in Cleveland – 90% of these Fine Folks Came from Out of State!
(And One From Australia!)

Taking it to the East Coast – and Beyond

After running three consecutive classes in Cleveland (April, July, and August), and seeing a packed classroom for the last two, we’ve decided that I should start occasionally venturing out of the Heartland and teaching the class elsewhere too.

This time we’re going to be partnering with Microsoft itself, and teaching in their MTC (Microsoft Technology Center) just outside of Philadelphia.  An exciting step for sure, uniting me (former ‘Softie and Power Pivot’s most passionate advocate), with, you know, the company that makes the product.  Probably should have figured out some way to cooperate sooner, but such is the independent nature of current and former ‘Softies.

Click Here to View Class Details & Registration

Optional Gathering/Dinner on “Middle” Night

image

Some Folks from the August Class Throws the “Excel Gang Sign” at Dinner
(Can You Spot MrExcel Himself, Bill Jelen?)

On the night of the first classroom day, we’ve been running an informal gathering at a local restaurant, and many people reported that it was one of their favorite social outings ever.  Just being surrounded by people with similar backgrounds, mindsets, and problems is a unique experience, especially for the Excel crowd.

So of course we will organize such an outing in Philly as well.  Venue TBD (if you have suggestions, send them our way).

Included:  Thumb Drive and 50% Off Online University

All Students Receive a PowerPivotPro thumbdrive containing the materials from the course:

thumbdrive

And also a 50% off discount code to the online video course.  Past students have found it to be a helpful “reinforcement” to the live class (as well as covering topics that we don’t have time for in two days), so we have decided to offer it as a bundle.

More Info and Registration…

Click Here to View Class Details & Registration


Greetings from San Jose!

May 8, 2014

 
image

53 People Showed Up for My Full-Day Pre-Conference Session on Power Pivot
(Definitely the Largest Class I Have Ever Taught)

I know, it’s nearly 2:00 Wednesday morning, Eastern time, as I write this.

But on the West Coast, hey, it IS still technically Tuesday, so this post isn’t really that late.  Heh heh.

As usual, I burned a lot of psychic energy teaching the class today, leaving me pretty drained at day’s end.  But wow, totally worth it – which is why, every time, I throw myself into it completely.  And wind up totally zonked that evening.

I get to get up tomorrow and do it again, albeit this time in a 1-hour session.  And then another Friday with Mike.

In other news, Kasper’s book is real!

image

Two Books Make it a Series!  With Alchemy on the Way Shortly.

What a pleasant surprise to have Kasper walk up to me and hand me a shiny new copy of his book today!

I haven’t had a chance to review it, at all, yet.  But a quick glance shows me that he took the “personal/informal” approach rather than the super-dry tech book approach.  People have really seemed to appreciate that about my book, so I think that bodes well for this one.

Stay tuned for a review once I’ve had time to digest.  In the meantime you can order it on Amazon if you prefer not to wait.

And yes, Alchemy IS on its way.  Looks like it is going to be printed and bound this weekend:

image

Alchemy Goes to the Print Machines This Sunday Night!

It has been a VERY busy year.


Mini-Post: 2-Day Class in Cleveland, July 30-31

May 1, 2014

 
teacher power pivot

Yes, I Look Precisely Like This in Person Smile with tongue out
(But No, I Don’t Have One of Those Little Teacher Batons)

The last time we did this was a blast.  So we thought we’d do it again, this time with more advanced notice.  I met some truly amazing people – even the lunch breaks were just a lot of fun.  And, as amazing people are inclined to do, they are now off doing amazing things with their data.

Half the class actually traveled in from out of town last time, which is an inversion of my normal dynamic of flying out to a client’s headquarters.  It’s a very cool feeling to wake up at my house, get in the car, and go teach Power Pivot all day.

It makes it all feel very mainstream, which is of course becoming more true every day.  The first time I taught Power Pivot professionally was 3.5 years ago out in California, and for what felt like a long time after that, ALL of my clients seemed to be “out West.”

That I can now teach classes without leaving town is, in itself, a sign of the times.  Just fantastic.  And I hope to see a few of you there.

This time I think we will also schedule a “social event” of sorts at the end of the first day.  Even if it’s just grabbing a beer or something similarly simple, it’s something I wish we’d done the first time, especially for the out of towners.  Purely optional and informal.  But fun.

Syllabus, pricing, and registration information here


Mini-Post: Agenda “Slides” from One of my PASS Talks Next Week in San Jose, CA

April 30, 2014

 

Power Pivot Talk on Self Service BI Revolution

One of my Intro “Slides” for Next Week
(“Slides” in quotes because the live version is animated)

I’ve mentioned before that I am speaking at the 2nd annual PASS Business Analytics Conference, aka BACON, and I’ve also mentioned that I’m scheduled to present three separate sessions:

  1. A full-day pre-conference session – a Power Pivot Jumpstart, if you will.
  2. A joint presentation with Mike Miskell of Kaman Industrial Technologies, where we talk about their tremendous Enterprise-wide scorecarding success with Power Pivot.
  3. A “solo, standard” session on My Seven Principles for the Data Revolution (listed as Six in the program, but Now With 16.7% More Principles!)

In Case You Like BA-CON on a Whim…

I think there’s approximately a 0% chance anyone is going to decide “hey, I’m gonna fly to San Jose next week on short notice,” but just in case, remember to use the discount code BASB5O.

Those of you who are already signed up?  Well, I will see you next week Smile

Power Pivot Talk on Self Service BI Revolution

This “Crypto-Cute” Agenda Slide Will Be Explained to Attendees Next Week
(Also Animated.  Hmm, Maybe I Will Do a YouTube Version in the Future)


A Few Updates

April 17, 2014

 
Rob here, checking in quickly…

1) Check out today’s guest post below.  I needed to add these updates but I don’t want to push Seth off of the page and have you miss his perspective.  Click here to view his brief thoughts.

2) Yeah, the site was down for 13 hours yesterday.  Bluehost had a widespread outage affecting thousands of customers.  We hired a local consultant yesterday and are moving everything “in house.”  Buh bye, Bluehost.

3) I’ve added another session at the PASS BA Conference next month, which means I am now doing three.  The new one is an exciting new twist for me, because it’s one of our clients sharing their experiences with Power Pivot, with me merely in “color commentary” role:

Power Pivot Case Study - Live at the PASS BA Conference

Click Image to View the Abstract

It’s a CRAZY cool story about Power Pivot solving a problem at the highest levels for a billion-dollar company.  Enterprise impact from a tool that’s often mistakenly pigeonholed as limited to “team” level.

This is not proving to be the exception, either – we now already have two other clients doing VERY similar things, and like Kaman they are both in the “billion dollar plus” range in terms of annual revenue.  Not small, in other words.

Remember, if you choose to register for the conference, use code BASB5O for $150 off.

See this post for more details about the conference.


Occupy BACON: Let’s Do This. (Sessions & Discount)

March 18, 2014

 
image

It’s Possible that Maybe I Added Something to Their Banner Image :)
(Click Image to Visit Site)

Year One Was Great, So I’m Speaking Again – San Jose CA, May 7-9

I really enjoyed the inaugural PASS Business Analytics Conference, aka PASS BACON, last year.  Before that, I’d never been to a conference that was even remotely aimed at “my kind of people.”  That all changed for me last year.  I think we have found our home.

THIS is the kind of conference we need – one that’s accessible without heavy technology expertise.  One where Business Impact take center stage, and the only pre-requisite is that you enjoy working with data.  (And it helps if you don’t flinch at the word “Microsoft.”)

Which suits us Excel folks to a tee, doesn’t it?  They might as well put us on the front page.  But an explicit mention of Excel would scare off those other people – the non-Excel people (that we outnumber 100 to 1).  Honestly I think we should just take this thing over.  You know, like…  Occupy BACON.  (Brief pause while I replace the previously-bland title of this post with precisely that).

Putting my time where my mouth is, this year I am “doubling down” and presenting two sessions – a full-day “pre-con” and a “regular” session – see below for details.  AND I’m in discussions about presenting a third session as well, stay tuned on that.

We like dominating the "BACON Challenge"Last Year’s Referral Champion Wants to Repeat!

A little bird told us that last year, more people signed up for PASS BACON using the PowerPivotPro discount code than any other discount code.

Pretty cool, eh?  Anyway, there’s a discount code again this year, but I’ve been slow to share it.  Let’s pretend we did that to give all those “non-Excel” websites a head start, given that whole “100 to 1 outnumber” thing (in reality I have just been swamped).

Read the rest of this entry »


Speaking Next Week in Minneapolis! (Tue 2/25)

February 17, 2014

 
image

Be There, Twin Cities!  I’ll Be Signing Babies and Kissing Books.
(Strike That.  Reverse It.)

Would love to meet some of you in person!  I’m not sure about the agenda for the evening but maybe we’ll all end up going out for dinner and/or a beer after the talk.

I’ll also bring a Sharpie in case anyone wants to experience the awkward moment of data-nerd book signing!  (I’ll also try to lug a few extra books on the plane).

Click Here to Reserve a Seat (Only 39 of 150 seats remain)


Tuesday Post #2: User Groups Update

June 18, 2013

Big flood of responses today, we’re approaching 300 total Smile

Updated status (changes in CAPS)…

Places that are ready:  PORTLAND, DETROIT, WASHINGTON DC, VANCOUVER BC, Boston, Cincy/Dayton, Milwaukee/Madison, Seattle, Atlanta

Places that are getting close:  MINNEAPOLIS/ST. PAUL, KANSAS CITY, CHICAGO, LONDON, BUENOS AIRES, CAPE TOWN, NORTHERN ENGLAND, PERTH, MELBOURNE, SYDNEY, New York, Dallas, and Indianapolis

Places that just need an organizer:  NorCal and Denver.

(If we can count Toronto/Buffalo as one area, we’re ready there, too, but that seems like a stretch?)

Updated maps, since these seem popular:

imageimageimage

image image

Click Each Thumbnail for Larger View
(Now if only there were a way for me to publish these interactively…)

I’m going to leave the signup forms open for a few more days before I take any action on this, but some time next week I should start the ball rolling on actually making these happen.

If you know folks in your corner of the world who SHOULD be signing up, please send them to the signup page!

Signup to be notified here (if you haven’t already)


User Group Interest: All Maps So Far (Monday Mini-post #3)

June 17, 2013

 
image imageimage

imageimage

Click each thumbnail for larger version
(My first ‘”production” use of Power View, by the way)

183 total responses so far.  Cleveland and SoCal are now ready in my opinion (joining Boston, Cincy/Dayton, Milwaukee/Madison, Seattle, and Atlanta).  New York, Dallas, and Indianapolis are getting close.  NorCal and Denver each really just need an organizer. 

Outside the US, Sydney, Singapore, London, and Buenos Aires are getting close.

I don’t see critical mass of responses from Europe yet – are user groups not “a thing” in Europe?  (I do know that lots of people are using PowerPivot in Europe so I expect more responses over time.)

Click here to register your interest (if you haven’t already)


PowerPivot User Groups! (Mini-Post #2)

June 13, 2013

 PowerPivot User Groups

Let’s get this party started.  Register to be notified Smile

I just spent three days training a wonderful team of Excel pros who are up to their eyeballs in data.

Even though I play the role of “expert” on trips like that, I still learn new things everywhere I go.  Sometimes, I learn things that I already “knew,” but didn’t really “know.”  If you know what I mean.

For instance, great question this week:  “Are there PowerPivot user groups?  If there are, I think we would all attend.”

I talk about this all the time.  SQL pros have user groups that meet on weekday evenings, and they have SQL Saturdays which almost always “sell out” (they are free).  SharePoint pros have the same things – weekday user groups and SharePoint Saturdays.

So for a few years I’ve essentially been whining about this – how Excel has no equivalent community.  This week’s question showed me that it’s time to just get up off the bench and get this started.  The world is ready for it.  PowerPivot is the reason to cut your fingernails, in Fight Club terms.

So let’s do it.  Please take this short survey and we’ll see which cities are ready to get started immediately.

Click here to register your interest in a User Group in Your Area


Heading Down to Uniontown (MrExcel HQ)!

May 10, 2013

 

image

Chandoo:  “It’s 46 miles to Uniontown, we’ve got a full tank of gas, half a stack of Excel books, it’s overcast, and we’re wearing sunglasses.”

Rob:  “Hit it.”

Hitting the Road.  Holding a Mini-Summit.

Chandoo and I are jumping in the car this afternoon for a short journey down I-77 to a place MrExcel calls home.  Well, at least, that’s where Bill lives and works today.  He is, sadly, moving to Florida this summer.  (The second friend of mine to leave Ohio for Florida since I moved here – traitors! Smile)

This is going to be fun, having the three of us in one place like this.  But I’m a little bummed that we couldn’t get a good picture of us sitting IN the car.  There was too much glare on the windshield.

Otherwise, we were prepared to re-enact this classic scene:

image

Me, Chandoo, and Bill in One Place?  Serious Stuff?  Maybe.

When a bunch of Excel “heavies” get together like this for a day, you might think the gathering looks like this:

image

Sometimes, that’s true.  But they just as often turn out more like the barbecue scene from Mystery Men:

image

I’m interested to see which way today goes Smile


Chandoo’s “Excel Love” Spring US Tour!

April 21, 2013

 
image

The Chandoo Tour Bus:  Rolling Into Chicago, NYC,
Washington DC, and Columbus this May and June!

Excel and PowerPivot Masterclasses!

The one and only Chandoo is coming to the USA this Spring to teach some of his signature two-day  “masterclasses” on Advanced Excel and Dashboards, as well as a first-ever edition of PowerPivot and Data Analysis.

I’m particularly excited by that last one, as he’s invited me to teach it in conjunction with him!  That’s gonna be pretty damn cool – a “dueling pianos” format seems to be in order Smile.  

Class Dates

Note that these are all Thursday/Friday classes, except for the Columbus Dashboard class, which is Tuesday/Wednesday (followed by PowerPivot class on the same Thursday/Friday).

  • Chicago May 30-31 – Advanced Excel and Dashboards
  • New York June 6-7 – Advanced Excel and Dashboards
  • Washington DC June 13-14 – Advanced Excel and Dashboards
  • Columbus OH June 18-19 – Advanced Excel and Dashboards
  • Columbus OH June 20-21 – PowerPivot and Data Analysis (co-taught by me)

Pricing and Discounts

Read the rest of this entry »