AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Roche Diagnostics Data Analyst Interview Questions and Answers
Roche Diagnostics Data Analyst Interview Experiences
2 interviews found
Anonymous
(2 Questions)
- Q1. Explain example of window function
- Ans.
Window functions are used to perform calculations across a set of table rows related to the current row.
Window functions are used in SQL to perform calculations within a specific window or subset of rows.
They allow you to perform aggregate functions like SUM, AVG, COUNT, etc. over a specific range of rows.
Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().
- Q2. A question using aggregate function and case when in sql
Interview Preparation Tips
(2 Questions)
- Q1. Do you know adobe analytics
- Ans.
Yes, I am familiar with Adobe Analytics and have experience using it for data analysis.
I have used Adobe Analytics to track website traffic and user behavior
I have created custom reports and dashboards using Adobe Analytics
I am proficient in extracting insights from Adobe Analytics data to drive business decisions
- Q2. Explain example of window function
- Ans.
Window functions are used to perform calculations across a set of table rows related to the current row.
Window functions are applied to a set of rows related to the current row in a query result.
They can be used to calculate running totals, averages, ranks, and more.
Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().
Interview Preparation Tips
Top trending discussions
Interview questions from similar companies
ANIRUDH Jagtap
(1 Question)
- Q1. About your self
I applied via Approached by Company and was interviewed in Mar 2024. There was 1 interview round.
(2 Questions)
- Q1. BI and excel presentation on sales related data: all the questions were asked from the presentation only.
- Q2. Why I am switching my job?
Interview Preparation Tips
- Power Bi
- Advanced Excel
- sales data
I applied via Recruitment Consulltant and was interviewed before May 2021. There were 4 interview rounds.
(3 Questions)
- Q1. Questions related to Data analytics and SharePoint for my role.
- Q2. Previous projects and their solutions.
- Q3. Tool used in previous company. (SharePoint, Power BI, Nintex, InfoPath, Power Apps, Workflows)
(1 Question)
- Q1. Related to professional life and assurance to work.
(1 Question)
- Q1. Salary details and candidature check.
Interview Preparation Tips
Nishant Deswal
I applied via Campus Placement
It was a 90 mins round, and we have to do 85 questions. Coding was also a part of it.
Selected
I applied via Recruitment Consulltant and was interviewed in Oct 2024. There were 2 interview rounds.
Logical reasoning numerical English sum
Python power bi sql tablue
Interview Preparation Tips
- Python
- SQL
- Power Bi
- Tablu
I applied via Naukri.com and was interviewed in May 2024. There were 2 interview rounds.
(2 Questions)
- 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
- 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)
(2 Questions)
- Q1. Explain your previous work experience
- Q2. Explain with example how your work related to real life example
Interview Preparation Tips
Skills evaluated in this interview
ROHIT JAIN
(1 Question)
- 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 ...
Skills evaluated in this interview
I applied via LinkedIn and was interviewed in Nov 2021. There were 5 interview rounds.
Interview Questionnaire
1 Question
- Q1. Excel and SQL
Interview Preparation Tips
Roche Diagnostics Interview FAQs
Tell us how to improve this page.
Roche Diagnostics Interviews By Designations
- Roche Diagnostics Technical Lead Interview Questions
- Roche Diagnostics Data Analyst Interview Questions
- Roche Diagnostics Executive Accountant Interview Questions
- Roche Diagnostics Territory Manager Interview Questions
- Roche Diagnostics Analyst Interview Questions
- Roche Diagnostics Engineering Manager Interview Questions
- Roche Diagnostics Summer Intern Interview Questions
- Roche Diagnostics Intern Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
Roche Diagnostics Data Analyst Interview Process
based on 2 interviews
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
Roche Diagnostics Data Analyst Reviews and Ratings
based on 3 reviews
Rating in categories
|
Zonal Manager
29
salaries
|  ₹13.2 L/yr - ₹26 L/yr |
|
Analyst
26
salaries
| ₹5.7 L/yr - ₹11 L/yr |
|
Senior Analyst
26
salaries
| ₹9 L/yr - ₹19.1 L/yr |
|
Area Sales Manager
19
salaries
| ₹11 L/yr - ₹16 L/yr |
|
Service Engineer
18
salaries
| ₹3.6 L/yr - ₹12 L/yr |
Sanofi
AstraZeneca
Apotex Research
Otsuka Pharmaceutical India Private Limited
- Home >
- Interviews >
- Roche Diagnostics Interview Questions >
- Roche Diagnostics Data Analyst Interview Questions
