Deloitte Digital Business Analyst Interview Questions and Answers

Good and got time to keep my point

Q1. What is your weakness
Add your answer
Q2. How well you know python
Ans. 
I have a strong understanding of Python and have used it extensively in my previous projects.
• Proficient in Python programming language

• Experience in using Python for data analysis and visualization

• Familiar with popular Python libraries such as Pandas, NumPy, and Matplotlib

• Have developed scripts and automation tools using Python
Answered by AI
Add your answer

Q1. How many joins are in SQL?
Ans. 
The number of joins in SQL can vary depending on the complexity of the query.
• The number of joins in SQL can range from 0 (no joins) to multiple joins in a single query.

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• Joins are used to combine rows from two or more tables based on a related column between them.

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id;
Answered by AI
Add your answer
Q2. Explain about difference left and inner join? And scenarios questions
Add your answer

Q1. What is a user story and what all components make the user story complete.
Ans. 
A user story is a concise description of a feature told from the perspective of the end user.
• A user story typically follows the format: As a [type of user], I want [some goal] so that [some reason].

• User stories help capture the 'who', 'what', and 'why' of a feature in a simple and understandable way.

• Components of a user story include a title, narrative, acceptance criteria, and priority.

• Example: As a customer, I want t...read more
Answered by AI
Add your answer
Q2. Explain the difficult situation that you faced with stakeholders
Add your answer

Q1. As a business analyst how is your day-in and day-out responsibilities
Add your answer
Q2. How do validate ServiceNOw application ?
Ans. 
ServiceNow application can be validated through testing, documentation review, and user feedback.
• Perform functional testing to ensure all features work as expected

• Review documentation to confirm alignment with requirements

• Collect user feedback to identify any issues or improvements needed
Answered by AI
Add your answer

Basic questions related to aptitude

Case study for documentation

Q1. Questions related to project
Add your answer
Q2. What is your current role?
Add your answer
Q3. How to write user story
Ans. 
User stories are concise descriptions of a feature told from the perspective of the end user.
• Start with 'As a [type of user], I want [some goal] so that [some reason]'

• Focus on the user's needs and goals

• Keep it simple and specific

• Include acceptance criteria for clear understanding
Answered by AI
Add your answer
Q4. Scenarios based questions
Add your answer

Algorithms, blood relations and basic math and aptitude question

Q1. Explain more details on previous project
Add your answer

Easy, basic knowledge sufficient to clear the round

Easy basic coding knowledge sufficient to clear the round

Q1. Why opt for BI ?
Ans. 
BI helps in making data-driven decisions, improving efficiency, and gaining competitive advantage.
• BI provides valuable insights into business operations and performance.

• It helps in identifying trends, patterns, and opportunities for improvement.

• BI enables better decision-making by providing accurate and timely information.

• It allows for monitoring key performance indicators (KPIs) and tracking progress towards goals.

• BI ...read more
Answered by AI
Add your answer
Q2. Goals and ambitions in life
Add your answer

Q1. Asked about previous experience related to the BA, tools which i know or used, asked about Jira experience and difference between epic and userstory
Add your answer

Q1. Almost like round 1 about previous experiences, given some real time challenging questions
Add your answer

Q1. Package discussion
Add your answer

Q1. SQL queries with joins. How to do requirement gathering?
Ans. 
Requirement gathering involves identifying and documenting the needs and expectations of stakeholders.
• Identify stakeholders and their roles

• Conduct interviews and surveys

• Use techniques such as brainstorming and mind mapping

• Document requirements in a clear and concise manner
Answered by AI
Add your answer

Your past experience related questions.

Q1. Salary discussion and other HR related points.
Add your answer