__STYLES__
This report presents a data-driven strategy for a group of investors seeking entry into the US coffee market. Leveraging insights from "The Great American Coffee Taste Test," conducted by YouTube coffee expert James Hoffmann and Cometeer, the report aims to:
(i) Define the target audience and discern their coffee preferences. (ii) Recommend a tailored product offering aligned with consumer preferences. (iii) Formulate an effective pricing strategy to maximize market penetration and profitability.
Data Preparation Overview:
The data preparation process involved leveraging multiple tools and techniques, including Excel, Power Query, SQL, and Tableau, to ensure comprehensive data analysis and visualization. Here's an overview of each step:
By leveraging these tools in the data preparation process, the dataset was refined and transformed into a clean, structured format suitable for analysis in Tableau. This comprehensive approach ensured that the data was accurate, reliable, and ready for insightful analysis and visualization.