Novartis Analyst Interview Questions and Answers

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...read more
Answered by AI
Add your answer

Q1. Difference between Epi based forecasting and non-Epi based forecasting.
Add your answer
Q2. How to estimate market share with precision of a pipeline product. Different methodologies, their flaws and merits.
Ans. 
Estimating market share of a pipeline product involves using various methodologies with their own flaws and merits.
• One common method is using sales data from competitors and industry reports to estimate market size and then calculate the product's share.

• Another approach is conducting surveys or focus groups to gather customer feedback and preferences, which can help in estimating market share.

• Using predictive modeling ...read more
Answered by AI
Add your answer
Q3. Tell about different databases you have worked on ? Questions related to that specific database.
Add your answer

Market Estimation Case Study is given which tests a candidate understanding of the Pharma market, his technical skills, his aptitude and patience.

Q1. How do your previous collegaues gauge you? Postive and negative both.
Ans. 
My previous colleagues would likely gauge me as hardworking, reliable, and detail-oriented, but may also see me as overly focused on perfection.
• Colleagues would likely appreciate my strong work ethic and dedication to completing tasks efficiently.

• They may see me as reliable and someone they can depend on to deliver high-quality work consistently.

• Some colleagues may view me as overly focused on perfection, which could p...read more
Answered by AI
Add your answer
Q2. What value did you add to your previous team ?
Add your answer

Q1. Solve the data query.
Ans. 
The query requires a structured approach to analyze and interpret data effectively.
• Identify the data sources: e.g., databases, spreadsheets.

• Define the key metrics to analyze: e.g., sales growth, customer retention.

• Use data visualization tools: e.g., Tableau, Power BI for insights.

• Ensure data accuracy: e.g., validate data entries and sources.

• Present findings clearly: e.g., use charts and graphs for better understanding.
Answered by AI
Add your answer

Solve and present the case study

Q1. Salary discussion
Add your answer

Q1. Basic SQL to calculate ranks
Add your answer
Q2. Explain how does patient journey works
Add your answer

Q1. Basic Sql questions and some questions related to the role
Add your answer

Q1. Logical questions general aptitude related questions
Add your answer

Q1. With group head. No technical questions
Add your answer

Q1. Brief overview of SAP PP/ MM
Ans. 
SAP PP (Production Planning) and SAP MM (Materials Management) are modules in the SAP ERP system that help manage production processes and materials procurement.
• SAP PP focuses on planning and controlling the manufacturing process

• SAP MM deals with procurement and inventory management

• Integration between SAP PP and SAP MM ensures smooth production processes

• SAP PP includes functionalities like Bill of Materials (BOM) and W...read more
Answered by AI
Add your answer

Q1. Why do you want to start your career with Novartis?
Add your answer