AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Clear (1)
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
Top trending discussions
Interview questions from similar companies
Anonymous
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
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
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
I applied via Recruitment Consulltant and was interviewed in Jan 2022. There were 2 interview rounds.
This is kind of mixed round with both technical questions followed by coding test.This position if for SR RPA developer(uipath) so I was asked about UiPath and then was asked to extract data from some pdf invoices using document understanding.
I was asked if I know Power BI,( if they have had a look at my resume before shortlisting my profile,they would have known that I dont have any exposure to power BI),Still they shortlisted it.
(1 Question)
- Q1. Combined tech and coding round
Interview Preparation Tips
I was approached by a consultancy regarding this job opportunity with Dentsu,Bangalore COE.
Pathetic experience right from the beginning.
I told my CTC expectation and the HR(consultancy) was like 'Dentsu offers only 30-40% hike at max.'. and I was like ' what! When did RPA skillset become a non-digital skill, that too when digital profiles recruitment is on a peak stage. (Trust me the hike % have gone all time high during the last 3-4 months for digital skillset.), But after 1 day, HR replied back saying that the company is ok to match my expectation.(this was a bit fishy).
Then,
The interview was rescheduled 4 times because they want to conduct interview after 3PM and during weekdays only and also the interview is for 1 hr and 30 mins (which is pretty much busy time as I work during UK hours and also 1.30 hrs seriously?)
Finally I compromised and i took half day leave to attend the interview.
I've answered pretty much everything they asked and have completed the data extraction task within the given time but I dont know what made them drop my profile.
This is what I came to conclusion :
They needed someone who is having POWER BI,VBA experience with RPA tools knowledge.
Then why the hell have they raised a CO to hire an sr. RPA developer for UIPATH?
Are they expecting everything to be done by a single resource, if that's the expectation then here's my Tip "READ THE RESUMES PROPERLY" before shortlisting.
Here's my tip to those who attend interviews for similar positions in this company:
Don't waste your precious time and dont compromise.Just because they are offering a job doesn't mean you have to compromise. When interviews are being scheduled on weekdays and for experienced professionals, its a common sense that the schedule has to be based on common available times for both the parties and if the interview is going to be more than an hour,it has to be scheduled on a weekend.
The whole interview seemed to be a timepass activity as the people (2 persons) interviewing me dropped one after the other saying that they had some work. Lol.
I had to attend interview at the time they wanted and by applying a leave but they couldn't wait.
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
IPG Mediabrands Interview FAQs
Recently Viewed
INTERVIEWS
Jindal Industries Private Limited
No Interviews
INTERVIEWS
Electrotherm
No Interviews
INTERVIEWS
Electrotherm
No Interviews
INTERVIEWS
Jindal Industries Private Limited
No Interviews
INTERVIEWS
Darwinbox
No Interviews
INTERVIEWS
Electrotherm
No Interviews
LIST OF COMPANIES
Electrotherm
Locations
DESIGNATION
SALARIES
Gujarat Alkalies & Chemicals
INTERVIEWS
Jindal Industries Private Limited
No Interviews
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
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
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 Executive
50
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Senior Associate
47
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Analyst
37
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Assistant Manager
36
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Data Analyst
22
salaries
| ₹0 L/yr - ₹0 L/yr |
Groupm Media
Dentsu Aegis Network
Madison World
Havas Media
- Home >
- Interviews >
- IPG Mediabrands Interview Questions >
- IPG Mediabrands Data Analyst Interview Questions
