AstraZeneca Analyst Interview Questions and Answers

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 and 2 coding questions

The first round had aptitude,logical reasoning questions. There were three coding question of which I remember Jump Game IV.

Q1. They started off with a brief introduction of myself and then asked questions regarding my projects.And this went on - mainly based on projects.
Add your answer

Sql coding + project discussion

Q1. Share your excel experience
Ans. 
Proficient in Excel with experience in data analysis, pivot tables, and VLOOKUP functions.
• Experience in creating complex formulas and macros to automate tasks

• Skilled in data visualization using charts and graphs

• Familiar with advanced functions such as INDEX-MATCH and conditional formatting
Answered by AI
Add your answer
Q2. How will you resolve conflict
Ans. 
I will address conflicts by actively listening, understanding all perspectives, and facilitating open communication to find a mutually beneficial solution.
• Actively listen to all parties involved to understand their perspectives

• Encourage open communication and dialogue to address underlying issues

• Seek common ground and find a mutually beneficial solution

• Mediate discussions and facilitate conflict resolution

• Use problem-s
Answered by AI
Add your answer

Q1. Questions were asked from excel and sql .
Add your answer

Q1. Basic to advance sql related
Add your answer