Novartis Analytics Manager Interview Questions and Answers

Q1. Project based discussion
Add your answer

Q1. Project based questions
Add your answer

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'
Answered by AI
Add your answer
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
Answered by AI
Add your answer

Q1. Nlp related stuff
Add your answer

17 questions including mcq, case study, sql coding

Q1. 10 quiz about ML questions, case study
Add your answer

Q1. Share details of your previous job.
Add your answer
Q2. Why are you looking for a change?
Add your answer
Q3. Tell me about yourself.
Add your answer

House price prediction

Q1. About data, data science and Pharma domain
Add your answer

Core values, Experience, Behavorial

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

Q1. Tell me about yourself How was last experience Data concepts basics
Add your answer
Q2. Checking confidence, fluent English, listening carefully
Add your answer