What’s It Actually Like To Be A Data Analyst?

Tom Taylor

Ever wondered what a data analyst does with their day? Keen to find out what it’s actually like to be a data analyst? We certainly were curious. We sat down with our friend Radi, who works at CENTOGENE in Berlin, to get the lowdown on life as a data analyst.

We touched upon a range of topics; from why he got into data analytics, to how his background helped him in his current work. We also got a fascinating insight into his particular role within his company, and the tools he uses on a daily basis.

If hearing about Radi’s life as a data analyst has made you think ‘I could do this job!”, then why not get a taste by actually doing some data analytics? As part of our Intro to Data Analytics Course, you’ll focus on Microsoft Excel—a key tool in analytics— and get a crash course in analyzing data over 10 exercises.

But without further ado, let’s meet Radi!

Our questions for Radi

  1. A background in data science
  2. A day in the life of a data analyst
  3. A career in data analytics and the future

1. A background in data science

What drew you to the world of data analytics?

Before I started working in the field, my understanding was that data analysis is used by companies to target specific consumers, or as a way for companies like Facebook and Google to “enhance the user experience” by targeting adverts based on browsing habits.

My opinions changed once I started working for my current company, which uses data analysis for a good cause. My company analyzes DNA related data in young people to predict future diseases such as Alzheimer’s, Diabetes, Crohn’s, and many more. This really changed my perspective on data analysis and made me feel like I’m making an actual difference in the world.

How has your background in computer science helped you?

To work as a data analyst, you need to master at least one of the main programming languages. The analysis for our medical data is done by an AI software that we built and continue to improve using two programming languages: R and Python. These are powerful statistical programming languages used to perform advanced analyses and predictive analytics on big data sets. They’re both standard languages in data analytics, and my computer science studies in university certainly gave me a good grounding in the languages from which I’ve built on.

Data analysts in the workplace

In your words, what do data analysts do?

I like to think of a data analyst as a ‘translator’. It’s someone who is capable of translating numbers into plain English in order for a company to improve their business. Personally, my role as a data analyst involves collecting, processing, and performing statistical data analysis to help my company improve their product.

What do you like about being a data analyst?

What I like most about my current job is working with high-end AI software that analyzes DNA sequencing. It’s such a complex task and I’ve always liked puzzles. It takes a lot of creativity and problem-solving skills to be able to think outside of the box and find new solutions. I like being challenged, and I love the thrill of finding a solution to a problem that we spent months trying to solve. It’s that sense of accomplishment that makes me love my job.

2. A day in the life of a data analyst

Can you walk us through a typical day at work?

Usually, my day doesn’t start until I’ve finished my first cup of coffee. It’s not about the caffeine as much as it is a ritual of getting into “the zone” before I start working with massive amounts of medical data.

A typical day usually includes, but is not limited to, meetings with the analytics team to discuss the tasks of the day and brainstorm for possible solutions. When everything is clear, I start working on the data. Analyzing data consists of three main tasks: gathering the data, cleaning the data, and finally processing the data.

Depending on the problem I’m working on, gathering data is usually the most simple part of the process, because the medical databases I work with are easily accessible—and I don’t have to worry about searching for it. Cleaning the data, which is the next step, simply means going through the data and trying to understand it, making corrections where needed such as moving outliers or data that should not be included in the analysis. This step can take a lot of time, but understanding the data is crucial in order for me to start processing the data.

The data processing part of the process is where I get to use my programming skills, which I use alongside several different data tools. I use these skills and tools to analyze the work and come up with solutions for the problem at hand.

What are a data analyst’s responsibilities?

My role involves:

  • Gathering data
  • Cleaning data
  • Processing data
  • Producing reports
  • Spotting patterns
  • Collaborating with others and setting up infrastructure

How much of a role does data cleansing play in your processes?

Cleaning data is a very important process because you need to recognize which data should stay and which should not. Including incorrect data while processing it might give you the wrong results, which in turn can lead to coming up with the wrong solutions. You then have to repeat your work, which is a waste of your time.

How often do you meet with stakeholders to discuss business needs and new things to analyze?

Personally, I don’t have to meet with any stakeholders, that’s the job of my team members. The only people I collaborate with are the analytics team because we need to keep each other updated on how things are going.

What are your experiences with Excel?

While Excel is a powerful tool in data analysis, it still has a lot of serious limitations. Excel cannot handle datasets above a certain size, and does not easily allow for reproducing previously conducted analyses on new datasets. The main weakness of such programs is that it was developed for very specific uses, and do not have a large community of contributors constantly adding new tools. Which is why I prefer using and R and Python.

Tell us more about R and Python!

R and Python are the two most popular programming languages used by data analysts and data scientists. Both are free and open source. R is used for statistical analysis, and Python is a general-purpose programming language. For anyone interested in machine learning, working with large datasets, or creating complex data visualizations, they are both godsends.

To go into a bit more detail, R is one of the most frequently used tools in data science and machine learning. Over the last few years R has become the golden child of data science. It’s used frequently to unlock patterns in large blocks of data and was designed by people like me, statisticians, to make our work easier. It one of the most must-know programming languages in the field of data analytics and data science.

Python is also one of the most popular languages in data analysis. Since my job deals with machine learning, artificial intelligence (AI) and predictive analytics, Python is an ideal language because it’s widely used in scientific computing, data mining, and others.

What steps do you take when beginning a new analytics project and how do you know if you’re asking the right questions and performing the right analysis?

Usually, for my work, there are certain logical steps that I follow to reach the desired outcome. Sometimes it’s not very straightforward, and that’s when meetings with the analytics team come in handy. As long as everything seems to run smoothly, then you’re most likely on the right path.

Logical thinking is the main process involved. I learned mathematical logic in school and that really helps when it comes to connecting the dots and making educated conclusions regarding the data that’s being processed.

How important do you think having a familiarity with the industry you’re working in is?

Understanding of the inner workings, processes, procedures and other key aspects of a company is a very important thing when it comes to data analytics. It would have been really hard for me to do my job in the medical sector if I didn’t have the relevant background experience. Thankfully, in addition to my education in computer science and graphic design, I have a background in chemistry and biology which definitely help when it comes to analyzing DNA sequences.

3. Having a career in data analytics and what the future holds

Where can you see data analytics heading in the future?

Data analytics IS the future, and the future is NOW!

All the actions you do on your computer, smartphone or tablet are recorded and collected by a data analyst somewhere who is trying to make their business flourish. That’s right—every mouse click, keyboard button press, swipe or tap is used to shape business decisions. Everything is about data these days. Data is information and information is power. I don’t want to get political, but the more ‘data’ you have on someone, the more you can control their lives.

Where do you see yourself in 5 years?

Honestly, I don’t know. A year ago, I couldn’t have imagined living and working in Berlin, but here I am, and it’s the same regarding my work. As long as the effort I put into my work is worth the reward then I will keep doing it until it’s not. And fortunately, my education in computer science and graphic design will always be in demand, so I try not to worry about the future and just enjoy the moment for now.

What does career progression in data analytics look like?

There are various professional possibilities that people in data analytics can aim for.

Some of these possibilities are, but not limited to:

  • Data Management Professional
  • Data Engineer
  • Business Analyst
  • Machine Learning Researcher/Practitioner
  • Data-oriented Professional

But of course, each one of these categories can branch out to subcategories which can open up more career opportunities.

What impact do you want your skill to have on the world?

If I wasn’t convinced that my current work is important for improving peoples’ lives, then I would have kept my old job as a graphic designer. I believe that what we do will someday eliminate or find a cure for many of the diseases that are incurable at the moment, and the thought itself makes me feel like I’m helping in creating a better world.

Thanks for sparing the time to give us an insight into what it’s like to be a data analyst, Radi! If hearing about Radi’s life as a data analyst has got you interested in pursuing it as a career yourself, you might now be wondering: Am I a good fit for a career as a data analyst? If so, check out this guide. You can also get a feel for what it’s like to work as a data analyst in this free introductory short course—or take a look at some of our other articles on the topic:

What You Should Do Now

  1. Get a hands-on introduction to data analytics with a free, 5-day data analytics short course.

  2. Take part in one of our live online data analytics events with industry experts.

  3. Talk to a program advisor to discuss career change and find out if data analytics is right for you.

  4. Discover how to become a qualified data analyst in just 4-7 months—complete with a job guarantee.