Data Analytics Project: Exploring Coffee Quality Data With Power BI

Introduction

In the realm of coffee production, quality is paramount. The Coffee Quality Institute (CQI), a non-profit organization dedicated to enhancing the quality and value of coffee globally. It has provided a comprehensive dataset that includes sensory evaluations, defect counts, processing methods, and origin information. This project aims to leverage Power BI to analyse this rich coffee quality data and uncover insights about the factors that contribute to coffee quality.

View Dashboard & Key Insights Here...

Objectives

The primary goals of this project are:

1. To identify the key determinants of coffee quality as evaluated through sensory attributes such as aroma, flavour, and acidity.
2. To explore the correlation between processing methods, origin regions, and coffee quality scores.
3. To identify trends or patterns in defect occurrences and their impact on overall coffee quality.
4. To analyse how different variables interact to influence the Total Cup Points, an overall measure of coffee quality.

Data Overview of Coffee Quality Data from CQI

The Coffee Quality Data from CQI includes various features such as:

• Sensory Evaluations: Aroma, Flavour, Aftertaste, Acidity, Body, Balance, Uniformity, Clean Cup, Sweetness.
• Defects: Category One (visual defects) and Category Two (taste defects).
• Processing Methods: Washed/Wet, Natural/Dry, Pulped Natural/Honey, etc.
• Origin Information: Country of origin, harvest year, and coffee variety.