OPPO Data Analyst Interview Questions and Answers

Q1. What is an inactive relationship in PBI
Ans. 
An inactive relationship in Power BI is a relationship that is not being used in any visualizations or calculations.
• Inactive relationships can occur when a relationship is created but not utilized in any measures or visuals.

• These relationships do not impact the data model or query performance, but can clutter the model view.

• To remove an inactive relationship, you can delete it from the relationship view in Power BI.

• Ina...read more
Answered by AI
Add your answer
Q2. Import vs Direct Query vs Live connection
Ans. 
Import vs Direct Query vs Live connection
• Import: Data is imported into the tool for analysis, suitable for small datasets or when real-time data is not required

• Direct Query: Data is queried directly from the source in real-time, suitable for large datasets or when up-to-date data is needed

• Live connection: Data is connected live to the source, allowing for real-time updates and analysis without storing data locally
Answered by AI
Add your answer

It was simple but lengthy

Q1. Tell me about yourself
Ans. 
I am a data analyst with a strong background in statistics and data visualization.
• Graduated with a degree in Statistics

• Proficient in programming languages like Python and R

• Experience in analyzing large datasets and creating data visualizations

• Strong problem-solving skills
Answered by AI
Add your answer
Q2. About resume and technical
Add your answer

Retail operations on if to put a apple store in best buy. Need to deicide if feasible or not. That is really the extent, and you must formulate something very thoughtful. I don't know what else you would really like to know, it was super duper insane. I really went so hard at grinding on the interviewer she practically pulled her pants down and ate me out. It was a brutal one until I got to smash, which was great. Then we went back to my place and did the deed about 100 more times precisely. It was one of the wildest experiences I will ever have in my life. detail oriented, one on one interview.

Q1. What is your favorite activity outside of work?
Add your answer
Q2. How much would you like to eat me out.
Add your answer
Q3. More than I would like to care to admit.
Add your answer

Detailed case with four questions, required intensive number crunching and data analysis.
Suggestions: Stick to your basic understanding of the problem statement and state all your assumptions clearly.

A real business case was presented in a group of 5-7 people. Each one of us was given a specific role and we were told to discuss the case as a group and come up with a detailed solution.
A brief description of your answers/approach: We discussed the problem in hand from different angles - considering each function in detail. In the end of the discussion, we presented the business model of our idea to the Apple representatives in the form of a presentation.

Q1. Tell me about yourself
Add your answer
Q2. Tell me about a time when you had to deal with a difficult colleague
Add your answer
Q3. Biggest achievement
Add your answer
Q4. Resume based questions
Add your answer
Q5. Next part of the interview was case presentation - the at-home case we submitted before the GD round. We were given 10 minutes to give a detailed PPT on the case, which was followed by 30 minutes of Q&A se...read more
Add your answer

There were three python based interview questions

There were three Aptitude based interview questions

Q1. Tell me yourself
Add your answer

Q1. Discussion about salary
Add your answer

Q1. Growth of sales between the years
Ans. 
The sales growth between the years is calculated by comparing the sales figures from one year to another.
• Calculate the difference in sales between the two years

• Divide the difference by the sales figure of the initial year

• Multiply the result by 100 to get the percentage growth

• For example, if sales were $100 in year 1 and $120 in year 2, the growth would be (120-100)/100 * 100 = 20%
Answered by AI
Add your answer