Upload Button Icon Add office photos
Premium Employer

i

This company page is being actively managed by Omnicom Media Group Team. If you also belong to the team, you can get access from here

Omnicom Media Group

Compare button icon Compare button icon Compare

Filter interviews by

Omnicom Media Group Data Analyst Interview Questions and Answers

Updated 9 Aug 2024

Omnicom Media Group Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 9 Aug 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Aug 2023. There were 2 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Difference between union and union all in SQL?
  • Ans. 

    Union combines and removes duplicates, Union All combines without removing duplicates.

    • Union combines result sets and removes duplicates

    • Union All combines result sets without removing duplicates

    • Union is slower than Union All as it involves removing duplicates

    • Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

    • Example: SELECT column1 FROM table1 UNION ALL SELECT column1 FROM table2;

  • Answered by AI
  • Q2. How to show top 5 in pandas?
  • Ans. 

    To show top 5 in pandas, use the nlargest() function.

    • Use the nlargest() function with the 'n' parameter set to 5 to get the top 5 values in a pandas DataFrame.

    • For example: df['column_name'].nlargest(5) will return the top 5 values in the specified column.

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. If we have 3 numerical columns, which chart is a better representation these column?
  • Ans. 

    A scatter plot is a better representation for 3 numerical columns.

    • Use a scatter plot to show the relationship between the numerical columns.

    • Scatter plots are effective for visualizing correlations and patterns in data.

    • Each point on the plot represents a data point with values from all 3 columns.

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Omnicom Media Group Data Analyst interview:
  • SQL Server
  • Pandas
  • Power Bi

Skills evaluated in this interview

Interview questions from similar companies

I applied via Naukri.com and was interviewed in Oct 2022. There were 4 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 tips
Round 2 - Aptitude Test 

Mathematics, English and Reasoning..

Round 3 - Technical 

(2 Questions)

  • Q1. What is python? What is uses of python?
  • Ans. 

    Python is a high-level, interpreted programming language used for web development, data analysis, artificial intelligence, and more.

    • Python is easy to learn and has a simple syntax.

    • It is used for web development with frameworks like Django and Flask.

    • Python is popular for data analysis and visualization with libraries like Pandas and Matplotlib.

    • It is used for artificial intelligence and machine learning with libraries li...

  • Answered by AI
  • Q2. Some coding based questions of python.
Round 4 - HR 

(3 Questions)

  • Q1. Salary and work discussionion
  • Q2. Short and long term goals.
  • Q3. Work Role, post and company work.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be careful during interview and hear all the instruction carefully.

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Tell me about your projects
  • Q2. Tell me yourself
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What are SQL Joins?
  • Ans. 

    SQL Joins are used to combine rows from two or more tables based on a related column between them.

    • SQL Joins are used to retrieve data from multiple tables based on a related column between them.

    • Common types of SQL 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
  • Q2. Different functions in Python numpy
  • Ans. 

    Python numpy provides various functions for numerical operations on arrays.

    • numpy.sum() - calculates the sum of array elements

    • numpy.mean() - calculates the mean of array elements

    • numpy.max() - returns the maximum value in an array

    • numpy.min() - returns the minimum value in an array

    • numpy.std() - calculates the standard deviation of array elements

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - HR 

(2 Questions)

  • Q1. Talk about yourself
  • Q2. What is your professional experience
Round 2 - Aptitude Test 

Simple SQL questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Be honest if you don't know!
Interview experience
4
Good
Difficulty level
Easy
Process Duration
6-8 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Jun 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 tips
Round 2 - Case Study 

They gave me case study in interview based on that I had provide the solution.

Round 3 - Technical 

(1 Question)

  • Q1. They asked question regarding SQL, statistics and some project related questions

I applied via Campus Placement and was interviewed in Feb 2022. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Tell me about Projects done during course

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared with core concepts and portfolio of your work to showcase your skill
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. What are joins and how do you use it?
  • Ans. 

    Joins are used in databases to combine rows from two or more tables based on a related column between them.

    • Joins are used to retrieve data from multiple tables based on a related column between them

    • Common 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
  • Q2. Processing speed of different scriting languages?
  • Ans. 

    Processing speed of scripting languages varies based on factors like code complexity and optimization.

    • Processing speed can vary based on the specific task being performed.

    • Compiled languages like C++ tend to be faster than interpreted languages like Python.

    • Optimizing code can improve processing speed.

    • JavaScript can be faster than Python for certain tasks.

    • Consider using libraries or frameworks optimized for performance.

  • Answered by AI

Skills evaluated in this interview

Analyst Interview Questions & Answers

WPP user image Anonymous

posted on 12 Aug 2024

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Accountings based question
  • Q2. P2p cycle and invoicing process

Interview Preparation Tips

Interview preparation tips for other job seekers - All the best
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Profile Related
  • Q2. Product management

Omnicom Media Group Interview FAQs

How many rounds are there in Omnicom Media Group Data Analyst interview?
Omnicom Media Group interview process usually has 2 rounds. The most common rounds in the Omnicom Media Group interview process are One-on-one Round and Technical.
How to prepare for Omnicom Media Group 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 Omnicom Media Group. The most common topics and skills that interviewers at Omnicom Media Group expect are Data Analysis, SQL, Tableau, Data Analytics and Excel.
What are the top questions asked in Omnicom Media Group Data Analyst interview?

Some of the top questions asked at the Omnicom Media Group Data Analyst interview -

  1. If we have 3 numerical columns, which chart is a better representation these co...read more
  2. Difference between union and union all in S...read more
  3. How to show top 5 in pand...read more

Tell us how to improve this page.

Omnicom Media Group Data Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

R.R. Donnelley Interview Questions
3.9
 • 100 Interviews
3 Minds Digital Interview Questions
4.4
 • 65 Interviews
Publicis Interview Questions
3.7
 • 52 Interviews
Groupm Media Interview Questions
3.9
 • 35 Interviews
Smollan Group Interview Questions
4.1
 • 34 Interviews
Moris Media Interview Questions
4.5
 • 24 Interviews
Cheil India Interview Questions
3.0
 • 17 Interviews
IPG Mediabrands Interview Questions
3.5
 • 15 Interviews
WPP Interview Questions
3.0
 • 11 Interviews
View all
Omnicom Media Group Data Analyst Salary
based on 46 salaries
₹3.7 L/yr - ₹16 L/yr
47% more than the average Data Analyst Salary in India
View more details

Omnicom Media Group Data Analyst Reviews and Ratings

based on 6 reviews

2.6/5

Rating in categories

2.6

Skill development

2.6

Work-life balance

2.3

Salary

2.7

Job security

2.3

Company culture

2.0

Promotions

2.3

Work satisfaction

Explore 6 Reviews and Ratings
Analyst
93 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Analyst
49 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Analyst
46 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Associate
28 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate
27 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Omnicom Media Group with

Groupm Media

3.9
Compare

Madison World

3.8
Compare

Dentsu Aegis Network

3.4
Compare

IPG Mediabrands

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview