Data analyst interview questions and answers in English

B1 answer

I'm a data analyst. I have worked for a retail company for three years. I use SQL and spreadsheets every day, and I build dashboards for the sales team. I like finding answers in the data. Now I want to work with bigger datasets and learn more Python.

B2 answer

I've been a data analyst for three years in retail, where I support the sales and marketing teams. Most of my work is in SQL and a BI tool, and I've built around twenty dashboards that managers use every week. I've recently started using Python to automate reports, and I'd like to grow in a role with more advanced analysis, like this one.

B1 answer

I always liked maths at school. In my first job I was in the marketing team, and I made reports in spreadsheets. I enjoyed finding patterns in the numbers. My manager used my reports to make decisions, so I decided to study data analysis.

B2 answer

I studied economics, and my favourite part was always working with real numbers. In my first job, in marketing, I started building reports, and I noticed that my manager used them to make real decisions. That was exciting, so I took an online course in SQL and moved into an analyst role. I enjoy turning messy data into a clear answer.

B1 answer

First I think about what the manager needs to know. Then I use simple words and one clear chart, not big tables. I start with the main point, for example 'Sales fell in the north.' After that, I explain the reason and what we can do.

B2 answer

I start with the question the person asked, not with my method. First I give the main finding in one sentence, then I show one clear chart that supports it. I avoid technical words like 'regression' unless they ask. Finally, I suggest what to do next, because managers usually want a decision, not just numbers, and I always leave time for questions.

B1 answer

First I check where the data comes from. Then I look for missing values and duplicates. I compare the totals with another report. Before I send the report, I ask a colleague to check it. If something looks strange, I find out why.

B2 answer

I treat data cleaning as part of the analysis, not an extra step. First I check the source and look for missing values, duplicates and outliers. Then I compare my totals with a trusted report, for example last month's finance figures. Before I share anything, I do a sense check: do the numbers make sense for the business? For important reports, I ask a colleague to review my query.

B1 answer

Last year, the marketing team wanted to spend more money on social media ads. I looked at the data and I found that most new customers came from email. I showed this to the manager in a short report. In the end, they moved part of the budget to email, and sales went up.

B2 answer

Last spring, our marketing team planned to increase the social media budget. I wanted to check whether that spending was working, so I joined the campaign data with our sales data. I found that email brought in three times more paying customers for the same money. I presented this with two simple charts. As a result, they moved twenty percent of the budget to email, and new sales rose over the next quarter.

B1 answer

First I ask what decision the report is for. Then I agree on the most important numbers. I make a simple version first and I tell the manager about any limits in the data. Later, if they need more detail, I make a full report.

B2 answer

First, I ask what decision the report will support, because that tells me what really matters. Then I agree on a smaller scope, for example three key numbers instead of a full dashboard. I deliver a quick version on time and say clearly what I couldn't check yet. Afterwards, I follow up with a fuller report if it's still useful.

B1 answer

Once our weekly sales report showed a very big increase. It looked strange, so I checked the data. I found that some orders were counted twice. I had to fix it before the meeting. I corrected the query and told my manager. In the end, the report was right and we added an automatic check.

B2 answer

A few months ago, our dashboard suddenly showed a 40 percent jump in sales, which made no sense. I had to find the cause before the Monday meeting. I traced the problem to a system update that duplicated some orders, fixed the query and told my manager what had happened. As a result, the directors saw the correct numbers, and we now run an automatic duplicate check every night.

B1 answer

Yes. Which tools does the analytics team use? And who are the main users of the reports?

B2 answer

Yes, two. What does a typical week look like for an analyst here, between planned projects and ad hoc requests? And which teams would I work with most closely?