TIPS I WISH I KNEW BEFORE

Starting A Data Career

Take Note of These Points if You are a Junior Data Analyst

Jason Huynh
Geek Culture
Published in
5 min readMar 5, 2022

--

Photo by Glenn Carstens-Peters on Unsplash

Regardless of working with R, Python, Excel or PowerBi, somethings stay the same, you need to clean data. This is something that all beginner data analyst should be aware of. Making data models, machine learning models, and graphs, are part of the job, but really as the maxim goes, it’s only 20% of the job. The 80% really is data cleaning.

Furthermore, most managers don’t understand that data analysis involves a lot of data cleaning, unless they are data analysts themselves. In my experience, managers believe that a data analyst should be able to craft whatever graphic they want in a matter in minutes like an artist painting a portrait on demand. However, they tend to neglect the fact that most business data is messy.

Nevertheless, data analysts are like artists in some ways, but instead of mixing painting and performing the right stroke, they cleanse data. It’s not really beautiful and can be a bit mundane. Furthermore, artists sometimes take hours to years to paint as well.

Here are some tips, I’ve gathered over the years that are transferable between languages and platforms, and which can help you become a better data cleaner. (Yes, not a data analyst)

--

--

Jason Huynh
Geek Culture

Christian. Loves using tech to make investing more efficient.