Business Data Analyst Interview Questions

708 business data analyst interview questions shared by candidates

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 661 - 670 interview questions

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