Full metadata
Title
Sagebrush Coffee: Applying Data Analytics to Customer Purchases
Description
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.
Date Created
2018-05
Contributors
- Blue, Jessica Morgan (Author)
- Kellso, James (Thesis director)
- Davila, Eddie (Committee member)
- Department of Information Systems (Contributor)
- Economics Program in CLAS (Contributor)
- Department of Supply Chain Management (Contributor)
- Morrison School of Agribusiness (Contributor)
- Barrett, The Honors College (Contributor)
Resource Type
Extent
36 pages
Language
Copyright Statement
In Copyright
Primary Member of
Series
Academic Year 2017-2018
Handle
https://hdl.handle.net/2286/R.I.47737
Level of coding
minimal
Cataloging Standards
System Created
- 2018-04-13 12:01:20
System Modified
- 2021-08-11 04:09:57
- 2 years 9 months ago
Additional Formats