Sales Trends for a Coffee Shop Chain in NYC

Maven Roasters is a fictional franchise with 3 stores in NYC.

The data set contains about 150k transactions occurred from January to June 2023, with dimensions about the store where they occurred and products sold.

The project first phase concerned profiling data e creating new calcolated columns like Month, Weekday and Hour of day and a new measure Revenue (=quantity sold * unit price).

The second phase regarded pivoting and analyzing data, to prepare some views about revenue trend, and transactions by several dimentions.

The last step was about designing and building a dashboard, with a slicer to allow the user the store selection, and some pivot chart to visualize pivot table data from previous step (-> open the attached picture to see the final result).

Here some considerations about the data analyzed:

• Overall sales grew up during the first semester of 2023, with total revenue doubled in six month.
• About 45% of the total transactions are concentrated in the time slot from 7 to 11 AM, therefore it is advisable to guarantee an adequate level of service during the morning.
• After 7pm transactions tend to drop to zero, so a reduction in late afternoon opening hours may be considered.
• Brewed Chai tea is the product type best seller by quantity of transactions, while Barista Espresso is the top product type by revenue.