AB InBev India MIS Executive Interview Questions and Answers

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.

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

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

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

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

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

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

My current salary at my last company was competitive, reflecting my skills and contributions to the team.

• Salary was aligned with industry standards for my role and experience.

• I received a performance-based raise after my first year.

• Participated in projects that increased company revenue, justifying my salary level.

• Salary included benefits such as health insurance and bonuses.

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

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