Get AmbitionBox App
Faster and better experience!
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
IPG Mediabrands Data Analyst Interview Experiences
2 interviews found
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
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?
- 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
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
- 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
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
I applied via Campus Placement and was interviewed before Aug 2020. There were 6 interview rounds.
Interview Questionnaire
2 Questions
- Q1. List out some of the best practice for data cleaning.
- Ans.
Data cleaning best practices
Remove duplicate records
Handle missing values
Standardize data formats
Correct inconsistent data
Validate data integrity
Remove outliers
Normalize data
Handle data inconsistencies
Ensure data accuracy
- Q2. Explain what is logistic regression?
- Ans.
Logistic regression is a statistical method used to analyze and model the relationship between a categorical dependent variable and one or more independent variables.
It is a type of regression analysis used for predicting the probability of a categorical outcome
It is commonly used in binary classification problems
It uses a logistic function to model the relationship between the independent variables and the dependent v...
Interview Preparation Tips
Skills evaluated in this interview
Data Analyst Interview Questions & Answers
CMS Computers Limited (INDIA)
Anonymous
posted on 7 May 2022
I applied via Referral and was interviewed before May 2021. There were 2 interview rounds.
(2 Questions)
- Q1. How Social media can be useful for government
- Ans.
Social media can help government to connect with citizens, gather feedback, and disseminate information.
Social media can be used to share important news and updates with citizens
It can be used to gather feedback and opinions from citizens on various issues
Government agencies can use social media to provide customer service and respond to inquiries
Social media can also be used to promote transparency and accountability ...
- Q2. What tools are being used currently
- Ans.
Various tools are being used for data analysis.
Microsoft Excel for basic data manipulation and analysis
Python for data cleaning, visualization, and statistical analysis
Tableau for creating interactive visualizations and dashboards
SQL for querying and managing large datasets
R for statistical computing and graphics
Power BI for creating interactive reports and dashboards
Google Analytics for web analytics
SAS for advanced s...
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 Assistant Manager Interview Questions
- IPG Mediabrands Data Engineer Interview Questions
- IPG Mediabrands Public Relations & Media Relations Manager Interview Questions
- Show more
IPG Mediabrands Data Analyst Interview Process
based on 2 interviews
Interview experience
Interview Questions from Similar Companies
IPG Mediabrands Data Analyst Reviews and Ratings
based on 2 reviews
Rating in categories
|
Senior Associate
58
salaries
|  ₹5.9 L/yr - ₹12 L/yr |
|
Senior Executive
46
salaries
| ₹4.2 L/yr - ₹11 L/yr |
|
Senior Analyst
42
salaries
| ₹7 L/yr - ₹21.2 L/yr |
|
Assistant Manager
40
salaries
| ₹8.4 L/yr - ₹15 L/yr |
|
Data Analyst
25
salaries
| ₹4.1 L/yr - ₹11 L/yr |
Omnicom Media Group
Z1 Tech
7Search PPC
Bikayi
- Home >
- Interviews >
- IPG Mediabrands Interview Questions >
- IPG Mediabrands Data Analyst Interview Questions
