Tableau Project | My Coffee Consumption

SOURCE OF DATA: MY OWN COFFEE CONSUMPTION FOR 28 DAYS

SITUATION

Even though I’ve been drinking coffee for five years, I only have a rough estimate of how much I consume every day and how much I buy in a month.

TASK

My goal was to discover patterns in my daily coffee ritual particularly for home brewing.

ACTION

Data Collection
- I created an excel file with 31 headers
  - I filled it out after each brewing session
  - I did this for 28 days
  - The end result is a CSV with 61 rows and 31 columns

Data Analysis
- Excel was used mainly for data collection
  - The rest of the project was created through Tableau
- I selected the information I wanted to focus on to answer two questions
  - How much did I spend on coffee?
    - I need to know the quantity so that I can calculate my coffee expenses
      - Amount of coffee in grams
      - Number of cups I drank each day
    - Price of coffee
      - Per gram
      - Per cup
        
        Minimum, median, maximum
      - Per day
        
        Average daily spend
      - Total expenses for 28 days
  - Which coffees did I prefer?
    - I considered the factors that affect the taste of the coffee in the supply chain
      - Coffee origin
      - Roaster
        
        I wanted to see if I was consuming more coffee from one roaster
        
        Measured grams of coffee brewed from each roaster
      - Frequently used brewing method
        
        Helps me determine which type of roast I enjoy more
        
        Easier to decide how much of each roast I should buy in my next coffee purchase
    - The way the coffee is processed also affects the flavor, but I excluded this in the analysis since I'm open to exploring various kinds of processing and did not want to limit it

Data Visualization
- Font
  - Used Arial for readability
- Color
  - Warm grey color palette to reduce cognitive load
  - Dark grey for the KPIs and two main questions to stand out
  - Cream color for the background
    - White sometimes has a jarring effect that makes it difficult to look at
- Layout
  - Used horizontal containers with a dark background for the two main questions
  - Containers are fixed
  - Removed clutter such as lines and sub-headers
  - Added uniform side margins for the charts
- Parameter
  - Created a parameter called "Choose your currency"
    - I wanted the dashboard to be interactive
      - Even though the list of currencies are limited, integrating this tiny feature creates:
        
        Ease in understanding the price of coffee because it's similar to the currency that the viewer uses or is familiar with
  - Created calculated fields
    - In order for the "Choose your currency" dropdown to work, I needed to create calculated fields
    - Here are the screenshots for the parameter and one calculated field:

- KPIs (3)
  - The three KPIs is a quick overview of how much I consumed and spent in a month
    - Guides me in my next coffee purchase
- Titles of Charts
  - Wrote clear titles for the charts
    - Makes it easier to:
      - Understand what the purpose of the chart is
      - Quickly pick up the information in that chart
    - Instead of a separate legend window
      - I formatted the color and the weight of select words in the title to function as the legend in some charts
      - The "I brewed more filter and espresso roast..." bar chart at the bottom right of the dashboard is an example of this
  - Created a dynamic title for one chart
    - "The most expensive cup costs X" chart changes seamlessly with the currency selected

RESULT

Here's a short slideshow of the results. Click on the icon "i" at the bottom of the slideshow for more information about each image.

By understanding my coffee consumption patterns, I've identified potential annual savings of P8,088 on coffee beans alone. Here's how this newfound knowledge translates into tangible benefits:

Informed Purchasing Decisions: Armed with a clearer picture of my coffee preferences, I made a strategic decision to purchase two additional bags of coffee from Yardstick, one espresso and one filter roast. This choice was driven by both taste and affordability, aligning perfectly with my criteria.
Subscription Savings: Upon exploring Yardstick's subscription offers, I calculated that subscribing would reduce my monthly coffee expenses from P2,794 to P2,120. This monthly saving of P674 amounts to an impressive 24% reduction in my coffee expenditure.
Increased Coffee Supply: Not only does the subscription save me money, but it also provides me with an additional 70g of coffee per month, equivalent to four more espresso cups or cortados. This means more coffee to enjoy without compromising my budget.
Budget Allocation: The P674 saved each month can now be redirected toward purchasing essential coffee supplies like filter paper, milk, or even a water solution for coffee, further enhancing my coffee experience.

In conclusion, while some may argue for quitting caffeine to reduce expenses, this data-driven analysis has empowered me to continue enjoying my coffee ritual while making it more cost-effective. The P8,088 in potential annual savings demonstrates the value of understanding one's consumption habits and making informed choices. By subscribing to Yardstick's coffee, not only can I enjoy more coffee, but I can also optimize my expenses and ensure a consistent supply of my favorite brew.

This is the Tableau creation.