AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Mapup Data Analyst Interview Questions and Answers
Mapup Data Analyst Interview Experiences
5 interviews found
Anonymous
I applied via Naukri.com and was interviewed in Oct 2024. There were 3 interview rounds.
Coding test based on Python and SQL
Assignment based on python and excel
(4 Questions)
- Q1. Based on excel assignment
- Q2. Based on python assignment
- Q3. Give numericaL SERIES
- Ans.
Numerical series are sequences of numbers that follow a specific pattern or rule.
Arithmetic series: 2, 4, 6, 8, 10
Geometric series: 3, 6, 12, 24, 48
Fibonacci series: 0, 1, 1, 2, 3, 5, 8
- Q4. LOOK UPS IN EXCEL
- Ans.
LOOKUPS IN EXCEL
LOOKUP function searches for a value in a range and returns a value in the same position in a different range
VLOOKUP function searches for a value in the first column of a table and returns a value in the same row from a specified column
HLOOKUP function searches for a value in the first row of a table and returns a value in the same column from a specified row
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Oct 2024. There were 3 interview rounds.
Aptitude, technical, SQL, coding
DSA, Python Pandas, Data Analysis
(1 Question)
- Q1. DSA, Python, SQL, Excel,
You will get assignment based in Python and Excel
Selected
I applied via Naukri.com and was interviewed before Oct 2023. There were 2 interview rounds.
It was scraping task from website
(2 Questions)
- Q1. Asked about coding knowledge related Python and Excel usage
- Q2. Questions related to work ethics
Mapup interview questions for designations
I applied via LinkedIn and was interviewed in Aug 2021. There were 3 interview rounds.
1st Round was MCQ type. Questions were from Aptitude, Logical Reasoning, Python, Excel & SQL.
For round 2, tasks related to Excel & Python were given and total allowed time was 3 hours. Also, 1 web scraping task was given for which time allowed was 2 days.
(1 Question)
- Q1. Questions were related to the tasks which were given. Like approach for solving those tasks or any other better way of doing it.
Interview Preparation Tips
- Python
- Excel
Top trending discussions
Interview questions from similar companies
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
(2 Questions)
- Q1. Explain difference between joins
- Q2. What is your area of intrest
Interview Preparation Tips
I applied via campus placement at Indian Institute of Technology (IIT), Jodhpur and was interviewed in Nov 2024. There were 2 interview rounds.
It consists of resume-based skill questions.
(2 Questions)
- Q1. Why do you want to join ICICI Bank?
- Ans.
I want to join ICICI Bank because of its strong reputation in the banking industry and the opportunities for growth and development it offers.
ICICI Bank is one of the leading banks in India with a strong reputation for innovation and customer service
I am impressed by ICICI Bank's focus on technology and digital banking solutions
I believe that working at ICICI Bank will provide me with opportunities for career growth an...
- Q2. Can you tell me about your projects?
- Ans.
I have worked on projects involving data analysis for marketing campaigns, customer segmentation, and sales forecasting.
Developed predictive models to optimize marketing strategies
Utilized clustering techniques for customer segmentation
Built time series models for sales forecasting
Selected
I applied via Company Website and was interviewed in Feb 2024. There was 1 interview round.
(3 Questions)
- Q1. What are the different kinds of joins
- Ans.
Different kinds of joins include inner join, outer join, left join, and right join.
Inner join: Returns only the rows that have matching values in both tables.
Outer join: Returns all rows when there is a match in one of the tables.
Left join: Returns all rows from the left table and the matched rows from the right table.
Right join: Returns all rows from the right table and the matched rows from the left table.
- Q2. What is the difference between columns and measures in power BI
- Ans.
Columns are the fields in a dataset, while measures are calculations based on those fields in Power BI.
Columns are the raw data fields in a dataset, such as 'Sales Amount' or 'Product Category'.
Measures are calculations performed on columns, like sum, average, count, etc.
Measures are created using DAX (Data Analysis Expressions) in Power BI.
Columns are used for grouping, filtering, and slicing data, while measures are
- Q3. How can you remove duplicates in sql
- Ans.
Use the DISTINCT keyword in a SELECT statement to remove duplicates in SQL.
Use the DISTINCT keyword in a SELECT statement to retrieve unique values.
Example: SELECT DISTINCT column_name FROM table_name;
Another way is to use the GROUP BY clause to remove duplicates.
Example: SELECT column_name FROM table_name GROUP BY column_name;
Interview Preparation Tips
- SQL Server
- Power Bi
- alteryx
Skills evaluated in this interview
I applied via Recruitment Consulltant and was interviewed in Mar 2024. There were 2 interview rounds.
(2 Questions)
- Q1. All SQL Question
- Q2. Related Join write query and Basic SQL
Python Leetcode Question they ask
Interview Preparation Tips
(1 Question)
- Q1. Typing and speed
Interview Preparation Tips
Mapup Interview FAQs
Tell us how to improve this page.
Mapup Data Analyst Interview Process
based on 4 interviews
Interview experience
Data Analyst Interview Questions from Similar Companies
Mapup Data Analyst Reviews and Ratings
based on 11 reviews
Rating in categories
|
Data Analyst
44
salaries
|  ₹4 L/yr - ₹10.5 L/yr |
|
Software Development Engineer
5
salaries
| ₹3.6 L/yr - ₹14 L/yr |
|
Front end Developer
5
salaries
| ₹5 L/yr - ₹12 L/yr |
|
Software Developer
4
salaries
| ₹7.5 L/yr - ₹15 L/yr |
|
Data Engineer
4
salaries
| ₹4 L/yr - ₹27 L/yr |
Zomato
Swiggy
Ola Cabs
Uber
- Home >
- Interviews >
- Mapup Interview Questions >
- Mapup Data Analyst Interview Questions
