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 for Experienced
Omnicom Media Group Data Analyst Interview Experiences for Experienced
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 May 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Questions on vlook up, h-look up, pivot and if else condition
- Q2. You must know how to use vlook up, h-look up and if-else condition
Excel file was give, used sumifs, countifs , index match formulas
Interview Preparation Tips
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
I applied via Referral and was interviewed in Jul 2024. There was 1 interview round.
(2 Questions)
- Q1. Reasons for the drop in CPM
- Ans.
Possible reasons for drop in CPM include seasonality, changes in ad inventory, shifts in audience demographics, and increased competition.
Seasonal fluctuations in advertising demand
Changes in available ad inventory
Shifts in audience demographics affecting targeting effectiveness
Increased competition leading to lower bids
- Q2. Types of floor in GAM
- Ans.
Types of floors in GAM include carpet, hardwood, tile, and laminate.
Carpet
Hardwood
Tile
Laminate
Interview Preparation Tips
Selected
I applied via Referral and was interviewed in Jan 2023. There were 3 interview rounds.
Easy and simple quest during round one. Easy to crack
(3 Questions)
- Q1. Tell me abt yourself
- Q2. Platforms knowledge and process related questions
- Q3. Explain metrics used in Digital marketing's and main KPI
- Ans.
Metrics used in digital marketing include CTR, CPC, CPA, and main KPI is ROI.
CTR (Click-Through Rate) measures the percentage of clicks on an ad compared to the number of impressions.
CPC (Cost Per Click) is the amount paid for each click on an ad.
CPA (Cost Per Acquisition) measures the cost of acquiring a customer through a specific campaign.
ROI (Return on Investment) is the main KPI, calculating the revenue generated
Interview Preparation Tips
Skills evaluated in this interview
I applied via LinkedIn and was interviewed before Dec 2020. There were 5 interview rounds.
Interview Questionnaire
1 Question
- Q1. What is sem in digital marketing?
- Ans.
SEM stands for Search Engine Marketing, which involves promoting websites by increasing their visibility in search engine results pages.
SEM involves paid advertising on search engines like Google and Bing
It includes strategies like keyword research, ad copywriting, and bid management
SEM can be used to drive traffic, increase brand awareness, and generate leads or sales
Examples of SEM platforms include Google Ads, Bing
Interview Preparation Tips
Skills evaluated in this interview
(2 Questions)
- Q1. Profile Related
- Q2. Product management
Selected
I applied via Recruitment Consulltant and was interviewed before Apr 2022. There were 3 interview rounds.
(1 Question)
- Q1. Basic questions about your previous experience
(1 Question)
- Q1. Excel and Data visualization questions. Depends on the role you are being hired for.
Interview Preparation Tips
Reasoning and logic base qus
(1 Question)
- Q1. About metrics like Cpc, cvr
(1 Question)
- Q1. Discuss about previous work
Selected
I applied via Walk-in and was interviewed before Jun 2022. There were 3 interview rounds.
General grammar questions for checking the english proficiency of the candidates
(3 Questions)
- Q1. You'll have a direct one on one with the elad and they will enquire about yourself and your skills, especially they will check your communication skills
- Q2. What is Adobe and Office 365
- Ans.
Adobe and Office 365 are software suites commonly used for various business purposes.
Adobe is a software suite used for graphic design, video editing, and web development.
Office 365 is a cloud-based suite of productivity applications including Word, Excel, PowerPoint, and Outlook.
Both Adobe and Office 365 are widely used in businesses for creating, editing, and sharing documents and multimedia content.
- Q3. Communication skills test
Interview Preparation Tips
- Agile Methodology
- Brd
- Business Analysis
- JIRA
- Analytical skills
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 Analyst 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 Creative Producer Interview Questions
- Omnicom Media Group Finance Executive Interview Questions
- Omnicom Media Group Associate 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
Omnicom Media Group Data Analyst Interview Process for Experienced
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Omnicom Media Group Data Analyst Reviews and Ratings
based on 7 reviews
Rating in categories
|
Analyst
93
salaries
|  ₹4.5 L/yr - ₹10 L/yr |
|
Senior Analyst
51
salaries
| ₹5.8 L/yr - ₹12.2 L/yr |
|
Data Analyst
51
salaries
| ₹4.5 L/yr - ₹18 L/yr |
|
Senior Associate
29
salaries
| ₹3.5 L/yr - ₹6 L/yr |
|
Associate
26
salaries
| ₹3 L/yr - ₹5 L/yr |
R.R. Donnelley
Smollan Group
Publicis
CPM India Sales & Marketing
- Home >
- Interviews >
- Omnicom Media Group Interview Questions >
- Omnicom Media Group Data Analyst Interview Questions for Experienced
