MagicPin Key Relationship Manager Interview Questions and Answers

Q1. Questions related to SCM
Add your answer
Q2. Bucket level creation
Add your answer

Q1. Reports and tracking required.
Add your answer
Q2. How to deal with low fill rate
Ans. 
Low fill rate can be dealt with by analyzing the root cause and implementing corrective actions.
• Analyze the reasons for low fill rate such as inaccurate forecasting, poor inventory management, or supplier issues

• Implement corrective actions such as improving forecasting accuracy, optimizing inventory levels, or finding alternative suppliers

• Regularly monitor and measure fill rate to ensure improvements are sustained

• Colla...read more
Answered by AI
Add your answer

Q1. Last organisation experiance
Add your answer

Q1. Tell me about yourself.
Add your answer

Q1. SQL: left join, right join and inner join questions find out the latest entry for an user when they log in to a app Python: few basic questions on python like count the characters in a word. Linux: what co...read more
Add your answer

Q1. Why data? Why Tokopedia? Talk about bachelor's thesis?
Ans. 
Data analysis is crucial for making informed decisions. Tokopedia's vast data provides a great opportunity for analysis. My bachelor's thesis focused on data-driven insights.
• Data allows for informed decision-making and insights.

• Tokopedia's extensive data provides a valuable opportunity for analysis.

• My bachelor's thesis delved into data-driven insights and analysis.
Answered by AI
Add your answer

Q1. Walkthrough bachelor's thesis
Add your answer

Q1. Introduction of yourself
Add your answer

Assignment of Google sheets

Q1. Self introduction
Add your answer
Q2. What do you know about analysis and logical reasoning
Ans. 
Analysis and logical reasoning involve examining data, identifying patterns, and drawing conclusions based on evidence.
• Analysis involves breaking down complex information into smaller components for better understanding.

• Logical reasoning is the process of using rational thinking to make sense of information and draw valid conclusions.

• Analytical skills are essential for interpreting data accurately and making informed d...read more
Answered by AI
Add your answer

Q1. Difference between rank and dense rank
Ans. 
Rank assigns unique ranks to each distinct value, while dense rank does not leave gaps between ranks.
• Rank assigns unique ranks to each distinct value in a dataset

• Dense rank does not leave gaps between ranks, assigning consecutive ranks to values with the same rank

• For example, if values are 10, 20, 20, 30, then rank would be 1, 2, 2, 4 and dense rank would be 1, 2, 2, 3
Answered by AI
Add your answer
Q2. How will merge multiple file in python
Ans. 
Merge multiple files in Python using pandas.concat() or pd.merge() functions.
• Use pandas.concat() function to merge multiple files vertically (row-wise).

• Use pd.merge() function to merge multiple files horizontally (column-wise) based on a common column.

• Ensure that the files have compatible column names and data types before merging.

• Handle any missing or duplicate values appropriately during the merging process.

• Consider ...read more
Answered by AI
Add your answer
Q3. Data frame explain in detail
Ans. 
A data frame is a two-dimensional data structure in which data is stored in rows and columns.
• Data frames are commonly used in programming languages like R and Python for data analysis.

• Each column in a data frame represents a variable, while each row represents an observation.

• Data frames can contain different types of data, such as numeric, character, and factor.

• Data frames can be created from various sources like CSV f
Answered by AI
Add your answer