Adroitent Business Analyst Interview Questions and Answers for Experienced

Sql and business metrics designing

Q1. Tell me a business problem that you solved
Ans. 
Implemented a data analytics solution to optimize inventory management and reduce costs
• Identified key factors affecting inventory levels and costs

• Developed a predictive model to forecast demand and optimize ordering quantities

• Implemented a dashboard for real-time monitoring of inventory levels and performance

• Collaborated with cross-functional teams to ensure successful implementation
Answered by AI
Add your answer
Q2. Youtube wants to open a new office, what factors would h consider
Ans. 
Factors to consider when opening a new office for Youtube
• Location - proximity to talent pool, access to transportation

• Cost - real estate prices, taxes, cost of living

• Market - target audience, competition in the area

• Infrastructure - availability of utilities, internet connectivity

• Regulations - local laws, permits required
Answered by AI
Add your answer

Q1. Problem situation given and what metrics would you design around it
Add your answer

Q1. SQL and business Analyst questions
Add your answer

Q1. Situation based questions SQL
Add your answer

Q1. Difference between FRD and BRD
Ans. 
FRD is Functional Requirement Document which specifies what the system must do. BRD is Business Requirement Document which specifies why the system must do it.
• FRD focuses on the technical aspects of the system functionality.

• BRD focuses on the business objectives and goals that the system must achieve.

• FRD is used by developers to understand the specific requirements of the system.

• BRD is used by stakeholders to understan...read more
Answered by AI
Add your answer
Q2. Explain user story writing experience
Ans. 
I have extensive experience in writing user stories to capture requirements and ensure clear communication between stakeholders and development teams.
• I have worked on various projects where I have written user stories to define features and functionalities from end user perspective.

• I have collaborated with product owners, developers, and other stakeholders to gather requirements and prioritize user stories.

• I have used ...read more
Answered by AI
Add your answer

Q1. The First Round is technical by the Project leader and the next round is situational and behavioral round by the director.
Add your answer

Q1. What are the different sections in FRD?
Ans. 
FRD (Functional Requirements Document) typically consists of sections like Introduction, Scope, Functional Requirements, Non-Functional Requirements, etc.
• Introduction: Provides an overview of the project and its objectives.

• Scope: Defines the boundaries of the project and what is included/excluded.

• Functional Requirements: Describes the specific functions the system must perform.

• Non-Functional Requirements: Specifies the...read more
Answered by AI
Add your answer

Q1. Context filters in tableau ?
Ans. 
Context filters in Tableau allow users to control the scope of the data being analyzed by defining specific filters for certain worksheets or dashboards.
• Context filters are used to limit the data being analyzed in Tableau to a specific subset.

• They can be applied to individual worksheets or entire dashboards.

• Context filters are useful for focusing on specific segments of data without affecting the overall analysis.

• They ...read more
Answered by AI
Add your answer
Q2. Difference between blending and join in tableau
Ans. 
Blending in Tableau combines data from multiple data sources on a single worksheet, while joining combines data from the same data source.
• Blending is used when data comes from different data sources, while joining is used when data comes from the same data source.

• Blending creates a relationship between data sources on a worksheet level, while joining creates a relationship at the data source level.

• Blending allows for c...read more
Answered by AI
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. About your work experience
Add your answer
Q3. Hr salary discussion
Add your answer

Q1. How to handle difficult stakeholders
Ans. 
Handling difficult stakeholders involves effective communication, building trust, managing expectations, and finding common ground.
• Listen actively to their concerns and try to understand their perspective

• Communicate clearly and regularly to keep them informed

• Build trust by delivering on promises and being transparent

• Manage expectations by setting realistic goals and timelines

• Find common ground by focusing on shared obj
Answered by AI
Add your answer
Q2. What are the Agile Ceremonies
Ans. 
Agile ceremonies are regular meetings or events in Agile methodology to facilitate communication, collaboration, and decision-making within the team.
• Sprint Planning: Meeting at the start of a sprint to plan the work to be done.

• Daily Stand-up: Short daily meeting for team members to discuss progress and plan for the day.

• Sprint Review: Meeting at the end of a sprint to review and demonstrate the completed work.

• Sprint Ret...read more
Answered by AI
Add your answer
Q3. What is BRD, FRD
Ans. 
BRD stands for Business Requirements Document and FRD stands for Functional Requirements Document.
• BRD outlines the business solution for a project, including the business needs and objectives.

• FRD details the functional requirements of a project, specifying what the system must do.

• BRD focuses on the 'what' of a project, while FRD focuses on the 'how'.
Answered by AI
Add your answer

Basic aptitude test required for analyst

Coding test consist of python,sql queries to test your logic for the problem

Q1. Salary discussion, negotiation, and other ability based question. Checking your team work capability
Add your answer
Q2. Shsjsjsksosksmsbsmzmzl
Add your answer