Live Class, Online, Online U… Which is Right For You?

January 26, 2015

By Avi Singh

Few of you have inquired about the learning options now available. This may help you choose:-

  • Live In-Person Classes (Cleveland & DC): The most engaging format. Hard to replicate the energy of a live class in any other format.
  • Live Online: If you are unable to travel to an in-person class, this is a great alternative. Fully interactive and we use online chats, polls & tests to enrich the training experience
  • Online University (Recorded): 22+ hours of video! This would be equivalent to a 5+ day course but you pace yourself and can revisit topics for a full year. Greater depth and breadth than what can be covered in two days.  Often taken “standalone” or as a “supplement” to our other offerings.
  • Onsite Jumpstarts (Your Location):   We bring the class to you and your team.  For larger teams, this is more cost effective than sending everyone to the In-Person Class, plus we get to use YOUR data and biz problems as the basis of the training.  Together we build working solutions to your current problems while you learn.

    Multiple Paths All Lead to Awesome Power Smile

    A former instructor, once told me, “Every person learns in their own way”. So in the end, the choice is yours. But we encourage you, in this new year, to seize the day, grab the bull by the horns and make 2015 the year you kicked things in high gear!

    Power On!
    Avi Singh

  • Reminder: Webinar – Excel to Power Pivot Jan 20th (mini-post)

    January 19, 2015

    Folks, our Webinar: Excel to Power Pivot, is coming up today Tuesday Jan 20th (click to add to calendar). We hope to see you there. Participants would also have an opportunity to sign-up for our online class at a discounted rate.

    Here is what we would cover, see event page for more details:-

    Walkthrough key steps in using Power Pivot and explain how Power Pivot supercharges regular Excel
    Do it Yourself! We would provide you dataset and instructions to try those steps yourself at your own pace and build your first data model. Best way to learn is by doing.
    Q&A: There would be opportunity to ask questions and seek guidance regarding using or deploying Power Pivot or Power BI
    Resources to continue your journey

    Excel Power Pivot steps we would cover in our walkthrough:-

    Pull data into Power Pivot
    Build a Data Model
    Write new Measures (Formulas)
    Write time-intelligence Measures

    Subscribe to our blog to receive updates on future events.

    Power On!
    Avi Singh

    PowerPivot Live Online Class in January and New Year Resolutions

    January 12, 2015

    By Avi Singh [Twitter]

    We wish all the readers of PowerPivotPro a very happy new year. We wish that you get your groove power on this year :-). I have never been big on New Year’s resolutions. For good reason; reportedly only 8% of people achieve their New Year’s resolution. Sharing your resolution socially and publicly, is one factor that could help you get there though (check out other factors).

    So here I am, going out on a limb and saying:

    I will help a thousand people to start using Power Pivot

    That is my BHAG (Big Hairy Audacious Goal) for the year. I had a late start in 2014, but here is how many I helped last year (via training, webinar, workshops, consulting).

    Here is a geographical representation. Yes that’s an embedded Power View (view full screen); more on that in a later post.

    In order to get to this goal, we will continue existing offerings but also add some new ones:-

  • Live In-Person classes
  • Online University
  • Consulting
  • Webinars
  • *New* Live Online Class

      New! Live Online Class in January

      I am excited to offer our first live online class. Click below for details and registration.
      There are limited seats for first online class as we ramp this up.

      Read the rest of this entry »

    • Cleveland and D.C. In-Person Classes in February!

      January 8, 2015

      Post by Rob Collie

      How recent students have described the class


      One of Our 2014 Classes

      Washington D.C. Feb 24-25 and Cleveland Feb 17-18

      Washington DC Class Info

      Register for Washington DC Class!

      Cleveland OH Class Info

      Register for Cleveland OH Class!

      Optional Gathering/Dinner on “Middle” Night

      Read the rest of this entry »

      Mini-Post: Excel to Power Pivot, Webinar Jan 2015

      January 5, 2015

      by Avi Singh [Twitter]

      Pop quiz: For 2015, do you
      a) change nothing this year?
      b) Embark on a brand new path of empowered BI?

      Calling out to folks who are sitting on the Excel fence and have not dipped their toe in Power Pivot.
      Or business groups that want to explore a whole new way of doing BI, that is low cost, agile and delivers results.

      Join us for our next Webinar: Excel to Power Pivot: Cross the Gap, Tuesday Jan 20th 2015

      Click here for Webinar Details

      For many readers who have already crossed the gap, please forward this to those who need help.
      We did face some technical difficulties in our first attempt on Dec 1st, but since then have switched to using GoToMeeting – world leader in web conferencing – and it has performed superbly. Thanks for bearing with us as we experiment with this new format.

      Monday Mini-Post: Excel to Power Pivot Cross the Gap Webinar (Fri Dec 5th)

      November 24, 2014

      By Avi Singh [Twitter]

      UPDATE: We ran into technical issues with the Webinar on Dec 1st using Rescheduling to Fri Dec 5th. See event page for details. Switching to world class web conferencing this time (GoToWebinar)…um, but we are limited to 100 attendees (and a bit oversold, oops!). Join on time to make sure you get your spot – if unable to join, rest assured; you’ll get first dibs on the next one we schedule (planned in January)

      Happy Monday! We’ll be going light this week for Thanksgiving, but we have big things cooking for next week. Monday Dec 1st we are hosting our Webinar Excel to Power Pivot: Cross the Gap. Webinar is targeted towards Excel users who are new to Power Pivot.

      Most readers here are already across the gap, but do share this with others you know who might benefit. Like the guy in the next cubicle, who has the monthly Excel report that’s chock full of formulas across ten sheets and takes a week to update; and how he needs to schedule his vacation always around the weekly update because no one else can do it. Yeah, tell him his life is about to be transformed.

      Click Here to Register for Webinar

      5 common mistakes made by self taught DAX students

      October 30, 2014

      by Matt Allington

      I am well under way in my career as a PowerPivot Consultant, Trainer and Workbook Hosting Provider.  And I have to say (now that I have delivered a number of Rob’s “PowerPivot for Excel” training classes) that I am finding delivering training to be one of the most rewarding things I do.

      It occurred to me recently that people like me (and also Rob, Avi, Scott), that train users in PowerPivot are able to glean useful insights into the way people learn (and incorrectly learn) PowerPivot.  Today I am going to share with you 5 common mistakes that I have personally observed – maybe you will identify yourself in some of these things, or maybe you will confirm that you are doing just great.  Either way, it is worth a read to either discover a gap or confirm your skill.

      But first: I have trained 2 general types of students

      I have found there are 2 groups of students that sign up for my PowerPivot for Excel classes.  There are students that are very new, very green (see what I did there – green, get it?) and are using the class to get started.  They come in with very little knowledge about PowerPivot, but enough to know that this could be something awesome.  In the second group are students who have a reasonable amount of PowerPivot experience under their belt but realise there is more to it.  What is a “reasonable amount” of course can vary, but I would classify these people as “active” for 6-26 weeks with a total number of “invested hours” in the vicinity of 10 – 60 hours or so.  Often they are struggling to move forward, and this post covers the main reasons why.

      I always ask my students to rank their knowledge on a scale of 0 to 10, and they normally rank themselves 0 (newbies) or about 3 or 4.

      2 types

      Read the rest of this entry »

      Mini-Post: Getting Ready for the Seattle Class Nov 11-12

      October 29, 2014

      By Avichal Singh

      Getting amped up for our first class in Seattle! Just got the box of books from Rob, which we hand out at the class. Check out all the other goodies you would get :-)


      The Excel to Power Pivot workshops have been a blast, but the class is going to be even more fun. Just looking forward to meeting a whole bunch of cool new people as well, who are all excited about Power Pivot (we’ll get you excited, if you aren’t yet). Everyone learns in their own way, however

    • Live class is a terrific way to jumpstart your learning
    • It is amazing how much easier it is to really absorb and cement the concepts, even if you have been using Power Pivot for a while
    • It is also a great networking opportunity. Some of these folks may be your new Excel friends for life :-)

      Speaking from my personal experience here – after attending Rob’s class even with 5 year’s worth of Power Pivot experience – and I have heard the same from Rob and Matt. See you soon!

      Click Here to View Class Details & Registration

    • In-Person Power Pivot Class in Seattle, Nov 11-12 Signups Open

      October 22, 2014

      Intro by Rob:  You Will See What I Mean

      Last week I explained why Avi is the Right Guy For the Job, and mentioned that he might be a better “me” than me.

      Everyone in the Seattle area now gets a chance to see what I mean, as he will be teaching my official class there in November.  (He joins Matt Allington as the only two human beings I have certified to teach this class, other than myself, and it’s well-deserved company for both gentlemen).

      Enough from me though, I’ll let Avi take it from here.

      PowerPivotPro Comes Full Circle, Returns to Seattle


      Click for Info on the Seattle Class

      Rob started his Power Pivot journey here in Seattle as one of the founding engineers for Power Pivot. I feel honored to bring that full circle and offer the next  Power Pivot class right here in Microsoft’s backyard. I have spent past several years at Microsoft, building large scale BI systems based on Power Pivot; and training internal and external users alike. Read or watch my Power Pivot journey or read all my posts.

      Read the rest of this entry »

      Excel to Power Pivot: Cross the Gap, Change the World

      October 21, 2014

      by Avichal Singh

      Oh boy! What an intro…thanks Rob. “A better me than me”…now I would need to live up to that. Let’s get to work.

      Change the World

      What happened to ‘Cross the Gap’ you say. Well, that’s covered later. This is more important, plus we are never about doing things in the expected order (e.g. we like building BI faucets before plumbing Smile).

      #1 challenge with Power Pivot is awareness. You can generalize that for Power BI, although each component of Power BI also has it’s unique challenges (e.g. Power Query).

      #1 road block in spreading awareness is Power Pivot availability.

    • Excel 2010: Power Pivot is a free add-in
    • Excel 2013/Office 365: you need to be a maze runner Smile (see illustration below)

      Either the whole world should downgrade back to Excel 2010 or we can beseech Microsoft to do something about Excel 2013/Office 365. I tossed a coin and the latter won out. So here it is folks: Free Power Pivot!

      CALL TO ACTION: Sign yourself and recruit others to support the Petition to Microsoft to “Free Power Pivot!”. Make Power Pivot freely available in Office 2013, Office 365 (and beyond)

      Check it out, sign the petition, ask your friends, neighbors, heck even call your Grandparents.

      One clarification though, the request to Microsoft is
      - To make it “freely available
      - and not necessarily “free”, as in a free handout

      If you need more inspiration, read

    • Bill Jelen (Mr Excel)’s lament

    • Comments on the original post: “Hey, Who Moved My (PowerPivot 2013) Cheese?”

    • Scott’s comment on the petition says it all “Amazing product, amazingly hard to getRead the rest of this entry »

    • Reminder: Live Class in Philly in < 2 Weeks

      October 10, 2014

      Post by Rob Collie

      PowerPivot University - Philadelphia

      Final Reminder:  I Will Be in Philadelphia Oct 21-22, Teaching a Two-Day Class
      (at the Microsoft Facility in Malvern, specifically)

      1. More Details
      2. Blog Post on Why You Should Attend
      3. Register

      See you there!

      Aussie Aussie Aussie! Pivot Pivot Pivot!

      September 26, 2014

      Post by Rob Collie

      Just a quick reminder for our friends Down Under, make sure to catch the one and only Matt Allington at one of his upcoming classes in Adelaide, Melbourne, Brisbane, and Sydney. 

      I wouldn’t let just anyone teach my materials – Matt is one fantastic dude.  It will be fun, productive, and life changing.  I swear on the CALCULATE function.

      2-day live Power PIvot training in Australia!