I had one of these days at work today… the kind of day when… well…
A big part of my job involves working with data, the details of which would be monotonous and boring to most. If you’d tried to sell me on it a few years ago, my response would have been along the lines of “What? NO!” But I enjoy it. I really do.
My company uses data for different purposes, depending on what our clients need. And we’re still sort of new to it all. Sort of. Big picture-wise. But we’re improving and growing every day.
Several weeks ago, one of my clients contacted me and asked if I could prove some specific results of the services we provide. We have all kinds of reports, but this particular result? Well, there’s not an automated way to produce it. But I had a strong feeling that if I could produce it, I could prove something valuable. If I could prove it, this client would be steering several other potential clients in our direction.
I set out to do some research. For the past few weeks, I’ve been filtering data extracts and comparing extracts from one date to the next. I’ve been trying to document the data changes in such a way to show a specific result, in an easy-to-understand manner.
Our staff is stretched a little thin and there are a lot of irons in the fire. My boss mentioned that while my goal was admirable, she didn’t think it was my job to prove what I was trying to prove. She felt bad that there wasn’t a report I could just call up to provide my client, and said she didn’t feel I should have to spend my time trying to find the proof I needed. She insinuated that if I was going to continue working on this, it should be filler work.
This project has been filling every spare moment I’ve had for weeks. And I have put so much effort into things that turned out to be dead-ends. Two days ago, I thought I’d finally hit my mark, only to find another inconsistency that shed doubt on my results. I was ready to throw it all in the trash and pull my hair out.
Thankfully, I have a coworker who is a big picture person. While I know what I can and cannot do with the data, and at times was ready to throw in the towel, she’s an idea person who keeps asking questions until she gets where she wants to be. She kept asking me questions. Some wrong questions. Some right. “Can you do this? Can you do that? If you could find X… would it prove Y?”
All of that trial and error, all of those questions… Today it finally added up to the answer I was looking for! I know… I know there is a way to automate a process to achieve that kind of result, but as of now, it doesn’t exist. And as of today, I found it anyway! I was hoping and praying that this result was the one that I needed and it was.
I feel like I’ve been fighting these past few weeks and I was really beginning to feel like it was all for nothing. And just when I was ready to walk away from the whole thing, I got excited about the project all over again and found exactly what I’ve been looking for. This is exactly the kind of thing that reminds me what it is I love so much about what I do. Kind of geeky, I know. Never would have guessed I had it in me. Feels GREAT!
I still have to polish things up a bit before I send anything to my client. But now I feel confident in the information I’ll be providing and I know my client will be more than pleased to see these results.
So yep! It was that kind of day; the kind that makes me excited to go back to work tomorrow. I am so grateful that I get to do what I do.