☕ Coffee Reference Analysis with MySQL

📌 Overview

This project applies structured SQL queries to analyze coffee reference data within a relational MySQL database. It was developed as part of a business analytics assignment to demonstrate proficiency in data modeling, query logic, and insight extraction. The database captures attributes such as origin, roast level, and flavor notes, allowing for targeted analysis of consumer preferences and product characteristics. Through schema design and analytical querying, the project reflects how SQL can support decision-making and operational understanding in a business setting.

🎯 Purpose

The goal of this project is to apply SQL techniques to a real-world dataset and demonstrate proficiency in relational data handling. It serves as a class assignment and portfolio piece to highlight skills in schema design, query logic, and analytical thinking within a business analytics framework.

🗃️ Files Included

• Coffee_database.sql — Defines the schema for the coffee reference database
• Tram Kim Khue_coffee reference.sql — Contains SQL queries for data exploration and analysis

🛠️ Technologies Used

• MySQL (Workbench or CLI)
• SQL (SELECT, JOIN, GROUP BY, HAVING, etc.)

📈 Key Features

• Designed and implemented a relational database schema to structure coffee reference data, including origin, roast level, and flavor attributes
• Executed targeted SQL queries to extract insights on coffee preferences across different regions and roasting styles
• Applied JOIN, GROUP BY, and HAVING clauses to analyze relationships between flavor profiles and brewing methods
• Demonstrated proficiency in data filtering, aggregation, and sorting to support business decision-making scenarios
• Structured query logic to reflect real-world data exploration tasks, emphasizing clarity, reusability, and analytical depth

🚀 How to Run

1. Import Coffee_database.sql into your MySQL environment to create the database
2. Run Tram Kim Khue_coffee reference.sql to execute the analysis queries
3. Modify or extend the queries to explore additional insights

🙋‍♀️ Author

Khue Tram — exploring business analytics through SQL, NoSQL, and Python tools, with a focus on turning data into strategic insight.
GitHub Profile LinkedIn Profile