Novartis Data Specialist Interview Questions and Answers

Logical reasoning numerical English sum

Python power bi sql tablue

Q1. How to handle noise in data
Add your answer

Q1. Difference rank dense rank and rownumber
Ans. 
Rank, Dense Rank, and Row Number are window functions used in SQL to assign a rank to each row based on a specific criteria.
• Rank assigns a unique rank to each row based on the specified order.

• Dense Rank assigns a unique rank to each row without any gaps, even if there are ties.

• Row Number assigns a unique sequential integer to each row, without any regard to the order of the rows.
Answered by AI
Add your answer
Q2. Questions from join condition
Add your answer

Q1. Why did you choose to work at Pfizer?
Add your answer

Q1. Tell me about your project
Add your answer

Time management and organization skills

Q1. Nlp related stuff
Add your answer

Q1. Asked about previous projects, mainly focusing around spark, redshift, glue
Add your answer

Q1. Excel shortcut keys?
Add your answer
Q2. WHAT IS THE ROLE OF DATA ANALYST?
Ans. 
Data Analysts are responsible for collecting, processing, and analyzing data to help organizations make informed decisions.
• Collecting and organizing data from various sources

• Cleaning and processing data to ensure accuracy and reliability

• Analyzing data to identify trends, patterns, and insights

• Creating visualizations and reports to communicate findings

• Providing recommendations based on data analysis

• Collaborating with st...read more
Answered by AI
Add your answer
Q3. What are the skills need for data analyst?
Ans. 
Skills needed for data analyst include strong analytical skills, proficiency in data analysis tools, programming knowledge, and communication skills.
• Strong analytical skills to interpret complex data sets

• Proficiency in data analysis tools such as Excel, SQL, Python, R, etc.

• Programming knowledge to manipulate and analyze data effectively

• Communication skills to present findings and insights to stakeholders
Answered by AI
Add your answer

17 questions including mcq, case study, sql coding

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