AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Clear (1)
Urban Company Senior Data Analyst Interview Questions, Process, and Tips
Urban Company Senior Data Analyst Interview Experiences
1 interview found
Anonymous
I applied via Referral and was interviewed in Feb 2022. There were 5 interview rounds.
Given time series data of provider, compute hour wise provider wise no of seconds online
(2 Questions)
- Q1. Case study on the customer churn.
- Q2. Questions on Probability and CLT
(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
- 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...
- 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...
- 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)
- 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 ...
- 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
- 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...
- 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...
- 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...
- 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
- 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...
Case Study - How do you improve user engagement of Facebook?
Guesstimates - How many people watched the Squid Game series on Netflix
How do you reduce partner churn in UC?
Interview Preparation Tips
- Machine Learning
- Statistics
- Case Studies
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
vinay kalikota
There are 2 coding challenges and 7 objective questions
(1 Question)
- Q1. Technical questions related to role
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.
Selected
I applied via Company Website and was interviewed before Feb 2023. There were 2 interview rounds.
Simple SQL & Excel test
(1 Question)
- Q1. Will Face hiring Manager
I applied via Company Website and was interviewed before Feb 2023. There was 1 interview round.
(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
- 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...
- 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
- 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...
Interview Preparation Tips
Skills evaluated in this interview
I applied via Company Website and was interviewed in Apr 2024. There was 1 interview round.
HackerRank Test - Python, SQL
Selected
I applied via Referral and was interviewed in Aug 2023. There were 2 interview rounds.
SQL query optimisation
(1 Question)
- Q1. Regular discussion, about job role, why swiggy
Interview Preparation Tips
Selected
I applied via Referral and was interviewed in Mar 2023. There were 2 interview rounds.
(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
- 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...
Interview Preparation Tips
- SQL
- Python
I applied via Job Portal and was interviewed before Jun 2022. There were 2 interview rounds.
(1 Question)
- Q1. Previous company experience and current company roles and responsibilities
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
Urban Company Interview FAQs
Some of the top questions asked at the Urban Company Senior Data Analyst interview -
Recently Viewed
INTERVIEWS
SKH Metals
No Interviews
INTERVIEWS
Aptiv
No Interviews
INTERVIEWS
Uber
No Interviews
SALARIES
Urban Company
INTERVIEWS
Uber
No Interviews
INTERVIEWS
InMobi
No Interviews
INTERVIEWS
Aptiv
No Interviews
INTERVIEWS
Aptiv
No Interviews
INTERVIEWS
InMobi
No Interviews
INTERVIEWS
Urban Company
No Interviews
Tell us how to improve this page.
Urban Company Interviews By Designations
- Urban Company Category Manager Interview Questions
- Urban Company Business Development Associate Interview Questions
- Urban Company Software Developer Interview Questions
- Urban Company Trainer Interview Questions
- Urban Company Electrician Interview Questions
- Urban Company Intern Interview Questions
- Urban Company BDA Interview Questions
- Urban Company Data Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Data Scientist Interview Questions
- Data Analyst Intern Interview Questions
- Senior Data Scientist Interview Questions
- Data Science Intern Interview Questions
- Associate Data Analyst Interview Questions
- Jr. Data Scientist Interview Questions
- Data Analyst Interview Questions
- Associate Data Scientist Interview Questions
- Show more
Interview Questions from Similar Companies
Fast track your campus placements
|
Category Manager
514
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Business Development Associate
488
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Beautician
157
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Category Manager
136
salaries
| ₹0 L/yr - ₹0 L/yr |
|
AC Technician
134
salaries
| ₹0 L/yr - ₹0 L/yr |
Housejoy
Urban Ladder
Qube Services
Zimmber
- Home >
- Interviews >
- Urban Company Interview Questions >
- Urban Company Senior Data Analyst Interview Questions
