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 »


2-Day Public Class in Cleveland April 9-10

March 6, 2014

 
If you’re in the Ohio/Midwest area, I would love to meet you in person and help you on your Journey Through the Land of Data.

Only 18 seats in the class, so it will be “intimate.”  Lots of interaction, fun, and obviously…  mind-blowingly powerful techniques.  You know the drill – act fast and reserve your seat today, etc etc. Smile

Syllabus, pricing, and registration information here

(Apologies, no “real” post today – but only because I am so “slammed” with real work.  There are guest posts in the pipeline where if I just could have gotten free for a few minutes…)


Closing Midnight Tonight (US Pacific Time): PowerPivotPro University / Chandoo Bundles

February 21, 2014

Final Reminder!

PowerPivotPro University, aka Advanced Power Pivot on Chandoo's site.

Click Image to Register

And again, here’s the Q&A posted last week.  Happy learning!


What is “Modern Excel?”

February 20, 2014

Modern Excel:  Is it Just Power Pivot?

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

Read the rest of this entry »


Nashville Modern Excel UG Meeting–THIS Thursday!

February 18, 2014

 
image

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) – Why Now, What IS “New Excel,” the MASSIVE Opportunities Awaiting, and a Map to the Road Ahead.

2. Meet and greet – meet your fellow Excel professionals from the Nashville area.  You will be surprised at how “Not Alone” you are.

3. Discussion led by Will Harvey – who drove 4 hours to the Atlanta meeting last year (!) – covering things like:  Where are you on the roadmap?  What are the challenges to making progress?  What would you like to see from the group?

Revitalize your career.  Win with data.


“Level Up” Your Data Powers with PowerPivotPro University and Chandoo Course Bundles :)

February 17, 2014

 
Power Pivot Pokemon Last Week, Power Pivot Mario This Week

An Enthusiastic PowerPivotPro University Student Sent Me These Over the Weekend Smile

Signup Closes Friday:  Bundle PowerPivotPro Univ. w/ Chandoo Courses

Just a reminder that the joint discount/bundle offering with Chandoo closes this Friday:

Read the rest of this entry »


PowerPivotPro University Open on Chandoo.org

February 10, 2014

Open for Signups, Start Immediately.

PowerPivotPro University, aka Advanced Power Pivot on Chandoo's site.
Click to Enroll!

Questions & Answers

Q:  You Call it PowerPivotPro University, but Chandoo only offers “Power Pivot” and “Advanced Power Pivot.”  What’s going on?

A:  PowerPivotPro University is the same thing as Chandoo’s Advanced Power Pivot. It’s the exact same content, produced and taught by me, under two different names.  It’s just that Chandoo has his own Power Pivot course, and we needed to differentiate his from mine when offered on the same site.

PowerPivotPro University, aka Advanced Power Pivot on Chandoo's site.

When You Go to Chandoo’s Page, Scroll to the Bottom

Q:  So is your course really that advanced?  Should I be scared if I am new to Power Pivot?

A:  No.  I built my course to truly take you from “zero to sixty.”  It turns Beginners into Magicians.  So it’s basically Beginner AND Advanced combined – I may even split it into smaller courses in the future to reflect that.

Q:  What have the first few waves of students thought of PowerPivotPro University?

A:  Click here for some testimonials.

Q:  In the future, are you going to be offering PowerPivotPro University independently via this site, separate from Chandoo?

A:  Yes.  Even though there are many people already taking it through us directly, we are downplaying our independent delivery for now, and delivering it one more time through Chandoo in order to honor past commitments.  Then we’re “going solo” – but then may cooperate with Chandoo in other ways going forward.

Q:  Ah, that explains the confusing naming etc.  Seems like a tangled web.

A:  Bingo.  It’s just two entities doing right by each other.  Chandoo is awesome and a little confusion is nothing in the grand scheme.  It all clarifies in the near future.  Bear with us.

Q:  Are there any advantages to signing up now via Chandoo versus your solo offering in the near future?

A:  Yes, there are two benefits.  One is that you can start immediately, rather than waiting.  The second is that if you are interested in also taking some of Chandoo’s other courses, you can bundle them for a discount.


Seattle User Group Kickoff, Alchemy, and More

February 4, 2014

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, which also happens to be the building where Bill Gates used to work.

We already have 70 of the 125 seats filled, so act fast!

***REGISTER HERE:  https://seattlemeug.eventbrite.com

image

Exclusive 20-Minute Video Kickoff Presentation by Yours Truly – You Can Only See This at MEUG In-Person Events (Such as Seattle on Feb 10)

2) Alchemy Update – Power Writing Session at Undisclosed Location

Yes we’ve been a bit behind on the new book.  But last week I took an emergency plane trip to the MrExcel Secret Winter HQ so we could get this sucker done.

image

Time Lapse Photos of an Epic Writing Session:

7 am Breakfast:  Eggs / Sausage / Choco Chip Pancakes for Me, Mahi Sandwich for Bill (Fancy!)
4 pm Recharge:  Holy Cow, Dr. Pepper Slurpee???  YES.  And Diet Coke for Bill (Bah!)
3 am Still Going Strong:  Note Empty Coffee Mug and Slurpee cup.

Summary of Results:

  1. On Day 1 we sent 150+ pages sent to off for copy editing.  Several of those chapters are already back in Bill’s hands for the addition of his magic touch.
  2. On Day 2 we added Power View, Power Map, and Power Query to the book.  We wrote about 70 pages or so on the spot, fueled by the fine nutrition pictured above.
  3. “Early Bird” preview versions will be available THIS MONTH to students of PowerPivotPro University (which is known as “Advanced Power Pivot” over on Chandoo.org)

3) PowerPivotPro University – Sign Up to Be Notified for Feb 10 Launch

Just a follow up from last week:  we’re counting down to the 2014 re-launch:

Click here to be added to the notifications list

If you have questions or just can’t bear to wait til next week, drop us a note at training@powerpivotpro.com Smile


Power Pivot Job Opening in Baltimore Area

February 3, 2014

 
Always happy to post these Smile

Avesis is a managed care organization located outside of Baltimore, MD.  We specialize in vision, dental, and hearing plans in the government and private sectors.  Avesis covers over 7 million lives nationally. 

Recently we made the decision to utilize Microsoft BI for our dashboarding efforts.  As part of this exciting project we are looking to bring in business analysts with experience with PowerPivot and PowerView.  The more experience the better.  We are very dedicated to the idea of making our data transparent and building a smarter company.  Our project will be focused on making dashboards for our executive team and publishing them via our SharePoint 2013 farm. For additional information please contact Brad Mendelson, Senior Business Analyst at Avesis, at bmendelson@avesis.com


PowerPivotPro University Re-Opens Feb 10

January 30, 2014

Power Pivot Pro Online University

“They’re calling me the ‘go-to guy’ here at work.  All the credit goes to you.”

-C. Gilbert

All Systems Go!

Apologies for the delay.  We’ve been holding off on a broad re-launch because we wanted/needed a few things done first:

  1. All of the content is complete.  The last official lesson, Using Macros with Power Pivot, was published this past weekend.
  2. The Alchemy book is on track.  Students of the class will receive an electronic copy of Power Pivot Alchemy before it even goes to the printer.  I just got back from Bill Jelen’s secret winter hideout, where we conducted a marathon writing session.  I am now confident we will be distributing the “early bird” e-version to students during the month of February.
  3. Chandoo and I have aligned our plans.  P3 University will be offered one more time (Feb 10) in partnership with Chandoo.org, and subsequently will only be available through PowerPivotPro.

Sign up to be notified

Join the waiting list here, or use the form below to be notified when enrollments officially open:


Cleveland User Group: January 14th

January 6, 2014

Monday, January 13, 2014 from 5:30 PM to 7:00 PM (EST)

Microsoft Office — Independence, OH
6050 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 will cover the ins and outs of the CALCULATE function in Power Pivot, including:
 

  1. Why every single person reading this needs CALCULATE, and can easily learn it (much easier than VLOOKUP for instance)
  2. A brief explanation of how it works
  3. How even its simplest usage will save you massive amounts of time
  4. Why it is essentially the SUMIF function you always wished you’d had – simpler and more powerful/flexible and the same time!
  5. A “taste” of its more advanced usage – opening doors that were invisible and closed before

Reserve Your Spot Today!

Space is limited.  Click here to reserve your spot.  (Yes, the meetings are free).


Chicago User Group: January Meeting!

January 6, 2014

Wednesday, January 15, 2014 from 6:30 PM to 8:00 PM (CST)

Holiday Club
4000 North Sheridan Road
Chicago, IL 60613

Welcome to “New Excel”

Please join us for the inaugural meeting of the Chicago “New Excel” User Group.  Agenda:

1. Exclusive video intro from Rob Collie (former Microsoft engineering leader and founder of PowerPivotPro) – Why Now, What IS “New Excel,” the MASSIVE Opportunities Awaiting, and a Map to the Road Ahead.

2. Meet and greet – meet your fellow Excel professionals from the Chicago area.  You will be surprised at how “Not Alone” you are.

3. Discussion led by data and reporting expert and evangelist, Oz du Soleil – where are you on the roadmap?  What are the challenges to making progress?  What would you like to see from the group?

Revitalize your career.  Win with data.

Reserve Your Spot Today!

Space is limited.  Click here to reserve your spot.  (Yes, the meetings are free).