Procter & Gamble Data Scientist Interview Questions and Answers

Data Science MCQ questions

Building a baseline ML model with EDA etc.

Q1. How do you analyse outliers?
Ans. 
Outliers can be analyzed using statistical methods like Z-score, IQR, or visualization techniques like box plots.
• Calculate Z-score and identify data points with Z-score greater than a certain threshold as outliers.

• Use Interquartile Range (IQR) to detect outliers by identifying data points outside 1.5 * IQR range.

• Visualize data using box plots to identify any data points that fall outside the whiskers.

• Consider domain kn...read more
Answered by AI
Add your answer
Q2. Tell me about a time when what you found did not match expectation with what you thought analysing the dataset.
Add your answer

Q1. Why Unilever now?
Add your answer
Q2. Where do you see yourself in 5 years?
Add your answer

Q1. Intro about yourself and role
Add your answer

Q1. Details of work done
Add your answer

Q1. Skill set should be clear
Add your answer

Q1. What time intelligence functions can be used for ytd and qtd analysis
Ans. 
Time intelligence functions like YTD (Year-to-Date) and QTD (Quarter-to-Date) can be used for YTD and QTD analysis in data analytics.
• YTD analysis can be done using functions like YTD() or TOTALYTD() to calculate values from the beginning of the year up to the selected date.

• QTD analysis can be done using functions like QTD() or TOTALQTD() to calculate values from the beginning of the quarter up to the selected date.

• Thes...read more
Answered by AI
Add your answer
Q2. Difference between import and direct query
Ans. 
Import brings data into Power BI for further analysis, while direct query connects to data source in real-time.
• Import: Data is loaded into Power BI for analysis, improving performance but requiring periodic refreshes.

• Direct Query: Connects to data source in real-time, allowing for up-to-date information but potentially slower performance.

• Import is suitable for smaller datasets, while direct query is better for large da
Answered by AI
Add your answer