i
Stanza Living
Filter interviews by
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
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
I applied via IIM Jobs and was interviewed before Dec 2021. There were 3 interview rounds.
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...
I applied via LinkedIn and was interviewed in May 2023. There were 3 interview rounds.
Send assignment doings MS Excel
I applied via Approached by Company and was interviewed in Apr 2023. There were 2 interview rounds.
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
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...
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.
I applied via Approached by Company and was interviewed in Apr 2023. There were 6 interview rounds.
Operation questions like vlookups, Hlookups, xlookups etc,.
Reporting questions like pivot tables, typing speed, power pivots, pricing sheet preparation
SQL queries like joins, aggregation functions, filters etc,.
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.
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
I applied via Referral and was interviewed in Mar 2023. There were 2 interview rounds.
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
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...
I applied via Job Portal and was interviewed before Jun 2022. There were 2 interview rounds.
In the second technical round interview asked me about advanced sql topics, theory questions and two coding questions in joins and window functions.
based on 3 interviews
1 Interview rounds
based on 4 reviews
Rating in categories
Property Manager
264
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
89
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Associate
75
salaries
| ₹0 L/yr - ₹0 L/yr |
Zolo
OYO Life
Nestaway
CoLive