1 hr 28 min
Earth's Only Hope vs. Alien Excel Invaders, w/ Ken Puls Raw Data By P3 Adaptive
-
- Business
Ken Puls is the epitome of an Excel and Power BI guru by being an incredible guide, a teacher, and "Remover of Darkness" of the secrets of these tools. Born from a fusion of Accounting and IT, Ken's mastery of Excel includes VBA programming and Power Pivot modeling, data cleansing and reshaping, and financial modeling. We highly encourage you to check out Ken's website, Excelguru.ca, if you desire to be enlightened in the ways of Excel and Power BI.
References on this episode:
Download Rob's Reference Card
Episode Timeline:
7:20 - Mr. Excel is in the house, Ken's Origin story is born from an IT and Accounting fusion, and Rob reveals some little known Excel facts 33:50 - Who will protect us from the Alien Invasion? And some scenarios that may start a fight! 1:10:45 - Microsoft 365 VS The Perpetual Version, Are Array Formulas still widely used?, and Lambda Functions 1:25:35 - Ken shares something that ties Rob to a cool add-in called Monkey Tools Episode Transcript:
Rob Collie (00:00:00):
Welcome friends. Today's guest is the famous Ken Puls. I've known Ken for over a decade through the Microsoft MVP program, but you might know him as the author of the Power Query book, M is for (Data) Monkey. Or as the driving force behind the website, excelguru.ca. It's Canada A. Or perhaps most recently as the creator of the Monkey Tools add-on for Power Pivot and Power Query.
Rob Collie (00:00:28):
A conversation that I had with Ken about 10 years ago was really the critical turning point in me deciding to write my first book. If you want to know what those conversations were, I won't spoil them, you'll just have to listen to the episode.
Rob Collie (00:00:42):
So, Ken has been a part of the landscape and certainly a part of my life and career for a very long time. If this happens to be your first time hearing of Ken, for some reason, here's the best way to describe him. Imagine the land of Power BI and the land of Excel where those two landscapes meet. There's this hazy, like demilitarized zone between the two, and Ken stalks those hills like an apex predator. Of course, whenever I describe him in terms like those, he's always really quick to remind me, "Hey, I'm actually pretty nice." And he is. He's the nicest apex predator you'll ever meet.
Rob Collie (00:01:15):
As a program note, Tom couldn't make it to this recording session, so we just subbed in Bill Jelen. What do you think about that? I took advantage of the rare opportunity of having Ken and Bill in the same place to try to resolve a very important question, which is, if the fate of the Earth hung in the balance, who would we nominate as our Excel champion to represent us? I also confronted Ken with the unwinnable Kobayashi Maru scenario of you can only pick one, Power Query or DAX. Forced him into an answer. Did he get it right? Did he get it wrong? You'll decide. So, let's get into it.
Announcer (00:01:50):
Ladies and gentlemen, may I have your attention, please.
Announcer (00:01:57):
This is the Raw Data by P3 Adaptive podcast with your host, Rob Collie. Find out what the experts at P3 Adaptive can do for your business. Just go to p3adaptive.com. Raw Data by P3 Adaptive is data with the human element.
Rob Collie (00:02:18):
Welcome to the show, Ken Puls. The long awaited Ken Puls, how are you today?
Ken Puls (00:02:23):
I'm doing well, Rob. How are you?
Rob Collie (00:02:25):
Fantastic. Fantastic. Well, I said this a few times with a few different guests, but it had been so obvious if we'd kick this podcast off and like just gone stampeding to Ken in the first few weeks. We had to kind of play it cool a little bit. Kind of like circle our way around like, "Oh, right. Yeah, Ken." As opposed to the obvious choice like from the very beginning. So, I appreciate you being patient with us. I'm sure you've been sitting there going, "When is the phone going to ring? When is it going to ring, damn it?"
Ken Puls (00:02:54):
You flatter me, Rob, ho
Ken Puls is the epitome of an Excel and Power BI guru by being an incredible guide, a teacher, and "Remover of Darkness" of the secrets of these tools. Born from a fusion of Accounting and IT, Ken's mastery of Excel includes VBA programming and Power Pivot modeling, data cleansing and reshaping, and financial modeling. We highly encourage you to check out Ken's website, Excelguru.ca, if you desire to be enlightened in the ways of Excel and Power BI.
References on this episode:
Download Rob's Reference Card
Episode Timeline:
7:20 - Mr. Excel is in the house, Ken's Origin story is born from an IT and Accounting fusion, and Rob reveals some little known Excel facts 33:50 - Who will protect us from the Alien Invasion? And some scenarios that may start a fight! 1:10:45 - Microsoft 365 VS The Perpetual Version, Are Array Formulas still widely used?, and Lambda Functions 1:25:35 - Ken shares something that ties Rob to a cool add-in called Monkey Tools Episode Transcript:
Rob Collie (00:00:00):
Welcome friends. Today's guest is the famous Ken Puls. I've known Ken for over a decade through the Microsoft MVP program, but you might know him as the author of the Power Query book, M is for (Data) Monkey. Or as the driving force behind the website, excelguru.ca. It's Canada A. Or perhaps most recently as the creator of the Monkey Tools add-on for Power Pivot and Power Query.
Rob Collie (00:00:28):
A conversation that I had with Ken about 10 years ago was really the critical turning point in me deciding to write my first book. If you want to know what those conversations were, I won't spoil them, you'll just have to listen to the episode.
Rob Collie (00:00:42):
So, Ken has been a part of the landscape and certainly a part of my life and career for a very long time. If this happens to be your first time hearing of Ken, for some reason, here's the best way to describe him. Imagine the land of Power BI and the land of Excel where those two landscapes meet. There's this hazy, like demilitarized zone between the two, and Ken stalks those hills like an apex predator. Of course, whenever I describe him in terms like those, he's always really quick to remind me, "Hey, I'm actually pretty nice." And he is. He's the nicest apex predator you'll ever meet.
Rob Collie (00:01:15):
As a program note, Tom couldn't make it to this recording session, so we just subbed in Bill Jelen. What do you think about that? I took advantage of the rare opportunity of having Ken and Bill in the same place to try to resolve a very important question, which is, if the fate of the Earth hung in the balance, who would we nominate as our Excel champion to represent us? I also confronted Ken with the unwinnable Kobayashi Maru scenario of you can only pick one, Power Query or DAX. Forced him into an answer. Did he get it right? Did he get it wrong? You'll decide. So, let's get into it.
Announcer (00:01:50):
Ladies and gentlemen, may I have your attention, please.
Announcer (00:01:57):
This is the Raw Data by P3 Adaptive podcast with your host, Rob Collie. Find out what the experts at P3 Adaptive can do for your business. Just go to p3adaptive.com. Raw Data by P3 Adaptive is data with the human element.
Rob Collie (00:02:18):
Welcome to the show, Ken Puls. The long awaited Ken Puls, how are you today?
Ken Puls (00:02:23):
I'm doing well, Rob. How are you?
Rob Collie (00:02:25):
Fantastic. Fantastic. Well, I said this a few times with a few different guests, but it had been so obvious if we'd kick this podcast off and like just gone stampeding to Ken in the first few weeks. We had to kind of play it cool a little bit. Kind of like circle our way around like, "Oh, right. Yeah, Ken." As opposed to the obvious choice like from the very beginning. So, I appreciate you being patient with us. I'm sure you've been sitting there going, "When is the phone going to ring? When is it going to ring, damn it?"
Ken Puls (00:02:54):
You flatter me, Rob, ho
1 hr 28 min