AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Groupm Media Senior Data Analyst Interview Questions and Answers
Groupm Media Senior Data Analyst Interview Experiences
1 interview found
Anonymous
(1 Question)
- Q1. What is DBMS AND RDMS
- Ans.
DBMS stands for Database Management System, which is a software system that allows users to define, create, maintain and control access to the database. RDBMS stands for Relational Database Management System, which is a type of DBMS that stores data in a structured format using rows and columns.
DBMS is a software system that allows users to define, create, maintain and control access to the database
RDBMS is a type of D...
Interview Preparation Tips
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
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
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
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
(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
I applied via Recruitment Consulltant and was interviewed before Oct 2021. There were 2 interview rounds.
Generic aptitude like logical questions, puzzles and analytical ability
(2 Questions)
- Q1. Why us and why are you exiting
- Ans.
I am interested in this company because of its strong reputation and growth opportunities. I am exiting my current position to pursue new challenges and professional growth.
I am impressed by the company's strong reputation in the industry.
I believe this company offers great growth opportunities for career advancement.
I am excited about the company's innovative approach and commitment to excellence.
I am leaving my curre...
- Q2. What is your long term aspiration?
- Ans.
To become a senior analyst and contribute to the growth of the company.
My long term aspiration is to become a senior analyst and take on more responsibilities.
I aim to contribute to the growth and success of the company by providing valuable insights and recommendations.
I want to continuously develop my analytical skills and stay updated with industry trends.
I aspire to lead a team of analysts and mentor junior members
Interview Preparation Tips
- Digital Marketing
Selected
I applied via Naukri.com and was interviewed before Sep 2022. There were 2 interview rounds.
(2 Questions)
- Q1. Tableau questions Sql questions And excel questions
- Q2. What is data validation What is delete and truncate Delete and drop
- Ans.
Data validation ensures data is accurate and useful. Delete removes specific records, truncate removes all records, drop removes entire table.
Data validation ensures data is accurate, complete, and useful for analysis
Delete removes specific records from a table based on a condition
Truncate removes all records from a table, but keeps the table structure
Drop removes an entire table from the database
Example: DELETE FROM t...
Interview Preparation Tips
Groupm Media Interview FAQs
Tell us how to improve this page.
Groupm Media Interviews By Designations
- Groupm Media MIS Executive Interview Questions
- Groupm Media HR Executive Interview Questions
- Groupm Media Internship Trainee Interview Questions
- Groupm Media Data Analyst Interview Questions
- Groupm Media Executive Interview Questions
- Groupm Media Senior Executive Interview Questions
- Groupm Media Data Scientist Interview Questions
- Groupm Media Analytics Manager Interview Questions
- Show more
Interview Questions for Popular Designations
- Data Scientist Interview Questions
- Data Analyst Intern Interview Questions
- Senior Data Scientist Interview Questions
- Data Science Intern Interview Questions
- Associate Data Analyst Interview Questions
- Jr. Data Scientist Interview Questions
- Data Analyst Interview Questions
- Associate Data Scientist Interview Questions
- Show more
Groupm Media Senior Data Analyst Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Groupm Media Senior Data Analyst Reviews and Ratings
based on 1 review
Rating in categories
|
Senior Executive
176
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Manager
146
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Business Manager
127
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Associate Director
108
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Executive
74
salaries
| ₹0 L/yr - ₹0 L/yr |
Madison World
Dentsu Aegis Network
IPG Mediabrands
Havas Media
- Home >
- Interviews >
- Groupm Media Interview Questions >
- Groupm Media Senior Data Analyst Interview Questions
