Power Pivot Blitz: Webinar, Seattle Class, Online Class

February 27, 2015

By Avi Singh [Twitter]

My New Year’s resolution to help 1000 people start using Power Pivot, will not achieve itself. So we are taking the bull by the horns and announcing the training events below. Click on the links to enroll or obtain additional information.

Need help choosing? Webinar is a free event so all are welcome to join. Read this article to help you…Choose Between: Live In-Person, Live Online and other training options. 

Mar 17

Live In-Person Class
Apr 1-2

Live Online Class
Apr 6-7

PowerPivot for Excel Live Class (Seattle)

PowerPivot for Excel Online Class

More Info on Live In-Person Class

Live In-Person class includes: Thumb Drive, 50% Off Online University and other goodies!

All Students Receive a PowerPivotPro thumb drive containing the materials from the course.

Power Pivot Seattle Class: Free Thumb Drive

You also receive 50% off our online video course.  Past students have found it to be a helpful “reinforcement” to the live class (as well as covering topics that we just can’t get to in two days), so we now offer it as a bundle.

More goodies! You receive a physical copy of one of Rob Collie’s Books and digital copy of both books. Wait wait, there’s more Winking smile: you also get a laminated DAX Reference Card – which many have sworn is a life saver when solving a complex CALCULATE() puzzle.

Live In-Person Seattle Class Details & Registration

Visit Us at PASS BA CON! (Apr 20-22, Santa Clara)

February 5, 2015

Post by Rob Collie

Excel Speakers are a BIG Presence at This Year's PASS Business Analytics Conference

The “Modern Excel” Vibe is Taking Over This Year’s Speaker Lineup.
Come Hang Out With Us…  And Oh Yeah, Attend Our Sessions Smile

Getting the Band Back Together!

Holy cow folks, am I stoked!  Look at that lineup!  I’d go to this event (PASS Business Analytics Conference) just to HANG OUT with these people.  Other than the Excel MVP Summit at Microsoft HQ, you don’t ever really find this many “EXCELebrities” in one place.  (See what I did there?  I made a new word!  Let’s make it stick.)

But unlike the MVP Summit, this event is open to the public.  Come hang out with us.  And oh yeah, attend our sessions too!

Registration Discount Code

Register using the official PowerPivotPro discount code BASPROB and save $150.

Register Here and Use Code BASPROB

Full Day Pre-Conference Sessions by Rob/Avi… and Chandoo!

Read the rest of this entry »

Upcoming Webinar at PASS BA Marathon Tue Feb 3rd

February 2, 2015

By Avi Singh [Twitter]

Thanks to all those who attended our past Excel to Power Pivot webinar on January 20th. Some of the attendees also joined us later for our first ever online class. For those who missed out, keep reading to learn about our upcoming options.

First of all, it is a joy and a privilege to speak to all of you about my favorite topic – Power Pivot/Power BI. So thank you for giving me that opportunity. My favorite part was the Q&A session at the end where I got a chance to interact with all of you. At the bottom of this post you will see some of the key questions, that were asked and answers. I figured that might help all the readers of this blog.

We plan to be running these webinars every month; best way to stay informed of our upcoming events is to subscribe to our blog. We are locked onto the Citrix/GoToMeeting platform, which has performed flawlessly for our recent events. But we are looking to increase the maximum capacity, to accommodate more attendees.

There is a special opportunity, to attend our webinar on February 3, as part of the BA marathon, being conducted by the SQL PASS folks. Details as below:-

SQL PASS Business Analytics BA Marathon

Productivity Revolution in Excel By Avi Singh, Chandoo
Tue Feb 3rd 11AM PST (click to change Time Zone)
Register at PASS BA Marathon

Yes, I am collaborating with the “awesome” Chandoo for this Webinar. Gosh!

…now as promised here are the popular questions from our past webinar.

Questions from past Webinar

Some questions were asked over audio and others via the chat window. Some of these topics are meaty enough that we will follow up with full blog post and/or YouTube Video.

Read the rest of this entry »

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 (Seattle): 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. Geared towards Power Pivot beginners.
  • 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 Join.me. 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 »