I recently moved in with my boyfriend of 4 years (yeee I know!!) and went from living in SOMA to Nob Hill. What a transition.
After living in SOMA for 3 years, I was beginning to fall out of love with San Francisco. I was going to the same restaurants, running by the same water, and hanging out with the same friends. When I decided to move in with my boyfriend, we were totally considering moving to a different city. In the end, we settled on Nob Hill for a variety of reasons, but mostly because we were both still doing well in our careers here and it didn’t make sense to move elsewhere, yet.
I’m so glad we decided to move to Nob Hill, because this is the cutest neighborhood ever, DEFINITELY UNDERRATED. And I have fallen back in love with San Francisco. Does our view of the Golden Gate bridge have to do with it? Maybe.
We are located in upper Nob Hill, bordering Russian Hill, which is also very close to Marina. If you ask any San Franciscan, they’ll agree with me that this area is extremely bougie, with girls in yoga pants walking around at all times, coffee in hand. At first I thought, ‘ew do these girls even work out?’ And now I’ve turned into one of them, no shame.
This neighborhood is filled with cute coffee shops, amazing restaurants (most which I can’t afford), and many workout studios. The only part I didn’t like when moving into this hood, but am slowly getting used to is the hills. I’m a runner but not one good with hills WHATSOEVER, so I’ve been slacking for my fear of going up and down these monstrous streets. I’m hoping this is something I’ll overcome with time. I mean, no pain no gain, right?
All in all, I am IN LOVE with my new hub, and I still have so much to explore.
To strip a data analyst’s job to its very core, it involves taking data and turning it into insights a business can act on to make more profit. What does that process actually look like step by step?
I recently worked on a project that required the exact steps I’m about to take you through. The goal of the project was to streamline a monthly 22-market marketing performance report process, making it quicker and less prone to human error. The process once required four people to put in a month’s worth of time to complete, and throughout a LOT of unnecessarily busy work. I cut that process down to just one person, some technology, and a week’s time to pull together.
So here were the steps involved in streamlining the process. I’ve also included in parentheses the tool(s) I used for each step.
Step 1: Create a data collection template
(Tool used: Excel)
- If your data comes from multiple sources in various formats, you will want to create a data collection template that will allow you to easily combine the data every month. Excel is still the most universal tool for storing data so I recommend using Excel to create the template. If you are looking at more than a few hundred thousand rows of data, however, you may want to consider building a database.
Step 2: Clean and process data further – this step will ideally take minimal energy if Step 1 was done right
- Ideally, when you give someone a template, they follow it. But we’re human, and humans mess up. That’s when you want to leverage a tool like Alteryx to further validate and clean the data, then join together all data sets so you only have one or a few files to work with.
Step 3: Create charts and interactive data visualizations to capture trends
- You’ve spent hours gathering and cleaning the data, and now you finally arrive at the most interesting part: visualizing the information for others to quickly spot trends and make decisions on how to act on them.
Step 4: Form insights and actionable next steps
(Tool used: Tableau + Email)
- Outline trends you see right away and work with the marketing execution team to further understand what the most important takeaways are. At this point you will have taken some numbers and made them into money drivers. That’s it, you’ve done your job!
Additional Tips for Overachievers
- Continue evolving the data cleaning and blending process to save more time and energy every time you repeat the cycle; allow the process to be malleable to data structure changes and anomalies
- Ask for feedback from the marketing execution and other relevant teams and act upon them
- Don’t underestimate the importance of data visualizations in enhancing your story
I started taking a web developer course online last fall, and when the time came to create our final project, I happened to be working on my code on election day. When results didn’t go my way, I found a lot of satisfaction in creating my own virtual reality.
How do we take data, understand it, and use it to impact change? That’s a million dollar question I ask myself everyday. Straddled between media strategists and spreadsheets, I take everyday business questions, churn them, and spit out an answer to steer clients into the correct decision. There’s no right or wrong answer to the questions I get asked, but I can get darn close to a “correct” answer and help propel businesses forward. That’s the exciting part in all of this – to see how close I actually got after the fact.
In my daily life, I also ask a million questions and try to piece the answer together through information gathered from news sites, blogs, social media, and even those around me. I want to use this blog to document some of the most interesting questions I’ve been answering, provide tips for up and coming trend enthusiasts, and pave the way for those that have just begun their journey in the data world.