Skip to main content
Rob Collie

Rob Collie

CEO and founder of data consultancy P3 Adaptive, former Microsoft Excel/Power BI founding engineer, author of "Fair Game," and host of the Raw Data podcast.

Oct 12, 2026

3:36
So Rob, before we get started, anything you think the audience needs to know about you and, uh, what you've been up to?
3:42
I think you did a great job.
3:43
I mean, uh, I helped build the first version of Power BI at Microsoft.
3:48
Um, and so that's where I grew up essentially was, was at Microsoft.
3:52
And, um, yeah, I saw what Power BI was gonna do to the BI industry, and I wanted to be part of that.
3:59
And then so, um, you know, P3 Adaptive, um, we, we originally were called Power Pivot Pro at the time because Power BI was called Power Pivot at the time.
4:07
Um, we were the first, uh, consultancy dedicated to Power BI.

20 MINS LATER

24:19
Mm-hmm
13:12
all right.
13:14
I'm glad I broke through there.
13:15
The way I describe it is that the old way of building a business intelligence project, and I was part of this problem.
13:21
I helped build the first and older wave of business intelligence technology, and then I helped build this new wave.
13:28
So I'm sort of like...
13:30
Reformed in a way, right? Like I'm making up for past sins when I say this.
13:34
So the old way of doing a BI project was very plumbing first.

20 MINS LATER

33:28
So you embarked on this research process.
5:39
And in fact, that
5:40
was the reason why they recruited me to work, be one of the first people working on Power BI was because of my experience with the Excel crew.
5:48
Yeah, I mean, Excel is a much deeper product than, let's say, something like Word or Outlook.
5:57
Everyone looks at the Office suite.
6:00
And, you know, it's sort of just sees a row of icons, uh, as if they're all kind of the same animal and they all, they all kind of look like the same animal.
6:08
They've all got the same sort of user interface ribbons across the top and they all produce documents and they have the same file open and file save experience and all that kind of stuff.
6:19
Excel is the, is the world's not even like VBA, not even macros or the JavaScript API.

34 MINS LATER

40:19
the longer the chats go, the weirder it gets.
6:23
So if you were a leader, you were to advise a leader, um, what, what's kind of the baby steps they should be taking right now, um, or is this something that you don't start at the, uh, at the top level? Maybe like you mentioned, uh, this is a bottom-up kind of plan.
6:40
Well, I think there's two things here.
6:41
There's a-- there are, you know, there's again, like multiple altitudes at which you need to approach this stuff.
6:46
Um, [clears throat] one of them, I think the-- I, I give you an example sort of at both, at both heights, right? So like a high level example and then a, a low level.
6:56
So the, the high level example is, um, basically to understand that, um, these LLMs basically have a PhD in every topic that humanity offers PhDs in.
7:10
I mean, it, they, it just, they know so much, and they, they are so, they're so capable of reasoning through all of those things.
7:18
But they still show up at your business every day, and in every chat, they show up as a new hire.

16 MINS LATER

23:34
... that can do this for you, but for most organizations it sounds like this is a definitely a stumbling block or at least the thing that keeps the leadership up at night.
2:29
But boy, that blank page is intimidating.
2:32
Yeah, I honestly wouldn't recommend it.
2:35
I've written books before.
2:38
About 10 years ago, I wrote what was at the time the runaway number one bestseller on Power BI, the dashboards and BI product from Microsoft.
2:52
And that process was so grueling on both me and my family that I swore it off.
2:58
I said, that's it.
2:59
That's the last time I'm ever going to do that.

34 MINS LATER

37:20
but you know for people getting involved it's like the llms are very well trained to like start to understand your habits and what you like and what you don't like and make recommendations around workflows that like actually you know make a big difference
Unpivot

Unpivot

Rob Collie

Aug 8 · 1h 24m

21:28
And what's the story arc then from that founding of Power Pivot and the blog and the company to the P3 Adaptive days?
21:40
Well, the short version of it is that I was really shocked at how good PowerPivot was, even though I was one of the first few people to work on it.
21:51
I mean, Nets came and recruited me to be one of the first few to represent this Excel demographic that we're talking about in the design of this product.
22:09
I've worked on plenty of version one initiatives like this at Microsoft.
22:13
I was as familiar as anyone about the trope that Microsoft doesn't get anything right until version three, if ever.
22:22
It was a very easy mission to be excited about, but it just seems like such a reach that when I started actually using Power Pivot, I wanted to... my expectation was that it would be, it would fall short of what could be done in multidimensional, in traditional IT.
22:49
That was my expectation.

38 MINS LATER

61:14
just used fable this afternoon and half an hour i built what looks like a working version of that it's just ridiculous right just ridiculous and so that those two things that that was sort of the uh the inspiring bit out of the book for me really
12:51
I've had a few projects like that.
12:52
Yeah.
12:52
Well, I do too, right? You know? [laughs] So but I felt like what, what you're describing, Glenn, I think you're really picking up on exactly the kind of feeling I was having then, was this like, like, like, you know, these silly things, it's almost like my whole career had been building to that moment.
13:09
And, and people needed to know the things that were in my head, and I knew that other people were gonna be able to do this, that it wasn't something special about me.
13:19
It was just that I had kind of like an early glimpse.
13:22
And yeah, I am feeling that again today, and you know, this, this book that I'm, you know, releasing soon, I didn't go into this process of, of diving deep into AI so that I could write a book.
13:36
You know, it really started a little over a year ago, like really diving really super deep into AI because not...
15:59
Well, and actually, while you're talking about it, let's be sure that everybody knows the name and, and it sounds like I- we have a pretty good idea of what it's about, but maybe a little bit more details about what it's about, and uh, release date and where people can find it and all that.
12:51
I've had a few projects like that.
12:52
Yeah.
12:52
Well, I do too, right? You know? [laughs] So but I felt like what, what you're describing, Glenn, I think you're really picking up on exactly the kind of feeling I was having then, was this like, like, like, you know, these silly things, it's almost like my whole career had been building to that moment.
13:09
And, and people needed to know the things that were in my head, and I knew that other people were gonna be able to do this, that it wasn't something special about me.
13:19
It was just that I had kind of like an early glimpse.
13:22
And yeah, I am feeling that again today, and you know, this, this book that I'm, you know, releasing soon, I didn't go into this process of, of diving deep into AI so that I could write a book.
13:36
You know, it really started a little over a year ago, like really diving really super deep into AI because not...
15:59
Well, and actually, while you're talking about it, let's be sure that everybody knows the name and, and it sounds like I- we have a pretty good idea of what it's about, but maybe a little bit more details about what it's about and, uh, release date and where people can find it and all that.
16:12
I've had a few projects like that.
16:14
Yeah.
16:14
Well, I do, too, right? You know? [laughs] So, but I felt like, you know, what, what you're describing, Glenn, I think you're really picking up on exactly the kind of feeling I was having then, was this, like, like, like, you know, these silly things.
16:27
It's almost like my whole career had been building to that moment and, and people needed to know the things that were in my head.
16:35
And I knew that other people were gonna be able to do this, that there wasn't something special about me.
16:40
It was just that I had kind of, like, an early glimpse.
16:43
And yeah, I am feeling that again today, and you know, this, this book that I'm, you know, releasing soon, I didn't go into this process of, of diving deep into AI so that I could write a book.

9 MINS LATER

25:31
He's... [laughs]
40:42
Like how would an individual contributor think about going about that in a way that's productive for them in role? Like, do you have any advice for taking that leap, which feels like another step?
40:53
Yeah.
40:53
I mean, the, the what's really amazing is just how much smarter even the LLM seem to get when you give them something to go on.
41:02
Um, so the, the first example that I talk about in the book is this, the concept of what I call a handbook.
41:08
Um, so if you, if you had a new hire, uh, and one of the metaphors I use is, um, an LLM is basically something that has a, especially the frontier new LLMs, they basically have PhDs in every human subject.
41:22
Every-everything that you could get a PhD in, the LLM has that level of knowledge [chuckles] and even ability to reason to a certain extent in all of those subjects.
41:32
But it shows up every day knowing nothing about your business.

6 MINS LATER

47:26
[laughs]

We value your privacy

We use cookies to understand how you use our platform and to improve your experience. Click “Accept All” to consent, or “Decline non-essential” to opt out of non-essential cookies. Read our Privacy Policy.