FP20 Analytics Challenge: Coffee Brands Analysis
Project Overview: A Deep Dive into Coffee Analytics
The FP20 Analytics Challenge, in collaboration with ZoomCharts, pushed participants to delve into a rich dataset of coffee reviews. The goal was clear: reveal compelling insights and tell a story through data. Utilizing Power BI's robust features and ZoomCharts' dynamic visuals, I embarked on a journey to uncover the hidden gems of the coffee world.
Why This Project Matters
The coffee industry is vast and complex, with data spanning origins, brands, and consumer ratings. This project highlights the power of data analytics in transforming raw information into strategic insights that drive business decisions. By making complex data accessible and engaging, we can foster a deeper understanding of the global coffee market.
The Process: From Raw Data to Interactive Dashboard
Transforming raw data into meaningful insights starts with meticulous data cleaning and preparation. The first step involved addressing missing values by filling in averages for ratings and other relevant data points, ensuring a complete dataset. I eliminated duplicate entries to maintain data integrity and standardized formats for consistency across the dataset. Additionally, I developed calculated columns, such as Price per 100g (USD), to enable more granular analysis.
Next, I prepared the data for mapping by geocoding roaster and origin locations into precise latitude and longitude coordinates for accurate visualization. I combined origin and roaster location data into a single table, including fields like Origin, Origin Latitude, Origin Longitude, Roaster Location, Roaster Latitude, Roaster Longitude, Roast, Roasters, and Brand Name. This unified table was crucial for creating comprehensive maps.
For the visual design and interactive elements, I visualized the global spread of coffee origins and roaster locations using dynamic maps. I enabled users to filter data by roast type, origin, and brand through dynamic slicers, providing tailored insights. To allow deeper exploration of data layers, I integrated ZoomCharts' drill-down features, enhancing the overall interactivity and depth of the analysis.
The Dashboard: Interactive and User-Friendly
Key Visuals and Insights
Explore the most compelling insights from my analysis through interactive visuals. The interactive map allows users to explore coffee origins and roaster locations worldwide, providing a comprehensive geographical overview. The price vs. rating analysis reveals the relationship between coffee prices and consumer ratings, offering valuable insights into pricing strategies and consumer preferences. Additionally, the review of top-rated coffee brands in Asia highlights the market characteristics of the leading brands in this region.
My Power BI dashboard is designed to be intuitive and engaging. Here's how to make the most of it:
Navigating the Dashboard: Use the tabs at the bottom to switch between the "Overview and Key Insights" and "Detailed Analysis and Relationships" pages.
Using Slicers: Dynamically filter the data using slicers for roast type, origin, and year to tailor the insights to your interests.
Interacting with Visuals: Hover over visuals to see detailed tooltips and click on data points to filter other charts on the page, enhancing interactivity and data exploration.
Exploring Tooltips: Gain additional insights by hovering over data points in scatter plots, maps, and pie charts, revealing deeper details about the data.
Navigating Back: Use the navigation buttons to return to the main dashboard or other sections as needed, ensuring smooth and intuitive navigation.
Reflection: Transforming Data into Insights
Key Findings and Recommendations for Asian Markets
Common Mouthfeel: The top 5 high average rating coffee brands in Asia commonly have a sweet and juicy mouthfeel.
Common Aroma: The predominant aroma among these top brands is cocoa and chocolate.
Market Comparisons: The number of coffee brands in North America is almost double that in Asia. North American roasters use 27 different origins, whereas Asian roasters use only 20.
Recommendations
Focus on Sweet and Juicy Coffees: Product Development: Develop and market coffee products that emphasize a sweet and juicy mouthfeel.
Blend Innovation: Experiment with different blends and roasting techniques to enhance sweet and juicy characteristics.
Highlight Cocoa and Chocolate Aromas: Marketing Strategy: Emphasize cocoa and chocolate aromas in marketing campaigns.
Product Labeling: Clearly label and describe these aromatic notes on product packaging.
Expand Variety of Origins: Sourcing Strategy: Increase the variety of coffee origins used by Asian roasters.
Partnerships: Establish partnerships with coffee producers from new origins to diversify the supply chain.
Compete with North American and European Markets:
Premium Offerings: Develop premium coffee products to compete with expensive coffees from North America and Europe.
Market Expansion: Expand market reach to include North American and European consumers willing to pay a premium for high-quality Asian coffee brands.
Increase Brand Presence and Brand Growth: Encourage the growth of new coffee brands in Asia.
Support Local Roasters: Provide resources to local roasters to help them innovate and expand.
Consumer Education: Tasting Events: Host coffee-tasting events and workshops to educate consumers about the unique flavors and aromas of Asian coffee.
Content Marketing: Use content marketing to share stories about the origins, roasting processes, and unique characteristics of Asian coffee.
