AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
MagicPin Data Analyst Interview Questions and Answers
MagicPin Data Analyst Interview Experiences
2 interviews found
I applied via LinkedIn and was interviewed in Mar 2023. There were 3 interview rounds.
(1 Question)
- Q1. Excel and SQL based questions
(1 Question)
- Q1. Python and project based questions
Interview Preparation Tips
Utter disregard for a candidate's time and work. The humiliating level of such degraded professionalism that they cannot decide before posting an interview that they don't want to hire.
But they have the audacity to expect 7 days and open-ended work schedule from the candidates.
DO NOT APPLY.
Anonymous
I applied via LinkedIn and was interviewed before Aug 2021. There were 2 interview rounds.
(4 Questions)
- Q1. Advance Excel (Vlookup, Index, Countifs, sumifs and others)
- Q2. Python Basics (data frame, data types, lamda, series etc)
- Q3. SQL Functions (joins, limits, partitions, orders by and group by)
- Q4. 3rd round was managerial round, where mostly non-technicial questions asked.
Interview Preparation Tips
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 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 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
I applied via Walk-in and was interviewed before Feb 2021. There were 3 interview rounds.
(1 Question)
- Q1. Tell me about yourself.
Interview Preparation Tips
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 in Oct 2021. There was 1 interview round.
(2 Questions)
- Q1. Basic SQL and excel question.
- Q2. Questions about google data studio
Interview Preparation Tips
I applied via Job Portal and was interviewed in Jun 2023. There were 3 interview rounds.
Aptitude test is a way for employers to assess a candidate's abilities through a variety of different testing formats. Aptitude tests will test your ability to perform tasks and react to situations at work. This includes: problem-solving.
(2 Questions)
- Q1. Tell me something about yourself. How did you hear about this position? Why do you want to work here?
- Ans. Hi thank you for giving me this opportunity to introduce my self lakshmi r am basically from doddballapur i graduate in b. Com from banglore north university
- Q2. What is your greatest strength? What are your strengths and weaknesses? What do you know about this company/organization?
I applied via Approached by Company and was interviewed in Apr 2024. There was 1 interview round.
(2 Questions)
- Q1. About previous experience situation based questions excel problem solving
- Q2. Tell me about yourself difference between data quality and data validity
Interview Preparation Tips
MagicPin Interview FAQs
Tell us how to improve this page.
MagicPin Interviews By Designations
- MagicPin Associate Interview Questions
- MagicPin Customer Support Executive Interview Questions
- MagicPin Analyst Interview Questions
- MagicPin Product Manager Interview Questions
- MagicPin Data Analyst Interview Questions
- MagicPin Key Account Manager Interview Questions
- MagicPin Production Analyst Interview Questions
- MagicPin Customer Service 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
MagicPin Data Analyst Interview Process
based on 1 interview
Interview experience
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
MagicPin Data Analyst Reviews and Ratings
based on 3 reviews
Rating in categories
|
Team Lead
56
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Senior Associate
54
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Key Account Manager
52
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Business Development Executive
50
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Associate
46
salaries
| ₹0 L/yr - ₹0 L/yr |
Nearbuy
Little India
Paytm
BookMyShow
- Home >
- Interviews >
- MagicPin Interview Questions >
- MagicPin Data Analyst Interview Questions
