Eli Lilly and Company Data Analyst Interview Questions and Answers

Q1. Explain about project in detail
Add your answer
Q2. How did you manage so much cgpa?
Ans. 
I managed a high CGPA through consistent hard work, effective time management, seeking help when needed, and staying organized.
• Consistent hard work by studying regularly and staying focused on academics

• Effective time management to balance studies, assignments, and extracurricular activities

• Seeking help from professors, tutors, or classmates when facing challenges

• Staying organized with study schedules, notes, and deadli
Answered by AI
Add your answer

Tableau Developer

I was given an assignment where I had to build dashboard with final story within 1 hour

Q1. Why Novo? Why this role?
Add your answer

Q1. Director Round with department head
Add your answer

Q1. Affiliate Round with either US folks or Denmark folks
Add your answer

Q1. What is your family background?
Add your answer
Q2. What are your strengths and weaknesses?
Add your answer
Q3. Tell me about yourself.
Add your answer
Q4. What are your salary expectations?
Add your answer

Q1. Tell us data science project where you developed a script for forecastings, KNN, Data science models with practical examples.
Ans. 
Developed a script for forecasting using KNN and data science models.
• Developed a script using Python to forecast sales for a retail company using KNN algorithm.

• Built a data science model to predict customer churn for a telecom company using logistic regression.

• Used time series analysis to forecast stock prices for a financial services company.

• Developed a script to predict the likelihood of a customer defaulting on a lo...read more
Answered by AI
Add your answer
Q2. 1. Why you are asking this role is for Data analyst or data scientist? 2. Don't go for the provided JD and do you think you are well aware of Data science concepts and models, algorithms etc.
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. Difference rank dense rank and rownumber
Ans. 
Rank, Dense Rank, and Row Number are window functions used in SQL to assign a rank to each row based on a specific criteria.
• Rank assigns a unique rank to each row based on the specified order.

• Dense Rank assigns a unique rank to each row without any gaps, even if there are ties.

• Row Number assigns a unique sequential integer to each row, without any regard to the order of the rows.
Answered by AI
Add your answer
Q2. Questions from join condition
Add your answer

Q1. Describe project done previously
Ans. 
Developed a predictive analytics model to forecast sales for a retail company
• Collected and cleaned historical sales data

• Used machine learning algorithms to analyze trends and patterns

• Built a forecasting model to predict future sales based on various factors

• Evaluated the model's performance and made adjustments for accuracy
Answered by AI
Add your answer