
Unacademy Business Analyst Interview Questions
& Process
Real candidates share what happened, how many rounds they had,
and how the experience turned out.
Based on 5 interview experiences · FREE TO READ
Candidate interview experiences
First-hand accounts from people who interviewed at Unacademy.
Business Analyst
The hiring manager and team were great. HR did a good job coordinating things. The interviewer was supportive and the assignments were good. The whole interview process went smoothly, and I got quick responses. The team handling was very nice, and I received good assistance throughout.
- Tell me about your skills and efficiency.
Business Analyst
It was a SQL test, then a core technical round, followed by case studies and SQL. Somehow, I tried to answer all the questions, and in 4 mins I got a mail saying I wasn't selected. When I asked for feedback, they told me they'd tell me in 2 days. Without feedback from the interviewer, how are they rejecting? I think they had someone in mind and just interviewed for the sake of it.
- For case studies in the next round: Calculate daily, weekly, and monthly distinct users from a table.
- What is indexing in SQL?
- Is 'a left join b' the same output as 'b right join a'?
Business Analyst
This was the first round for the Business Analyst role at unacademy. The interviewer seemed unprepared throughout the whole interview. First, they asked questions outside the scope of the job description, making me wonder if the role involved ML, but they clarified it was more focused on Analytics than Data Science. Then, we discussed some projects from my resume, which went okay. The SQL part was confusing because the interviewer's questions were unclear. For the first SQL question, they asked for a solution using a function or self-join. I used a self-join, which they said was correct but noted a function could also be used. The second question was completely unclear to me, and the interviewer's explanation confused me. The third question asked for DAU, WAU, and MAU date-wise from the transactions table. My answer, which I later confirmed as correct, was met with 'I don't think this will work'. Overall, it was a bad and time-wasting interview with a lack of clarity and an unprepared, confused interviewer.
- Could you calculate the Daily Active Users (DAU), Weekly Active Users (WAU), and Monthly Active Users (MAU) on a date-wise basis from the transactions table?
Unacademy Business Analyst Interview Questions
Quoted word for word from Unacademy interview reports.
“Is 'a left join b' the same output as 'b right join a'?”
Read reports →“How to perform roll up sum in Python?”
Read reports →“What is the alternative to vlookup in SQL?”
Read reports →“What is indexing in SQL?”
Read reports →“Could you calculate the Daily Active Users (DAU), Weekly Active Users (WAU), and Monthly Active Users (MAU) on a date-wise basis from the transactions table?”
Read report →“With employee id, employee name, and manager id fields in a table, how will you add another field with the manager's name?”
Read report →“Explain window functions.”
Read report →“Every user has a credit score, which is mainly based on whether you decide the user will convert or not. How to decide the user's credit score so that if you give the data to the sales team, they will call the user and pitch about the product?”
Read report →“If revenue dipped by 10% in Unacademy, how would you find the solution?”
Read report →Formats, difficulty and experience
Across all 5 Unacademy interview reports.