Waters Corporation Business Analyst Interview Questions and Answers

Q1. CALCULATE function from DAX.
Ans. 
The CALCULATE function in DAX is used to apply filters to a calculation in a formula.
• CALCULATE function modifies the filter context for a calculation in DAX.

• It can be used to override existing filters or apply new filters.

• Example: CALCULATE(SUM(Sales[Amount]), Sales[Region] = 'North')
Answered by AI
Add your answer
Q2. What are data structure?
Ans. 
Data structures are ways of organizing and storing data in a computer so that it can be accessed and used efficiently.
• Data structures define the way data is stored, accessed, and manipulated in a computer program.

• Examples of data structures include arrays, linked lists, stacks, queues, trees, and graphs.

• Choosing the right data structure is crucial for optimizing the performance of a program.
Answered by AI
Add your answer

Q1. Basic round vfffvbjj
Add your answer

Q1. SQL , business analyst related queries
Add your answer

Q1. With the manager
Add your answer

Q1. Salary round vffscbb
Add your answer

Q1. Final hr discussion
Add your answer

Q1. First round of interview was a simple technical and HR round where mostly questions were related to the description in resume and expertise. Some basic questions related to BA, Agile and Excel were asked. ...read more
Add your answer
Q2. Agile ceremonies, Vlook up and it's demerit.
Ans. 
Agile ceremonies and Vlook up's demerit
• Agile ceremonies are regular meetings held in Agile methodology to ensure effective communication and collaboration among team members.

• Vlook up is a function in Excel used to search for a specific value in a table and return a corresponding value.

• The demerit of Vlook up is that it only searches for exact matches and cannot handle errors or inconsistencies in data.

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

Q1. It went on for more than an hour. Questions were related to Healthcare domain, Agile and scrum, SQL, Excel, Business Analysis. Almost tried answering every questions. Mostly I was 80-85% satisfied with my...read more
Add your answer

Q1. Self introduction
Add your answer

Basic aptitude test , more focused on reasoning and problem solving skills.

Q1. Good experience, in total 3 problem solving based questions with some other basic questions such as tell me about yourself , what do you know about iqvia , etc
Add your answer
Q2. There 12 identical cubes out of which 1 is defective ( heavier or lighter ) . If you were given with a weight balance , in how many minimum rounds you can identify the defective cube?
Ans. 
Identify the defective cube out of 12 identical cubes using a weight balance in minimum rounds.
• Divide the cubes into three groups of four each.

• Weigh two groups against each other.

• If they balance, the defective cube is in the third group.

• If they don't balance, take the heavier group and weigh two cubes against each other.

• If they balance, the defective cube is the remaining cube.

• If they don't balance, the heavier cube is
Answered by AI
Add your answer

Q1. Good round , more of a combination of hr and technical .
Add your answer

Q1. Basic discussion regarding role and responsibilities .
Add your answer

Q1. Outcome of joins
Ans. 
Joins in SQL combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column between them.

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

• INNER JOIN returns rows when there is at least one match in both tables.

• LEFT JOIN returns all rows from the left table and the matched rows from the right table.

• R...read more
Answered by AI
Add your answer
Q2. Types of joins in sql
Ans. 
Types of joins in SQL include inner join, outer join, left join, right join, and full join.
• Inner join: Returns rows when there is a match in both tables

• Outer join: Returns all rows when there is a match in one of the tables

• Left join: Returns all rows from the left table and the matched rows from the right table

• Right join: Returns all rows from the right table and the matched rows from the left table

• Full join: Returns r
Answered by AI
Add your answer