AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
OPPO
Compare
Filter interviews by
Clear (1)
OPPO Data Analyst Interview Questions and Answers
OPPO Data Analyst Interview Experiences
1 interview found
Anonymous
Selected
I applied via LinkedIn and was interviewed before Dec 2022. There were 3 interview rounds.
(1 Question)
- Q1. Tell me about yourself
(1 Question)
- Q1. About yourself n work profile
Interview Preparation Tips
BigBasket
We don't just offer jobs; we offer peace of mind.
Top trending discussions
Interview questions from similar companies
Divya Shree
(2 Questions)
- 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
- 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
Skills evaluated in this interview
Selected
(1 Question)
- Q1. Asked to create a power bi dashboard
(1 Question)
- Q1. Had coding test on SQL and Python
Interview Questionnaire
3 Questions
- Q1. Rate yourself in ADVANCED EXCEL, AND SQL
- Ans.
I rate myself 8/10 in Advanced Excel and 9/10 in SQL.
Advanced Excel: proficient in pivot tables, VLOOKUP, macros, and data visualization
SQL: skilled in writing complex queries, joins, subqueries, and stored procedures
Experience in using Excel and SQL together to analyze large datasets
- Q2. How to Work with dynamic data, how to remove duplicate data or fix the data
- Ans.
To work with dynamic data, remove duplicates and fix errors, use data cleaning techniques.
Use software tools like OpenRefine or Excel to clean data
Identify and remove duplicate data using unique identifiers
Fix errors by standardizing data formats and using regular expressions
Use data validation to ensure accuracy and completeness
Create a data cleaning plan and document all changes made
Test the cleaned data to ensure it
- Q3. Difference between formula and a function
- Ans.
Formula is a mathematical expression while function is a pre-built formula that performs a specific task.
Formula is a combination of mathematical operators and values used to calculate a result.
Function is a pre-built formula that performs a specific task, such as finding the average of a range of numbers.
Formulas can be customized and modified, while functions are fixed and cannot be changed.
Examples of functions incl
Interview Preparation Tips
Skills evaluated in this interview
Skil set for My relevant job update
Communication discussion
(2 Questions)
- Q1. About My profile and knowledge
- Q2. About My attitude and experience
(1 Question)
- Q1. Excel formula and macro MS word and PowerPoint dashboard advanced Excel and power bi
I applied via LinkedIn and was interviewed before Apr 2022. There were 2 interview rounds.
The diagonals AC and BD of a cyclic quadrilateral ABCD intersect each other at the point P. Then, it is always true that
(2 Questions)
- 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...
- 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...
Interview Preparation Tips
(1 Question)
- Q1. Couple of leetcode medium questions (i think it was around 3 questions) and they had their own platform
I applied via Recruitment Consulltant and was interviewed in Jun 2024. There were 2 interview rounds.
(2 Questions)
- 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
- 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
Excel assessment- was made to make a report from multiple sheets
Shashank S
(2 Questions)
- Q1. Questions were based on DSA and C
- Q2. It was basically a coding round with simple logic
I applied via Referral and was interviewed in May 2024. There were 2 interview rounds.
There were three python based interview questions
There were three Aptitude based interview questions
Interview Preparation Tips
OPPO Interview FAQs
Recently Viewed
SALARIES
Goibibo
SALARIES
Exicom
SALARIES
HEG
SALARIES
Tripjack
DESIGNATION
SALARIES
CWT
SALARIES
Tripjack
SALARIES
Exicom
DESIGNATION
SALARIES
Tripjack
Tell us how to improve this page.
OPPO Interviews By Designations
- OPPO Assistant Engineer Interview Questions
- OPPO Sales Executive Interview Questions
- OPPO Production Engineer Interview Questions
- OPPO Team Lead Interview Questions
- OPPO Management Trainee Interview Questions
- OPPO Senior Engineer Interview Questions
- OPPO Sales Promoter Interview Questions
- OPPO Operator Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
OPPO Data Analyst Interview Process
based on 1 interview
Interview experience
Tesco
Secure your future with a company that values your job stability.
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
OPPO Data Analyst Reviews and Ratings
based on 8 reviews
Rating in categories
|
Sales Executive
516
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Assistant Engineer
423
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Team Lead
420
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Production Engineer
310
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Area Sales Manager
219
salaries
| ₹0 L/yr - ₹0 L/yr |
Xiaomi
Samsung
Vivo
OnePlus
- Home >
- Interviews >
- OPPO Interview Questions >
- OPPO Data Analyst Interview Questions
