Roche Diagnostics Analytics Lead Interview Questions and Answers

It was a 90 mins round, and we have to do 85 questions. Coding was also a part of it.

Logical reasoning numerical English sum

Python power bi sql tablue

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. 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. BI and excel presentation on sales related data: all the questions were asked from the presentation only.
Add your answer
Q2. Why I am switching my job?
Add your answer

Q1. Process of aggregate in brief for all sections
Ans. 
Aggregate is the process of combining data from different sections into a single result.
• Aggregate functions are used to perform calculations on groups of rows to give a single result.

• Common aggregate functions include SUM, AVG, COUNT, MAX, and MIN.

• Aggregate queries often involve grouping data by certain criteria before applying the aggregate function.

• For example, calculating the total sales revenue by region or finding
Answered by AI
Add your answer

Q1. What is pv, and valid case criteria
Add your answer
Q2. Which are serious ness criteria?
Ans. 
Seriousness criteria are factors used to determine the severity of a situation or condition.
• Severity of symptoms

• Likelihood of complications

• Impact on daily functioning

• Potential for long-term consequences
Answered by AI
Add your answer