4 Stanza Living Data Analyst Interview Questions & Answers | Complete Prep Guide 2025

Stanza Living Data Analyst Interview Experiences

3 interviews found

Data Analyst Interview Questions & Answers

Anonymous

posted on 16 Mar 2023

Interview experience

Average

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

No response

I applied via Job Portal and was interviewed in Feb 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 Resume tips

Round 2 - Coding Test

There were 3 SQL questions
Q1. Find the second highest transaction I'd
Q2. Find the total transaction amount who signed up yesterday
Q3. How to calculate running sum without using window functions.
Excel question
Q1. How to get the data in pivot format without using pivot table option.

Round 3 - Aptitude Test

I didn't clear my first round interview

Interview Preparation Tips

Interview preparation tips for other job seekers - It was easy. Just brush up your skills beforehand.
All the best!

Data Analyst Interview Questions & Answers

Anonymous

posted on 10 Aug 2023

Interview experience

Good

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

Selected

I applied via Referral and was interviewed before Aug 2022. There were 4 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 Resume tips

Round 2 - Coding Test

Sql, excel questions were asked

Round 3 - Case Study

To figure out the red colour car in delhi

Round 4 - HR

(1 Question)

Q1. Hr questions were asked to me

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Good work, confused higher management and middle management are very scared of their bosses.

Data Analyst Interview Questions & Answers

Anonymous

posted on 9 Dec 2022

Interview experience

Good

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

Selected

I applied via IIM Jobs and was interviewed before Dec 2021. 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 Resume tips

Round 2 - Technical

(2 Questions)

Q1. SQL queries using group by and windows function.

Ans.

Group by and window functions are used in SQL queries to aggregate data and perform calculations on subsets of data.

Group by is used to group data based on one or more columns and perform aggregate functions on each group.
Window functions are used to perform calculations on a subset of data within a group, without affecting the grouping of the data.
Examples of aggregate functions include SUM, AVG, COUNT, MAX, and MIN.
E...

Answered by AI

View 1 more answer

Q2. Excel index match. Python loops and function

Add your answer

Round 3 - One-on-one

(1 Question)

Q1. Business understanding, guesstimates etc.

Add your answer

Interview Preparation Tips

Interview preparation tips for other job seekers - Practice sql before the interview. You will be judged on that.

Skills evaluated in this interview

Top trending discussions

View All

Interview Tips & Stories

5d (edited)

timepasstiwari

A Digital Markter

Got Rejected In an Interview, Just Because I Didn’t Answer a Personal Question

So, I got invited for this interview, and they told me to be there at 9 AM. Of course, I get there early, like 8:30, because I don't want to be late. But then I end up waiting for 1.5 hours... read more

Got a question about Stanza Living?

Ask anonymously on communities.

Interview questions from similar companies

Data Analyst Interview Questions & Answers

Zolo

Anonymous

posted on 25 Jul 2020

Interview Questionnaire

2 Questions

Q1. SQL and Excel were the key that helped me get this job.

Add your answer

Q2. Puzzles

Add your answer

Data Analyst Interview Questions & Answers

Zolo

Anonymous

posted on 21 Jun 2023

Interview experience

Good

Difficulty level

Moderate

Process Duration

2-4 weeks

Result

No response

I applied via LinkedIn and was interviewed in May 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 Resume tips

Round 2 - Assignment

Send assignment doings MS Excel

Round 3 - Technical

(2 Questions)

Q1. Asked about the previous project

Add your answer

Q2. What about your roles in previous company

Add your answer

Interview Preparation Tips

Topics to prepare for Zolo Data Analyst interview:

Excel

Data Analyst Interview Questions & Answers

Meesho

Anonymous

posted on 19 Jun 2023

Interview experience

Excellent

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

I applied via Job Portal and was interviewed before Jun 2022. There were 2 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 Resume tips

Round 2 - One-on-one

(1 Question)

Q1. Previous company experience and current company roles and responsibilities

Add your answer

Data Analyst Interview Questions & Answers

Meesho

Anonymous

posted on 12 Feb 2024

Interview experience

Good

Difficulty level

Moderate

Process Duration

Less than 2 weeks

Result

Selected

I applied via Company Website and was interviewed before Feb 2023. There were 2 interview rounds.

Round 1 - Coding Test

Simple SQL & Excel test

Round 2 - One-on-one

(1 Question)

Q1. Will Face hiring Manager

Add your answer

Data Analyst Interview Questions & Answers

Meesho

Anonymous

posted on 30 May 2024

Interview experience

Average

Difficulty level

Process Duration

Result

I applied via Naukri.com and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Coding Test

Test was based on SQL, coding and MCQ. Coding involved nested query.

Data Analyst Interview Questions & Answers

Meesho

vinay kalikota

posted on 2 Sep 2024

Interview experience

Good

Difficulty level

Process Duration

Result

Round 1 - Coding Test

There are 2 coding challenges and 7 objective questions

Round 2 - Technical

(1 Question)

Q1. Technical questions related to role

Add your answer

Data Analyst Interview Questions & Answers

Meesho

Gautham Reddy

posted on 8 Nov 2024

Interview experience

Excellent

Difficulty level

Process Duration

Result

Round 1 - Technical

(2 Questions)

Q1. Interviewer asked me basic SQL questions

Add your answer

Q2. In the second technical round he asked me advanced SQL topics (Windows Functions, Joins & Subqueries)

Add your answer

Round 2 - Coding Test

In the second technical round interview asked me about advanced sql topics, theory questions and two coding questions in joins and window functions.

Stanza Living Interview FAQs

How many rounds are there in Stanza Living Data Analyst interview?

Stanza Living interview process usually has 3-4 rounds. The most common rounds in the Stanza Living interview process are Resume Shortlist, Coding Test and Technical.

How to prepare for Stanza Living 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 Stanza Living. The most common topics and skills that interviewers at Stanza Living expect are SQL, Python, Advanced Excel, Analytics and Data Analytics.

What are the top questions asked in Stanza Living Data Analyst interview?

Some of the top questions asked at the Stanza Living Data Analyst interview -

SQL queries using group by and windows functi...read more
Excel index match. Python loops and funct...read more
business understanding, guesstimates e...read more

Tell us how to improve this page.

Stanza Living Interviews By Designations

Interview Questions for Popular Designations

Stanza Living Data Analyst Interview Process

based on 3 interviews

1 Interview rounds

Resume Shortlist Round

Meesho Data Analyst Interview Questions

3.7

• 9 Interviews

Zolo Data Analyst Interview Questions

3.4

• 2 Interviews

Swiggy Data Analyst Interview Questions

3.8

• 2 Interviews

Zepto Data Analyst Interview Questions

3.5

• 2 Interviews

Urban Company Data Analyst Interview Questions

3.4

• 2 Interviews

Porter Data Analyst Interview Questions

3.9

• 2 Interviews

PharmEasy Data Analyst Interview Questions

3.7

• 2 Interviews

ShareChat Data Analyst Interview Questions

3.6

• 2 Interviews

Udaan Data Analyst Interview Questions

4.0

• 1 Interview

Digit Insurance Data Analyst Interview Questions

3.9

• 1 Interview

View all

Vel Technology, Chennai Placement Questions

1 Interview

View all

Stanza Living Data Analyst Salary

based on 37 salaries

₹4.8 L/yr - ₹13 L/yr

47% more than the average Data Analyst Salary in India

View more details

Stanza Living Salaries in India

Property Manager 242 salaries	₹0 L/yr - ₹0 L/yr
Cluster Manager 176 salaries	₹0 L/yr - ₹0 L/yr
Resident Manager 103 salaries	₹0 L/yr - ₹0 L/yr
Sales Associate 92 salaries	₹0 L/yr - ₹0 L/yr
Senior Associate 75 salaries	₹0 L/yr - ₹0 L/yr