Skip to content

Files for the capstone project in the Google Data Analytics program

Notifications You must be signed in to change notification settings

brianbloom/Coursera_Google_Capstone

Repository files navigation

Coursera Google Capstone

Files for the capstone project in the Google Data Analytics program

Backstory

This was a case study performed for the (fictional) Whizzo Chocolate Company, who was seeking to improve their image after a poor health assessment for a number of their popular chocolates: Cherry Fondue, Crunchy Frog, Ram's Bladder Cup, Cockroach Cluster, Anthrax Ripple, and Spring Surprise. (additional explanation is available at Youtube )

Despite the fact they use no artificial preservatives or additives and any kind, their unconventional product line was deemed needing to be replaced with more traditional chocolates. Alternatives such as pralines, lime creme, and strawberry delight were discarded due to market oversaturation. Instead they will focus on luxury single varietal chocolate bars with the plan to establish themselves as a top 10 brand in the market segment.
My assignment was to identify what chocolate bean origins and varietals were most likely to produce the best chocolate bars.

Includes

  • raw spreadsheet files containing chocolate rating scores and cocoa production data
  • some interim spreadsheets used for holding cleaned up data
  • R Markdown notebook (RStudio .rmd format) with all steps performed for analysis
  • A supplemental R script file that was used for some exploratory analysis (all useful scripts were also replicated in the notebook)
  • A Impress presentation summarizing the findings of the analysis

Data sources

Flavors of Cacao database

2400 chocolate bars, tasted, rated, and published online.
http://flavorsofcacao.com/chocolate_database.html

The C-spot Chocolate Census

Over 2000 chocolate bars independently rated and reviewed.
https://www.c-spot.com/chocolate-census/bars/

NationMaster statistics database

Economic information from United Nations Food and Agriculture Organization (FAO) published online.
https://www.nationmaster.com/nmx/ranking/cocoa-beans-production

(*Vietnam data was missing and sourced from: https://trendeconomy.com/data/h2/Vietnam/18 )

About

Files for the capstone project in the Google Data Analytics program

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Languages