AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Stanza Living
Compare
Filter interviews by
Stanza Living Data Analyst Interview Questions and Answers
Stanza Living Data Analyst Interview Experiences
3 interviews found
Anonymous
I applied via Job Portal and was interviewed in Feb 2023. There were 3 interview rounds.
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.
I didn't clear my first round interview
Interview Preparation Tips
All the best!
Selected
I applied via Referral and was interviewed before Aug 2022. There were 4 interview rounds.
Sql, excel questions were asked
To figure out the red colour car in delhi
(1 Question)
- Q1. Hr questions were asked to me
Interview Preparation Tips
Selected
I applied via IIM Jobs and was interviewed before Dec 2021. There were 3 interview rounds.
(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...
- Q2. Excel index match. Python loops and function
(1 Question)
- Q1. Business understanding, guesstimates etc.
Interview Preparation Tips
Skills evaluated in this interview
Interview questions from similar companies
I applied via campus placement at Nitte Meenakshi Institute of Technology, Bangalore and was interviewed in Nov 2024. There were 4 interview rounds.
Questions from arrays and strings and some aptitude questions
(2 Questions)
- Q1. How to merge 2 csv files
- Ans.
To merge two CSV files, you can use software like Microsoft Excel or programming languages like Python.
Open both CSV files in a software like Microsoft Excel.
Copy the data from one CSV file and paste it into the other CSV file.
Save the merged CSV file with a new name.
Alternatively, you can use programming languages like Python to merge CSV files by reading both files, combining the data, and writing to a new file.
- Q2. Basic questions on arrays
(1 Question)
- Q1. 3 reasons why u choose this company
- Ans.
I applied to this company because of its reputation in the industry, opportunities for growth, and company culture.
Reputation in the industry - I have heard great things about the company's innovative projects and successful track record.
Opportunities for growth - The company offers various training programs and career advancement opportunities for employees.
Company culture - I value a positive work environment and the...
(1 Question)
- Q1. Questions on python
Skills evaluated in this interview
Gautham Reddy
(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)
In the second technical round interview asked me about advanced sql topics, theory questions and two coding questions in joins and window functions.
(5 Questions)
- Q1. Basic Excel Questions
- Q2. Medium and Basic SQL Questions
- Q3. Resume based Question
- Q4. Case Study Questions
- Q5. Questions on Project
I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.
SQL based questions wer asked on joins , rank function,
Selected
I applied via LinkedIn and was interviewed in Apr 2024. There was 1 interview round.
(2 Questions)
- Q1. SQL base Question
- Q2. About your projects
I applied via Instahyre and was interviewed in May 2024. There were 2 interview rounds.
Asked to write different SQL queries.
1. Moving average of lf previous 10 days
2. For a data which records in and out time of an employee. How many employees were present in the office at a given time
3. A/B testing vs pre-post testing
1. Had to come up with a method to give a score to each user based on FRM(frequency, recency, monetory)
2. Guesstimate: how many burgers does McD sells in a day
Selected
I applied via Company Website and was interviewed in Jul 2023. There were 4 interview rounds.
Number sires, clock, logic, arithmetic, geometry
Code test basic, ans the basic knowledge, write code
(5 Questions)
- Q1. What is python?
- Ans.
Python is a high-level programming language known for its simplicity and readability.
Python is widely used for web development, data analysis, artificial intelligence, and scientific computing.
It emphasizes code readability and uses indentation to define code blocks.
Python has a large standard library and a vibrant community of developers.
Example: print('Hello, World!')
Example: import pandas as pd
- Q2. What is python used for?
- Ans.
Python is a versatile programming language used for data analysis, web development, artificial intelligence, automation, and more.
Data analysis and visualization
Web development (Django, Flask)
Artificial intelligence and machine learning (TensorFlow, PyTorch)
Automation and scripting
Scientific computing (NumPy, SciPy)
- Q3. What type of language is python?
- Ans.
Python is a high-level programming language known for its simplicity and readability.
Python is an interpreted language, meaning it does not need to be compiled before running.
It supports multiple programming paradigms, including object-oriented, imperative, and functional programming.
Python has a large standard library and a thriving community, making it versatile and widely used.
Example: Python is used for web develop...
- Q4. What is oops in python?
- Ans.
Object-oriented programming (OOP) is a programming paradigm based on the concept of 'objects', which can contain data and code.
OOP allows for the organization of code into reusable components called classes.
Classes can have attributes (variables) and methods (functions) associated with them.
In Python, everything is an object, and classes can be defined using the 'class' keyword.
Encapsulation, inheritance, and polymorph
- Q5. What is array in python?
- Ans.
An array in Python is a data structure that stores a collection of elements of the same type.
Arrays can store elements such as integers, floats, or strings.
Arrays are indexed starting from 0, with elements accessed using their index.
Example: arr = ['apple', 'banana', 'cherry']
Interview Preparation Tips
- Advanced Excel
- SQL Server
- Python
Skills evaluated in this interview
Stanza Living Interview FAQs
Tell us how to improve this page.
Stanza Living Interviews By Designations
- Stanza Living Property Manager Interview Questions
- Stanza Living Sales Associate Interview Questions
- Stanza Living Assistant Manager Interview Questions
- Stanza Living Data Analyst Interview Questions
- Stanza Living Nodal Officer Interview Questions
- Stanza Living Program Manager Interview Questions
- Stanza Living Regional Sales Manager Interview Questions
- Stanza Living Senior Associate Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Data Science Analyst Interview Questions
- Show more
Stanza Living Data Analyst Interview Process
based on 3 interviews
1 Interview rounds
- Resume Shortlist Round
Data Analyst Interview Questions from Similar Companies
Stanza Living Data Analyst Reviews and Ratings
based on 4 reviews
Rating in categories
|
Property Manager
274
salaries
|  ₹1.4 L/yr - ₹5.2 L/yr |
|
Cluster Manager
172
salaries
| ₹5.5 L/yr - ₹16.1 L/yr |
|
Resident Manager
98
salaries
| ₹1.8 L/yr - ₹6.1 L/yr |
|
Sales Associate
90
salaries
| ₹3.2 L/yr - ₹9 L/yr |
|
Senior Associate
75
salaries
| ₹4.3 L/yr - ₹10 L/yr |
Zolo
OYO Life
Nestaway
CoLive
- Home >
- Interviews >
- Stanza Living Interview Questions >
- Stanza Living Data Analyst Interview Questions
