Overview

<aside> 📊

Business context:

The Client may add funds to their wallet account using their credit and debit cards. The Client has partnered with a 3rd party application to process all of these account funding credit and debit card transactions.

</aside>

<aside> 💭

Problem:

The Client is experiencing a decline in the acceptance rate of credit and debit card payments processed by the 3rd party application in the recent period.

</aside>

<aside> 🌰

In a nutshell:

• The analysis of the 3rd party application transaction data from January to June 2019 reveals an overall acceptance rate of 69.23%, with a notable decline in April to 65.8%, primarily affecting CAD, EUR, and MXN currencies.
• Recovery in subsequent months (although not to previous values for some currencies) indicates the issue was likely temporary or partially fixed.
• This event-driven drop suggests possible regional fraud-detection sensitivity or payment infrastructure issues in those markets.
• Recommendations include reviewing fraud rules and infrastructure for affected currencies and ensuring that robust security measures are in place for all transactions. Security practices, such as CVV verification, remain important for reducing declines. </aside>

Data Exploration

Data provided

Screenshot of table structure of data provided

Data Overview

• 5,430 transactions from January to June 2019.

• Rapid monthly increase in payments, with a notable rise in USD transactions.

• Other currencies (CAD, EUR, GBP, MXN) show an equal split.