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 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 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
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 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
(2 Questions)
- Q1. Profile Related
- Q2. Product management
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
I applied via Recruitment Consultant and was interviewed in Oct 2021. There were 3 interview rounds.
Interview Questionnaire
6 Questions
- Q1. Tell me about yourself
- Q2. Business Process Transformation
- Q3. Frameworks used by a Business Analyst
- Ans.
Business Analysts use various frameworks to analyze and solve business problems.
SWOT Analysis
PESTLE Analysis
Porter's Five Forces
Business Model Canvas
Value Stream Mapping
- Q4. How do you handle conflicts between team members and also stakeholders?
- Q5. Questions on SQL, Tableau and Power BI
- Q6. Why do you think you're suitable for this role?
Interview Preparation Tips
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
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 - ₹15 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
