Upload Button Icon Add office photos

Urban Company

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Urban Company Data Analyst Interview Questions and Answers

Updated 22 Oct 2024

Urban Company Data Analyst Interview Experiences

2 interviews found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 22 Oct 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - Technical 

(2 Questions)

  • Q1. SQL base Question
  • Q2. About your projects

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 3 Sep 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
No response

I applied via Referral and was interviewed before Sep 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

Quant, LR, puzzles, cat based level 2 questions

Round 2 - Technical 

(2 Questions)

  • Q1. Difference between tuple nd list
  • Ans. 

    Tuple is immutable and ordered, while list is mutable and ordered in Python.

    • Tuple is created using parentheses () while list is created using square brackets []

    • Tuple elements cannot be changed once assigned, while list elements can be modified

    • Tuple is faster than list for iteration and accessing elements

    • Example: tuple = (1, 2, 3) and list = [1, 2, 3]

  • Answered by AI
  • Q2. How will you cut a cake into 8 equal pieces by 3 cuts
Round 3 - HR 

(2 Questions)

  • Q1. Walk me through ur cv
  • Ans. 

    I have a strong background in data analysis with experience in various industries.

    • Bachelor's degree in Statistics with a focus on data analysis

    • Proficient in SQL, Python, and data visualization tools like Tableau

    • Experience working with large datasets and conducting statistical analysis

    • Completed internships at XYZ Company and ABC Organization

    • Presented findings at industry conferences

  • Answered by AI
  • Q2. What have learnt from this experience?
  • Ans. 

    I have learned to effectively analyze and interpret data to derive meaningful insights and make informed decisions.

    • Developed strong analytical skills through hands-on experience with various data analysis tools and techniques

    • Improved ability to identify trends, patterns, and outliers in data sets

    • Enhanced communication skills by presenting findings and recommendations to stakeholders

    • Learned to collaborate with team memb

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - just be honest , calm

Skills evaluated in this interview

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

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

I applied via Campus Placement and was interviewed in Nov 2024. There were 4 interview rounds.

Round 1 - Coding Test 

Questions from arrays and strings and some aptitude questions

Round 2 - One-on-one 

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

  • Answered by AI
  • Q2. Basic questions on arrays
Round 3 - HR 

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

  • Answered by AI
Round 4 - Technical 

(1 Question)

  • Q1. Questions on python

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Instahyre and was interviewed in May 2024. There were 2 interview rounds.

Round 1 - Coding Test 

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

Round 2 - Case Study 

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

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

(4 Questions)

  • Q1. How do you setup a Dark Store?
  • Ans. 

    Setting up a Dark Store involves converting a retail store into a fulfillment center for online orders.

    • Select a suitable location for the Dark Store, preferably in a centralized area with good access to transportation.

    • Optimize the layout of the store for efficient picking, packing, and shipping of orders.

    • Implement inventory management systems to track stock levels accurately and prevent stockouts.

    • Train staff on order f...

  • Answered by AI
  • Q2. How do joins work in the simplest manner?
  • Ans. 

    Joins combine data from two or more tables based on a related column.

    • Joins are used to retrieve data from multiple tables based on a related column

    • Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

    • Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id

  • Answered by AI
  • Q3. Write a basic query explaining the order of execution?
  • Ans. 

    The order of execution in a query determines the sequence in which operations are performed.

    • 1. The order of execution in a query typically follows the sequence: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.

    • 2. The FROM clause specifies the tables involved in the query.

    • 3. The WHERE clause filters the rows based on specified conditions.

    • 4. The GROUP BY clause groups the rows that have the same values into summary rows.

    • 5...

  • Answered by AI
  • Q4. Difference between Group By and Distinct?
  • Ans. 

    Group By is used to aggregate data based on a specific column, while Distinct is used to remove duplicate rows from a result set.

    • Group By is used with aggregate functions like COUNT, SUM, AVG, etc.

    • Distinct is used to retrieve unique values from a column or set of columns.

    • Group By can be used to group data based on multiple columns, while Distinct operates on individual columns only.

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Blinkit Data Analyst interview:
  • SQL
  • joins
  • window functions

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Jul 2023. 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 - Aptitude Test 

Number sires, clock, logic, arithmetic, geometry

Round 3 - Coding Test 

Code test basic, ans the basic knowledge, write code

Round 4 - Technical 

(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

  • Answered by AI
  • 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)

  • Answered by AI
  • 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...

  • Answered by AI
  • 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

  • Answered by AI
  • 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']

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Swiggy Data Analyst interview:
  • Advanced Excel
  • SQL Server
  • Python
Interview preparation tips for other job seekers - online interview

Skills evaluated in this interview

Data Analyst Interview Questions & Answers

Meesho user image Abhilasa Barman

posted on 26 Dec 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

I was asked a medium-level SQL question that involved the RANK function.

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

I applied via Naukri.com and was interviewed before Apr 2021. There were 4 interview rounds.

Round 1 - Aptitude Test 

Technica questions related to sql

Round 2 - Technical 

(1 Question)

  • Q1. Some technical questions related to sql and advance excel .
Round 3 - One-on-one 

(1 Question)

  • Q1. Some questions related to cars insurance and second cars
Round 4 - HR 

(1 Question)

  • Q1. Salary discussion and some hr questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on sql join where clause having clause etc and advance excel
Interview experience
3
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.

Contribute & help others!
anonymous
You can choose to be anonymous

Urban Company Interview FAQs

How many rounds are there in Urban Company Data Analyst interview?
Urban Company interview process usually has 2 rounds. The most common rounds in the Urban Company interview process are Technical, HR and Aptitude Test.
How to prepare for Urban Company 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 Urban Company. The most common topics and skills that interviewers at Urban Company expect are Analytical skills, Collaboration, Problem Solving, Python and SQL.
What are the top questions asked in Urban Company Data Analyst interview?

Some of the top questions asked at the Urban Company Data Analyst interview -

  1. how will you cut a cake into 8 equal pieces by 3 c...read more
  2. difference between tuple nd l...read more
  3. walk me through ur...read more

Recently Viewed

INTERVIEWS

Aptiv

No Interviews

SALARIES

InMobi

INTERVIEWS

Uber

No Interviews

INTERVIEWS

SKH Metals

No Interviews

INTERVIEWS

Urban Company

No Interviews

INTERVIEWS

InMobi

No Interviews

INTERVIEWS

InMobi

No Interviews

INTERVIEWS

InMobi

No Interviews

INTERVIEWS

InMobi

No Interviews

SALARIES

Urban Company

Tell us how to improve this page.

Urban Company Data Analyst Interview Process

based on 2 interviews

Interview experience

5
  
Excellent
View more
Urban Company Data Analyst Salary
based on 31 salaries
₹2 L/yr - ₹5.5 L/yr
32% less than the average Data Analyst Salary in India
View more details

Urban Company Data Analyst Reviews and Ratings

based on 2 reviews

1.4/5

Rating in categories

1.4

Skill development

1.6

Work-life balance

1.6

Salary

1.4

Job security

1.4

Company culture

1.4

Promotions

1.4

Work satisfaction

Explore 2 Reviews and Ratings
Category Manager
514 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Development Associate
488 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Beautician
157 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Category Manager
136 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

AC Technician
134 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Urban Company with

Housejoy

4.2
Compare

Urban Ladder

3.7
Compare

Qube Services

4.4
Compare

Zimmber

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