Pharmaace Analytics Interview Questions and Answers

30 mins basic aptitude questions

Q1. What is the role of AHA and how to revive a cardiac arrest ?
Add your answer
Q2. How will you analize a large data set using ETL?
Ans. 
I will use ETL (Extract, Transform, Load) process to analyze a large data set by extracting data from various sources, transforming it into a usable format, and loading it into a target database.
• Extract data from multiple sources such as databases, files, APIs, etc.

• Transform the data by cleaning, filtering, aggregating, and structuring it for analysis.

• Load the transformed data into a target database for further analysi...read more
Answered by AI
Add your answer
Q3. What is your pofeciancy in Excel
Ans. 
I am highly proficient in Excel, with advanced skills in data analysis, formulas, and pivot tables.
• Advanced knowledge of Excel functions and formulas

• Experience with creating complex spreadsheets for data analysis

• Proficient in using pivot tables for summarizing and analyzing data

• Skilled in data visualization using charts and graphs

• Familiarity with macros and VBA for automation tasks
Answered by AI
Add your answer

Q1. Health care related questions
Add your answer
Q2. Business strategies
Add your answer

Q1. Cumulative Sum in SQL
Ans. 
Cumulative sum in SQL is a running total of a column's values.
• Use the SUM() function with the OVER() clause to calculate the cumulative sum.

• The OVER() clause specifies the partitioning and ordering of rows for the calculation.

• Example: SELECT column_name, SUM(column_name) OVER (ORDER BY column_name) AS cumulative_sum FROM table_name;
Answered by AI
Add your answer
Q2. Case When in SQL
Add your answer

Q1. Background in pharma
Add your answer
Q2. How long in previous company
Add your answer