Hey guys! I’m working on a big project with a lot of complex moving parts and despite having zero background in working with data, I’d really appreciate it if you sent me all of the data so I can work out what it is I need.
Data Analyst [unfortunate enough to be covering the request process that day] permalink
Hmmm, ok. Can you narrow it down a little bit, anything in particular you want to see? Maybe trends in usage or sales or customer profiling?
Now I’m freaking out because I have an action from a project meeting and really can’t go back with the great big page of nothing that’s on my desk.
So can you just give me everything right now?
When I look at it the real answer will magically appear on my screen like one of those magic eye 3D pictures where a dolphin swims out at you and playfully dances like Flipper in that old 1960s TV show.
Bona fide 100% guaranteed to successfully nail the metrics you need to push that project into Green status. The big win that cements their future career progression as the brightest young thing of the project management world.
It’s the lazy option of not having to think about what they are trying to solve and it’s frustrating as hell.
It also really highlights the importance of building a robust process for requirements gathering.
The data team has to be involved as early as possible in projects. It’s no good just being a mailbox waiting on a cold request arriving from the business and blindly being delivered without further question or input.
I get embarrassed for the person asking this question. The simple fact is that they are out of their depth but don’t necessarily want to admit it, either to the data analysts or to their managers.
Or worst of all, to themselves.
What if they are just hedging their bets? permalink
I’ve had customers who say they would rather ask for something and not need it than need it and not have it. This is another issue altogether.
Running a small analyst team means we only want to strip requests down to the bare bones of what is really needed.
What this actually is might not always be easily apparent. But it’s another important skill to level up on for the requirements gathering and general business education stage.
As analytics becomes more vital to the business, it becomes even more necessary to take the lead and set the agenda.
If you have any plans for progressing your career as an analyst, you will have to embrace the pain of sometimes telling customers what it is they REALLY want. Not what they THINK they want.
Rob Collie and Avichal Singh put the conundrum perfectly in their book “Power Pivot and Power BI: The Excel User’s Guide to DAX”:
“Human beings do not know what they need until they have seen what they asked for”
This x 1,000,000.
Part of your role as an analyst is helping them visualise where they want to go and what they want to see when they get there.
If you only want to do the technical work then that’s fine. There are more than enough tech-only paths to take in analytics. Just remember that you lose the opportunity to craft the direction of the requests if you remove yourself from the customer facing part of the process altogether.
So how do we handle the Veruca Salts without dumping them down a garbage chute in the data factory? permalink
I’m thinking back to similar requests over the years and shuddering at the memories.
Part of that comes from remembering my own unwillingness back then to assert my own knowledge on older, more experienced stakeholders. There was a certain reluctance to not just give them whatever they asked for.
Sometimes it takes time to learn and grow the confidence to do that. Having good air cover from your manager helps.
The frustration of getting in a request like this never goes away. These days I treat it as a puzzle that needs solved. An investigation that needs a little creativity to tease out the real underlying question. Sometimes that makes it a little easier to deal with.
(And sometimes I just want to leave it to a crowd of oversized squirrels to drag the offender off to a big garbage chute and let the data version of the world of Wonka do it’s magic but I’m not allowed to say that out loud of course...)