Add office photos
Filter interviews by
Urban Company Data Analyst Interview Questions and Answers
Urban Company Data Analyst Interview Experiences
2 interviews found
Anonymous
Selected
I applied via LinkedIn and was interviewed in Apr 2024. There was 1 interview round.
(2 Questions)
- Q1. SQL base Question
- Q2. About your projects
I applied via Referral and was interviewed before Sep 2023. There were 3 interview rounds.
Quant, LR, puzzles, cat based level 2 questions
(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]
- Q2. How will you cut a cake into 8 equal pieces by 3 cuts
(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
- 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
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
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.
(5 Questions)
- Q1. Basic Excel Questions
- Q2. Medium and Basic SQL Questions
- Q3. Resume based Question
- Q4. Case Study Questions
- Q5. Questions on Project
I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.
SQL based questions wer asked on joins , rank function,
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
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
(1 Question)
- Q1. Joins and basics
Netflix user churn case study,
Uber booking number reduce
Snigdha Dhupal
I applied via Job Portal
SQL and Python data analysis questions
(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...
(1 Question)
- Q1. SQl questions what is rank in sql
Case study on fuel and diesel consumption
(1 Question)
- Q1. Why porter and how
Urban Company Interview FAQs
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 Bdm Executive Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
People are getting interviews through
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
Urban Company Data Analyst Reviews and Ratings
based on 2 reviews
Rating in categories
|
Category Manager
472
salaries
|  ₹4 L/yr - ₹14 L/yr |
|
Business Development Associate
469
salaries
| ₹1.8 L/yr - ₹5 L/yr |
|
Beautician
140
salaries
| ₹1 L/yr - ₹9.5 L/yr |
|
Senior Associate
128
salaries
| ₹2.5 L/yr - ₹7.5 L/yr |
|
AC Technician
124
salaries
| ₹0.7 L/yr - ₹7.2 L/yr |
Housejoy
Urban Ladder
Qube Services
Zimmber
Calculate your in-hand salary
- Home >
- Interviews >
- Urban Company Interview Questions >
- Urban Company Data Analyst Interview Questions
