Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Peel-works Team. If you also belong to the team, you can get access from here

Peel-works Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Peel-works Data Analyst Interview Questions and Answers

Updated 24 Apr 2023

Peel-works Data Analyst Interview Experiences

2 interviews found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 14 Apr 2023

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
Selected Selected
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(6 Questions)

  • Q1. DON'T GIVE THE INTERVIEW THERE. IF YOU GOT HIRED, THEY WILL MAKE YOU WORK ROUND THE CLOCK WITHOUT PAYING ANYTHING EXTRA. YOU WILL BE END UP WORKING TILL 2 AM. IF YOU DENY THAT YOU CANT WORK, THEY WILL TH...
  • Q2. STUPID HR CALLED ME 15 TIMES IN 2 HOURS WHEN I DID NOT PICK UP HER FIRST CALL. THEY ARE DESPERATE TO HIRE YOU AND THEN THEY WILL MAKE YOU DESPERATE TO LEAVE THE COMPANY.
  • Q3. FIRST, YOU SHOULD ASK YOURSELF, WHY SHOULD YOU JOIN THIS COMPANY?
  • Ans. THEN, YOU SHOULD ASK YOURSELF, IF YOU ARE READY TO LOOSE YOUR SELF-STEAM? BECAUSE, EACH MANAGER WILL SHOUT ON YOU, THEY DON'T KNOW HOW TO TALK.
  • Answered Anonymously
  • Q4. YOU SHOULD ASK YOURSELF, IF YOU ARE READY TO WORK 24*7 FOR THEM WITHOUT EXPECTING EXTRA MONEY?
  • Ans. YOU SHOULD ASK YOURSELF, IF YOU ARE READY TO WORK, EVEN ON HOLIDAYS AND SATURDAYS WITHOUT ANY EXTRA COMPENSATION?
  • Answered Anonymously
  • Q5. YOU SHOULD ASK YOURSELF, IF YOU ARE READY TO TAKE CALLS OF YOUR STUPID MANAGER, EVER IF YOU ARE DRIVING TO REACH OFFICE ON TIME?
  • Q6. YOU SHOULD ASK YOURSELF, IF YOU CAN HAVE BREAKFAST IN OFFICE PEACEFULLY, BECAUSE MANAGERS DON'T CARE IF YOU ARE HAVING FOOD, THEY WILL MAKE YOU TO MEET THEM, EVEN IF THEY SEE YOU EATING.
Round 3 - Technical 

(1 Question)

  • Q1. DON'T GIVE THE INTERVIEW ITSELF.

Interview Preparation Tips

Interview preparation tips for other job seekers - IF YOU ARE LOOKING FOR A DATA ANALYST ROLE FOR PEEL WORKS, DON'T FALL IN TO THEIR TRAP. THEY WILL ANYHOW INCREASE 10% SALARY TO MAKE YOU A SLAVE. THEY WILL PEEL YOUR SOUL APART.

Data Analyst Interview Questions & Answers

user image Revathi Harikrishnan

posted on 24 Apr 2023

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Apr 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Technical 

(2 Questions)

  • Q1. R software, excel file
  • Q2. SQL query and advanced Excel

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

I applied via IIM Jobs and was interviewed in Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

7 Questions

  • Q1. Advance SQL Questions.
  • Q2. Multiple Approaches in the SQL questions were seen. Some unconventional SQL Syntax was also asked.
  • Q3. Metrics Driven Case studies.
  • Q4. More number of solutions were seen instead of in depth implementation of 1 solution. Good Communication skills is judged.
  • Q5. Tell me something about yourself.
  • Ans. 

    I am a highly motivated and detail-oriented Business Analyst with a strong background in data analysis and problem-solving.

    • I have a Bachelor's degree in Business Administration with a focus on analytics.

    • I have experience working with cross-functional teams to gather and analyze business requirements.

    • I am proficient in using tools such as Excel, SQL, and Tableau for data analysis and visualization.

    • I have successfully im...

  • Answered by AI
  • Q6. Why quit last job.
  • Ans. 

    Seeking better growth opportunities and work-life balance.

    • Limited growth prospects in previous role

    • Lack of work-life balance

    • Desire for new challenges and learning opportunities

    • Company culture misalignment

    • Relocation or commute issues

    • Better compensation or benefits elsewhere

  • Answered by AI
  • Q7. Why Meesho.
  • Ans. 

    Meesho is a leading e-commerce platform that empowers individuals to start their own online businesses.

    • Meesho provides a user-friendly platform for individuals to sell products online without any investment.

    • It offers a wide range of products from various categories, allowing sellers to cater to different customer preferences.

    • Meesho provides extensive training and support to its sellers, helping them succeed in their on...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be calm, It's very similar to any other business analyst interview in industry.

I applied via LinkedIn and was interviewed in Mar 2022. There were 5 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Coding Test 

The test was based on SQL and the questions were similar to medium difficulty level questions in leetcode.

Round 3 - Technical 

(3 Questions)

  • Q1. Describe different types of joins
  • Ans. 

    Different types of joins are used in database queries to combine data from multiple tables.

    • Inner join: Returns only the matching records from both tables.

    • Left join: Returns all records from the left table and the matching records from the right table.

    • Right join: Returns all records from the right table and the matching records from the left table.

    • Full outer join: Returns all records when there is a match in either the ...

  • Answered by AI
  • Q2. 2 tables were given and I was asked to tell the number of rows in output based on different types of joins.
  • Q3. Calculated the rows based on joins and told the answer.
Round 4 - One-on-one 

(4 Questions)

  • Q1. Describe your previous experience
  • Ans. 

    I have 3 years of experience as a Business Analyst in the IT industry.

    • Worked on gathering and analyzing business requirements

    • Created functional specifications and user stories

    • Conducted stakeholder interviews and facilitated meetings

    • Performed data analysis and created reports

    • Collaborated with cross-functional teams to implement solutions

    • Utilized tools like JIRA and Confluence for project management

    • Improved business proc

  • Answered by AI
  • Q2. Shared the details regarding my experience
  • Q3. A SQL based puzzle based on window functions where I had to find 4 consecutive empty seats in a theater.
  • Q4. Solved using lag function.
Round 5 - Case Study 

The interviewer asked about my previous experience along with a few situation based questions and then gave me a case study to find out possible reasons for a decrease in the cancellations between order dispatch and order delivery.

Interview Preparation Tips

Topics to prepare for Meesho Business Analyst interview:
  • SQL
  • Problem solving
Interview preparation tips for other job seekers - SQL and problem solving are the most important for this interview.

Skills evaluated in this interview

Round 1 - Assignment 
Round 2 - One-on-one 

(1 Question)

  • Q1. Guesstimates, SQL, MS-Excel related questions.
Round 3 - Case Study 

A case study, few HR questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - SQL, Excel are must. Python is good to have.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Inkedin and was interviewed in Sep 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Coding Test 

Sql and python,numpy,pandas

Round 3 - Technical 

(1 Question)

  • Q1. Analyst skills,data handlling
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Referral and was interviewed in Aug 2023. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Coding Test 

HackerRank OA on SQL. 3 questions, 1 Hour with webcam proctoring.

Question 1:
"""
1. The Good and The Bad City

There is a blood bank which maintains two tables: DONOR that contains information on the people who are willing to donate blood and ACCEPTOR, the people who are in need of blood. The bank wants to conduct a survey and find out the city that has the best and the worst donor sum amount/acceptor sum amount ratio. Both ratios are unique. That is, exactly one city has the best ratio and exactly one city has the worst ratio.
The donor sum amount is the total amount of blood, regardless of blood group, that people are ready to donate. The acceptor sum amount is the total amount of blood needed by that city.
There must be exactly two rows that denote the best and the worst ratios. The order of the rows does not matter. Each row must contain the following attributes:

1. The city's name (CITY).
2. The ratio ( donor sum amount / acceptor sum amount ), correct to 4 decimal places.

The schema of the two tables is given below:
Schema
DONOR
Name Type Description
ID Integer It is the ID of the donor.
NAME String It is the name of the donor.
GENDER Character It is the gender of the donor.
CITY String It is the city where the donor lives.
BLOOD_GROUP String It is the blood group of the donor.
AMOUNT Integer It is the amount of blood in pints, which the donator can donate.
ACCEPTOR
Name Type Description
ID Integer It is the id of the acceptor.
NAME String It is the name of the acceptor.
GENDER Character It is the gender of the acceptor.
CITY String It is the city where the acceptor lives.
BLOOD_GROUP String It is the blood group of the acceptor.
AMOUNT Integer It is the amount of blood in pints, which the acceptor needs.
Sample Data Tables
DONOR
ID NAME GENDER CITY BLOOG_GROUP AMOUNT
1 MARIA F Warne, NH AB+ 7
2 DOROTHY F East Natchitoches, PA AB+ 3
3 CHARLES M East Natchitoches, PA A- 6
4 DOROTHY F East Natchitoches, PA AB+ 9
5 MICHAEL M Warne, NH A+ 1
ACCEPTOR
ID NAME GENDER CITY BLOOG_GROUP AMOUNT
1 LINDA F Warne, NH A+ 9
2 CHARLES M Warne, NH AB+ 8
3 RICHARD M East Natchitoches, PA AB+ 3
4 LINDA F East Natchitoches, PA A+ 1
5 PATRICIA F Warne, NH A+ 5

Sample Output

East Natchitoches, PA 4.5000
Warner, NH 0.3636



Explanation

The amount of blood available for donation in East Natchitoches, PA is 3 + 6 + 9 = 18.

The amount of blood needed in East Natchitoches, PA is 3 +1 = 4.

Hence, the ratio is = ( 18 : 4 ) = 4.5000.

The amount of blood available for donation in Warne, NH is 1 + 7 = 8.

The amount of blood needed in Warne, NH is 9 + 8 + 5 = 22.

Hence, the ratio is = ( 8 : 22 ) = 0.3636.
"""

Question 2:
"""
2. Maximum Discount Product

A department store maintains data on customers, products, and purchase records in three tables: CUSTOMER, PRODUCT, and PURCHASE. The store manager wants to know which product is on maximum discount for each category. Write a query to print the following fields for each category, ordered by category, ascending: category, product ID and discount for the product that has the maximum discount in the category. In the case of multiple products having same maximum discount within a category, print the product with minimum product_id.


Table Schema
CUSTOMER
Name Type Description
CUSTOMER_ID Integer A customer's ID in the inclusive range [1, 500]. This is a primary key.
CUSTOMER_NAME String A customer's name. This field contains between 1 and 100 characters (inclusive).
CITY String A city name. This field contains between 1 and 50 characters (inclusive).
STATE String A state name. This field contains between 1 and 50 characters (inclusive).


PRODUCT
Name Type Description
PRODUCT_ID Integer A product's ID in the inclusive range [1, 500]. This is a primary key.
PRODUCT_NAME String A product's name. This field contains between 1 and 50 characters (inclusive).
CATEGORY String A category name of the product. This field contains between 1 and 50 characters (inclusive).
PRICE Integer The price of the product in the inclusive range [500, 1000].
DISCOUNT Integer The discount associated with the product in the inclusive range [5, 20].
AVAILABLE Integer The availability of a product. It is 1 if the product is available or it is 0 if the product is not available.

PURCHASE
Name Type Description
ID Integer An id associated with a purchase that is done in the inclusive range [1, 1000]. This is a primary key.
CUSTOMER_ID Integer A customer ID. This is a foreign key to customer.customer_id.
PRODUCT_ID Integer A product ID. This is a foreign key to product.product_id.
PURCHASE_DATE Date The date associated with a purchase. The date falls in the range '2000-01-01' to '2000-12-31' (inclusive).
'
Sample Case 0

Sample Input for Custom Testing
CUSTOMER
CUSTOMER_ID CUSTOMER_NAME CITY STATE
1 Pickett Wilhelm Park SD
2 Pickett Ipswich AZ
3 Poole Farwell KS
4 Pollard Bent Pine WV
5 Phelps Momford Landing VA


PRODUCT
PRODUCT_ID PRODUCT_NAME CATEGORY PRICE DISCOUNT AVAILABLE
1 P-1 C-5 720 10 1
2 P-2 C-1 935 17 1
3 P-3 C-2 588 19 1
4 P-4 C-4 619 5 0
5 P-5 C-1 803 16 1


PURCHASE
ID CUSTOMER_ID PRODUCT_ID PURCHASE_DATE
1 5 5 2000-06-04
2 1 5 2000-11-24
3 1 3 2000-10-02
4 5 1 2000-08-06
5 5 3 2000-06-22
6 3 1 2000-06-30
7 2 5 2000-01-10
8 2 1 2000-07-26
9 3 5 2000-09-23
10 4 5 2000-09-02
11 3 2 2000-05-25



Sample Output

C-1 2 17
C-2 3 19
C-4 4 5
C-5 1 10

Explanation

By referring to the sample data above, we find that:

For category C-1, there are two products P-2 and P-5 with discount 17 and 16 respectively. So the maximum discount is for product P-2 which is 17.
For category C-2, there is only one product P-3 with discount 19, so this is the product with maximum discount in this category.
For category C-4, there is only one product P-4 with discount 5, so this is the product with maximum discount in this category.
For category C-5, there is only one product P-1 with discount 10, so this is the product with maximum discount in this category.
"""

Question 3:
"""
3. Increase in Population

You are provided with the records of births and deaths during the course of years. Their records consist of a year and a type, either 'birth' or 'death'. Determine the year(s) when the population is highest versus the starting population. Return the year and the amount of the increase in population. If there is a tie, return the earliest of them.


Schema

You are provided 1 table: records.
records
Name Type Description
id int The unique id of a record.
type char(5) The type of record (birth/death).
year int The year in which the birth/death happened.
Sample Data Tables
records
id type year
2187 birth 2002
9941 death 2001
4361 birth 2003
6477 death 2001
3478 birth 2005
9719 death 2005
7292 birth 2002
4931 death 2005
5833 birth 2002
9379 death 2001
3472 birth 2003
5580 death 2003
4472 birth 2002
5915 death 2004
2624 birth 2003
5223 death 2005
7198 birth 2002
5384 death 2001
7660 birth 2004
5302 death 2005
5192 birth 2003
2537 death 2003
5260 birth 2003
7218 death 2004
2726 birth 2002
3856 death 2002
6594 birth 2003
9013 death 2005
4657 birth 2001
1782 death 2005
9744 birth 2004
5149 death 2001
2054 birth 2003
7423 death 2003
7156 birth 2002
2956 death 2001
3273 birth 2001
3721 death 2002
9756 birth 2002
6632 death 2003


OUTPUT
year count
2003 5


Explanation
year count cumulative
2001 -4 -4
2002 6 2
2003 3 5
2004 0 5
2005 -5 0

The highest cumulative increase in population is in the years 2003 and 2004. Return the earlier of the two, so the output is:
2003 5
"""

Round 3 - Technical 

(1 Question)

  • Q1. No further communication received

Interview Preparation Tips

Interview preparation tips for other job seekers - SQL, joins, advanced sql
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed before Oct 2022. There were 3 interview rounds.

Round 1 - Coding Test 

3 SQL QUESTIONS, they were lengthy

Round 2 - Technical 

(2 Questions)

  • Q1. Joins and window function
  • Q2. Guesstimates and different puzzles
Round 3 - HR 

(1 Question)

  • Q1. Business case study

Interview Preparation Tips

Interview preparation tips for other job seekers - focus on sql and solve some guesstimates and case studies beforehand
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Company Website and was interviewed in Sep 2023. There were 5 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(1 Question)

  • Q1. SQL - BASIC TO ADVANCE
Round 3 - Technical 

(1 Question)

  • Q1. SQL BASED QUESTIONS WERE TO SOLVED IN THE INTERVIEW, WHERE THE QUESTIONS WERE GIVEN BY INTERVIEWER.
Round 4 - Case Study 

CASE STUDY ( BUSINESS RELATED PROBLEM + TECHNICAL)

Round 5 - One-on-one 

(1 Question)

  • Q1. BEHAVIORAL ROUND
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. It majorly based on basic sql and Python with some guesstimates.
Round 2 - Case Study 

It was based on a real life logistics scenario and then solving the case study.

Peel-works Interview FAQs

How many rounds are there in Peel-works Data Analyst interview?
Peel-works interview process usually has 2-3 rounds. The most common rounds in the Peel-works interview process are Resume Shortlist, Technical and One-on-one Round.
How to prepare for Peel-works 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 Peel-works. The most common topics and skills that interviewers at Peel-works expect are Advanced Excel, Business Analysis, Dashboards, Data Analysis and Data Analytics.
What are the top questions asked in Peel-works Data Analyst interview?

Some of the top questions asked at the Peel-works Data Analyst interview -

  1. STUPID HR CALLED ME 15 TIMES IN 2 HOURS WHEN I DID NOT PICK UP HER FIRST CALL. ...read more
  2. DON'T GIVE THE INTERVIEW ITSE...read more
  3. R software, excel f...read more

Tell us how to improve this page.

Peel-works Data Analyst Interview Process

based on 2 interviews

Interview experience

2
  
Poor
View more
Peel-works Data Analyst Salary
based on 15 salaries
₹3.9 L/yr - ₹7.2 L/yr
9% less than the average Data Analyst Salary in India
View more details

Peel-works Data Analyst Reviews and Ratings

based on 5 reviews

3.5/5

Rating in categories

3.5

Skill development

3.5

Work-life balance

3.8

Salary

3.2

Job security

3.5

Company culture

3.2

Promotions

3.5

Work satisfaction

Explore 5 Reviews and Ratings
Operations Manager
16 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Analyst
15 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Area Manager
14 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Analyst
10 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Relationship Manager
9 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Peel-works with

Zilingo

4.3
Compare

ShopX

4.3
Compare

Moglix

3.4
Compare

Meesho

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