Snap Finance provides point-of-sale financing that helps customers make purchases through retail merchants. A customer applies for financing during the shopping process, receives a decision, and may then use the approved offer to complete a purchase.
The analytics team works closely with Sales, Risk, Product, Finance, and Operations. Analysts are expected to turn raw application, merchant, and funding data into clear business recommendations. That usually means validating the data, defining metrics carefully, checking for grain issues or duplicate records, and explaining findings in a way that both technical and non-technical stakeholders can act on.
For this exercise, assume you are supporting a business review. The data you are using is provided in the data/ folder. Use your tool(s) of preference to analyze the data. We will provide a data dictionary with helpful terms below.
Application : A customer financing request submitted through a merchant.
Customer Application ID : An ID assigned to the customer's application.
Merchant : A retail partner that offers Snap financing to customers.
Merchant ID : An ID assigned to a Snap Finance merchant.
Industry : The merchant category, such as Jewelry, Furniture, Tires, or Electronics.
Submit Date : The date the application was sent to Snap Finance for an approval.
Approval : A decision indicating that Snap is willing to extend financing to the customer, usually up to an approved amount.
Approved Amount : The maximum amount the customer was approved to use.
Complete Date : The date the applciation was signed and completed after it has been approved by Snap Finance.
Funded Amount : The dollar amount actually financed after the customer completes the purchase.
Paid Amount : The total dollar amount of payments recieved from the customer.
Net Revenue : The total paid amount from the customer minus the total funded dollar amount given to the application.
- What was the top 3 industries by application count in 2023?
- What was the total net funded dollar amount by state in January of 2024?
- Excluding industries with less than 1,000 applications, what is the average time (days) to complete an application by industry?
- Please answer the open ended question below.
Output: Please provide the answers in a way that you can email us and we can view them on our own devices.
The VP of Sales says:
We increased approval rates in the Jewelry industry end of March 2026. Leadership thinks that this will increase net revenue. Do you agree or disagree?
Using the provided application and funding dataset, create a 10 minute presentation to share your results.
Please prepare a short analysis that includes:
- Whether you agree or disagree with the VP's claim.
- The metrics you used to evaluate the problem.
- Data cleaning decisions and assumptions.
- Risks or limitations in your analysis.
- A recommended action plan.
You are expected to use AI during the project. Include the model or tool used, prompts, and any other examples that helped you along the way.
This dataset contains synthetic, fictitious data created for educational purposes only. It does not reflect real customers, merchants, or business performance at Snap Finance. Any resemblance to actual data is coincidental. This exercise is intended to evaluate analytical and communication skills, not real-world outcomes.