AB InBev India MIS Executive Interview Questions and Answers

Q1. T-code used in procurement to pay, P2P cycle
Ans. 
The T-code used in procurement to pay in the P2P cycle is ME21N.
• ME21N is used in SAP for creating purchase orders in the procurement process.

• It is part of the procure-to-pay (P2P) cycle where goods or services are ordered and payment is made.

• ME21N allows users to input vendor information, material details, quantities, and pricing for the purchase order.
Answered by AI
Add your answer

Q1. Tell me about yourself?
Ans. 
I am a dedicated and detail-oriented analyst with a strong background in data analysis and problem-solving.
• Experienced in conducting thorough data analysis to identify trends and insights

• Skilled in creating reports and presentations to communicate findings to stakeholders

• Proficient in using analytical tools such as Excel, SQL, and Tableau
Answered by AI
Add your answer

Q1. What are the methods for evaluating machine learning models?
Ans. 
Methods for evaluating machine learning models include accuracy, precision, recall, F1 score, ROC curve, and confusion matrix.
• Accuracy: measures the proportion of correct predictions out of the total predictions made by the model.

• Precision: measures the proportion of true positive predictions out of all positive predictions made by the model.

• Recall: measures the proportion of true positive predictions out of all actual...read more
Answered by AI
Add your answer
Q2. What is the definition of standard deviation?
Ans. 
Standard deviation is a measure of the amount of variation or dispersion of a set of values.
• Standard deviation is calculated as the square root of the variance.

• It indicates how spread out the values in a data set are around the mean.

• A low standard deviation means the values are close to the mean, while a high standard deviation means the values are more spread out.

• For example, in a data set of test scores, a high stand...read more
Answered by AI
Add your answer

Q1. What is autocorrelation?
Ans. 
Autocorrelation is a statistical concept that measures the relationship between a variable's current value and its past values.
• Autocorrelation is the correlation of a signal with a delayed copy of itself.

• It is used to detect patterns or trends in time series data.

• Positive autocorrelation indicates a positive relationship between current and past values, while negative autocorrelation indicates a negative relationship.

• F...read more
Answered by AI
Add your answer
Q2. Linear Regression Assumptions
Ans. 
Linear regression assumptions include linearity, independence, homoscedasticity, and normality.
• Assumption of linearity: The relationship between the independent and dependent variables is linear.

• Assumption of independence: The residuals are independent of each other.

• Assumption of homoscedasticity: The variance of the residuals is constant across all levels of the independent variables.

• Assumption of normality: The resid...read more
Answered by AI
Add your answer
Q3. P value in simple terms
Ans. 
P value is a measure used in hypothesis testing to determine the significance of the results.
• P value is the probability of obtaining results at least as extreme as the observed results, assuming the null hypothesis is true.

• A small P value (typically ≤ 0.05) indicates strong evidence against the null hypothesis, leading to its rejection.

• A large P value (> 0.05) suggests weak evidence against the null hypothesis, lead...read more
Answered by AI
Add your answer
Q4. Bagging and Boosting algorithms
Add your answer
Q5. Multicollinearity
Add your answer

Q1. Do you know about excel formulas
Ans. 
Yes, I am familiar with Excel formulas and have experience using them in various MIS reports.
• I am proficient in using basic Excel formulas such as SUM, AVERAGE, VLOOKUP, and IF functions

• I have experience in creating complex formulas for data analysis and reporting purposes

• I am comfortable working with functions like INDEX, MATCH, and CONCATENATE to manipulate data efficiently
Answered by AI
View 1 more answer
Q2. Can you do it now
Add your answer
Q3. My answer is yes
Add your answer

Vlookup and pivot table etc

Q1. Conditional sum or distinct count in pivot
Ans. 
Conditional sum is used to calculate the sum based on certain conditions, while distinct count is used to count unique values in a pivot table.
• Conditional sum can be achieved using functions like SUMIF or SUMIFS in Excel.

• Distinct count can be achieved using the COUNTIF function with a unique identifier column.

• In a pivot table, you can use the Value Field Settings to choose between sum or count, based on your requiremen
Answered by AI
Add your answer
Q2. Advance Excel formula like lookup formula
Add your answer

Q1. Salaray Negosiation process
Add your answer
Q2. Responsibilties in prevoius organization
Ans. 
Managed database systems, generated reports, provided technical support, and implemented new technologies.
• Managed database systems to ensure data integrity and security

• Generated reports for management to analyze business performance

• Provided technical support to end users for software and hardware issues

• Implemented new technologies to improve efficiency and productivity

• Collaborated with cross-functional teams to integra
Answered by AI
Add your answer