Add office photos
Filter interviews by
IPG Mediabrands Data Analyst Interview Questions and Answers
IPG Mediabrands Data Analyst Interview Experiences
2 interviews found
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
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
Interview questions from similar companies
Anonymous
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 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 LinkedIn and was interviewed in Jul 2024. There was 1 interview round.
(2 Questions)
- Q1. SQL Window Functions and RANK, DENSE RANK Difference
- Ans.
SQL Window Functions like RANK and DENSE RANK are used to assign a rank to rows within a partition.
RANK function assigns a unique rank to each distinct row within a partition.
DENSE RANK function assigns a unique rank to each distinct row within a partition, but without any gaps.
Both functions are used with the OVER() clause in SQL to define the partition and order of rows.
- Q2. Hadoop Default Replication Factor
Interview Preparation Tips
- SQL
- Spark
- Hadoop
- YARN
Salary offered is below industry standard.
Overall not a good experience.
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 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 Referral and was interviewed in Nov 2021. There was 1 interview round.
Interview Questionnaire
4 Questions
- Q1. Difference between coalesce and repartition
- Ans.
Coalesce is used to select the first non-null value from a set of columns. Repartition is used to shuffle data across nodes.
Coalesce reduces the number of partitions to the minimum required.
Repartition increases or decreases the number of partitions.
Coalesce is a narrow transformation while repartition is a wide transformation.
Coalesce is used to optimize data for queries while repartition is used to balance data acros...
- Q2. How to optimise joins
- Ans.
Optimizing joins involves selecting appropriate join types, indexing tables, and minimizing data movement.
Choose the appropriate join type based on the size and structure of the tables being joined
Index the tables on the join columns to speed up the join process
Minimize data movement by selecting only the necessary columns and filtering rows before joining
Consider using denormalization or materialized views to precompu
- Q3. Spark optimizations
- Q4. Difference between RDD dataset and dataframe
- Ans.
RDD is a low-level distributed data structure while DataFrame is a high-level structured data abstraction.
RDD is immutable and unstructured while DataFrame is structured and has a schema
DataFrames are optimized for SQL queries and can be cached in memory
RDDs are more flexible and can be used for complex data processing tasks
DataFrames are easier to use and provide a more concise syntax for data manipulation
RDDs are the...
Interview Preparation Tips
Skills evaluated in this interview
Selected
I applied via LinkedIn and was interviewed before Oct 2022. There were 4 interview rounds.
Basic dsa question in python and data engineering questions ,sql
Basic dsa question in python and data engineering questions
(1 Question)
- Q1. Salary negotiation
Selected
I applied via LinkedIn and was interviewed before Apr 2022. There were 4 interview rounds.
(1 Question)
- Q1. Majorly about previous work experience.
(1 Question)
- Q1. Asked me to build a dashboard in Google sheet and advance Excel test
(1 Question)
- Q1. Salary and other discussions
Interview Preparation Tips
- advance excel
- google sheet
- Google Analytics
- google studio
IPG Mediabrands Interview FAQs
Tell us how to improve this page.
IPG Mediabrands Interviews By Designations
- IPG Mediabrands Campaign Manager Interview Questions
- IPG Mediabrands Data Analyst Interview Questions
- IPG Mediabrands Senior Analyst Interview Questions
- IPG Mediabrands Senior Associate 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
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
People are getting interviews through
Data Analyst Interview Questions from Similar Companies
IPG Mediabrands Data Analyst Reviews and Ratings
based on 2 reviews
Rating in categories
|
Senior Executive
48
salaries
|  ₹4.8 L/yr - ₹11 L/yr |
|
Assistant Manager
35
salaries
| ₹8.4 L/yr - ₹14 L/yr |
|
Senior Analyst
28
salaries
| ₹6.7 L/yr - ₹14.9 L/yr |
|
Senior Associate
22
salaries
| ₹5.7 L/yr - ₹11 L/yr |
|
Data Analyst
16
salaries
| ₹4.1 L/yr - ₹8.5 L/yr |
Groupm Media
Dentsu Aegis Network
Madison World
Havas Media
Calculate your in-hand salary
- Home >
- Interviews >
- IPG Mediabrands Interview Questions >
- IPG Mediabrands Data Analyst Interview Questions
