ECommerce-Donation-Packages

Using historical online purchases of various cause combinations to create high value donation 'packages' for an Animal Shelter

Ecommerce – Transactional Product (Donation Cause) Pairs

An analysis of products (Causes) that are purchased together most frequently.

Executive Summary

An executive wants to put together a donation “package” blending two cause types together and wants to know which products are purchased together to decide on which products should be grouped together for the donation packages.

Recommendations:

Business Problem:

Which donation causes should be grouped together to appeal

We need to know:

1. Which Causes bring in the most donations
2. Which Causes are most frequently purchased together

Methodology:

1. A SQL calculation using a Hex Notebook to
2. A SQL calculation using a self-join to determine which products are most frequently purchased together
3. A visualization to

Skills

SQL: Data cleaning, Self-Join, Aggregation, window functions Visualization: Hex notebooks, bar charts

Results and Recommendations:

Causes Ranked by Revenue

1. Grooming Supplies
2. Rosie's Litter
3. Monetary Donations or Gift Cards
4. Emergency Care
5. Molly's Litter

Causes Ranked by Number of Orders

1. Rosie's Litter
2. Monetary Donations or Gift Cards
3. Grooming Supplies
4. Cleaning Supplies
5. Emergency Care

Top Pair Occurances (over 20 Occurances):