Merck Business Analyst Interview Questions and Answers

Q1. What is lamda function
Ans. 
Lambda function is an anonymous function in programming that can have multiple arguments but can only have one expression.
• Lambda functions are used for creating small, one-time use functions without the need to define a formal function.

• They are often used in functional programming languages like Python.

• Lambda functions can take any number of arguments, but can only have one expression.

• Example: lambda x: x*2 defines a l
Answered by AI
Add your answer
Q2. Difference between list and tuple
Ans. 
List is mutable, tuple is immutable in Python.
• List can be modified after creation, tuple cannot.

• List uses square brackets [], tuple uses parentheses ().

• List is used for collections of items that may change, tuple for fixed collections.

• Example: list_example = [1, 2, 3], tuple_example = (4, 5, 6)
Answered by AI
Add your answer

Q1. Explain your previous work experience
Add your answer
Q2. Explain with example how your work related to real life example
Add your answer

Q1. What are the basics of power bi
Ans. 
Power BI is a business analytics tool by Microsoft for visualizing and analyzing data.
• Power BI is a business analytics tool by Microsoft

• It allows users to visualize and analyze data from various sources

• Users can create interactive reports and dashboards

• Power BI offers a wide range of data connectors for seamless integration

• It provides features like data modeling, data preparation, and data visualization

• Power BI can be ...read more
Answered by AI
Add your answer

Q1. Basic introduction with HR on call
Add your answer

Q1. Technical questions with respect to SQL and SAS, complexity was easy to medium.
Add your answer

Q1. Manager asked during the final round regarding the job, your motivation to join the company, and about my role in previous organization.
Add your answer

Q1. Coding questions on python
Add your answer
Q2. Version control system GitHub questions
Add your answer
Q3. Web scraping questions
Add your answer

Q1. Behavioral questions on senarioy
Add your answer

Q1. Why did you choose to work at Pfizer?
Add your answer

Q1. Tell me about your project
Add your answer

Time management and organization skills

Q1. Questions related to Data analytics and SharePoint for my role.
Add your answer
Q2. Previous projects and their solutions.
Add your answer
Q3. Tool used in previous company. (SharePoint, Power BI, Nintex, InfoPath, Power Apps, Workflows)
Add your answer

Q1. Related to professional life and assurance to work.
Add your answer

Q1. Salary details and candidature check.
Add your answer

Q1. What time intelligence functions can be used for ytd and qtd analysis
Ans. 
Time intelligence functions like YTD (Year-to-Date) and QTD (Quarter-to-Date) can be used for YTD and QTD analysis in data analytics.
• YTD analysis can be done using functions like YTD() or TOTALYTD() to calculate values from the beginning of the year up to the selected date.

• QTD analysis can be done using functions like QTD() or TOTALQTD() to calculate values from the beginning of the quarter up to the selected date.

• Thes...read more
Answered by AI
Add your answer
Q2. Difference between import and direct query
Ans. 
Import brings data into Power BI for further analysis, while direct query connects to data source in real-time.
• Import: Data is loaded into Power BI for analysis, improving performance but requiring periodic refreshes.

• Direct Query: Connects to data source in real-time, allowing for up-to-date information but potentially slower performance.

• Import is suitable for smaller datasets, while direct query is better for large da
Answered by AI
Add your answer

Basic questions based on sql theories and excel

Assignment to solve excel sheets using advanced excel functions

Q1. Common interview questions, index match, self join, SQL theoretical questions ( types of join, union and union all , delete and truncate difference), data modelling using excel, count if, case study.
Add your answer

Q1. Previous experience and personal questions and tools knowledge
Add your answer

Q1. Salary discussion round
Add your answer