Eli Lilly and Company TPM 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. Have you make any Down payment
Ans. 
Yes, I have made a down payment on my car loan.
• Yes, I made a down payment of 20% on my car loan.

• The down payment helped lower my monthly payments.

• I saved up for the down payment over several months.
Answered by AI
Add your answer
Q2. Did you come across any situation like aging invoices pending to process and how you clear that
Add your answer

Q1. Difference between List and Tuple?
Ans. 
List is mutable, Tuple is immutable in Python.
• List can be modified after creation, Tuple cannot be modified

• List is defined using square brackets [], Tuple is defined using parentheses ()

• Example: list_example = [1, 2, 3], tuple_example = (4, 5, 6)
Answered by AI
Add your answer
Q2. Define a sales forecasting approach?
Ans. 
Sales forecasting approach is a method used to predict future sales based on historical data and market trends.
• Sales forecasting can be done using quantitative methods like time series analysis or qualitative methods like expert opinion.

• It involves analyzing past sales data, market trends, and other relevant factors to predict future sales.

• Different approaches include moving average method, exponential smoothing, regre...read more
Answered by AI
Add your answer

Sql coding + project discussion

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

Q1. All related to previous work experiences
Add your answer