Shey Jean-Philippe Data Analytics Portfolio

Maven Coffee Analysis

Maven Premium Coffee Pilot

This portfolio case study explores whether Maven should keep, modify, or discontinue Jamaican Coffee River as a hypothetical menu pilot. I combined six months of sales data across three stores with coffee import prices and estimated bean and packaging costs to evaluate demand, margins, and pricing options.

Tools: SQL Server, SQL, and Claude for coding and documentation assistance.

My role: I defined the business question, selected the sources and cost assumptions, ran every query in SQL Server, checked the outputs, and made the final recommendation. Claude helped draft SQL, documentation, and supporting calculations. See how I worked with Claude.

read more

Project 2: Avocado Price Comparison In South Florida Cities

In this report, I will be exploring data from the Hass Avocado Board (HAB) and the Kaggle Avocado Price (2020) data set. The focus of this project is to compare prices of avocados in Tampa vs Miami, Florida and to showcase my experience writing complex queries.

read more

Project 1: An Exploration of LA Metro Bike Share Data

In this article, I will be exploring the data from the Metro Bike Share system in Los Angeles. From this page I downloaded the trip data from 2021 Q4 (October -December) and bike station information from Station Table.

read more