Upload Button Icon Add office photos

Urban Company

Compare button icon Compare button icon Compare

Filter interviews by

Urban Company Senior Data Analyst Interview Questions, Process, and Tips

Updated 17 Mar 2022

Urban Company Senior Data Analyst Interview Experiences

1 interview found

I applied via Referral and was interviewed in Feb 2022. There were 5 interview rounds.

Round 1 - Assignment 

Given time series data of provider, compute hour wise provider wise no of seconds online

Round 2 - Technical 

(2 Questions)

  • Q1. Case study on the customer churn.
  • Q2. Questions on Probability and CLT
Round 3 - Technical 

(11 Questions)

  • Q1. What are assumptions in Linear Regression
  • Ans. 

    Assumptions in Linear Regression

    • Linear relationship between independent and dependent variables

    • Homoscedasticity (constant variance) of residuals

    • Independence of residuals

    • Normal distribution of residuals

    • No multicollinearity among independent variables

  • Answered by AI
  • Q2. What are overfitting and underfitting
  • Ans. 

    Overfitting and underfitting are two common problems in machine learning models.

    • Overfitting occurs when a model is too complex and fits the training data too closely, resulting in poor performance on new data.

    • Underfitting occurs when a model is too simple and cannot capture the underlying patterns in the data, resulting in poor performance on both training and new data.

    • Overfitting can be prevented by using regularizati...

  • Answered by AI
  • Q3. How do you improve the performance of Linear Regression
  • Ans. 

    To improve the performance of Linear Regression, you can consider feature engineering, regularization, and handling outliers.

    • Perform feature engineering to create new features that capture important information.

    • Apply regularization techniques like L1 or L2 regularization to prevent overfitting.

    • Handle outliers by either removing them or using robust regression techniques.

    • Check for multicollinearity among the independent...

  • Answered by AI
  • Q4. What are the metrics used to evaluate Linear Regression
  • Ans. 

    Metrics used to evaluate Linear Regression

    • Mean Squared Error (MSE)

    • Root Mean Squared Error (RMSE)

    • R-squared (R²)

    • Adjusted R-squared (Adj R²)

    • Mean Absolute Error (MAE)

    • Residual Sum of Squares (RSS)

    • Akaike Information Criterion (AIC)

    • Bayesian Information Criterion (BIC)

  • Answered by AI
  • Q5. What is Cost function and Error Function
  • Ans. 

    Cost function measures the difference between predicted and actual values. Error function measures the average of cost function.

    • Cost function is used to evaluate the performance of a machine learning model.

    • It measures the difference between predicted and actual values.

    • Error function is the average of cost function over the entire dataset.

    • It is used to optimize the parameters of the model.

    • Examples of cost functions are ...

  • Answered by AI
  • Q6. How do you handle Overfitting in Linear Regression
  • Ans. 

    Overfitting in Linear Regression can be handled by using regularization techniques.

    • Regularization techniques like Ridge regression and Lasso regression can help in reducing overfitting.

    • Cross-validation can be used to find the optimal regularization parameter.

    • Feature selection and dimensionality reduction techniques can also help in reducing overfitting.

    • Collecting more data can help in reducing overfitting by providing

  • Answered by AI
  • Q7. What is the difference between Least Squares Method and the maximum likelihood
  • Ans. 

    Least Squares Method and Maximum Likelihood are both used to estimate parameters, but differ in their approach.

    • Least Squares Method minimizes the sum of squared errors between the observed and predicted values.

    • Maximum Likelihood estimates the parameters that maximize the likelihood of observing the given data.

    • Least Squares Method assumes that the errors are normally distributed and independent.

    • Maximum Likelihood does n...

  • Answered by AI
  • Q8. What is the formula of Logistic Regression
  • Ans. 

    Logistic Regression formula is used to model the probability of a certain event occurring.

    • The formula is: P(Y=1) = e^(b0 + b1*X1 + b2*X2 + ... + bn*Xn) / (1 + e^(b0 + b1*X1 + b2*X2 + ... + bn*Xn))

    • Y is the dependent variable and X1, X2, ..., Xn are the independent variables

    • b0, b1, b2, ..., bn are the coefficients that need to be estimated

    • The formula is used to predict the probability of a binary outcome, such as whether...

  • Answered by AI
  • Q9. What is Type I and Type II error
  • Ans. 

    Type I error is rejecting a true null hypothesis, while Type II error is failing to reject a false null hypothesis.

    • Type I error is also known as a false positive

    • Type II error is also known as a false negative

    • Type I error occurs when the significance level is set too high

    • Type II error occurs when the significance level is set too low

    • Examples: Type I error - Convicting an innocent person, Type II error - Failing to convi...

  • Answered by AI
  • Q10. What metrics do you use to evaluate classification models
  • Ans. 

    Metrics used to evaluate classification models

    • Accuracy

    • Precision

    • Recall

    • F1 Score

    • ROC Curve

    • Confusion Matrix

  • Answered by AI
  • Q11. How do you handle overfitting and underfitting in Decision Trees
  • Ans. 

    Overfitting in decision trees can be handled by pruning, reducing tree depth, increasing dataset size, and using ensemble methods.

    • Prune the tree to remove unnecessary branches

    • Reduce tree depth to prevent overfitting

    • Increase dataset size to improve model generalization

    • Use ensemble methods like Random Forest to reduce overfitting

    • Underfitting can be handled by increasing tree depth, adding more features, and reducing regu...

  • Answered by AI
Round 4 - Case Study 

Case Study - How do you improve user engagement of Facebook?
Guesstimates - How many people watched the Squid Game series on Netflix

Round 5 - Case Study 

How do you reduce partner churn in UC?

Interview Preparation Tips

Topics to prepare for Urban Company Senior Data Analyst interview:
  • Machine Learning
  • Statistics
  • Case Studies
Interview preparation tips for other job seekers - Be thorough with Mathematics behind ML Algo, Practice Case Study Interviews.

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-

I applied via Job Portal

Round 1 - Coding Test 

SQL and Python data analysis questions

Round 2 - Technical 

(1 Question)

  • Q1. How do you match the data in different columns.
  • Ans. 

    Matching data in different columns involves comparing the values in the columns and identifying similarities or patterns.

    • Use string matching techniques like exact match, partial match, or fuzzy matching.

    • Apply data cleaning and preprocessing techniques to standardize the data before matching.

    • Utilize advanced algorithms like Levenshtein distance or Jaccard similarity for more complex matching.

    • Consider using database join...

  • Answered by AI

I applied via LinkedIn and was interviewed in Sep 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 - One-on-one 

(2 Questions)

  • Q1. The hr scheduled a call with the analytics manager ,who asked about my experience and general details ,some background about projects and previous work ,why this job etc .30-40 minutes conversation.
  • Q2. Just a casual brief conversation
Round 3 - One-on-one 

(2 Questions)

  • Q1. Second round was with a senior analyst ,who asked 5-6 sql related questions , problems to solve etc ,tables to create ,joins ,window functions etc basic sql
  • Q2. Very friendly interviewer , you are allowed to google the syntax
Round 4 - One-on-one 

(1 Question)

  • Q1. Another round with the analytics head , case study ,problem solving ,logical reasoning etc.

Interview Preparation Tips

Interview preparation tips for other job seekers - Brush up sql concepts,joins,window functions etc.
Basic stats and mental math
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 Questionnaire 

2 Questions

  • Q1. Explain Normal distribution
  • Ans. 

    Normal distribution is a probability distribution that is symmetric and bell-shaped.

    • It is also known as Gaussian distribution.

    • It is characterized by mean and standard deviation.

    • Many natural phenomena follow normal distribution, such as height and weight of individuals.

    • 68% of the data falls within one standard deviation of the mean, 95% within two standard deviations, and 99.7% within three standard deviations.

    • It is wid...

  • Answered by AI
  • Q2. Types of jobs in sql
  • Ans. 

    SQL jobs include database administrator, data analyst, data scientist, business intelligence analyst, and software developer.

    • Database Administrator

    • Data Analyst

    • Data Scientist

    • Business Intelligence Analyst

    • Software Developer

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare for MySql thoroughly

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

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
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Company Website and was interviewed before Feb 2023. There was 1 interview round.

Round 1 - Technical 

(5 Questions)

  • Q1. SQL related questions like joins
  • Q2. Types of join in sql
  • Ans. 

    Types of join in SQL include inner join, left join, right join, and full outer join.

    • Inner join returns only the matching records from both tables.

    • Left join returns all records from the left table and the matching records from the right table.

    • Right join returns all records from the right table and the matching records from the left table.

    • Full outer join returns all records when there is a match in either the left or rig

  • Answered by AI
  • Q3. Practical use of left join
  • Ans. 

    A left join is used to combine data from two tables based on a common column, including all records from the left table.

    • Left join returns all rows from the left table and the matching rows from the right table.

    • It is useful when you want to retrieve all records from the left table, even if there are no matches in the right table.

    • The result of a left join will have NULL values in the columns from the right table where th...

  • Answered by AI
  • Q4. Number of rows after applying certain join operations
  • Ans. 

    The number of rows after applying join operations depends on the type of join used and the data in the tables being joined.

    • Inner join retains only the rows that have matching values in both tables

    • Left join retains all rows from the left table and the matched rows from the right table

    • Right join retains all rows from the right table and the matched rows from the left table

    • Full outer join retains all rows when there is a

  • Answered by AI
  • Q5. Difference between vlookup in excel and some function in sql
  • Ans. 

    VLOOKUP in Excel is used to search for a value in a table and return a corresponding value, while SQL functions like JOIN and WHERE are used to retrieve data from multiple tables based on specified conditions.

    • VLOOKUP is specific to Excel and works on a single table, while SQL functions can work on multiple tables.

    • VLOOKUP requires the table to be sorted in ascending order, while SQL functions do not have this requiremen...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well for SQL

Skills evaluated in this interview

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

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

Round 1 - Coding Test 

HackerRank Test - Python, SQL

Urban Company Interview FAQs

How many rounds are there in Urban Company Senior Data Analyst interview?
Urban Company interview process usually has 5 rounds. The most common rounds in the Urban Company interview process are Technical, Case Study and Assignment.
How to prepare for Urban Company Senior 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 Python, SQL, Business Intelligence, Data Analysis and Data Science.
What are the top questions asked in Urban Company Senior Data Analyst interview?

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

  1. What is the difference between Least Squares Method and the maximum likelih...read more
  2. How do you improve the performance of Linear Regress...read more
  3. What metrics do you use to evaluate classification mod...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

Swiggy Interview Questions
3.8
 • 432 Interviews
CARS24 Interview Questions
3.5
 • 335 Interviews
Udaan Interview Questions
4.0
 • 334 Interviews
Meesho Interview Questions
3.7
 • 329 Interviews
BlackBuck Interview Questions
3.8
 • 179 Interviews
Tata 1mg Interview Questions
3.6
 • 148 Interviews
Digit Insurance Interview Questions
3.9
 • 144 Interviews
Paisabazaar.com Interview Questions
3.4
 • 139 Interviews
Ninjacart Interview Questions
4.0
 • 96 Interviews
Zetwerk Interview Questions
4.1
 • 88 Interviews
View all
Category Manager
558 salaries
unlock blur

₹4 L/yr - ₹14 L/yr

Business Development Associate
490 salaries
unlock blur

₹1.8 L/yr - ₹5.2 L/yr

Senior Category Manager
137 salaries
unlock blur

₹10 L/yr - ₹24 L/yr

AC Technician
135 salaries
unlock blur

₹0.7 L/yr - ₹7.2 L/yr

Beautician
134 salaries
unlock blur

₹0.8 L/yr - ₹7.8 L/yr

Explore more salaries
Compare Urban Company with

Housejoy

4.2
Compare

Urban Ladder

3.7
Compare

Udaan

3.9
Compare

Swiggy

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