Raw Data with Rob Collie - podcast cover

Raw Data with Rob Collie

P3 Adaptivesites.libsyn.com
Raw Data with Rob Collie breaks down the complex world of AI into practical actions for modern business leaders. With co-host Justin Mannhardt and expert guests, the show uses real stories to deliver clarity and confidence to turn your data into real business value. Catering especially to mid-market leaders who know their size isn't a limitation but a competitive advantage, Raw Data cuts through the hype with straight talk from people who've actually built, deployed, and lived with these systems in high-stakes environments. Whether you're a business leader drowning in AI noise or a data practitioner ready to get off the starting line, you'll get accessible breakdowns of technology that drives actual impact, confidence-building roadmaps for modernizing data analytics, and practical wins you can apply immediately. This isn't theoretical frameworks or jargon wallpaper; it's honest guidance from leaders who've been in your shoes and figured out what actually works, so you can too.
Last refreshed:
Follow this podcast in the Metacast mobile app to refresh it and see new episodes.
Download Metacast podcast app
Podcasts are better in Metacast mobile app
Don't just listen to podcasts. Learn from them with transcripts, summaries, and chapters for every episode. Skim, search, and bookmark insights. Learn more

Episodes

Rob's New Book on AI (and Why He's Writing It)

This week's episode breaks the usual format, and that's the point. Instead of a guest or a debate, Rob does something he hasn't done publicly in a long time. He reads the foreword to a book he's actively writing. The first one since 2015. Back then, his books helped define how people learned Power BI. For a few years, he was literally the guy who wrote the book. Then he stopped. No updates. No sequels. An entire generation of practitioners came up without ever encountering his work. So why retur...

Jan 20, 202614 min

Is AI "Vibe Coding" the Next VBA?

Those Excel macros running your business were never meant to be permanent. Someone in accounting built them because the company needed custom software and didn't have the budget or patience for a two-year IT project. IT hates them. You know they're fragile. But they work. And compared to expensive software that never quite fits, working counts for a lot. In this episode, Rob and Justin dig into what might finally replace that world. Not in theory, but in practice. Over the next four years, is th...

Jan 13, 202626 min

Democratized Data Science, Custom Software is the Future, and the Data Gene Rides Again

Every week brings a new AI model, a new benchmark, and a new reason to believe everything just changed. But for most companies, none of that matters if the people closest to the work can't use these tools to build something real. In this episode, Rob and Justin walk through what democratized data science really looks like. Not dashboards. Not prompts. Actual analysis and custom software built around a specific problem, driven by someone who knows the data well enough to challenge the answers. Th...

Jan 06, 202626 min

The Apparent Meaninglessness of AI Benchmarks, plus How to Explain AI Opportunities to Others

Every week brings a new AI benchmark. Higher scores. Bigger claims. Louder voices insisting this changes everything. And yet, when you put AI in front of a real business problem, none of that noise seems to help. In this episode, Rob and Justin dig into why AI benchmarks often feel strangely meaningless in practice and why that disconnect is the point. Benchmarks aren't useless. They're just answering a different question than the one most businesses are asking. This isn't just random conjecture...

Dec 16, 202534 min

The Power BI Fundamentals Behind Expert Development *and* AI Simplicity, w/ Microsoft's Rui Romano

Everyone keeps asking whether AI kills Power BI or makes it stronger. Rui Romano flips that entire question on its head. As the Microsoft PM behind PBIP, TMDL, and all the file format work that rebuilt Power BI's foundation, he explains how the platform accidentally became one of the most AI-ready systems in analytics - and it wasn't by accident, not really. His team was solving problems for real developers who were tired of unsupported workarounds and offshore relay races. They weren't training...

Dec 09, 20251 hr 31 min

Why We Should Stop Paying Attention to the % of AI Projects which Fail (and Instead Learn Why the Others Succeed)

This episode starts with a familiar scene. A role opens, the applications pour in, and suddenly you're staring at a mountain of resumes that deserve real attention but arrive faster than anyone can process. The mix had everything… experienced candidates, newcomers trying to break in, and a growing stack of AI-generated submissions that looked sharp until you asked a second question. That's where Haystack came in. Instead of using AI as a blunt filter, Rob and the team treated it like a collabora...

Dec 02, 202537 min

Cat Negotiations, Dishonest Chatbots, AI vs AI in the Job Market, and More Real World AI Use Cases

Rob finally cracked his years long standoff with the podcast lair cat, and the fix was hilariously simple. That small victory ends up setting the tone for the whole episode, because everything that follows has the same energy: real problems that only make sense once you shrink the solution down. As Rob talks through the cat truce, Justin brings in a different kind of chaos. A customer service bot that sounded fully in command yet never actually did the thing it said it did. Pair that with a hiri...

Nov 18, 202545 min

Customizing AI for Your Business is Crucial But It Isn't Hard

Everyone's talking about AI like it's plug-and-play. Spoiler: it's not. In this episode, Rob digs into why Big Tech's billions in AI R&D haven't yet turned into matching revenue — and what that means for the rest of us. The truth? The real business wins don't come from off-the-shelf models; they come from smart customization. Rob breaks down the "magic Lego brick" approach that separates hype from practical reality, showing how everyday tools like Power BI and Power Automate can connect to A...

Nov 12, 202513 min

Is AI a Bubble?

When the bubble pops, what's left standing? Everyone's calling AI a bubble — and yeah, there's some wild stuff happening behind the scenes. Billions changing hands between the same few tech giants. Investments that look more like circular loans than innovation. But what if the real bubble isn't AI at all? Rob breaks down what's really inflating, what's not, and why your business shouldn't lose sleep over it. The headlines may sound like the sky's falling, but the tools driving real results aren'...

Nov 04, 202510 min

Getting Specific with AI via Categories: Chat, Headless, and Embedded

Everyone's talking about AI. Almost no one's getting specific. And that's the problem. Rob and Justin break down the three categories that matter: chat agents you talk to, embedded assistants baked into your workflows, and headless systems running quietly in the background doing the grunt work nobody wants to do. This isn't theory. This is how AI is finally working for real companies. They walk through Vendor Bot, Scheduler Bot, and Budget Bot — small, focused tools that do one thing exceptional...

Oct 28, 202536 min

AI Agents for the Manufacturing Industry, w/ Interpak CFO Bill Krolicki

AI without the committee: Most manufacturers are still holding meetings about AI. Bill Krolicki just built it. As CFO of Interpak, he didn't wait for a strategy deck or a vendor pilot—he wired Power BI and Power Automate into a self-running operation. His bots read supplier emails, catch late shipments before they blow up production, and update the ERP while everyone else is still asking who owns the spreadsheet. Rob Collie and Justin Mannhardt sit down with Bill to talk about what happens when ...

Oct 22, 20251 hr 16 min

AI is "Just" a New Faucet, plus the Value of Getting Specific

Last week we got a facelift—new name, new look, same deep data dives. This week? We prove the rebrand wasn't just cosmetic. Rob kicks things off with a time machine moment: his first gig at Microsoft in the '90s, building the Windows Installer. The running joke back then? "Installing yesterday's apps tomorrow." Cut to 2025, and that exact same code shows up while he's configuring an AI tool for data modeling. Build something right, and it really sticks around. And that's the bridge, AI context m...

Oct 14, 202535 min

YOU are the AI Cavalry

Everyone's talking like AI is coming for your job. Rob's here to tell you it's coming for your skill set. If you already think in tables, models, and relationships, congratulations—you're built for what's next. This episode is part pep talk, part reality check, and all proof that data people aren't getting replaced. We're getting promoted. Rob takes you inside Microsoft's campus and out into the real world, where big firms are burning millions on AI theater while mid-market teams quietly pull ah...

Oct 07, 202515 min

Can AI Go Straight from Requirements to Power BI Models?

Nobody loves requirements docs. They're the corporate equivalent of writing a novel just so someone can skim the back cover. The real question is whether you can ditch all that and go straight from "here's what I need" to a working Power BI model. In this episode, Rob and Justin push AI into that role and see what breaks, what builds, and what actually saves you time. Turns out, the magic isn't in making AI look impressive on a demo slide. It's in whether it can wire up tables, relationships, an...

Sep 30, 202541 min

AI Isn't Magic - It's Middleware (And That's Good News)

Large language models aren't magic. They're pivot tables for words. That's the real breakthrough — not a crystal ball, not a robot overlord, but a new way to roll up all the noise in your business into something you can actually use. And that's why AI belongs in the middle layer. Just like BI gave you visibility across systems, AI is becoming the connective tissue for all the unstructured stuff that never fit neatly in a database. Sure, every product is rushing to bolt on "AI features," but thos...

Sep 23, 202535 min

What Exactly IS an AI Agent? We Propose a Friendly, Non-Gatekeeping Definition

This isn't another AI think-piece, it's a full-on data brawl. Copilot is out here plagiarizing Rob's pivot table crusade while the self-appointed nerd police try to lock down the definition of agentic AI. Meanwhile, thirty years of fantasy football become the unexpected proof that tuning beats buzzwords every single time. What starts as a slip from Copilot turns into a bigger story about how AI really works. Off-the-shelf tools can sound impressive, but they collapse into clichés when they're no...

Sep 09, 202541 min

Is CoPilot the End of Filters? (Plus a Cautionary Tale)

Pivot tables finally auto-refresh. Humanity wins, but our host Rob Collie is still annoyed. Why? Because he asked for it back in 2007 and got shot down. That little gripe kicks off a bigger conversation: what else in data is overdue for a shake-up? Copilot might be next. Forget filters. Forget dashboards. Rob put it to the test on his beer-league hockey stats and found himself asking questions faster than any report could keep up. It felt natural, almost too natural. Then came the twist. Copilot...

Sep 03, 202547 min

The "Steal My Money" Lever: A Timely Tale of Data Saving the Day

Every campaign has it: that shiny "more reach, lower cost" lever that looks like marketing gold but really just siphons your budget into digital quicksand. We pulled it. The metrics looked fantastic. And that's exactly how we knew we'd been had. In this episode, Rob breaks down a real-world lesson in false signals, phantom clicks, and why data discipline isn't just consultant-speak—it's your financial survival strategy. We're talking about the bots that sneak in through "partner sites," how they...

Aug 26, 202514 min

Even in the AI Era, Communication is the Central Theme

AI is rewriting the rules of analytics. Copilot can pull answers straight from your semantic model and bypass the dashboard entirely. But for all the tech fireworks, the same old truth holds: communication is still the hardest part. Stakeholders don't always know what they want, builders don't always know how to translate it, and requirements docs have never fixed that gap. Copilot just puts the tension in sharper focus. Rob and Justin dig into why vanishing chat histories aren't just inconvenie...

Aug 19, 202532 min

Episode 200: The Road Ahead for Data and AI

Two hundred episodes in, and we're done with the warm-up! Episode 200 finds Rob flying solo and pulling zero punches on the question everyone's quietly asking: what's the future of data work? No anniversary nostalgia here, just uncomfortable truths about AI bootcamps at Starbucks, semantic models going naked, and why being "pretty good" at anything is about to get very complicated. If you think you know where this is all headed, think again. Rob spent yesterday turning a non-techie real estate a...

Aug 12, 202528 min

The "Dobie Moment" (The Awesome Power of AI/CoPilot Frontends - AND a Cautionary Tale)

Most of us have been in the trenches long enough to know when something's about to flip the script. And brother, we're standing at the edge of a cliff most data folks don't even see coming. Rob Collie thought he had Power BI figured out. Then Copilot did something impossible; it cracked a question that should've left it scratching its digital head. But it didn't just answer. It nailed it. That's what we're calling the Dobie Moment—when AI stops being a fancy calculator and starts being genuinely...

Aug 05, 202529 min

The Million-Token Myth and the Magic of Digital Colleagues

AI looks unstoppable… until you hand it a hundred pages of meeting notes. Rob and Justin dig into why context windows and token limits quietly run the show. That "million-token" brag from Google? More like weighing the Titanic in bananas. From Shakespeare to SharePoint, this episode shows why AI remembers the Roman Empire better than your company history—and why that's not a bad thing. Rob also introduces Griff, a digital colleague that fires off P3-flavored ideas like it's had three espressos. ...

Jul 29, 202529 min

Semantic Models Give You (and Microsoft) the AI Upper Hand - Plus a History Lesson on Why Frontends Matter

Back in 2010, Tableau beat smarter tools with a better demo. No brain, all charm and the market loved it. Fast-forward to now: same playbook, new costume. The AI dashboard crowd is selling "natural language BI" with zero semantic model, zero memory, and a whole lot of LinkedIn swagger. In this episode, Rob and Justin revisit why Tableau's empty-calorie approach won the first round, and how that same mistake is about to flood the AI + BI space all over again. Turns out, you can still sell snake o...

Jul 22, 202542 min

Everything's Real, Everything Matters, and Everyone Knows It w/ Quadrant Concrete CFO Joseph Graziano

Let's say your business runs on sun, sweat, and schedule precision. You've got crews in the field, materials that don't wait, and about 90 minutes to get it right before the product turns into a thousand-pound paperweight. That's the world Joseph Graziano lives in. He's the CFO of Quadrant Concrete and also the guy keeping the trucks moving, the forecasts dialed in, and the safety records spotless. Because in the mid-market, you don't get extra people. You get extra resourceful. Joseph shares ho...

Jul 15, 20251 hr 6 min

It's Time to Start Giving Power BI CoPilot a Serious Look (For End User Interaction)

It started as a side project. Rob Collie built a Power BI model for his rec league hockey team. Just for fun. Just to see what the data could say. But something weird happened. The dashboards were solid. The data model was solid. But, the users still had questions. And lots of them. And that's when it clicked: people don't think in slicers. They think in questions. Natural ones. The kind dashboards rarely anticipate. In this episode, Rob and Justin Mannhardt didn't just talk about Microsoft's Co...

Jun 24, 202525 min

Connecting AI to Your Company's Internal Information

AI wants your data, but it can't handle the truth . . . "We'll just plug our data into ChatGPT." Sure. Sounds easy. Rob thought so too, right up until he hit token limits, had to install Python, and discovered that even two megabytes of transcripts was too much for the world's smartest models to handle. In this episode, Rob and Justin break down what happens when you try to use AI on your company's internal data. Spoiler: it's a lot more complicated than the vendors make it sound. From semantic ...

Jun 10, 202544 min

An Inflection Point in AI? Understanding MCP and Multi-Agent

For a while, you could pretend AI was still a someday problem. Not anymore. Rob Collie and Justin Mannhardt are back, and this time they are tackling Model-Context-Protocol (MCP) and Multi-Agent Systems, two shifts that could finally put an end to the human copy-paste Olympics. This isn't about shinier tools. It is about AI that plugs in without the duct tape and starts doing the work without making you babysit. Rob and Justin dig into what's real, what's coming, and why "waiting to see" is no l...

Jun 03, 202525 min

Confessions of a Data Gener w/ Sakiko Stickley

Sakiko Stickley joins Raw Data to share a story that is part inspiration, part revelation, and a whole lot of truth-telling. From the first moment she discovered Power Pivot, Sakiko did not just learn data. She lived it. She rewired reporting systems, survived micromanagers, and navigated the strange realities of big consulting firms, all while quietly proving that one person, one model, and a little bit of DAX can change everything. In this episode, we get an inside look at how a passion for sm...

May 13, 20251 hr 2 min

The Biggest Improvements Announced at FabCon, and the Ever-Widening Gap Between Adoption and Capabilities

What's the value of a long-awaited feature? Well, that depends. Have you ever tried explaining a fiscal calendar that doesn't believe in months? This week, Rob Collie and Justin Mannhardt dive into the latest Microsoft Fabric updates, including the long-rumored, almost-mythical custom calendar support in DAX, the highly requested user-defined functions, and the Copilot expansion that might finally be worth the hype. These updates aren't just bells and whistles; they're fixes to problems that hav...

Apr 22, 202528 min

Data, Data, and Metadata: Letting ChatGPT Interpret Power BI Output

What happens when you hand off your Power BI output to ChatGPT and ask it to make sense of your world? You might be surprised. This week, Rob shares a deeply personal use case. One that ties together two major themes we've been exploring: Gen AI is reshaping the way we think about dashboards. To get real value out of AI, you need more than just data. You need metadata. And yes, that kind of metadata—the kind you create in Power BI when you translate raw data into something meaningful. Along the ...

Mar 25, 202516 min
Hosted on Libsyn
For the best experience, listen in Metacast app for iOS or Android