OPPO Data Analyst Interview Questions and Answers

Q1. Couple of leetcode medium questions (i think it was around 3 questions) and they had their own platform
Add your answer

Q1. Tell me about the project you have worked recently
Ans. 
Developed a predictive analytics model to forecast customer churn for a telecom company
• Used Python and SQL to clean and analyze customer data

• Implemented machine learning algorithms such as logistic regression and random forest

• Evaluated model performance using metrics like accuracy, precision, and recall
Answered by AI
Add your answer
Q2. What kind of forecasting have you done
Ans. 
I have experience in time series forecasting using statistical models and machine learning algorithms.
• Utilized ARIMA model to forecast sales data for a retail company

• Implemented Prophet algorithm to predict stock prices for a financial institution

• Used LSTM neural network for demand forecasting in supply chain management
Answered by AI
Add your answer

Excel assessment- was made to make a report from multiple sheets

Skil set for My relevant job update

Communication discussion

Q1. About My profile and knowledge
Add your answer
Q2. About My attitude and experience
Add your answer

Q1. Excel formula and macro MS word and PowerPoint dashboard advanced Excel and power bi
Add your answer

The diagonals AC and BD of a cyclic quadrilateral ABCD intersect each other at the point P. Then, it is always true that

Q1. Nding Now DSA Data Structures Algorithms Interview Preparation Data Science Topic-wise Practice C C++ Java JavaScript Python Competitive Programming Machine Learning Aptitude Write & Earn Web Development P...read more
Add your answer
Q2. Everything you need to know about the job-search process itself.nding Now DSA Data Structures Algorithms Interview Preparation Data Science Topic-wise Practice C C++ Java JavaScript Python Competitive Prog...read more
Add your answer

Q1. Questions were based on DSA and C
Add your answer
Q2. It was basically a coding round with simple logic
Add your answer

Q1. What is join in sql
Ans. 
Join in SQL is used to combine rows from two or more tables based on a related column between them.
• Join is used to retrieve data from multiple tables based on a related column

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Answered by AI
Add your answer
Q2. What is primary key
Ans. 
Primary key is a unique identifier for each record in a database table.
• Primary key ensures each record in a table is uniquely identified

• It must contain unique values and cannot have NULL values

• Primary key can be a single column or a combination of columns

• Example: 'ID' column in a 'Users' table can be a primary key
Answered by AI
Add your answer