Coffee Shop Dashboard

Project Goals

Build an interactive dashboard to explore and analyze coffee shop sales from a fictitious coffee shop in New York City

The Data Set

Coffee Shop Sales - Transaction records from a fictitious coffee shop in New York City

Project Objectives

1. Prepare the data for analysis
2. Explore the data with Pivot Tables
3. Build a dynamic dashboard

Project Results

1. Prepare the data for analysis

Added columns:

- revenue = [@[product_id]]*[@[unit_price]]
- month = TEXT([@[transaction_date]];"MMM")
- day of week = TEXT([@[transaction_date]];"ddd")
- hour = HOUR([@[transaction_time]])

2. Explore the data with Pivot Tables

3. Build a dynamic dashboard