Upload Button Icon Add office photos
Engaged Employer

i

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

Stanza Living Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Stanza Living Data Analyst Interview Questions and Answers

Updated 10 Aug 2023

Stanza Living Data Analyst Interview Experiences

3 interviews found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 16 Mar 2023

Interview experience
3
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 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

user image Anonymous

posted on 10 Aug 2023

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected 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 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

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

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 9 Dec 2022

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected 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 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
  • Q2. Excel index match. Python loops and function
Round 3 - One-on-one 

(1 Question)

  • Q1. Business understanding, guesstimates etc.

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

Interview questions from similar companies

Interview experience
4
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 tips
Round 2 - Assignment 

Send assignment doings MS Excel

Round 3 - Technical 

(2 Questions)

  • Q1. Asked about the previous project
  • Q2. What about your roles in previous company

Interview Preparation Tips

Topics to prepare for Zolo Data Analyst interview:
  • Excel

Interview Questionnaire 

2 Questions

  • Q1. SQL and Excel were the key that helped me get this job.
  • Q2. Puzzles
Interview experience
1
Bad
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Apr 2023. 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 tips
Round 2 - Technical 

(6 Questions)

  • Q1. Joins, operations questions not data analysis questions
  • Q2. Customer retention case study
  • Q3. Cumulative sum for given table
  • Ans. 

    To calculate cumulative sum for a given table

    • Sort the table in ascending order based on the column you want to calculate the cumulative sum for

    • Add a new column to the table to store the cumulative sum

    • Iterate through each row of the table and calculate the cumulative sum by adding the current row's value to the previous row's cumulative sum

    • Store the cumulative sum in the new column for each row

  • Answered by AI
  • Q4. Do you have experience in operations/data entry role
  • Ans. 

    Yes, I have experience in both operations and data entry roles.

    • I have worked as a data entry operator for a pharmaceutical company where I was responsible for entering patient data into the system.

    • In my previous role as an operations analyst, I was responsible for analyzing data and creating reports for the management team.

    • I have experience using various data entry software such as Microsoft Excel and Google Sheets.

    • I a...

  • Answered by AI
  • Q5. As a data analyst can you do data entry work also?
  • Ans. 

    Yes, I can do data entry work as a data analyst.

    • Data entry work is a part of data analysis process.

    • I have experience in data entry work and can perform it efficiently.

    • Data entry work includes entering data into spreadsheets, databases, or other software.

    • I understand the importance of accurate data entry for effective analysis.

  • Answered by AI
  • Q6. Normal excel statements like if, vlookup, xlookups etc.,

Interview Preparation Tips

Interview preparation tips for other job seekers - 1) Waste of time (never trust interviewer who explains about the role)
2) they are looking for candidates for data reporting operations guy from a tier 1 college
3) as discussed with the interviewer the profile will be like a data entry operations role so get clarification on the role properly.
4) if you get an offer letter try to make this company as least priority company as the JD is not clear and the way they explain the case study is truly confusing.
5) other than this central tendency, normal crunching, joins, etc,.
6) People from non - data analytics team took an interview I hope there is no data analyst in the company while checking in LinkedIn and even the interviewer mentioned the same.
7) Interview will get rescheduled several times because of the interviewer and will be more delay
8) as per their discussion it will be more about data reporting in google sheets, excel on a daily basis i guess and I hope there won't be any proper predictive or quantitative or qualitative analysis.
9) if you are looking for better learning, growth and advancement in your career then this is not a correct company for you(that's how I decided when comparing offers from other company).
10) try to communicate with employees of the company who are in current role or past role get a better understanding.
11) current company situtation might push you but take a better decision.
12)chhallaaang lagaane se pahale dekho.

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Apr 2023. There were 6 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 - HR 

(2 Questions)

  • Q1. Screening questions
  • Q2. Name, age, qualification, prior experience etc
Round 3 - Case Study 

Operation questions like vlookups, Hlookups, xlookups etc,.

Round 4 - Case Study 

Reporting questions like pivot tables, typing speed, power pivots, pricing sheet preparation

Round 5 - Case Study 

SQL queries like joins, aggregation functions, filters etc,.

Round 6 - One-on-one 

(3 Questions)

  • Q1. Advanced analytics and finding trends and patterns with MH - operations data
  • Q2. How fast can you prepare a bar chart with product operations data
  • Ans. 

    I can prepare a bar chart with product operations data within a few minutes.

    • I have experience using data visualization tools like Tableau, Power BI, or Excel to quickly create bar charts.

    • I am proficient in organizing and cleaning data to ensure accurate representation in the chart.

    • I can customize the chart with relevant labels, colors, and titles to make it visually appealing and easy to understand.

  • Answered by AI
  • Q3. How can I do merge multiple excel files together
  • Ans. 

    You can merge multiple Excel files together using the 'Consolidate' feature in Excel.

    • Open Excel and go to the 'Data' tab

    • Click on 'Consolidate' in the 'Data Tools' group

    • Select the files you want to merge and choose the desired options

    • Click 'OK' to merge the files together

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Mar 2023. 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 tips
Round 2 - HR 

(2 Questions)

  • Q1. What’s your previous experience
  • Ans. 

    I have 3 years of experience as a data analyst in the finance industry.

    • Worked with large datasets to extract meaningful insights

    • Performed data cleaning, transformation, and visualization

    • Created and maintained dashboards and reports for stakeholders

    • Conducted statistical analysis and built predictive models

    • Collaborated with cross-functional teams to identify business opportunities

  • Answered by AI
  • Q2. What’s your skills for the current role
  • Ans. 

    I have strong skills in data analysis, including proficiency in statistical analysis, data visualization, and programming languages such as Python and SQL.

    • Proficient in statistical analysis techniques

    • Skilled in data visualization using tools like Tableau

    • Strong programming skills in Python and SQL

    • Experience with data cleaning and preprocessing

    • Ability to interpret and communicate insights from data

    • Familiarity with machin...

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Udaan Data Analyst interview:
  • SQL
  • Python
Interview preparation tips for other job seekers - Good to have python and sql skills and for data analyst these skills are must plus one visualisation tool
Interview experience
5
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 tips
Round 2 - One-on-one 

(1 Question)

  • Q1. Previous company experience and current company roles and responsibilities
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Interviewer asked me basic SQL questions
  • Q2. In the second technical round he asked me advanced SQL topics (Windows Functions, Joins & Subqueries)
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 -

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

Tell us how to improve this page.

Stanza Living Data Analyst Interview Process

based on 3 interviews

1 Interview rounds

  • Resume Shortlist Round
View more

Fast track your campus placements

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 Data Analyst Reviews and Ratings

based on 4 reviews

2.3/5

Rating in categories

2.4

Skill development

1.3

Work-life balance

2.8

Salary

1.6

Job security

1.8

Company culture

2.2

Promotions

2.9

Work satisfaction

Explore 4 Reviews and Ratings
Property Manager
264 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Cluster Manager
176 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Resident Manager
103 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Sales Associate
89 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Associate
75 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Stanza Living with

Zolo

3.4
Compare

OYO Life

3.6
Compare

Nestaway

3.9
Compare

CoLive

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