AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Eli Lilly and Company Senior Data Analyst Interview Questions and Answers
Eli Lilly and Company Senior Data Analyst Interview Experiences
1 interview found
Adithya pythireddi
(2 Questions)
- Q1. Using sql extract substring of name
- Ans.
Using SQL to extract substring of name
Use the SUBSTRING function in SQL to extract a specific portion of a string
Specify the starting position and length of the substring to be extracted
Example: SELECT SUBSTRING('John Doe', 1, 4) AS First_Name will return 'John'
- Q2. Using sql print cummulative sum of sales
- Ans.
Use SQL to print cumulative sum of sales
Use the SUM() function to calculate the cumulative sum of sales
Utilize the OVER() clause with ORDER BY to specify the order of the cumulative sum
Example: SELECT date, sales, SUM(sales) OVER (ORDER BY date) AS cumulative_sales FROM table_name
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Tableau Developer
I was given an assignment where I had to build dashboard with final story within 1 hour
(1 Question)
- Q1. Why Novo? Why this role?
(1 Question)
- Q1. Director Round with department head
(1 Question)
- Q1. Affiliate Round with either US folks or Denmark folks
(4 Questions)
- Q1. What is your family background?
- Q2. What are your strengths and weaknesses?
- Q3. Tell me about yourself.
- Q4. What are your salary expectations?
Interview Preparation Tips
I applied via Company Website and was interviewed in Feb 2024. There were 3 interview rounds.
(1 Question)
- Q1. Why did you choose to work at Pfizer?
(1 Question)
- Q1. Tell me about your project
Time management and organization skills
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
Data Analyst Interview Questions & Answers
Akums Drugs & Pharmaceuticals Limited
Anonymous
posted on 20 Dec 2024
Selected
(1 Question)
- Q1. How to handle noise in data
Data Analyst Interview Questions & Answers
Akums Drugs & Pharmaceuticals Limited
Priyansh Goel
posted on 19 Nov 2023
(1 Question)
- Q1. Tell me about all your Candidature Background.
(1 Question)
- Q1. Salary Negotiation
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. HR interview , manager interview,case studies (this was actually data based case study. You will have data in excel sheet you need to answer the question using charts and other insights)
Interview Preparation Tips
I applied via Company Website and was interviewed before Jun 2021. There were 3 interview rounds.
(1 Question)
- Q1. It was very cool and the recruiter was very energetic.
Business usecases technical discussion and written test
(1 Question)
- Q1. Professional experiences
Interview Preparation Tips
Selected
I applied via LinkedIn and was interviewed before Aug 2023. There were 2 interview rounds.
There was an assignment which needed basic excel skills.
(1 Question)
- Q1. Journal Entries
Interview Preparation Tips
It was Ashwini K and Yukti Agarwal who took my interview. I felt them intentionally trying to bully and insult me for each point that i speak right from the beginning of the interview. These happened once they got to know of my salary expectation, which was a standard 35% of my CCTC, which was agreed by the HR before the call was scheduled. The interview didn’t start with any kind of formal introduction from their side, instead the first point they started with asking my CCTC and my ECTC post which the insulting session started.
I wouldn’t suggest anyone reading this to sit for an interview with Novo Nordisk if its with the same panel. Questions asked was very irrelevant to the role and it felt very intentional. I would especially like to highlight Ashwini K’s behaviour to be very casual and unprofessional, and her knowledge is very limited.
I am glad that i have withdrawn myself in advance than proceeding further with my candidature with Novonordisk as i believe currently i am in a much better place than being in a company that doesn’t know to respect its people.
I applied via Naukri.com and was interviewed in Apr 2021. There were 3 interview rounds.
Interview Questionnaire
4 Questions
- Q1. Key roles , responsibilities and initiatives taken during the journey in the organization
- Q2. Any certified support the process or the project
- Q3. Strength and weaknesses
- Q4. Changes in KPI every quarter
- Ans.
Changes in KPI every quarter - how to handle?
Understand the reason for the changes
Analyze the impact on business goals
Communicate the changes to stakeholders
Adjust strategies and plans accordingly
Track and measure the new KPIs
Continuously evaluate and improve
Examples: sales targets, customer satisfaction, employee retention
Interview Preparation Tips
Eli Lilly and Company Interview FAQs
Tell us how to improve this page.
Eli Lilly and Company Interviews By Designations
- Eli Lilly and Company Associate Consultant Interview Questions
- Eli Lilly and Company Analyst Interview Questions
- Eli Lilly and Company Associate Manager Interview Questions
- Eli Lilly and Company Data Scientist Interview Questions
- Eli Lilly and Company Consultant Interview Questions
- Eli Lilly and Company Senior Associate Manager Interview Questions
- Eli Lilly and Company Software Engineer Interview Questions
- Eli Lilly and Company Data Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Data Scientist Interview Questions
- Data Analyst Intern Interview Questions
- Senior Data Scientist Interview Questions
- Data Science Intern Interview Questions
- Associate Data Analyst Interview Questions
- Data Analyst Interview Questions
- Jr. Data Scientist Interview Questions
- Associate Data Scientist Interview Questions
- Show more
Eli Lilly and Company Senior Data Analyst Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
Eli Lilly and Company Senior Data Analyst Reviews and Ratings
based on 1 review
Rating in categories
|
Senior Associate Manager
228
salaries
|  ₹9 L/yr - ₹30.1 L/yr |
|
Associate Consultant
171
salaries
| ₹10.7 L/yr - ₹25.7 L/yr |
|
Associate Manager
163
salaries
| ₹8.1 L/yr - ₹21.5 L/yr |
|
Consultant
115
salaries
| ₹21 L/yr - ₹41 L/yr |
|
Senior Associate Consultant
111
salaries
| ₹15.4 L/yr - ₹34 L/yr |
Hetero
Viatris
Abbott
Akums Drugs & Pharmaceuticals Limited
- Home >
- Interviews >
- Eli Lilly and Company Interview Questions >
- Eli Lilly and Company Senior Data Analyst Interview Questions
