The Data Stack Show - The PRQL: Back to the Basics: The Importance of Solid Reporting and Analytics

Episode Date: October 7, 2024

The Data Stack Show is a weekly podcast powered by RudderStack, the CDP for developers. Each week we’ll talk to data engineers, analysts, and data scientists about their experience around building and maintaining data infrastructure, delivering data and data products, and driving better outcomes across their businesses with data.RudderStack helps businesses make the most out of their customer data while ensuring data privacy and security. To learn more about RudderStack visit rudderstack.com.

Welcome to the Data Stack Show prequel. This is a short bonus episode where we preview the upcoming show. You'll get to meet our guest and hear about the topics we're going to cover. If they're interesting to you, you can catch the full-length show when it drops on Wednesday. Welcome back to the Data Stack Show. We have a little bit of a special episode for you today. We're recording this straight to the computer without internet because we had severe weather in the southeast,

and it's caused a pretty big mess for a lot of people in the southeast, including us here in Greenville. Our hearts go out to everyone who's been affected by this. There are lots of people without power. There are lots of people, especially in Western North Carolina, who are in danger. So definitely send your care and help out in any way that you can. So today you get John and I alone, and I got to pick the subject, which is reporting and analytics. I love talking about this, and I can't wait to hear all your thoughts because

you've done this for a long time. But when I say reporting in analytics, John, what topic do you want to most hit? Yeah, I'm excited about this topic. But first, our thoughts and prayers are with those, and especially we're in the Western North Carolina area, which is just 45 minutes from us. So if you're listening in that area, our thoughts and prayers are with you for sure. So in the reporting and analytics, that, man, that topic, it's a little bit out of vogue, I would say. Like if you look back 10 years ago, reporting analyst, fairly popular job title, data analyst. Now, like you're saying, like data engineer or data scientist or analytics engineer analytics engineer of course yeah we got yeah with dbt coalesce around the corner here analytics

engineer so i think reporting in some ways has taken a back seat from a like high level view but practically almost every business has some kind of reporting going on. Sure. Of course. And I think it's, as far as the topic reporting analytics, like that whole space, like how you run your business, like in my mind, like that is typically off of reports or some kind of reporting adjacent thing. Yep. And then you get into what I might call studies, more like engineering studies or data science type work.

That might be how you make your business better. A lot of times I think of that as more of an ad hoc type thing. We need to do, we should get into definitions for all these things. Okay. Yeah, we'll definitely get into that. I'm going to ask you to define all those. Yeah. Okay. Sorry, I interrupted you. What else? Yeah. Yeah. And that, and then I think just understanding how businesses are thinking internally about these topics where we have a different definition of roles for a lot of companies. Like we're talking analytics engineer here, but more so in the reporting and analytics, like you've got these roles like data scientists, and then you've got these practical jobs like reporting and there's just this mix up of things, you know,

like there's just this like soup of things. Yeah, I'm excited. Definitely getting into those. Okay, the things that I'm interested to pick your brain on, one, how possible is it to automate some of this stuff across business models? I think that's a really interesting topic. There are companies that have tried to do it.

So I think that would be fun. And then if we have time, I want to ask you about the culture around reporting and analytics, because so much of this is not a technical, you know, the questions are not technical. It's actually like, you know, who is using the reports? How are they using them? How are decisions made? Communication between the teams, the data team, the business teams. Yeah. Okay. We'll try to get to all of it. Let's dig in. All right. Sounds good. All right. That's a wrap for the prequel. The full length episode will drop Wednesday morning. Subscribe now so you don't miss it.