AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
PivotRoots Interview Questions and Answers
PivotRoots Interview Experiences
4 interviews found
Anonymous
I applied via Recruitment Consulltant and was interviewed in Apr 2022. There were 2 interview rounds.
(1 Question)
- Q1. SQL,Python,Machine Learning,Model based question
(1 Question)
- Q1. General question , previous company role and responsibility etc
Interview Preparation Tips
Data Analyst Interview Questions asked at other Companies
sahil singh
The round primarily focused on assessing data structure and algorithm (DSA) knowledge, as well as coding proficiency.
Software Developer Interview Questions asked at other Companies
I applied via Naukri.com and was interviewed in Jul 2021. There was 1 interview round.
Interview Questionnaire
5 Questions
- Q1. It's completely based on job profile.
- Q2. Some basic questions in data analyst.
- Q3. Some questions on ML
- Q4. Some questions on statistics
- Q5. Some on previous projects
Interview Preparation Tips
Data Analyst Interview Questions asked at other Companies
Selected
I applied via Referral and was interviewed before Jul 2022. There were 3 interview rounds.
(1 Question)
- Q1. What are your qualifications, Experience, and expected CTC?
(1 Question)
- Q1. Will Ask you about the platform knowledge and knowledge about the specific role you have applied for including planning, executing, or manager.
- Ans. Talk about the experience of your previous work, and achievements if any, and details about the role and work.
Interview Preparation Tips
PivotRoots interview questions for popular designations
Jobs at PivotRoots
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
Easy leetcode data structure question
(1 Question)
- Q1. Write working code for calling a rest API, design rate limiter
- Ans.
Code for calling a REST API and designing a rate limiter
Use a library like requests or axios to make the API call
Implement a token bucket algorithm for rate limiting
Set a maximum number of requests per second and queue excess requests
Consider using a distributed rate limiter for scalability
(1 Question)
- Q1. Design Database schema for instagram
- Ans.
Design a database schema for Instagram.
Create tables for users, posts, comments, likes, and follows.
Use primary and foreign keys to establish relationships between tables.
Store user data such as username, email, and password securely.
Include fields for post content, location, and timestamp.
Track likes and comments on posts.
Implement a notification system for follows and likes.
Consider scalability and performance in the...
Interview Preparation Tips
Skills evaluated in this interview
(1 Question)
- Q1. Laravel framework question.
(1 Question)
- Q1. Laravel framework question
Interview Preparation Tips
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
(3 Questions)
- Q1. Basic SQL related- had to write 2 queries with basic joins.
- Q2. Questions related to past experience
- Q3. Drill down of 2 projects.
- Ans.
Managed project to implement new inventory system and led team in redesigning customer service process.
Implemented new inventory system to streamline operations
Led team in redesigning customer service process to improve efficiency
Successfully managed project timelines and budgets
Collaborated with cross-functional teams to ensure project success
Interview Preparation Tips
PivotRoots Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
PivotRoots Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
PivotRoots Reviews and Ratings
based on 52 reviews
Rating in categories
|
Assistant Manager
14
salaries
|  ₹4.7 L/yr - ₹7.2 L/yr |
|
Data Analyst
12
salaries
| ₹4.5 L/yr - ₹13.1 L/yr |
|
Paid Media Manager
10
salaries
| ₹5.6 L/yr - ₹14 L/yr |
|
Group Head
7
salaries
| ₹15 L/yr - ₹18.1 L/yr |
|
ART Director
7
salaries
| ₹8.6 L/yr - ₹17.5 L/yr |
Omnicom Media Group
Z1 Tech
7Search PPC
Bikayi
- Home >
- Interviews >
- PivotRoots Interview Questions
