Dream11 Business Analyst Interview Questions and Answers

1. Tell me about yourself
2. Estimate the number of hospitals in India

1. There has been a decrease in 20% of the users in the past 3 days in online pharmacy application, what will you do now?

Q1. Salary negotiation on what were last salary and related questions
Add your answer
Q2. How soon can you join?
Add your answer
Q3. Are you holding any other offer, in case you do..they will try to match it which ideally depends on your interview.
Add your answer
Q4. Are you comfortable relocating to the office location?
Add your answer

Q1. In this round basic SQL questions were asked.
Add your answer
Q2. In addition to SQL questions the business case study was discussed and some questions were asked around confusion metrics.
Add your answer

Q1. In this round two business case studies were discussed.
Add your answer

Q1. In this round basic HR questions related to my resume and profile were asked
Add your answer

20 questions in 20 mins

Given a topic to talk about among peers

Q1. Tell us about yourself
Add your answer
Q2. Why should we give you this job?
Ans. 
I bring a unique blend of analytical skills, industry knowledge, and a passion for problem-solving that aligns perfectly with your needs.
• Proven track record in data analysis: At my previous job, I improved reporting efficiency by 30% through automation.

• Strong communication skills: I effectively translated complex data insights into actionable strategies for stakeholders.

• Experience with industry-standard tools: Proficie...read more
Answered by AI
Add your answer

Q1. Can you describe a situation where you had a disagreement with your team members?
Ans. 
I faced a disagreement with my team on prioritizing project features, leading to a constructive discussion that improved our collaboration.
• Situation: We were working on a software project with tight deadlines.

• Disagreement: Team members wanted to prioritize different features based on their perspectives.

• My Approach: I suggested a meeting to discuss the pros and cons of each feature.

• Outcome: We used a voting system to pr...read more
Answered by AI
Add your answer
Q2. What are your most significant accomplishments?
Ans. 
Successfully led projects that improved efficiency and drove revenue growth through data-driven insights and stakeholder collaboration.
• Implemented a new data analytics tool that reduced reporting time by 30%, allowing the team to focus on strategic initiatives.

• Collaborated with cross-functional teams to streamline processes, resulting in a 15% increase in operational efficiency.

• Conducted market analysis that identified...read more
Answered by AI
Add your answer

Q1. Tell me about yourself.
Add your answer

Send assignment doings MS Excel

Q1. Asked about the previous project
Add your answer
Q2. What about your roles in previous company
Add your answer

Q1. Sql questions mostly about windows function, aggregate, using having clause in group, union vs union all, mostly basics about sql.
Add your answer
Q2. Power Bi questions - measures in powerbi, calculate, dashboard, excel vs powerbi.
Add your answer
Q3. Assesment 5 question based on sql and excel. Easy questions like second highest salary, manager salary, count a's.
Add your answer