AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Omnicom Media Group
Compare
Filter interviews by
Omnicom Media Group Data Analyst Interview Questions and Answers
Omnicom Media Group Data Analyst Interview Experiences
1 interview found
Anonymous
Selected
I applied via LinkedIn and was interviewed before Aug 2023. There were 2 interview rounds.
(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;
- 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.
(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.
Interview Preparation Tips
- SQL Server
- Pandas
- Power Bi
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via Naukri.com and was interviewed in Oct 2022. There were 4 interview rounds.
Mathematics, English and Reasoning..
(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...
- Q2. Some coding based questions of python.
(3 Questions)
- Q1. Salary and work discussionion
- Q2. Short and long term goals.
- Q3. Work Role, post and company work.
Interview Preparation Tips
Skills evaluated in this interview
rushi sukre
Selected
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
(2 Questions)
- Q1. Tell me about your projects
- Q2. Tell me yourself
Shrikanth Patil
(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;
- 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
Skills evaluated in this interview
Selected
I applied via Referral and was interviewed before Jun 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Talk about yourself
- Q2. What is your professional experience
Simple SQL questions
Interview Preparation Tips
Selected
I applied via Naukri.com and was interviewed before Jun 2022. There were 3 interview rounds.
They gave me case study in interview based on that I had provide the solution.
(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.
(1 Question)
- Q1. Tell me about Projects done during course
Interview Preparation Tips
(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
- 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.
Skills evaluated in this interview
Selected
I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.
(2 Questions)
- Q1. Accountings based question
- Q2. P2p cycle and invoicing process
Interview Preparation Tips
(2 Questions)
- Q1. Profile Related
- Q2. Product management
Omnicom Media Group Interview FAQs
Tell us how to improve this page.
Omnicom Media Group Interviews By Designations
- Omnicom Media Group Senior Associate Interview Questions
- Omnicom Media Group Data Analyst Interview Questions
- Omnicom Media Group Creative Designer Interview Questions
- Omnicom Media Group Senior Software Engineer Interview Questions
- Omnicom Media Group Finance Executive Interview Questions
- Omnicom Media Group Associate Interview Questions
- Omnicom Media Group Joiner Engineer Interview Questions
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
Omnicom Media Group Data Analyst Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Omnicom Media Group Data Analyst Reviews and Ratings
based on 6 reviews
Rating in categories
|
Analyst
93
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Senior Analyst
49
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Data Analyst
46
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Associate
28
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Associate
27
salaries
| ₹0 L/yr - ₹0 L/yr |
Groupm Media
Madison World
Dentsu Aegis Network
IPG Mediabrands
- Home >
- Interviews >
- Omnicom Media Group Interview Questions >
- Omnicom Media Group Data Analyst Interview Questions
