Upload Button Icon Add office photos

Filter interviews by

PivotRoots Data Analyst Interview Questions and Answers

Updated 7 May 2022

PivotRoots Data Analyst Interview Experiences

2 interviews found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 7 May 2022

I applied via Recruitment Consulltant and was interviewed in Apr 2022. There were 2 interview rounds.

Round 1 - One-on-one 

(1 Question)

  • Q1. SQL,Python,Machine Learning,Model based question
Round 2 - HR 

(1 Question)

  • Q1. General question , previous company role and responsibility etc

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare with market oriented model, clustering model, classification model,SQL analysis queries

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 31 Aug 2021

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

Interview preparation tips for other job seekers - Be prepared with job profile and the contents written in cv.

Data Analyst Interview Questions Asked at Other Companies

asked in Deloitte
Q1. Suppose there is a room in the office and X people enter room thr ... read more
asked in Wipro
Q2. Chocolate Distribution Problem You are given an array/list CHOCOL ... read more
asked in Wipro
Q3. Ninja and Substrings Problem Statement Ninja has to determine all ... read more
asked in Capgemini
Q4. Ninja and His Secret Information Encoding Problem Ninja, a new me ... read more
Q5. Sliding Window Maximum Problem Statement You are given an array/l ... read more

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview before Mar 2024.

Round 1 - Technical 

(2 Questions)

  • Q1. About datorama explain how it works
  • Q2. More about digital marketing
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Referral and was interviewed in Jul 2024. There was 1 interview round.

Round 1 - Technical 

(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

  • Answered by AI
  • Q2. Types of floor in GAM
  • Ans. 

    Types of floors in GAM include carpet, hardwood, tile, and laminate.

    • Carpet

    • Hardwood

    • Tile

    • Laminate

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared and confident
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview in Mar 2025, where I was asked the following questions.

  • Q1. Some Senario Based questions as it require to understand your business acumen and all
  • Q2. One Proposal making task is given

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...

  • Answered by AI
  • 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

  • Answered by AI
  • 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...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - The major focus was on Apache Spark.

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Oct 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Be honest with your years of experience. All information you share will be verified at the time of joining.
View all tips
Round 2 - Coding Test 

Basic dsa question in python and data engineering questions ,sql

Round 3 - Coding Test 

Basic dsa question in python and data engineering questions

Round 4 - HR 

(1 Question)

  • Q1. Salary negotiation
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed before Aug 2023. There were 2 interview rounds.

Round 1 - One-on-one 

(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;

  • Answered by AI
  • 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.

  • Answered by AI
Round 2 - Technical 

(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.

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Omnicom Media Group Data Analyst interview:
  • SQL Server
  • Pandas
  • Power Bi

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in May 2024. There were 2 interview rounds.

Round 1 - Technical 

(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
Round 2 - Assignment 

Excel file was give, used sumifs, countifs , index match formulas

Interview Preparation Tips

Interview preparation tips for other job seekers - Just learn the excel famous questions and concept like look up, index match, nested if, concate function etc

I applied via Campus Placement and was interviewed in Aug 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Questions on Projects.

Interview Preparation Tips

Interview preparation tips for other job seekers - Interviewers are very friendly.
Brush up technical concepts and coding

PivotRoots Interview FAQs

How many rounds are there in PivotRoots Data Analyst interview?
PivotRoots interview process usually has 2 rounds. The most common rounds in the PivotRoots interview process are One-on-one Round and HR.
How to prepare for PivotRoots Data Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at PivotRoots. The most common topics and skills that interviewers at PivotRoots expect are Data Analysis, Market Research, Analytical, Arima and Machine Learning.
What are the top questions asked in PivotRoots Data Analyst interview?

Some of the top questions asked at the PivotRoots Data Analyst interview -

  1. SQL,Python,Machine Learning,Model based quest...read more
  2. It's completely based on job profi...read more
  3. Some basic questions in data analy...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

3 Minds Digital Interview Questions
4.4
 • 70 Interviews
Moris Media Interview Questions
4.3
 • 24 Interviews
Z1 Tech Interview Questions
4.0
 • 11 Interviews
Bikayi Interview Questions
2.9
 • 10 Interviews
Xapads Media Interview Questions
4.3
 • 10 Interviews
Amitoje India Interview Questions
4.2
 • 10 Interviews
Jivox Interview Questions
3.8
 • 9 Interviews
View all
PivotRoots Data Analyst Salary
based on 15 salaries
₹4.5 L/yr - ₹14 L/yr
27% more than the average Data Analyst Salary in India
View more details

PivotRoots Data Analyst Reviews and Ratings

based on 2 reviews

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-life balance

5.0

Salary

5.0

Job security

5.0

Company culture

5.0

Promotions

5.0

Work satisfaction

Explore 2 Reviews and Ratings
Data Analyst
15 salaries
unlock blur

₹4.5 L/yr - ₹14 L/yr

Assistant Manager
14 salaries
unlock blur

₹4.7 L/yr - ₹7.2 L/yr

Paid Media Manager
10 salaries
unlock blur

₹5.6 L/yr - ₹14 L/yr

Group Head
7 salaries
unlock blur

₹15 L/yr - ₹18.1 L/yr

ART Director
7 salaries
unlock blur

₹8.6 L/yr - ₹17.5 L/yr

Explore more salaries
Compare PivotRoots with

Omnicom Media Group

2.9
Compare

Z1 Tech

4.0
Compare

7Search PPC

4.8
Compare

Bikayi

2.9
Compare
Did you find this page helpful?
Yes No
write
Share an Interview