Sagebrush Coffee: Applying Data Analytics to Customer Purchases

Sagebrush Coffee is a small business in Chandler, Arizona that purchases green beans, roasts them in small batches for quality, and ships fresh, gourmet roasted coffee beans across the nation. Deciding which coffee beans to buy and roast is one of the most crucial business decisions Sagebrush and other gourmet coffee roasters face. Further complicating this decision is the fact that coffee is a crop, and like all crops, has a specific growing season and the exact same product cannot usually be ordered from year to year, even if it proves to be successful. The goal of this research is to use data analytics and visualization to help Sagebrush make better purchasing decisions by identifying consumer purchasing trends and providing a recommendation for their portfolio mix. In the end, I found that Latin American coffees are popular with both returning and first-time customers, but a specific country of origin does not appear to be associated with the top coffee producing countries. Additionally, December is a critical month for Sagebrush and Sagebrush should make sure to target the states with the most sales: California, Pennsylvania, and New York. Arizona has growth potential as it is not one of the top three locations, despite the presence of a physical store. Also included in the following report is a portfolio recommendation suggesting how many of each product based on region, processing type, and roast level to carry in inventory.