Dentsu Aegis Network Business Analyst Interview Questions and Answers

Percentage,work and time

Q1. All questions were related to SQL and Context of the role
Add your answer
Q2. Joins, Unions and case scenario
Add your answer

Q1. Questions regarding BA documentation and deliverables
Add your answer
Q2. Questions related to customer retention and loyalty bonuses.
Add your answer

Q1. What is rank in sql .. kind of scenario based
Add your answer
Q2. Examples of with/ sub query in sql
Ans. 
Using subqueries in SQL allows for more complex queries by nesting queries within other queries.
• Subquery in SELECT statement: SELECT column_name FROM table_name WHERE column_name = (SELECT column_name FROM table_name)

• Subquery in WHERE clause: SELECT column_name FROM table_name WHERE column_name IN (SELECT column_name FROM table_name)

• Subquery in FROM clause: SELECT column_name FROM (SELECT column_name FROM table_name) A
Answered by AI
Add your answer

Q1. Tell about work experience
Add your answer
Q2. Details about skill set
Add your answer

Q1. Where do see yourself in 5 years?
Ans. 
In 5 years, I see myself as a senior business analyst leading a team and contributing to strategic decision-making.
• Leading a team of analysts

• Contributing to strategic decision-making

• Continuing professional development and certifications

• Possibly pursuing a management role

• Enhancing industry knowledge and expertise
Answered by AI
Add your answer
Q2. Why Epsilon? And why are you leaving your current organisation?
Ans. 
I am interested in Epsilon's innovative approach to data analytics and leaving my current organization for career growth opportunities.
• Epsilon's reputation for cutting-edge data analytics solutions

• Opportunity for career growth and development at Epsilon

• Excited about working with a new team and learning new skills
Answered by AI
Add your answer