The Analytics Power Hour · 2026-02-17 · 1h 3m
Key moments - from our scoring
Substance score
63 / 100
Five dimensions, 20 points each
Data and analytics teams regularly perform critical work that goes unrecognized in job descriptions: administrative coordination, ensuring metric alignment across departments, validating poorly documented external reports, educating stakeholders on data complexity, and managing major data architecture cleanups. Michael Helbling, Moe Kiss, Tim Wilson, and Val Kroll dig into the nuances of what counts as 'shadow work' - distinguishing between necessary accountability follow-through (tracking whether recommendations get implemented) and wasteful busywork (chasing people to fill spreadsheets). The hosts discuss how data practitioners often find themselves managing implementation projects, acting as therapists for frustrated stakeholders, and spending months rebuilding data warehouses before they can deliver any business insights. They emphasize that much of this work - alignment, culture-building, data fluency education - is genuinely valuable but invisible, making it hard to justify the time investment to leadership. The conversation touches on real scenarios: reverse-engineering external agency reports, explaining GA4 and LTV calculations, managing backend developer misconceptions about data requirements, and inheriting messy data infrastructure from previous teams.
Admin work is busywork like heckling people to fill out spreadsheets; legitimate accountability tracking is setting reminders to follow up on whether stakeholders actually implemented the recommended actions you provided.
Tim Wilson notes that replicating externally-sourced reports to validate them before carrying the work forward often puts analysts 'back in the locker room' when they should be at the starting line, consuming significant unbudgeted time.
These projects are time-intensive, unlock value only months later, and don't deliver immediate business results, making them much harder to sell internally than analyses promising near-term revenue impact.
Developers typically believe raw data feeds can just be pumped into data stores and queried via SQL without understanding deduplication, sessionization, and the messy nature of web analytics data schemas.
No - AI cannot overcome fundamentally broken data architecture; you need the right underlying data structure in place first for AI solutions to work effectively.
Our reviewer’s read on each dimension, with quotes from the episode.
The episode provides solid, practitioner-grounded observations about shadow work in analytics (admin tasks, data quality issues, alignment work, stakeholder management), but much of the discussion rehashes familiar pain points rather than surfacing novel frameworks or counterintuitive insights. The value lies in articulation and normalization of common experiences rather than discovery of new concepts.
not all shadow work is shit. Some shadow work is actually very valuable. It's just the fact that the business doesn't understand like how consuming it is or how important it is.
The shadow work is building trust, building the relationship, walking them at the appropriate pace through why a diff and diff is not appropriate in this situation.
The framing of invisible/undervalued analytics work as 'shadow work' is metaphorically apt but not novel, and the episode largely applies this lens to catalog common frustrations (data quality, admin tasks, alignment, stakeholder education) that have been discussed in analytics communities for years. The analysis lacks contrarian takes or first-principles rethinking of the work itself.
Maybe some days you feel more like a janitor cleaning up ugly data or a therapist listening to stakeholders' frustrations or some sort of data marketer just trying to sell your wares internally.
It's not doing anything but setting up a potential for a future as opposed to delivering a business result.
The hosts are credible, senior practitioners with real experience (multiple have led teams, consulted, run analytics operations), and they speak from concrete examples rather than theory. However, they are primarily podcast regulars rather than external guests, limiting fresh external perspectives. The conversation benefits from their depth but lacks the caliber of a major operator or category creator being brought on.
I co-created a consultancy that is geared a lot more around trying to get multiple parties on the same page, so that the analytics work or the experimentation work can be productive and successful
I worked at the American Medical Association, we were working off of the free version of GA at the time
The episode includes specific company examples (American Medical Association, UBS, Adobe Analytics implementations, media agency data feeds) and concrete technical pain points (GA sampling, sessionization, data warehouse inheritance), but few hard numbers, metrics, or quantified outcomes. Most examples are anecdotal illustrations rather than evidence-backed case studies with timelines or business impact.
I remember it like there was some, some backend developers were like, Oh, perfect. Now we can just, you can just give us all of your GA data every night and we'll just throw it into the membership cube.
Pull GA4, then export to Excel, write SQL for BigQuery, find my LTV formula. I don't know, let's say about three hours in a couple of existential crises.
The hosts ask probing follow-up questions and show willingness to press on nuance (e.g., Tim pushing back on whether analysts 'should' do all this work; Michael asking about visibility/recognition; Val offering a counterpoint on whether data fluency is shadow work at all). However, the conversation often becomes meandering agreement between colleagues, with few hard disagreements or sharp pivots that force new thinking. The pacing is conversational but occasionally loses thread.
Tim, when someone asks, which channel has the highest ROI adjusted for LTV, how long does that take you?
I don't think that's admin though. What's the word? That's checking back to be like, if we said there was going to be some outcome, did we achieve that outcome?
Computed from the transcript - who did the talking, and the words that came up most.
We know what the work of the data practitioner is, right? It's everything from managing data ingestion to data governance to report development to experimental design to basic and advanced analytics. It's writing (or vibe-writing?) SQL or Python or R while also being adept at whatever data stack - no matter how modern - is at hand. Of course, it's a lot more, too! And that's the topic of this episode: the unofficial, often unheralded, but often quite important "shadow work" of the analyst - the myriad tasks required to effectively glue together all the data work that occurs out in broad daylight to enable the data to truly be useful at driving the business forward. For complete show notes, including links to items mentioned in this episode and a transcript of the show, visit the show page .
Transcribed and scored by The B2B Podcast Index.
[Announcer]: Welcome to the Analytics Power Hour. [Announcer]: Analytics topics covered conversationally and sometimes with explicit language. [Michael Helbling]: Hey everybody, welcome to the Analytics Power Hour. [Michael Helbling]: This is episode 291.
[Michael Helbling]: Who knows what evil lurks in the heart of men? [Michael Helbling]: The Shadow knows. [Michael Helbling]: Moest of our listeners probably don't know that callback to the extremely famous radio drama The Shadow, but what they probably will recognize is the work that data and analytics people do that lurks in the shadows of our day to day. [Michael Helbling]: That's not really the job description.
[Michael Helbling]: It usually doesn't get recognized, but you do it anyway. [Michael Helbling]: Maybe some days you feel more like a janitor cleaning up ugly data or a therapist listening to stakeholders' frustrations or some sort of data marketer just trying to sell your wares internally. [Michael Helbling]: I think we should talk about it. [Michael Helbling]: Let me introduce my co-hosts.
[Michael Helbling]: Moee Kisss. [Michael Helbling]: How you going? [Moe Kiss]: I'm going great. [Moe Kiss]: Thanks for checking in.
[Michael Helbling]: Have you ever heard of The Shadow? [Michael Helbling]: The radio show, The Shadow? [Moe Kiss]: It was like from the early... No, but I'm deeply familiar with the sentiment.
[Michael Helbling]: Oh, okay. [Michael Helbling]: Yeah, yeah. [Michael Helbling]: And Val Kroll, welcome. [Michael Helbling]: Thank you.
[Michael Helbling]: Bye, everyone. [Michael Helbling]: Go Bears. [Michael Helbling]: Yeah. [Michael Helbling]: And...
[Michael Helbling]: Hey, it was close. [Michael Helbling]: Tim Wilson, probably the only person that got. [Michael Helbling]: I remember sitting around. [Michael Helbling]: I was going to ask you if you remember.
[Michael Helbling]: [Michael Helbling]: [Michael Helbling]: [Tim Wilson]: [Tim Wilson]: [Tim Wilson]: [Michael Helbling]: [Michael Helbling]: [Michael Helbling]: [Michael Helbling]: [Michael Helbling]: [Michael Helbling]: [Michael Helbling]: [Michael Helbling]: [Michael Helbling]: [Michael Helbling]: [Michael Helbling]: [Michael Helbling]: [Michael Helbling]: I was going [Michael Helbling]: I think first up, maybe let's talk about what kinds of shadow work have you found yourself getting into in your career?
[Michael Helbling]: Like what are some of the categories or the types of things you've gotten into? [Michael Helbling]: And then as we sort of get into that discussion, maybe figure out if we thought it was necessary or not or whether it was good or not. [Michael Helbling]: So who wants to start us off with some of the stuff you've run into? [Moe Kiss]: Oh, I mean, the one that starts with a capital A, admin.
[Moe Kiss]: And I think this is potentially more on the internal side. [Moe Kiss]: I'm going to be curious to hear reflections. [Moe Kiss]: But I feel like there ends up being a lot of cadences in a business. [Moe Kiss]: And I think I've gotten to a point now where I kind of see it.
[Moe Kiss]: And I'm like, if as a data team, you start to pick up, I don't know if admin's the right word or project management or heckling people to be like, you need to fill out this spreadsheet. [Moe Kiss]: Have you done this bit of this deck? [Moe Kiss]: All of that. [Moe Kiss]: And some people might think that that's fair.
[Moe Kiss]: But in a space where you have admin support and folks who are meant to have that as part of their role, [Moe Kiss]: feel like I see data, people end up having to fill that gap a lot just to keep momentum moving forward. [Moe Kiss]: And it's almost like once you assume responsibility for it, it's almost impossible to ever roll it back. [Tim Wilson]: I've thought, I mean, there's one specific part of that. [Tim Wilson]: There's like the input, I need to do admin to get stuff.
[Tim Wilson]: And then when you first said admin, I was thinking like, [Tim Wilson]: user governance, like, oh, somebody needs access to whatever. [Tim Wilson]: I feel like there's an admin part that I think is good for the analyst when [Tim Wilson]: An analysis is delivered or something is delivered that is supposed to lead to a decision and an action that for a long time, I've felt that the analyst does kind of need to own that because it's pretty easy for somebody to say, yeah, that's awesome, but they don't really necessarily have an incentive, direct incentive to take the action as was prescribed.
[Tim Wilson]: as an accountability mechanism for the analysts to say, oh, I'm going to be here because I know how to set recurring reminders. [Tim Wilson]: I'm going to set a reminder to come back and say, hey, you said that was great. [Tim Wilson]: In the next release, you were going to do X or Y. Did you do it?
[Tim Wilson]: I don't think that's admin though. [Moe Kiss]: That's not admin. [Moe Kiss]: What's the word? [Moe Kiss]: That's checking back to be like, if we said there was going to be some outcome, did we achieve that outcome?
[Moe Kiss]: I would see that almost as being accountable for measurement and making sure that we hit the success bar and making sure that other people in the business are accountable. [Moe Kiss]: I think it's more when you're like, [Moe Kiss]: I know, Tim, you're going to have strong views on this. [Moe Kiss]: But when you think of monthly reports and cadences like that, and it ends up being about getting people to fill out their section, not, hey, I'm doing the data bit and I'm going to partner with my stakeholder on the commentary or whatever it is, it's like heckling and following up people and making sure people have done their bit.
[Moe Kiss]: because ultimately like a data person might be responsible for making sure the reports are not or whatever. [Moe Kiss]: I think there's a difference between like ownership and making sure you're accountable and like [Moe Kiss]: Following up people to make sure they do their job. [Moe Kiss]: Oh, this is going to be like a trigger point, Tim. [Michael Helbling]: Well, it's interesting because I've definitely found in my career mode where we would go to the business and we would have like a recommendation or insight from the data, which was all part of our job.
[Michael Helbling]: A couple weeks later, we'd be in a meeting with the IT department to explain what we wanted to change on the website as a result of that. [Michael Helbling]: We're riding shotgun with the project now. [Michael Helbling]: It's like, wait a second, when do we stop doing the analysis and start being the project managers for the implementation of this? [Michael Helbling]: That was when I was like, wait a second, what job do I actually have here?
[Michael Helbling]: Because you're kind of like, I'm not now not doing data analytics. [Michael Helbling]: I'm now running sort of like an integration task force, if you will. [Michael Helbling]: So I don't know if that's more like in the line of what you're talking about. [Moe Kiss]: It's such a fine line though, right?
[Michael Helbling]: Because if you want to see your insight go live, you know, yeah. [Moe Kiss]: And it's something that I do worry sometimes like data folks are like, here, I've got a recommendation. [Moe Kiss]: I'm going to throw it over the fence. [Moe Kiss]: It's your choice if you do it.
[Moe Kiss]: And like not taking ownership. [Moe Kiss]: I think part of being a strategic partner is taking ownership and being like, I've made this recommendation. [Moe Kiss]: We've agreed on it. [Moe Kiss]: I like, I want to see it forward.
[Moe Kiss]: And I'm, I'm part of this. [Moe Kiss]: I'm accountable to it too, because I've made this recommendation. [Moe Kiss]: So it is such a fine line between picking up too much of the behind the scenes stuff and what you actually need to do to like see the project or recommendation move forward from a business perspective. [Tim Wilson]: Some of it gets down to just recognizing that if it's kind of Michael, to your example, it's when everybody agrees that should happen.
[Tim Wilson]: I mean, that's kind of like business 101. [Tim Wilson]: If it's like, well, everybody agrees, but no one actually assigned, there was no ownership assigned. [Tim Wilson]: If you can do that in the moment, then a lot of times it's like, well, who should be doing this? [Tim Wilson]: If I wait and we haven't got it, then it shouldn't be the analyst.
[Tim Wilson]: But if everybody leaves and the analyst is saying, well, nobody's gonna do it unless I step up and do it, [Tim Wilson]: That's a little bit of a shame on the organization, shame on the analyst, but there is that part of like the full life cycle is, does need to go all the way through. [Tim Wilson]: So what is the next milestone? [Tim Wilson]: Who's going to do what by when? [Tim Wilson]: And then looking at that person and being like, are they going to do it or is somebody going to need to babysit them?
[Tim Wilson]: Which isn't, I mean, that's kind of a reality of business as much as the analyst role, I guess. [Val Kroll]: As you were talking through the admin stuff, Moe, I think the consultancy equivalent of some of the admin work is, can you send me that thing that you told me you were going to send me? [Val Kroll]: Can you send me that thing? [Val Kroll]: Or can I have access to that?
[Val Kroll]: Especially if it's like I need one of your other partners or other agencies to send me or give me access to something. [Val Kroll]: The number of times, like, top of a call, like, okay, moving around a lot. [Val Kroll]: Did you get approval for that one thing? [Val Kroll]: Are we good to move forward with that thing?
[Val Kroll]: Which is, like, a lot less connected to meaningful stuff. [Michael Helbling]: Explaining another agency's data analytics to the client. [Michael Helbling]: That's some shadow work right there. [Michael Helbling]: I'll even just say, listen, I don't think you want to pay me to explain this to you, so let's find a different way to do it.
[Michael Helbling]: Not that I don't want to help you, but [Michael Helbling]: I've had many experiences where they're like, okay, we got this from this. [Michael Helbling]: Maybe it's a different agency that runs a specific program for them, like media or SEO or something, and they're pulling their own reports. [Michael Helbling]: They're like, how did they get these numbers? [Michael Helbling]: And I'm like, okay, so now you need me to go reverse engineer how they pulled these numbers together.
[Michael Helbling]: And it's like, oh boy. [Tim Wilson]: That's not a bad part of shadow work, getting poorly documented, regardless of where it comes from. [Tim Wilson]: Somebody wants me to take it forward. [Tim Wilson]: The first thing I have to do is basically replicate what was done so that I know what I'm carrying forward, which is just not...
Some of that can be addressed by documentation, but that's like this. [Tim Wilson]: There can be this expectation like, well, here's the number and it links to this dashboard so surely you know everything you need to know. [Tim Wilson]: You're at the starting line. [Tim Wilson]: It's like, well, no, no, I'm still actually back in the locker room trying to get ready to come out to the starting line.
[Michael Helbling]: That's a good point. [Michael Helbling]: And getting coordinated so that everyone's kind of using the same data and everyone trusts the data that's being presented, whether it's internal or external, goes to that sort of like, that work in preparation I think is very much a part of what I consider like a data and analytics role to be doing. [Michael Helbling]: But sometimes it falls in your lap in a weird way, maybe. [Moe Kiss]: Okay.
[Moe Kiss]: And I think the thing that comes to mind is the word alignment. [Moe Kiss]: So like not all shadow work is shit. [Moe Kiss]: Some shadow work is actually very valuable. [Moe Kiss]: It's just the fact that the business doesn't understand like how consuming it is or how important it is.
[Moe Kiss]: And alignment I think is one of those things where it really is often about like this business unit thinks this or this client thinks this and this area thinks this and like making sure that everyone is speaking the same language, whether it's about [Moe Kiss]: the metric definition, whether it's about the outcome of the work or like that alignment pace, I think is incredibly important. [Moe Kiss]: But I don't think it's always something that the business understands that it's such a big part of a data practitioners role.
[Tim Wilson]: I second that. [Tim Wilson]: I mean, I think even the alignment, what is it we ran this campaign? [Tim Wilson]: What was it supposed to do? [Tim Wilson]: And then the fact that the analysts are like, well, I need to be in the meeting up front like that.
[Tim Wilson]: We need to make sure everybody's on the same page of what we're trying to accomplish. [Tim Wilson]: It's not run it. [Tim Wilson]: And then the analyst gets involved because the data now exists so they can pull it and they can provide the answers. [Tim Wilson]: that upfront, which I mean, some would say I co-created a consultancy that is geared a lot more around trying to get multiple parties on the same page, so that the analytics work or the experimentation work can be productive and successful is a huge part.
[Val Kroll]: I'll third that motion on sometimes the shadow work is really important to move forward when we first started talking about this topic, the first thing that came up for me and granted I do have very much of a recency experimentation bend. [Val Kroll]: is the culture of experimentation work, how that's become more prominent, especially on LinkedIn in the zeitgeist about how to be successful with experimentation. [Val Kroll]: But if you think how many other roles around a business have to make space for everything that they're supposed to be doing after the job description was approved and you were hired.
[Val Kroll]: It really is all about like building consensus and getting people excited and a little dose of education, a little dose of this is why you should care about what I do kind of a stuff. [Tim Wilson]: And I feel like sometimes that's a little... The culture of finance, the culture of accounting. [Tim Wilson]: Famous.
[Val Kroll]: Famous for going around to get people on board. [Val Kroll]: Well, maybe during budgeting season, but just to go back to the point that it's not that it's not important, but it's usually not the first thing you think of when you're like, oh yeah, I lead an experimentation team inside of an organization. [Val Kroll]: It's not that it's not important, but it's usually not the first thing that comes to mind. [Tim Wilson]: It does seem like maybe to bridge from that to explaining the realities of the data, which kind of takes two angles.
[Tim Wilson]: there's always going to be a presumption that the data is cleaner, more accessible, less ambiguous, which is like, no, our data is a company. [Tim Wilson]: It is always wildly more complicated than any kind of new person to it thinks it is. [Tim Wilson]: And then there's the other part of that that is what the data can and can't deliver. [Tim Wilson]: Like the data is the objective truth.
[Tim Wilson]: So there's a data [Tim Wilson]: fluency component where it does sometimes feel like in analytics, and maybe this is the grass is always greener on the other side. [Tim Wilson]: If you're talking about finance, somebody's in a financial analyst, somebody would expect that they're an expert around finance and they can go to them and defer to their expertise. [Tim Wilson]: I feel like in marketing and product and digital analytics, sometimes it's like [Tim Wilson]: There's not a presumption of knowledge of complexity.
[Tim Wilson]: The shadow work is building trust, building the relationship, walking them at the appropriate pace through why a diff and diff is not appropriate in this situation. [Tim Wilson]: educating of the business partners that does feel like it's a proportionally heavier lift than many other roles. [Tim Wilson]: Does that count as shadow work? [Michael Helbling]: Tim, when someone asks, which channel has the highest ROI adjusted for LTV, how long does that take you?
[Tim Wilson]: Pull GA4, then export to Excel, write SQL for BigQuery, find my LTV formula. [Tim Wilson]: I don't know, let's say about three hours in a couple of existential crises. [Tim Wilson]: At least two. [Michael Helbling]: This is why ask-wise full-stack approach works.
[Michael Helbling]: Ask in plain English, prism orchestrates across your stack and applies your saved calculations. [Tim Wilson]: So I'm not manually stitching together five tools like some kind of data Frankenstein? [Michael Helbling]: Nope, everything's traceable, not a black box. [Michael Helbling]: DataState secure, semantic layer, generated code, runs locally.
[Michael Helbling]: It's all set up for you. [Tim Wilson]: So for a product with a name that makes you think of a title or asking why, repeatedly, this is pretty sophisticated. [Michael Helbling]: I'm not sure making fun of our sponsor's name is the move here, Tim. [Michael Helbling]: Wait, I did say pretty sophisticated.
[Michael Helbling]: That's a compliment. [Michael Helbling]: All right, fair enough. [Michael Helbling]: Well, go to ask-y.ai, that's ask-y.
ai, and use code APH for priority beta access. [Michael Helbling]: Join the rise of the AI analyst. [Val Kroll]: 100%. [Val Kroll]: Yeah, I think so.
[Val Kroll]: Or even some of that same concept, the explanation to like backend developers, like you were talking about the business partner audience, but that was one, I think we were talking about this a little bit too much. [Val Kroll]: I know that you have scars, but the story that comes to mind for me, when I worked at the American Medical Association, we were working off of the free version of GA at the time, and we had just gotten an analytics canvas license. [Val Kroll]: to overcome the sampling.
[Val Kroll]: So it would like hit like every 30 minutes or every hour or whatever it was so that we could extract air quotes, all the data. [Val Kroll]: And I remember it like there was some, some backend developers were like, Oh, perfect. [Val Kroll]: Now we can just, you can just give us all of your GA data every night and we'll just throw it into the membership cube. [Val Kroll]: And I was like, it doesn't work like that.
[Val Kroll]: Also, like, what do you mean everything? [Val Kroll]: Like, do you even, but like so many conversations, conversations that got escalated, my boss had to pull me into it. [Val Kroll]: And it was like, you guys, [Val Kroll]: This is not like, I don't, maybe this is on me at this point for not being able to explain this, but this is a little bit of a nightmare. [Val Kroll]: But the other thing is that membership cube, the ID, the key was the membership ID.
[Val Kroll]: And I was like, do you think that the only people who visit our website are members and that they're authenticating at least once every 30 days? [Val Kroll]: Like you are off your rocker, but it was like, at least, at least three months of my life spent on that topic, if not longer. [Michael Helbling]: And a lot of times shadow work is just cleaning up or trying to clean up a data warehouse you inherited from a previous team or something like that. [Michael Helbling]: You know, you walk into an Oregon, they're like, oh, we want to do this, this and this amazing thing.
[Michael Helbling]: And you're like, well, the snowflake instance we have is not going to do any of that till we really clean up a bunch of it. [Moe Kiss]: And you're helps. [Michael Helbling]: Yeah. [Moe Kiss]: Is this like one of those times where you read my exact life situation that is going on right now around to a huge rebuild of our entire data warehouse for a very specific, like very similar reason, right?
[Moe Kiss]: Like the data wasn't structured in a way that we can answer the business questions of today. [Moe Kiss]: And so, and I think the thing that's so hard about projects like this is they're often huge and very time intensive and unlock the heap of value, but people don't see the value until like months. [Michael Helbling]: Yes, it's a long time and it's hard to go pitch those because it's not very sexy or very exciting to be like it's not doing anything but setting up a potential for a future as opposed to delivering a business result.
[Michael Helbling]: It's so much nicer to go in and say, hey, here's this analysis where we can make $100 million more this year if we do X, Y, and Z versus, hey, we need to spend a bunch of money redoing stuff we already have because it's not doing this, this, and this. [Michael Helbling]: Eventually, you can write the business case to show where the value will come from, but man, it's an uphill battle. [Michael Helbling]: I don't know if that's shadow work exactly. [Tim Wilson]: I think there's often, I mean, I will see that example and raise it one with wait for a year.
[Tim Wilson]: I lived this scenario many times, but the most horrifying one, I think, traumatic one, working with a large pharma company that was using Adobe Analytics, and they said, we're going to get everything into a Azure [Tim Wilson]: you know, data store of some sort. [Tim Wilson]: And so many requests, they'd say, oh, we don't have that yet, but it's all going in. [Tim Wilson]: And they were just locked into these backend developers said, we're going to take the Adobe's horribly [Tim Wilson]: weird and never really thought through, gotta take the Viz high and Viz low, like stitching like messy, messy, messy data feed data.
[Tim Wilson]: And they were saying, we're just gonna pump it in at that raw level. [Tim Wilson]: And then we'll just kind of write SQL queries that people can use. [Tim Wilson]: I'm like, the SQL query just to answer how many users came to this page is kind of a beast. [Tim Wilson]: But we couldn't get an audience with them because they were just convinced, which seems very common with [Tim Wilson]: developers.
[Tim Wilson]: I feel like it's maybe less of an issue if you're taking an event-driven product analytics perspective, but anytime you're going to something where you've got this de-duping sessionization, developers think of event. [Tim Wilson]: They don't think of [Tim Wilson]: the need for stuff to be deduplicated by something. [Tim Wilson]: So this idea that, well, we'll just pump all the raw data in, and then you'll be set. [Tim Wilson]: You'll just have to write SQL, which then becomes a case of needing to maintain SQL libraries, I think.
[Tim Wilson]: I don't know whether, Moee, you're like, that really doesn't happen if you've done it right, or whether you're thinking, yeah, no, that happens. [Tim Wilson]: Oh, or yeah. [Michael Helbling]: Well, I mean, there's tools that help with that, like, you know, um, dbt or data form or stuff like that that helps you kind of maintain your sequel and repositories and use it effectively. [Tim Wilson]: But sometimes that's to me, you're like, you've gone with this, like, let's [Tim Wilson]: Let's get the full ocean, and then we're going to add layers on top of it.
[Michael Helbling]: And then the downstream is the next question that comes from the business user requires yet another SQL query to be written to build out the next reportlet or whatever. [Michael Helbling]: So you put yourself in a pretty challenging chain of events just to get answers to data, which AI will totally solve. [Michael Helbling]: So don't worry. [Moe Kiss]: Literally, that's about to be my comment.
[Moe Kiss]: I think the biggest challenge right now is that everyone thinks that you can overcome a shitty data architecture with AI, which is just so fucked and hard to manage because you're literally that'd be broken unless we have the right data architecture. [Moe Kiss]: The same way that we'd need to write a bespoke SQL query or you don't even know where to point the question because of the way we've structured the data. [Moe Kiss]: That's the problem that we need to solve.
[Moe Kiss]: And yeah, it's not sexy. [Moe Kiss]: Like getting the buying is incredibly difficult for this stuff. [Moe Kiss]: And it probably is the hardest. [Moe Kiss]: I would say one of the hardest parts of my role right now.
[Tim Wilson]: So that is deep because the business partners who ultimately want to get value from it, it's not going to maintain their attention or technical depth, but the analyst is supposed to be engaging with them and serving them. [Tim Wilson]: So the analyst becomes the proxy for the business and is now dealing with the backend. [Tim Wilson]: And so they become subject matter experts in an area that has [Tim Wilson]: Nothing to do with running analyses or validating hypotheses.
[Tim Wilson]: It's just they're living in that middle tier and there's just no one else. [Tim Wilson]: The shadow has to serve it because there is no one. [Tim Wilson]: That's all there is. [Tim Wilson]: That's the best you got.
[Moe Kiss]: spot on and then you end up with like one or two people in the air and the business who know one area and no one else can do it because it's so complex and there are all these like gotchas so even if you're going to write a bespoke fickle query it has to go through this one or two people because they're the ones that know those tables know how to [Moe Kiss]: to use it well and like that, then you've created your own bottleneck, right? [Moe Kiss]: And it's not an intentional thing.
[Moe Kiss]: I think often the systems were created with the intent to have a lot of flexibility, but then by having flexibility, you don't have enough standardization and like, yeah, it's a chicken and egg. [Moe Kiss]: But I would say that is one of the hardest shadow tasks for sure. [Tim Wilson]: There does seem like there's like a macro thought, this whole topic of the show that it's like the [Tim Wilson]: I feel like I've worked with analysts who take the attitude, well, that's, that shouldn't be my job.
[Tim Wilson]: So it's not my job. [Tim Wilson]: So I'm not going to do it. [Tim Wilson]: And then it kind of falls through the cracks and doesn't happen. [Michael Helbling]: So on that meta thing, like there's something to the idea that like some people by personality are going to be more suited to generalist types of roles versus specialist ones or more drawn to them.
[Michael Helbling]: And so like, I'm definitely much more of a generalist. [Michael Helbling]: So when I find myself running further afield of doing the actual data work and the analysis, it doesn't bug me at all. [Michael Helbling]: It's actually kind of fun to see something different and do something different for a little while. [Michael Helbling]: I sometimes will think about, is this really truly serving our purpose?
[Michael Helbling]: Are we getting done? [Michael Helbling]: We need to get done. [Michael Helbling]: But generally speaking, doing those tasks, not a big deal. [Michael Helbling]: I feel great about it.
[Michael Helbling]: But I absolutely think there are people who [Michael Helbling]: Like that is much more disconcerting to step outside of the role to do those things and less of something that plays to their strengths and much more plays to like the things they definitely do not want to do. [Michael Helbling]: And so like that's the other issue is just sort of like the person kind of matters a little bit to this too. [Val Kroll]: Yeah. [Val Kroll]: And I don't think, I mean, at least from my personal experience, it hasn't been like a conscious choice of like, whether I'm going to step outside or, you know, get in someone else's lane, but it always feels like I'm tugging on a thread of something that in the moment feels necessary for me to [Val Kroll]: understand what I'm analyzing or to understand root cause of like why that had been a problem.
[Val Kroll]: I mean, and a lot of times I personally just get fascinated by like, you know, authentication handshakes and like, you know, all the different nuances in that space. [Val Kroll]: But it always ends up feeling like it's adding to this like mosaic of my understanding, which always feels like it pays dividends in the future too. [Val Kroll]: So I've never, I've never tried to quiet that voice. [Val Kroll]: Also, I'm just really nosy.
[Tim Wilson]: This reminds me of me going overboard on it, where there were webinars in a company that we think we know what webinars. [Tim Wilson]: You have a registration and attendance. [Tim Wilson]: This was in a business model where it was not that at all, and it was like [Tim Wilson]: bonkers how salespeople would sometimes go into an office and sit and watch the webinars, and there were two or three systems involved. [Tim Wilson]: The more I pulled on that thread, it definitely was interesting, but it was like, oh, wow, I was looking at this one table of data and interpreting that attendees meant the number of people who attended the webinar, and that was completely wrong.
[Tim Wilson]: I wound up writing up [Tim Wilson]: It was probably a 10 or 12 page document very, very clearly written because there were all these parties in different places and I thought, nobody has put all this together. [Tim Wilson]: I have done the most glorious, valuable. [Tim Wilson]: This is so useful. [Tim Wilson]: I'm pretty sure not even the webinar business owner.
[Tim Wilson]: read it. [Tim Wilson]: I got probably 25% of the information from her, but I was like, oh, she was excited to explain to me the nuances of the complexity, but I kept digging further and further and saying, aha, look what I, the external consultant, [Tim Wilson]: has done to really help you understand what's going on here. [Tim Wilson]: And there was kind of no interest. [Tim Wilson]: So that was one where I'm like, it was useful for me.
[Tim Wilson]: It should have been useful downstream. [Tim Wilson]: In today's world now, boy, I'd be throwing that into an LLM somewhere and saying, that's really helpful data potentially. [Tim Wilson]: But I'm pretty sure that document, I was like, I became the domain expert on something that [Tim Wilson]: People cared about webinars, they did not care to hear how messy it was to interpret any of the data that was captured. [Moe Kiss]: The thing that's resonating with me a lot right now, one of the values that I, I do have leadership values, it's a weird corny thing.
[Moe Kiss]: But one of them is be unwaveringly useful. [Moe Kiss]: Does anyone, pop quiz, anyone remember where that comes from? [Tim Wilson]: I don't think so. [Moe Kiss]: Oh, from being useful would be...
A good friend, Cassie. [Moe Kiss]: Yep. [Moe Kiss]: I got it. [Moe Kiss]: Ding, ding, ding.
[Moe Kiss]: Yeah. [Moe Kiss]: Yeah. [Moe Kiss]: She put it in one of her blog articles and it's always resonated with me. [Moe Kiss]: And I'm completely contradicting myself now because at the start I was like, don't pick up the admin work.
[Moe Kiss]: But I'm the first person to be like, if someone's not doing something and I can add value or move something forward, I'll normally just end up doing it. [Moe Kiss]: So like I am, yeah, a walking contradiction. [Moe Kiss]: But I do think there is part of that. [Moe Kiss]: responsibility of data folk like I tend to get really frustrated when a data person is like, well, that's not my job.
[Moe Kiss]: And I'm like, your job is to help the business make better decisions. [Moe Kiss]: So if there's something you can do to be useful to help the business make better decisions, that is your job. [Moe Kiss]: Yeah, I don't know. [Moe Kiss]: That's just the thing that's bubbling around in my mind at the moment as we're, I mean, not relevant to Tim's example, but more broadly about this area of like sometimes it is about getting the domain expertise.
[Moe Kiss]: Sometimes it is about documenting something that no one in the business has written down. [Moe Kiss]: It's like, sometimes those things are less useful, but a lot of the times are really useful. [Michael Helbling]: just to give some people who might be listening a chance to sort of be like, well, maybe, Moe, I can't do that thing or I'm not good at that thing. [Michael Helbling]: Is it necessarily that you have to go personally be the one in charge of that as much as be part of helping solve it in some way, see that it gets done?
[Michael Helbling]: So it's more of like the ownership taking versus the taking on the role and doing it yourself, just so that people who are very specialized or don't [Michael Helbling]: Yeah, because I have a ton of empathy for people who are like, Michael, I just can't get up in front of people and talk. [Michael Helbling]: Cause like I analyze data and that's what I like to do. [Michael Helbling]: And I very stressed out every time I have to go present something. [Michael Helbling]: And it's like, okay, well then has someone else can do that part, but like you just need to make sure you're a facilitating it up to the moment where it, where it happens.
[Michael Helbling]: So it doesn't have to be you necessarily taking on that role. [Michael Helbling]: I don't know if I agree. [Michael Helbling]: So don't pick presenting something then, something else, like managing the project or something like that. [Michael Helbling]: But the point being, like, not every person fits every single role.
[Michael Helbling]: Like, you don't have to be a polyglot, if you will. [Michael Helbling]: Or a polymath. [Tim Wilson]: What that, I mean, if you... Poly PM.
[Tim Wilson]: First break all the rules, like the precursor to the now discover your strengths, strengths finder, which... But first break all the rules. [Tim Wilson]: I've always, to that same point, identifying what needs to happen. [Tim Wilson]: I think, Moe, that's the brilliant way to frame it.
[Tim Wilson]: What is your job? [Tim Wilson]: It is not to write SQL. [Tim Wilson]: It is not to develop reports. [Tim Wilson]: It is not to deliver results.
[Tim Wilson]: It is to move the organization forward by helping them make decisions. [Tim Wilson]: If you say, well, [Tim Wilson]: That means that somebody every Tuesday morning needs to reach out to this one person and ask them a question. [Tim Wilson]: Like it can be frustrating. [Tim Wilson]: It can suck.
[Tim Wilson]: But you know what? [Tim Wilson]: There's somebody who's actually super sociable, who loves to ping people or whatever. [Tim Wilson]: Like building up that list is kind of, these are the discrete tasks. [Tim Wilson]: Not that somebody's going to love and relish doing every one of them, but it does at a team level.
[Tim Wilson]: help start to shift around, like, oh, somebody needs to document these database tables, or somebody needs to ask why Guru, they need to know how that tool works really well, figuring out who gravitates to it. [Tim Wilson]: I do think there's, and I think I was cringing similarly with Michael grabbing a random example, there is a fine line between what is a complete analyst [Tim Wilson]: need to be able to do and do even if they're outside of their comfort zone. [Tim Wilson]: So it's, it gets a little squishy.
[Tim Wilson]: Which of this is shadow work that like somebody's got to do it, this person gravitates to it. [Tim Wilson]: Which of this is going to be a really ineffective handoff because someone just doesn't, doesn't want to write sequel. [Tim Wilson]: I mean, they'll use that example. [Tim Wilson]: Somebody, I don't want to, I'm just not the kind of analyst who's going to learn to write [Tim Wilson]: code.
[Tim Wilson]: It's like, cool, then you're not the kind of analyst who's going to progress particularly far in your career. [Tim Wilson]: So, cool. [Tim Wilson]: We got it. [Michael Helbling]: Hey, I've gotten pretty far.
[Michael Helbling]: So, you know, no, now you can't do it. [Michael Helbling]: You can't. [Moe Kiss]: I don't want to get into team dynamics too much, but I do think a big part of figuring out the shadow work as a team is figuring out who had strengths for different parts of it and we're making sure people lean in. [Moe Kiss]: I know in my previous team, we had a really big gap of, we didn't really have someone who was really good at the [Moe Kiss]: I would say leadership team documenting stuff, pushing it forward, hyper-organized, being like, hey, Moe, these are all the things we have coming up in this time frame.
[Moe Kiss]: We very intentionally hired someone that was really strong in that space to complement our team. [Moe Kiss]: I think that we really need to be thoughtful of what are all those [Moe Kiss]: things, especially the shadow work, because if you put someone on something and that's their strength, it's so much easier for everyone. [Moe Kiss]: They feel like they're adding value, that the balance feels better. [Moe Kiss]: And to be fair, there are some things that no one particularly wants to do, and then it just comes about making sure everyone takes a turn.
[Tim Wilson]: Can we hit on that stuff a little bit? [Tim Wilson]: And maybe this administrative work, maybe more broadly, because I think that is the danger there. [Tim Wilson]: And I do think I've seen stuff written that women are much more likely to get screwed on this one, is that this thing needs to happen. [Tim Wilson]: And they're like, oh, well, it's admin work, like the latent misogyny [Tim Wilson]: Maybe not intentional is, well, Moee's really good at that, but it's absolute shit work, and she's not going to speak up.
[Tim Wilson]: I think there is that the shadow work that needs to be done that has value, that is being done as efficiently as possible, and there can be some gravitate to it. [Tim Wilson]: Shadow work that is has to be done. [Tim Wilson]: There is value. [Tim Wilson]: No one wants to do it and making sure that that doesn't fall to the passive nice person because because that can spin out where wait now half of your job is unseen shadow work and you can't advance in your career.
[Tim Wilson]: Even though everybody's like, well, this all needs to be done. [Tim Wilson]: But good old Jane is, you know, always there for it, you know, but it's in the shadows. [Tim Wilson]: It's not getting [Michael Helbling]: Yeah. [Michael Helbling]: That's not visible.
[Michael Helbling]: So this is actually kind of an interesting pivot, Tim, because as you turn into a leader in your space or leading teams and those kinds of things, your job becomes taking the work out of the shadows for some of the exact reasons you just said, because it needs to be recognized. [Michael Helbling]: What's being done, the people doing it need to be recognized. [Michael Helbling]: And then who should be doing it, should be much more strategically thought out as opposed to [Michael Helbling]: quote, fallen into just because, oh, so-and-so is more agreeable, so they just take it on without fighting too much, which is just a terrible solution to the problem.
[Michael Helbling]: So anyways, I thought that was a really great point, Tim. [Michael Helbling]: And I think that's sort of the thing that maybe take away is like, when you turn from an individual practitioner or individual contributor into a leader, you know, when you're just an IC sitting at your desk, you're like, wow, do all the shadow work. [Michael Helbling]: When you're a leader, you're like, we need to take the shadow work and expose it to the light. [Tim Wilson]: That sounds hard.
[Tim Wilson]: That's why I'm not going to, I'm not striving to be a leader. [Moe Kiss]: I do think though it also is about like recognition. [Moe Kiss]: And like one of the things that I would say like, and I'm thinking of this particular person, like I know at the moment their rating would be very good or like they're like an assessment of their performance, right? [Moe Kiss]: Because I value that work.
[Moe Kiss]: And so I think where the challenge is is like, [Moe Kiss]: when there's that tension where someone's like picking up a lot of shadow work, that then is not valued or not given the value that it's deserved. [Moe Kiss]: Whereas I see it as like being incredibly essential. [Moe Kiss]: And if you do that shit well, like you can unlock a lot for your your team or the business. [Moe Kiss]: And so like, I want to make sure that that's rewarded and reflected.
[Moe Kiss]: So it there's a lot of new ones, though, like, obviously, it's very dependent on specifically like what paths we're talking about. [Moe Kiss]: And yeah, [Moe Kiss]: and many factors. [Tim Wilson]: I'd just like to say to all of Moee's team who's listening to this podcast, she's talking about you. [Moe Kiss]: She values you.
[Tim Wilson]: Oh, wow. [Tim Wilson]: She gave us the name off Mike and it was your name. [Tim Wilson]: So good job. [Moe Kiss]: Stop it.
[Moe Kiss]: You were so cruel. [Val Kroll]: The other thing that this is making me think about is that when any in-house role that I've had, I've never reported to an analyst. [Val Kroll]: It's always been, you know, ahead of digital or someone else who it was really hard to message up not only for myself when I was the IC, but then when I grew my team about all the things that takes like, I'll say, do you think we just sit there and like convey your belt? [Val Kroll]: Just like analyze, analyze.
[Val Kroll]: Like that's so not all that the job is, right? [Val Kroll]: So there's a lot more. [Val Kroll]: education in that scenario, whereas I was thinking about your comment, Michael, like with the elevation of analysts and to those leadership roles that there's a lot more visibility and line of sight. [Val Kroll]: So I agree with you on the accountability we're going to put on any listener to bring that work out of the shadows and acknowledge and like what you were talking about both.
[Val Kroll]: So that's a really good point. [Michael Helbling]: I think what we're finding out is that the work has value. [Michael Helbling]: Whether we should be doing it or not as analytics people isn't necessarily all the story. [Michael Helbling]: Sometimes you should go back and say, workflow-wise, the solution should be to take this group and pull them into this piece of work.
[Michael Helbling]: rearrange it and come up with a strategy. [Michael Helbling]: My early example, Tim, you pointed out, we exposed basically an organizational workflow flaw when we came up with an insight and then had to go drive the insight through the org. [Michael Helbling]: What we exposed was no one had thought about, hey, what if we have an optimization, we want to make a reality? [Michael Helbling]: How does that get done in our company?
[Michael Helbling]: Well, somebody should have probably thought about that, and so that was the work that had to be done was to figure out and create a machine that would take care of that. [Michael Helbling]: But it's the same thing with all the rest of it. [Michael Helbling]: It's sort of like, okay, well, what are the parts that need to move into the right places to get it done? [Michael Helbling]: Not necessarily you, the data analyst should do it, but [Michael Helbling]: that it gets done because it is valuable work at the end of the day, especially if it's actually driving impact or decision making in the organization using data, which is sort of like the thing that makes me smile anytime I get a chance to be part of something like that.
[Moe Kiss]: Can we talk about data quality? [Moe Kiss]: We have not touched on that at all. [Michael Helbling]: It's usually pretty good. [Michael Helbling]: Yeah.
[Michael Helbling]: I mean, just kind of automatically. [Michael Helbling]: Yeah. [Michael Helbling]: What do you mean? [Michael Helbling]: What was there to talk about?
[Michael Helbling]: So I'm pretty sure. [Moe Kiss]: I think it's going. [Michael Helbling]: I think it's going. [Moe Kiss]: Oh my God, stop.
[Moe Kiss]: Everyone stop triggering me. [Michael Helbling]: Sorry. [Michael Helbling]: Sorry, well. [Moe Kiss]: Just come on.
[Moe Kiss]: I think the one that I'm specifically comes to mind is [Moe Kiss]: Bend sent from a media agency. [Moe Kiss]: And I just get so frustrated or from a finance team. [Michael Helbling]: Talk about the highly formatted Excel files you might be receiving. [Tim Wilson]: In wide format when they should be in a long format.
[Moe Kiss]: Of course. [Moe Kiss]: I'm glad you could all laugh about it. [Moe Kiss]: I am not at the laughing stage. [Charles Barkley]: Sorry, well, this is probably a whole episode we need to do on stuff like this.
[Moe Kiss]: But it just, I think what's so fucking hard is that your stakeholder will be like, especially the one that owns the relationship with the media agency. [Moe Kiss]: I didn't get it. [Moe Kiss]: They sent a spreadsheet over on Moenday. [Moe Kiss]: Like, you've got the data.
[Moe Kiss]: What's the problem? [Moe Kiss]: Like, why is it going to take you a week? [Moe Kiss]: And you're like, [Moe Kiss]: Do you know that every single city that they run media in is in a completely different format and we then need to sense check it with our record? [Moe Kiss]: No, that is a huge lift.
[Moe Kiss]: And fuck. [Moe Kiss]: Anyway, and then you've got some very senior, brilliant data scientist that is spending their time basically QAing data. [Moe Kiss]: It's really frustrating. [Tim Wilson]: That is one of those cases where that's another shadow that the analysts can fall into where they're the bridge between the data creation.
[Tim Wilson]: That data may be created out of some contractual necessity, but doesn't have any real incentive or stake outside of what's in an agreement. [Tim Wilson]: It's like, oh, we'll send you data. [Tim Wilson]: We'll send you data. [Tim Wilson]: Check the box.
[Tim Wilson]: And this is going after media agencies pretty hard, that a lot of times they don't really under, they're like, whatever the platforms, you know, trade desk spits this data out or runs into our data warehouse and we'll just give you a feed. [Tim Wilson]: And the analyst is the one who winds up having to explain their data to them. [Tim Wilson]: So it's like another version of that. [Tim Wilson]: That particularly is another version of what you were talking about earlier, Michael, where you have to be like, [Tim Wilson]: Yeah, how can this possibly be zeros across here?
[Tim Wilson]: It's like, wait a minute, I'm now having to reach out to... Everybody seems to assume that it's coming in fine, but I have to set up time to go three levels deep with some partner to get them [Tim Wilson]: to agree that it's actually a problem or explain to me why it's not a problem. [Michael Helbling]: I'm literally in a situation like that right now. [Michael Helbling]: I ran into a situation just this past week where a company is like, yeah, we're pretty sure the quality of the data in this system is great, and so I get my hands on it and immediately see three things I'm pretty sure making their data quality really bad.
[Michael Helbling]: And so you're literally starting out with sort of like, okay, well, our first conversation is gonna be, guess what? [Michael Helbling]: The data you thought was really good? [Michael Helbling]: Not good. [Michael Helbling]: And there's a number of fixes we're gonna need to do before we even start on the things we wanna get further along.
[Michael Helbling]: And it's frustrating but real, right? [Michael Helbling]: So it's sort of like, yeah. [Michael Helbling]: And then the other one that gets me sometimes is sort of like alerts and notifications, anomaly detection and those kinds of things. [Michael Helbling]: That is a part of data, but it's not really what an analyst does necessarily.
[Tim Wilson]: Well, the analyst gets blamed if the data all of a sudden it's found that something wasn't there for weeks. [Tim Wilson]: They're like, what were you doing as an analyst? [Tim Wilson]: How did you not notice? [Michael Helbling]: Raise your hand if you're the only one that's had your own secret dashboard so you don't get caught up in one of those things.
[Michael Helbling]: So you have advanced warning of something that's happening. [Moe Kiss]: I think anomalies is part of our job, but you will keep saying analyst, and I think of data practitioners, whether it's a data analyst, analytics engineer, data scientist. [Moe Kiss]: For example, if there is something in our B2B pipeline that breaks [Moe Kiss]: our leads coming through that is absolutely data quality and normally detection and I would expect an analytics engineer to go in and solve that.
[Moe Kiss]: Absolutely. [Moe Kiss]: When we're doing at the complete other end of like a metric goes up, a metric goes down, that sort of stuff, again, I would expect a data person to go in and kind of debug that. [Moe Kiss]: It might, they might not be responsible for the complete like up level, you know, challenge of why that thing is or isn't working anymore. [Moe Kiss]: But like, I would expect someone to be pretty across that if we saw like a number tank or something like that or a number skyrocket.
[Tim Wilson]: But, but that's the, I mean, the way you just framed it, not to, I mean, you're just speaking off the cuff that a, [Tim Wilson]: There is a perception that, yeah, yeah, yeah, they need to catch if a number of tanks are a number of skyrockets. [Tim Wilson]: In practice, every time I've had a system where it's like trying to tune where, like there's not a threshold, then there will be platforms out there that say, look, you can set this at a 95% threshold, set up 100 alerts.
[Tim Wilson]: I'm like, cool, I'll get on average five alerts a day. [Moe Kiss]: I'm not necessarily expecting a data person to catch them all. [Moe Kiss]: I think that's a really hard thing. [Moe Kiss]: It's so difficult, right?
[Moe Kiss]: Because if you have a stakeholder who comes to you and is like, hey, this number declined and you're the data person who's like, what? [Moe Kiss]: I had no idea. [Moe Kiss]: That's shit. [Moe Kiss]: It's hard for trust.
[Moe Kiss]: But at the same token, expecting a data person to be able to be ahead of the game on every anomaly is also not an expectation I have. [Moe Kiss]: But I would [Moe Kiss]: I would basically be like, okay, something has gone wrong here. [Moe Kiss]: I'm going to reach out to my stakeholders. [Moe Kiss]: I'm responsible for letting them know.
[Moe Kiss]: I'm responsible for letting them know what we're doing to investigate, how we're going to solve it, keep them updated. [Moe Kiss]: That, absolutely, I do think is a data person's role. [Tim Wilson]: I still have the alert turned on for a certain tax preparation company that you and I worked on years ago and like January 12th, their home page was down from Seattle because I just never turned it off. [Tim Wilson]: But that was one where they were having sporadic [Tim Wilson]: Issues and it was like somebody should be monitoring this and I can go set something up And I had to set up on like my personal account and I just never turned it off.
[Michael Helbling]: So literally Michael knows the brand I know the brand it was down for about 35 minutes Yeah You need to do some account access cleanup that's some shadow work that a lot of consultants have to do [Michael Helbling]: Get yourself off of those old GA accounts or Adobe accounts that you've been on for years and years that you no longer work with. [Tim Wilson]: No, this was using Site 24 by 7. [Tim Wilson]: I was doing like a ping tracker that I set up, so I had set it up.
[Tim Wilson]: So a third-party tool. [Michael Helbling]: You're doing third-party data collection. [Michael Helbling]: I was using a third-party tool. [Michael Helbling]: And they're probably like, why is our website getting crawled by this website?
[Tim Wilson]: But that was, they were sometimes saying like, the tool is down. [Tim Wilson]: And I'm like, no, like why is this anomaly in the data? [Tim Wilson]: Cause your fucking site went down. [Tim Wilson]: Like, that's not a, cause I think I set up a ping for the footer as well.
[Tim Wilson]: Cause based on where they had the tagging track, but I think it started with them saying your digital analytics, your web analytics data is bad. [Tim Wilson]: And I was like, yeah, that's weird. [Tim Wilson]: What's going on? [Tim Wilson]: It's like, well, no, the whole site went down.
[Moe Kiss]: No, I didn't once find, though I was working somewhere there was like an issue that I couldn't figure out like why this number had gone weird or whatever. [Moe Kiss]: And then like a month after I left, I figured out why. [Moe Kiss]: And it was like completely tangential. [Moe Kiss]: I was just working on something different.
[Moe Kiss]: And I did reach out to let them know. [Moe Kiss]: I was like, Hey, this is probably what this was. [Moe Kiss]: You should fix it. [Moe Kiss]: Here is how to fix it.
[Moe Kiss]: You're welcome. [Moe Kiss]: I'm not a shit human. [Moe Kiss]: I want everyone to have the best data they can. [Tim Wilson]: I also get the, it's backup.
[Tim Wilson]: So every time I've seen it, it's come back up quickly. [Tim Wilson]: So there hasn't been a point. [Val Kroll]: Okay. [Val Kroll]: So before Michael wraps, cause you got that look in your eyes.
[Val Kroll]: I would love to hear. [Val Kroll]: love to hear people's thoughts on shadow work, not shadow work for like data fluency, data literacy. [Val Kroll]: We'll call it, we'll call it, cause data literacy programs I think are one of the more common ways people talk about it because it is like a whole category of work. [Val Kroll]: Yeah.
[Val Kroll]: I like data fluency. [Val Kroll]: I think it's less obnoxious than data literacy. [Michael Helbling]: Everybody can read and write. [Val Kroll]: Yes.
[Val Kroll]: So is it shadow work, not shadow work? [Val Kroll]: I think it's shadow work, but I think it's important shadow work. [Michael Helbling]: Yeah, I think it goes back to that sort of like what do you need to do to help the organization take a step forward with data, make decisions, use the data, be effective with the data. [Michael Helbling]: And a lot of times that's building up data fluency in an org or helping people build up their data fluency.
[Tim Wilson]: But that's one where if you try to bring it out of the shadows and say, oh, why don't we just solve this once and for all and send everybody through a data fluency program, pretty ineffective. [Tim Wilson]: So it's the thing that needs to be in the shadows that is a [Tim Wilson]: I mean, not that there's not the opportunity for some of that training. [Tim Wilson]: I feel like I've been learning how much, I mean, it's not, it's the reality of a short attention span that the more you can have like in the moment, like, let me come up with, let me show you this now.
[Tim Wilson]: Let me explain this little thing now. [Tim Wilson]: Let's talk about, oh, you know what? [Tim Wilson]: When you all people say correlation is not causation, this is like the perfect example. [Tim Wilson]: Let's talk about that for five minutes because that's a trap you're falling into.
[Moe Kiss]: Tim, it actually makes me think about gender bias training and all the research on that, where lots of companies do gender bias training. [Moe Kiss]: It doesn't necessarily result in any differences in behaviour or attitudes or anything, but it's a tick the box thing. [Moe Kiss]: When we start talking about like data fluency or training or education or whatever it is in the data space, I think what happens when we sometimes roll out those programs with really good intent, it's a tick the box thing.
[Moe Kiss]: But again, like those in the moment. [Tim Wilson]: That sounds like the sort of observational woman would make, by the way. [Moe Kiss]: We're going to send Tim back to training. [Moe Kiss]: Those in the moment discussions are actually what I think is [Moe Kiss]: makes it so hard because it is shadow work because it's not like I built a program, I've shipped it, I've ticked it, it's done.
[Moe Kiss]: It's like every time I talk to the stakeholder, I'm trying to help them get a little bit further in how they think and understand data. [Moe Kiss]: And that is like you're never done, you've never ticked the box. [Moe Kiss]: And so it does have like a very heavy cognitive load, but it's incredibly important and probably leads to the best outcome I say without a data informed opinion on that at all. [Moe Kiss]: Just like that.
[Val Kroll]: I'm actually surprised that you guys are all on the same page. [Val Kroll]: I don't think it's shadow work at all, whether it's bite-sized or a big part of it, because even some of the criteria we were talking about using earlier, if your role is to help the business make smarter decisions, [Val Kroll]: like making sure that you're connecting what you're finding, what you saw, what you observed, what you validated, what your recommendations are with like what the business can actually be doing with that information.
[Val Kroll]: It feels like it's a, I don't know, to put it another way, there was a leader who I worked for at UBS who like the four D's of product development, like the defined design, develop, deploy. [Val Kroll]: He always said there was a fifth like shadow. [Val Kroll]: not actually a fifth one of adoption. [Val Kroll]: Until you understand how people are using that or if this is a data product or whatever, then you're not done.
[Val Kroll]: The work isn't done when you ship it. [Val Kroll]: The work is done when you understand and create the feedback loops. [Val Kroll]: I feel like it's very much in the same vein of how to make sure that your work continues. [Val Kroll]: Michael, the work almost similar to what you were saying, creating the processes so that the team knew how to take advantage of those recommendations.
[Val Kroll]: I don't know how I just feel like it's not [Val Kroll]: Like you're not done just when the analysis is complete, or it's not. [Tim Wilson]: Yeah, shadow is optional. [Tim Wilson]: Like it has to happen, it's just not identified as something. [Val Kroll]: It feels like it's squarely in the court of, I would expect it to be in a job description.
[Val Kroll]: Like, that's what makes me feel like it's not shadow work. [Michael Helbling]: Again, that's where I think some of this work should rise up out of shadow work. [Michael Helbling]: But again, it's about recognition. [Michael Helbling]: The importance of it, I completely agree.
[Michael Helbling]: But Tim's point, I think, was, will you see it in a job description? [Michael Helbling]: Probably not. [Michael Helbling]: Or if you do, it'll be run a once-in-a-quarter training and call it done. [Michael Helbling]: And we all know that's not going to be effective.
[Michael Helbling]: But it's spending that time, like I'm realizing this episode that like 90% of what I do is shadow work sometimes. [Michael Helbling]: It's so hard to pin down. [Michael Helbling]: Michael works the shadows. [Michael Helbling]: That or I just don't do anything.
[Michael Helbling]: I don't know. [Michael Helbling]: But I remember I had a very specific instance where I had a review and my boss at the time was like, [Michael Helbling]: you're not spending your time the way that it should be spent. [Michael Helbling]: And I had to actually walk him through. [Michael Helbling]: If I spent the time the way that they wanted me to, it would lose the company money.
[Michael Helbling]: And I walked him through step by step. [Michael Helbling]: If I actually did it the way you said, the company would lose money as a result of the effort. [Michael Helbling]: So what you're telling me is that you would like the company to lose this much revenue [Michael Helbling]: by changing what I do day to day, are you sure that's what you want? [Michael Helbling]: And so it was a really interesting conversation because I was able to enunciate exactly where the value lied in each of those things that I was doing.
[Michael Helbling]: I could show the outputs of those things. [Michael Helbling]: But it was a very interesting conversation because it was like, oh yeah. [Michael Helbling]: Now, in that case, I had actually prepped that person ahead of time by showing them exactly how I was going to spend my time. [Michael Helbling]: They just ignored it and came back with the template.
[Moe Kiss]: What was the outcome, though? [Moe Kiss]: Like, what was the end of the story? [Moe Kiss]: Did you get off to change it? [Moe Kiss]: Or did they, like, be like, oh, I see the value of what you're doing.
[Michael Helbling]: I kept going. [Michael Helbling]: Yeah. [Michael Helbling]: No, I was, uh, that was a role in which firing me probably wasn't an option. [Michael Helbling]: Probably they felt like it in the moment.
[Michael Helbling]: I sent an email to the head of HR ahead of that meeting being like, I'm about to chew up my boss. [Michael Helbling]: Um, [Michael Helbling]: But it worked, and I still had a good relationship with that person afterwards. [Michael Helbling]: But it was a situation where they were like, oh, OK, well, never mind then. [Michael Helbling]: And I just kept going with what I was doing, since it was made sense.
[Tim Wilson]: I will claim to the job description that I think when we read job descriptions and say, well, this is looking for a unicorn that's ridiculous. [Tim Wilson]: Or when we read a job description and say, wow, that looks really good, [Tim Wilson]: I bet, I'm thinking through some that I've seen, the ones that actually have the shadow work articulated as part of the responsibility is collaborating with the business partners to how to ask questions in an informed way. [Tim Wilson]: That actually may be, it would be fascinating to look through some job descriptions that when people say this is garbage and say, is any of the shadow work captured?
[Tim Wilson]: Hey, this one looked, because you've had that reaction where you look at one and you're like, oh, they get it. [Tim Wilson]: Like they actually, they're describing a realistic and practical role. [Tim Wilson]: And I bet that that is because there are nuggets of what you'll be expected to do, include some of the shadow work we've talked about. [Moe Kiss]: Okay, but just a push on that I do agree.
[Moe Kiss]: I think the challenge though is like In my role we write we write the job descriptions for data people data people are writing job descriptions for data people So you can still have a mismatch with the stakeholder of what they think a data person should be doing like so I'm just saying it's not like bulletproof [Tim Wilson]: Yeah, but I think if that's recognized, it's like, hey, we've got a bunch of really difficult, unrealistic stakeholder. [Tim Wilson]: We should have in the job description that part of this is collaborating with, not you don't say collaborating with assholes, but you're like, [Tim Wilson]: You know, collaborating with, educating, informing, iterating with, so I think he can still be captured.
[Val Kroll]: He's ambiguous in challenging circumstances. [Val Kroll]: That's right. [Val Kroll]: Yeah, exactly. [Val Kroll]: Oh, yeah, there we go.
[Michael Helbling]: Sell starter, able to juggle multiple priorities simultaneously. [Michael Helbling]: It's like, ugh. [Tim Wilson]: Often when the hiring manager isn't an analyst, then that's why that job description doesn't have the shadow work in it. [Tim Wilson]: And that does some of the.
[Michael Helbling]: And it comes out ringing false. [Michael Helbling]: Yeah. [Michael Helbling]: Well, some of my shadow work is trying to get the show wrapped up on time. [Michael Helbling]: So let's go to do that.
[Tim Wilson]: We got to find somebody who's good at it. [Michael Helbling]: All right. [Michael Helbling]: Let's hand that off to somebody else. [Michael Helbling]: All right.
[Michael Helbling]: Well, listen, Moe and Val and Tim, thank you so much. [Michael Helbling]: This is, I think, a really interesting topic. [Michael Helbling]: And I appreciate your insights on the show. [Michael Helbling]: A lot of work is really important, but doesn't necessarily get recognized for what it is.
[Michael Helbling]: And I think that's sort of where this discussion took us today. [Michael Helbling]: So thank you for that. [Michael Helbling]: You know, as you're listening, I imagine you're thinking some of the thoughts yourself. [Michael Helbling]: We'd love to hear from you and you can reach out to us.
[Michael Helbling]: You can reach out to us on LinkedIn or the Measure Slack chat group or through email at contact at analyticshour.io. [Michael Helbling]: And if you're listening to this on [Michael Helbling]: Apple podcasts or Spotify or whatever platform you listen to it, give us a review or a rating or a comment. [Michael Helbling]: We'd love to see it, love to hear it, love to hear from you.
[Michael Helbling]: And of course, a couple other things. [Michael Helbling]: We're not doing less calls, but a couple of things where you can find us coming up this year. [Michael Helbling]: is at a couple of few conferences and actually coming up really quickly. [Michael Helbling]: So, I know Tim and Val, you all will be at the Datatune conference in Nashville.
[Michael Helbling]: Is that right? [Michael Helbling]: You want to talk about it? [Tim Wilson]: Yeah. [Tim Wilson]: It's a little, it's a Friday is workshops and Saturday, it's a [Tim Wilson]: Conference, it's a pretty low cost, low three-figures conference all day.
[Tim Wilson]: It looks kind of not measure campy from an unconference perspective, but from a enthusiasm and critical people, a lot of people, critical mass of people showing up pretty interesting topics. [Michael Helbling]: What are the dates? [Tim Wilson]: Oh, that would be important. [Tim Wilson]: Yeah.
[Michael Helbling]: I'm here for you. [Tim Wilson]: I'm here for you. [Michael Helbling]: Talk about shadow work. [Tim Wilson]: What is it?
[Michael Helbling]: That's awesome. [Michael Helbling]: And then, of course, Measure Camp New York will be in March 28th in New York City. [Michael Helbling]: It's officially in New York City, not New Jersey this year. [Val Kroll]: Very exciting.
[Val Kroll]: Very exciting stuff. [Michael Helbling]: Yeah, it's going to be a great... Measure Camp is always a great time. [Michael Helbling]: Obviously, Val's super involved with Measure Camp Chicago.
[Michael Helbling]: Moe with Measure Camp Sydney. [Michael Helbling]: Tim with Measure Camp Columbus. [Michael Helbling]: Me with not being involved with Measure Camp in any official capacity, but I love going to them. [Michael Helbling]: And I think right now Tim and I are planning to be at that one, and that's March 28th in New York City.
[Michael Helbling]: And then finally, April 28th and 29th, the whole Analytics Power Hour, or a lot of the Analytics Power Hour folks will be at the Marketing Analytics Summit in Santa Barbara, California, which sunshine on the West Coast. [Michael Helbling]: Hello. [Michael Helbling]: Get there. [Michael Helbling]: We love to.
[Tim Wilson]: We got some exciting plans for that. [Tim Wilson]: Stay tuned to future episodes. [Michael Helbling]: What's the drink that you have in Santa Barbara? [Michael Helbling]: What's like a good cocktail for that?
[Tim Wilson]: I'm sure it's some fruity California liberal. [Michael Helbling]: Wine. [Michael Helbling]: Exactly. [Michael Helbling]: Wine.
[Michael Helbling]: White wine or rosé on the beach or in the sunshine. [Moe Kiss]: Love this. [Michael Helbling]: Love this from me. [Michael Helbling]: I don't know.
[Michael Helbling]: I'm terrible at picking out drinks. [Michael Helbling]: All right. [Michael Helbling]: That's the show. [Michael Helbling]: We're excited to have brought it to you.
[Michael Helbling]: And I think I speak for all my co-hosts when I say, no matter whether the work is in the shadows or way out in the open, keep analyzing. [Announcer]: Thanks for listening. [Announcer]: Let's keep the conversation going with your comments, suggestions, and questions on Twitter at @analyticshour on the web at analyticshour.io, our LinkedIn group, and the Measure Chat Slack group.
[Announcer]: Music for the podcast by Josh Crowhurst. [Charles Barkley]: Those smart guys wanted to fit in, so they made up a term called analytics. [Charles Barkley]: Analytics don't work. [Charles Barkley]: Do the analytics say go for it, no matter who's going for it?
[Charles Barkley]: So if you and I were on the field, the analytics say go for it. [Charles Barkley]: It's the stupidest, laziest, lamest thing I've ever heard for reasoning in competition. [Michael Helbling]: Lacy Fusion Productions. [Michael Helbling]: Lacy Fusion.
[Tim Wilson]: That's our production studio's sister organization on Southern Hemisphere covering Lacy Fusion Media. [Michael Helbling]: 4th floor productions, Lacyfusion Media. [Val Kroll]: Known for expanding into Australia. [Michael Helbling]: Ken Riverside.
[Michael Helbling]: And the Lacyfusion Media. [Michael Helbling]: Present a 4th floor production. [Val Kroll]: Okay, well screw your green bars. [Val Kroll]: You sound like you're in this building with a paper cup and a string.
[Val Kroll]: All right, love you. [Michael Helbling]: Your temperature, Matt. [Moe Kiss]: She is so cute. [Michael Helbling]: I know.
[Michael Helbling]: It's ridiculous. [Moe Kiss]: So cute. [Tim Wilson]: Rock flag and who knows what insights lurk in the tables of our databases. [Tim Wilson]: The shadow analyst knows.
[Michael Helbing]: Nice. [Michael Helbling]: That's actually pretty close. [Moe Kiss]: I'm like, damn, you got the voice. [Tim Wilson]: That's got something.