AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
IPG Mediabrands Data Analyst Interview Questions and Answers for Freshers
IPG Mediabrands Data Analyst Interview Experiences for Freshers
1 interview found
Shrikanth Patil
(2 Questions)
- Q1. What are SQL Joins?
- 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
Top trending discussions
Interview questions from similar companies
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?
- 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
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
Selected
I appeared for an interview before Mar 2024.
(2 Questions)
- Q1. About datorama explain how it works
- Ans.
Datorama is a marketing intelligence platform that integrates data from various sources for analysis and visualization.
Data Integration: Datorama connects to multiple data sources like Google Analytics, Salesforce, and social media platforms.
Data Harmonization: It standardizes data formats and metrics, allowing for consistent analysis across different datasets.
Visualization: Users can create customizable dashboards to ...
- Q2. More about digital marketing
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 appeared for an interview in Mar 2025, where I was asked the following questions.
- Q1. Some Senario Based questions as it require to understand your business acumen and all
- Q2. One Proposal making task is given
I applied via Recruitment Consultant and was interviewed in Dec 2021. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Basics of Campaign building
- Q2. What is Ad network and Ad exchange
- Ans.
Ad network is a platform that connects advertisers with publishers to display ads. Ad exchange is a marketplace for buying and selling ad inventory.
Ad network connects advertisers with publishers to display ads
Ad exchange is a marketplace for buying and selling ad inventory
Ad network typically charges a commission on ad spend
Ad exchange uses real-time bidding to determine the price of ad inventory
Examples of ad network...
Interview Preparation Tips
Skills evaluated in this interview
Data Analyst Interview Questions & Answers
Suntory Global Spirits India
Anonymous
posted on 13 Jun 2022
I applied via Approached by Company and was interviewed before Jun 2021. There were 3 interview rounds.
(1 Question)
- Q1. Tell me about yourself, puzzles, python add sql questions.
(1 Question)
- Q1. Tell me about yourself. explain your projects, strengths and weaknesses.
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Jul 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Why do you want to join us Where do you see yourself 5 years from now What are your hobbies
Interview Preparation Tips
Interview Questionnaire
2 Questions
- Q1. SQL and Excel were the key that helped me get this job.
- Q2. Puzzles
IPG Mediabrands Interview FAQs
Tell us how to improve this page.
IPG Mediabrands Interviews By Designations
- IPG Mediabrands Senior Associate Interview Questions
- IPG Mediabrands Senior Analyst Interview Questions
- IPG Mediabrands Data Analyst Interview Questions
- IPG Mediabrands Campaign Manager Interview Questions
- IPG Mediabrands Analyst Interview Questions
- IPG Mediabrands AD Operations Executive Interview Questions
- IPG Mediabrands Assistant Manager Interview Questions
- IPG Mediabrands Paid Media Executive Interview Questions
- Show more
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 1 interview experience
Interview Questions from Similar Companies
IPG Mediabrands Data Analyst Reviews and Ratings
based on 2 reviews
Rating in categories
|
Senior Associate
124
salaries
|  ₹5.6 L/yr - ₹13 L/yr |
|
Senior Analyst
52
salaries
| ₹9 L/yr - ₹17 L/yr |
|
Senior Executive
52
salaries
| ₹4.8 L/yr - ₹11 L/yr |
|
Data Analyst
51
salaries
| ₹4.1 L/yr - ₹10 L/yr |
|
Assistant Manager
47
salaries
| ₹8.9 L/yr - ₹14.6 L/yr |
Omnicom Media Group
Z1 Tech
7Search PPC
Bikayi
- Home >
- Interviews >
- IPG Mediabrands Interview Questions >
- IPG Mediabrands Interview Questions for Fresher
