Business Data Analyst Interview Questions

720 business data analyst interview questions shared by candidates

What kind of data would I collect to answer a specific business problems (presented in the interview). How would I analyze the data I suggested collecting (which graphs to plot). Given a mock graph of the data, how would I interpret it and what would I do to better understand it
avatar

Business Data Analyst

Interviewed at Moon Active

4
Feb 18, 2025

What kind of data would I collect to answer a specific business problems (presented in the interview). How would I analyze the data I suggested collecting (which graphs to plot). Given a mock graph of the data, how would I interpret it and what would I do to better understand it

There was a short phone interview to check general fit, followed by a home assignment that was open for 2.5 hours. The first part was an Excel question (1 hour) where they described an application, provided raw data, and asked to choose 2–3 KPIs, calculate them, and analyze the results—explaining what insights can be drawn and why. The second part (1 hour) was a similar task, but with three Excel tabs containing additional graphs, again requiring KPI selection and analysis. After that, there was a 12-minute video question where I needed to explain the analysis I performed in the first two tasks. Finally, there was an SQL question, which was relatively straightforward.
avatar

Business Data Analyst

Interviewed at Moon Active

4
Aug 5, 2025

There was a short phone interview to check general fit, followed by a home assignment that was open for 2.5 hours. The first part was an Excel question (1 hour) where they described an application, provided raw data, and asked to choose 2–3 KPIs, calculate them, and analyze the results—explaining what insights can be drawn and why. The second part (1 hour) was a similar task, but with three Excel tabs containing additional graphs, again requiring KPI selection and analysis. After that, there was a 12-minute video question where I needed to explain the analysis I performed in the first two tasks. Finally, there was an SQL question, which was relatively straightforward.

Viewing 681 - 690 interview questions

Glassdoor has 720 interview questions and reports from Business data analyst interviews. Prepare for your interview. Get hired. Love your job.