2 Sony Data Analyst Interview Questions & Answers | Complete Prep Guide 2025

Sony Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

Divya Shree

posted on 14 Nov 2024

Interview experience

Average

Difficulty level

Process Duration

Result

Round 1 - Technical

(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

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

Skills evaluated in this interview

Top trending discussions

View All

Interview Tips & Stories

I have been shortlisted for an interview at Bloomberg for the investment / real estate reporter role. How can I prepare for the interview? What all do I need to keep in mind for my prep? Please help, I am very nervous! Thank you

Got a question about Sony?

Ask anonymously on communities.

Interview questions from similar companies

Data Analyst Interview Questions & Answers

OPPO

Anonymous

posted on 1 Dec 2023

Interview experience

Good

Difficulty level

Easy

Process Duration

Less than 2 weeks

Result

Selected

I applied via LinkedIn and was interviewed before Dec 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist

Pro Tip by AmbitionBox:

Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.

View all Resume tips

Round 2 - HR

(1 Question)

Q1. Tell me about yourself

Add your answer

Round 3 - One-on-one

(1 Question)

Q1. About yourself n work profile

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be you, as Chinese round is final round be confident with your English that’s it

Data Analyst Interview Questions & Answers

Whirlpool

POOJA DNYANESHWAR DEWALKAR

posted on 5 Jun 2024

Interview experience

Excellent

Difficulty level

Moderate

Process Duration

2-4 weeks

Result

Selected

I applied via Naukri.com and was interviewed before Jun 2023. There were 2 interview rounds.

Round 1 - Aptitude Test

SQL coding and MCQ duration 45 min

Round 2 - Technical

(2 Questions)

Q1. Job responsibilities

Add your answer

Q2. Power BI, tableau, SQL, python

Add your answer

Data Analyst Interview Questions & Answers

HARMAN

Anonymous

posted on 2 Jan 2025

Interview experience

Average

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

No response

Round 1 - Aptitude Test

1 hour baisc on general aptitude

Interview Preparation Tips

Interview preparation tips for other job seekers - just basic interview regarding backgroud, experience

Data Analyst Interview Questions & Answers

HARMAN

Anonymous

posted on 17 Nov 2024

Interview experience

Bad

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

Not Selected

I applied via Naukri.com and was interviewed in Oct 2024. There were 2 interview rounds.

Round 1 - Aptitude Test

It was simple but lengthy

Round 2 - HR

(2 Questions)

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

Interview Preparation Tips

Interview preparation tips for other job seekers - be prepared by your resume.

Data Analyst Interview Questions & Answers

Samsung

Anonymous

posted on 10 May 2024

Interview experience

Good

Difficulty level

Process Duration

Result

Round 1 - Technical

(1 Question)

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

Add your answer

Data Analyst Interview Questions & Answers

Samsung

Anonymous

posted on 27 Jul 2024

Interview experience

Good

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

Not Selected

I applied via Recruitment Consulltant and was interviewed in Jun 2024. There were 2 interview rounds.

Round 1 - One-on-one

(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

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

Round 2 - Assignment

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

Data Analyst Interview Questions & Answers

Samsung

Anonymous

posted on 13 Aug 2021

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

Answered by AI

Add your answer

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

Answered by AI

View 1 more answer

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

Answered by AI

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be confident in your reply, communication is most important

Skills evaluated in this interview

Data Analyst Interview Questions & Answers

Samsung

Anonymous

posted on 14 Dec 2024

Interview experience

Excellent

Difficulty level

Process Duration

Result

Round 1 - Aptitude Test

Skil set for My relevant job update

Round 2 - Group Discussion

Communication discussion

Round 3 - One-on-one

(2 Questions)

Q1. About My profile and knowledge

Add your answer

Q2. About My attitude and experience

Add your answer

Round 4 - Technical

(1 Question)

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

Add your answer

Data Analyst Interview Questions & Answers

Samsung

Anonymous

posted on 24 Apr 2023

Interview experience

Excellent

Difficulty level

Moderate

Process Duration

2-4 weeks

Result

Not Selected

I applied via LinkedIn and was interviewed before Apr 2022. There were 2 interview rounds.

Round 1 - Aptitude Test

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

Round 2 - One-on-one

(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...

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...

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Everything you need to know about the job-search process itself.

Sony Interview FAQs

How many rounds are there in Sony Data Analyst interview?

Sony interview process usually has 1 rounds. The most common rounds in the Sony interview process are Technical.

How to prepare for Sony Data Analyst interview?

Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Sony. The most common topics and skills that interviewers at Sony expect are Administration, Analytics, Asset Management, Budgeting and Data Analysis.

What are the top questions asked in Sony Data Analyst interview?

Some of the top questions asked at the Sony Data Analyst interview -

What is join in ...read more
What is primary ...read more

Sales Executive 187 salaries	₹0 L/yr - ₹0 L/yr
Area Sales Manager 80 salaries	₹0 L/yr - ₹0 L/yr
Senior Software Engineer 68 salaries	₹0 L/yr - ₹0 L/yr
Technical Support Engineer 56 salaries	₹0 L/yr - ₹0 L/yr
Software Engineer 53 salaries	₹0 L/yr - ₹0 L/yr

Sony Data Analyst Interview Questions and Answers

Sony Data Analyst Interview Experiences

1 interview found

(2 Questions)

Skills evaluated in this interview

Interview questions from similar companies

(1 Question)

(1 Question)

Interview Preparation Tips

(2 Questions)

Interview Preparation Tips

(2 Questions)

Interview Preparation Tips

(1 Question)

(2 Questions)

Interview Questionnaire

3 Questions

Interview Preparation Tips

Skills evaluated in this interview

(2 Questions)

(1 Question)

(2 Questions)

Interview Preparation Tips

Sony Interview FAQs

Recently Viewed

Tripjack

EaseMyTrip.com

Exicom

JCB

JCB

JCB

Statcon Energiaa

Tripjack

Tripjack

Tripjack

Tell us how to improve this page.

Sony Interviews By Designations

Interview Questions for Popular Designations

Sony Data Analyst Interview Process

Data Analyst Interview Questions from Similar Companies

Fast track your campus placements