AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Uber
Compare
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Uber MIS Analyst Interview Questions, Process, and Tips
Uber MIS Analyst Interview Experiences
1 interview found
Selected
I applied via Naukri.com and was interviewed in Dec 2022. There were 3 interview rounds.
Basic attitude test conducted first.
(5 Questions)
- Q1. Questions related to Advanced MS Excel, Basic SQL Queries.
- Q2. Count total no. of cities ?
- Ans.
The total number of cities cannot be counted without specific data or context.
The total number of cities can vary depending on the country, region, or dataset being considered.
One would need a list of cities or a specific area of focus to accurately count the total number of cities.
For example, the total number of cities in the United States is different from the total number of cities in India.
- Q3. What is Index and Match ?
- Ans.
Index and Match are functions in Excel used to lookup values in a table based on specific criteria.
Index function returns the value of a cell in a table based on the row and column number provided.
Match function returns the position of a value in a range.
Index and Match functions are often used together to perform more flexible lookups than VLOOKUP or HLOOKUP.
Example: =INDEX(A1:D10, MATCH(123, B1:B10, 0), 3) will retur...
- Q4. What is Vlookup and Hlookup ?
- Ans.
Vlookup and Hlookup are functions in Excel used to search for a value in a table and return a corresponding value.
Vlookup stands for vertical lookup and is used to search for a value in the first column of a table and return a value in the same row from a specified column.
Hlookup stands for horizontal lookup and is used to search for a value in the first row of a table and return a value in the same column from a speci...
- Q5. How to calculate Vlookup?
- Ans.
Vlookup is a function in Excel used to search for a value in a table and return a corresponding value.
Use the formula =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
lookup_value is the value to search for in the first column of the table
table_array is the range of cells that contains the data
col_index_num is the column number in the table from which to retrieve the data
range_lookup is optional and ca...
Interview Preparation Tips
Top trending discussions
Interview questions from similar companies
I applied via Recruitment Consulltant and was interviewed in Jul 2024. There were 2 interview rounds.
(4 Questions)
- Q1. Rank Function Application in Google Sheet?
- Ans.
Rank function in Google Sheets is used to assign a rank to a value in a list based on its order.
Rank function is used to determine the rank of a value in a list.
It can be used to rank values in ascending or descending order.
The syntax for the rank function is RANK(value, range, [is_ascending]).
- Q2. Joins From SQL?
- Ans.
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
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.column = table2.column;
- Q3. Order Of query execution in SQL?
- Ans.
The order of query execution in SQL is: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.
FROM: Specifies the tables from which data will be retrieved.
WHERE: Filters the rows based on specified conditions.
GROUP BY: Groups the rows based on specified columns.
HAVING: Filters the groups based on specified conditions.
SELECT: Retrieves the columns specified in the query.
ORDER BY: Sorts the result set based on specified column
- Q4. Write a query to find out students has greater than 80 marks and from English subject?
- Ans.
Query to find students with over 80 marks in English subject
Use SELECT statement to retrieve data
Filter the results using WHERE clause for marks greater than 80
Include condition for English subject using AND operator
(4 Questions)
- Q1. When we use having clause ?
- Ans.
HAVING clause is used in SQL to filter groups based on specified conditions after GROUP BY clause.
HAVING clause is used with GROUP BY clause to filter groups based on specified conditions.
It is used to filter the results of aggregate functions like COUNT, SUM, AVG, etc.
It is used to apply conditions to groups, similar to WHERE clause which applies conditions to individual rows.
Example: SELECT department, AVG(salary) FR...
- Q2. Aggregate Function Application?
- Ans.
Aggregate functions are used to perform calculations on groups of rows in a table.
Aggregate functions include SUM, AVG, COUNT, MIN, and MAX.
They are commonly used in SQL queries to summarize data.
For example, you can use SUM to calculate the total sales for a specific product.
Another example is using AVG to find the average salary of employees in a department.
- Q3. Group by and order By?
- Q4. Write a query employes join between such dates?
- Ans.
Use a SQL query with JOIN to retrieve employees between specified dates.
Use the JOIN keyword to combine data from two tables
Specify the date range using the WHERE clause
Example: SELECT * FROM employees e JOIN dates d ON e.date = d.date WHERE d.date BETWEEN '2022-01-01' AND '2022-12-31'
Interview Preparation Tips
- EXCEL FUNCTIONS
- SQL JOINS
- SQL CLAUSES
also prepare deep from SQL basic to advance.
Skills evaluated in this interview
I applied via Walk-in and was interviewed in Jun 2023. There were 2 interview rounds.
(1 Question)
- Q1. Self introduction and knowledge checking
(1 Question)
- Q1. SQL and Excel based questions
Selected
I was interviewed in Sep 2024.
(3 Questions)
- Q1. What was your previous process and how would it help solve a problem we have at Airbnb?
- Q2. Explain a situation where u failed to take a decision and how did you tackle such scenario based on your current role?
- Q3. Best hosting experience received and what made it special?
Interview Preparation Tips
I applied via Recruitment Consulltant and was interviewed in Nov 2024. There was 1 interview round.
(3 Questions)
- Q1. Difference Between Rank and Dense Rank
- Ans.
Rank assigns unique ranks to each distinct value, while Dense Rank assigns consecutive ranks to each distinct value.
Rank does not skip ranks when there are ties, while Dense Rank does
Rank will have gaps in ranks if there are ties, while Dense Rank will not
Rank function is used to assign a unique rank to each distinct row, while Dense Rank function is used to assign consecutive ranks to each distinct row
- Q2. Some Basic Joins
- Q3. Socks Pair Puzzle Qustions
Interview Preparation Tips
I applied via LinkedIn and was interviewed in Mar 2024. There were 3 interview rounds.
GD COMMON TOPIC WAS DISCUSSED
(1 Question)
- Q1. TELL ABOUT YOURSELF , SKILLSETS YOU BRING TO THE TABLE
(1 Question)
- Q1. EXPECTED INCOME , RELOCATION PREFERENCE
Interview Preparation Tips
Quality Analyst Interview Questions & Answers
Metric Stream Infotech
Anonymous
posted on 12 Sep 2023
(1 Question)
- Q1. All related to manual testing
(1 Question)
- Q1. 1. Related to Manual Testing
(1 Question)
- Q1. Manual testing, java
(1 Question)
- Q1. All fake build ups
- Ans.
Fake build ups refer to false claims or exaggerations made about a product or service.
Fake build ups can mislead customers and damage the reputation of a company.
Examples include exaggerated claims about the effectiveness of a product or false testimonials from supposed satisfied customers.
Quality analysts play a crucial role in identifying and rectifying fake build ups to ensure transparency and trustworthiness.
Interview Preparation Tips
I applied via Job Fair and was interviewed before Dec 2023. There was 1 interview round.
(1 Question)
- Q1. Strenghts/weaknesses
Interview Preparation Tips
Selected
I applied via Recruitment Consulltant and was interviewed before May 2023. There were 2 interview rounds.
Financial Modelling - three hour of financial model exercise
(2 Questions)
- Q1. Impact of Sell down in Valuation
- Ans.
A sell down in valuation refers to a decrease in the value of an asset due to selling a portion of it.
Sell down can lead to a lower valuation of the remaining asset due to reduced ownership percentage.
It can impact financial ratios and metrics such as price-to-earnings ratio and return on equity.
Sell down may be necessary for liquidity reasons or to diversify investments.
Example: If a company sells a portion of its sub...
- Q2. Impact different factors in renewable industry
- Ans.
Various factors such as government policies, technological advancements, and market demand impact the renewable industry.
Government policies play a crucial role in promoting renewable energy sources through incentives and regulations.
Technological advancements drive down costs and improve efficiency of renewable energy technologies.
Market demand for clean energy solutions influences investment and development in the re...
Selected
I applied via Company Website and was interviewed before Dec 2021. There were 2 interview rounds.
(3 Questions)
- Q1. When I initially joined my job right after college there was a point where I was constantly
- Q2. It's a great organisation and I've learner a lot here but it's such a small company that it's difficult to find ways to move up ask yourself what makes you feel passionate or happy when you work😊
- Q3. Opportunity great time interest must
Group discussion can also provide feedback to instructors on participant comprehension.
Interview Preparation Tips
Uber Interview FAQs
Tell us how to improve this page.
Uber Interviews By Designations
- Uber Software Engineer Interview Questions
- Uber Software Developer Interview Questions
- Uber Business Analyst Interview Questions
- Uber Data Analyst Interview Questions
- Uber Senior Software Engineer Interview Questions
- Uber Product Manager Interview Questions
- Uber Operations Manager Interview Questions
- Uber Software Developer Intern Interview Questions
- Show more
Interview Questions for Popular Designations
Uber MIS Analyst Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
Uber MIS Analyst Reviews and Ratings
based on 1 review
Rating in categories
|
Driver
584
salaries
|  ₹0.6 L/yr - ₹7.2 L/yr |
|
CAR Driver
312
salaries
| ₹0.9 L/yr - ₹5.1 L/yr |
|
Software Engineer
157
salaries
| ₹20 L/yr - ₹84.7 L/yr |
|
Operations Executive
136
salaries
| ₹1.6 L/yr - ₹4 L/yr |
|
Data Analyst
128
salaries
| ₹6 L/yr - ₹22 L/yr |
Amazon
Ola Cabs
Airbnb
- Home >
- Interviews >
- Uber Interview Questions >
- Uber MIS Analyst Interview Questions
