AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Clear (1)
Urban Company Data Analyst Intern Interview Questions and Answers
Urban Company Data Analyst Intern Interview Experiences
1 interview found
Anonymous
Selected
I applied via Referral and was interviewed in Feb 2024. There was 1 interview round.
Finding error in sql query
Top trending discussions
Interview questions from similar companies
Selected
I applied via Referral and was interviewed before Aug 2022. There were 2 interview rounds.
(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...
- 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
- 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...
- 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.
Interview Preparation Tips
- SQL
- joins
- window functions
Skills evaluated in this interview
I applied via Campus Placement 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
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 before Feb 2023. There were 2 interview rounds.
Simple SQL & Excel test
(1 Question)
- Q1. Will Face hiring Manager
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
I applied via Naukri.com and was interviewed before Apr 2021. There were 4 interview rounds.
Technica questions related to sql
(1 Question)
- Q1. Some technical questions related to sql and advance excel .
(1 Question)
- Q1. Some questions related to cars insurance and second cars
(1 Question)
- Q1. Salary discussion and some hr questions
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Apr 2024. There was 1 interview round.
Test was based on SQL, coding and MCQ. Coding involved nested query.
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.
Urban Company Interview FAQs
Recently Viewed
SALARIES
Urban Company
LIST OF COMPANIES
Hindalco Industries
Locations
INTERVIEWS
Aptiv
No Interviews
INTERVIEWS
Urban Company
No Interviews
LIST OF COMPANIES
Musashi Auto Parts
Locations
INTERVIEWS
Aptiv
No Interviews
INTERVIEWS
Urban Company
No Interviews
LIST OF COMPANIES
Fleetguard Filters
Locations
SALARIES
SKH Metals
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 Science Intern Interview Questions
- Senior Data Analyst Interview Questions
- Senior Data Scientist Interview Questions
- Data Scientist Intern Interview Questions
- Jr. Data Scientist Interview Questions
- Associate Data Scientist Interview Questions
- Data Science Engineer Interview Questions
- Show more
Urban Company Data Analyst Intern Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Category Manager
515
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Business Development Associate
455
salaries
| ₹0 L/yr - ₹0 L/yr |
|
AC Technician
138
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Beautician
137
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Category Manager
131
salaries
| ₹0 L/yr - ₹0 L/yr |
Housejoy
Urban Ladder
Qube Services
Zimmber
- Home >
- Interviews >
- Urban Company Interview Questions >
- Urban Company Data Analyst Intern Interview Questions
