MasterCard Analytical Interview Questions and Answers

List of decreasing integers with dates

• Create an array of strings with decreasing integers and corresponding dates

• Start with the highest integer and oldest date, and decrease the integer with each subsequent date

• Example: ['10 - 2022-01-01', '9 - 2022-01-02', '8 - 2022-01-03', ...]

To identify customers who have made transactions on more than 10 consecutive days.

• Identify customers who have made transactions every day for at least 10 days in a row.

• Check transaction history for each customer to determine consecutive days of transactions.

• Create a list of customers who meet the criteria.

• Consider using SQL queries or data visualization tools to analyze the data.

• Example: Customer A made transactions on...read more