Two Quick Updates: University Re-Launches Monday. And Power Query is Amazing. AMAZING.

Busy Day Today!

What can I say folks.  The Power Pivot “biz” continues to gain steam (one indicator:  last week recorded the highest traffic ever to this site) and that means busy days here at PowerPivotPro HQ.

So I will keep this brief.  First a quick note about the University, then read on for Power Query!

 

PowerPivotPro University (aka “Advanced Power Pivot” on Chandoo.org) Opens Monday

Highlights, again in brevity style:

  1. Like Power Pivot itself, it is accessible to beginners but slowly builds you up into a modeling ninja.
  2. Features the same highly visual and entertaining style that you’ve come to expect from the book and here on this site.  NOT dry or technical – VERY human.
  3. Represents six full months of work by me – it’s like I’ve offered my entire brain for purchase.
  4. The first wave of students seems to have enjoyed it:

image

Click image for more feedback from the first wave of University Students

Register to be notified on Monday when enrollment re-opens

Ode to Power Query – Topic of MANY Future Posts.

image

A VERY Common Situation – You are Given a Data Table but No Lookup Tables

This happens all the time.  In fact it happened to me last night.  I was looking at “wave one” students’ progression through the University lessons, and the data I have is one big fat CSV exported from the LMS software.

Web “data sources” are just like that.  They say, “here you go, here’s your big wide CSV file.  Now we can wash our hands of the whole analysis and reporting business and dump it on you.”

And actually, I LIKE it like that.  I don’t want my various web applications fumbling around and giving me terrible analytics.  Let ME do it.

But do they EVER give me the lookup tables?  Heck no.  List of course elements?  List of Students?  Nope.  Just one big CSV Frankenfile.

Lookup tables offer SO many benefits I don’t have room to list them here.  (Covered extensively in the University of course, cough cough).

But making Lookup tables manually…  sucks.  Who wants to go through that process over and over and over?  Not me.

Power Query to the rescue!

Using Power Query to Create Lookup (aka Dimension) Tables is SUPER Easy

Remove Duplicates in Power Query – Lets You Create Lookup Tables from Data Tables
(And the Lookup Table STAYS UP TO DATE On Every Refresh!)

More on this later, but for now, go download Power Query…

Download Power Query (Free) From Microsoft

4 Responses to Two Quick Updates: University Re-Launches Monday. And Power Query is Amazing. AMAZING.

  1. Agree Power Query is simply amazing. I knew it as soon as I found the “unpivot” function. One-click “normalization” of “denormalized” data. Love it!

  2. Joe Pase says:

    Power Query and PowerView are by far my new favorites. The power of each is amazing.

  3. Art Jacobson says:

    FYI, the download link above does not work properly. I did find a proper place to download it on the Microsoft web site.

    Now for my question. Unfortunately we are still using Windows XP and XP does not appear on the MS compatibility list in the download area for Power Query. Will it work with XP and Excel 2010 (32 bit)?

  4. Rob says:

    Rob, any suggestions/posts on how to solve “PowerPivot issues” with an assist from Power Query? Seems like it would fit a few of the known problem niches….

Leave a Comment or Question