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 P3 Adaptive HQ.

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

P3 Adaptive University (aka “Advanced Power Pivot” on 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:

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.


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…

[link removed due to 404] Download Power Query (Free) From Microsoft

Read more on our blog

Get in touch with a P3 team member

  • Hidden
  • Hidden
  • This field is for validation purposes and should be left unchanged.

This field is for validation purposes and should be left unchanged.

Related Content

What Is the Microsoft Fabric Free License?

The Microsoft Fabric free license represents a significant offering regarding data management

Read the Blog

What Is New in Microsoft Fabric?

Microsoft has once again made headlines with the introduction of Microsoft Fabric,

Read the Blog

What Is the Difference Between Microsoft Fabric and Databricks?

Businesses seeking to make informed data decisions must appreciate the distinctions between

Read the Blog

Power BI Usage Metric Reporting: A Guide to Game-Changing Insights

If you build it, they will come.  That movie line doesn’t just

Read the Blog