Ahex Technologies Business Analyst Interview Questions and Answers

Q1. Components of BRD, FRD
Ans. 
BRD and FRD are key documents in business analysis.
• BRD stands for Business Requirements Document.

• FRD stands for Functional Requirements Document.

• BRD defines the business needs and objectives of a project.

• FRD outlines the specific functionalities and features required to meet those needs.

• BRD focuses on the 'what' of a project, while FRD focuses on the 'how'.

• BRD includes sections like project scope, stakeholders, busines...read more
Answered by AI
Add your answer
Q2. User story format and acceptance criteria format
Add your answer

Q1. How do you handle conflicting stockholder requirements n a project?
Ans. 
I prioritize stakeholder requirements through effective communication, negotiation, and alignment with project goals.
• Identify and document all stakeholder requirements to understand the full scope.

• Facilitate meetings to discuss conflicting requirements and encourage open dialogue.

• Use prioritization techniques, such as MoSCoW (Must have, Should have, Could have, Won't have), to assess the importance of each requirement.

• ...read more
Answered by AI
Add your answer

SQL Test with 5 questions

Q1. Approach towards solving the SQL Queries from the test
Add your answer
Q2. Past Experiences
Add your answer

Q1. Resume related Questions
Add your answer
Q2. Power BI and SQL related questions. How to approach in a dashboard building process
Add your answer

Q1. VB and QTP basics
Add your answer
Q2. How to create a TSR file?
Ans. 
A TSR file can be created using a text editor or a software program that supports saving files in the TSR format.
• Use a text editor like Notepad or a software program like Turbo Pascal to write the code for the TSR program.

• Save the file with a .tsr extension to create the TSR file.

• Compile the code if necessary before saving it as a TSR file.
Answered by AI
Add your answer
Q3. How to automate windows componenets
Ans. 
Windows components can be automated using scripting languages like PowerShell or batch files.
• Use PowerShell scripts to automate tasks such as installing software or configuring settings.

• Utilize batch files to automate repetitive tasks like file management or system maintenance.

• Explore the Windows Task Scheduler to schedule automated tasks to run at specific times or events.
Answered by AI
Add your answer
Q4. Remoe automation
Add your answer

Q1. Behavioral questions
Add your answer

Q1. What experience do you have in this role?
Add your answer
Q2. What tools or technologies are you comfortable using?
Ans. 
I am proficient in various data analysis tools, including Excel, SQL, Python, and visualization software like Tableau.
• Excel: Advanced functions, pivot tables, and data visualization.

• SQL: Writing complex queries for data extraction and manipulation.

• Python: Utilizing libraries like Pandas and NumPy for data analysis.

• Tableau: Creating interactive dashboards for data visualization.

• R: Statistical analysis and data visualiza
Answered by AI
Add your answer

Q1. What is the pivot table in Excel
Ans. 
A pivot table in Excel is a data summarization tool that allows you to reorganize and summarize selected columns and rows of data.
• Allows users to summarize and analyze large datasets

• Can easily reorganize data by dragging and dropping fields

• Provides options to calculate sums, averages, counts, etc. for data

• Helps in creating interactive reports and charts

• Useful for identifying trends and patterns in data
Answered by AI
Add your answer
Q2. A pivot table is used to summarize...........etc.
Add your answer

Q1. They don’t take interview and they just ask money for for entering and never provide you job
Add your answer
Q2. They just fooling people
Add your answer
Q3. They are fake and unprofessional
Add your answer
Q4. They provide my salary and then I ended my month and they did not gave me my salary
Add your answer
Q5. Dynpro is fake company who provide the fake job and salary slips
Add your answer