Coffee rose to 360.10 USd/Lbs on June 9, 2025, up 0.73% from the previous day. Over the past month, Coffee's price has fallen 5.85%, but it is still 62.14% higher than a year ago, according to trading on a contract for difference (CFD) that tracks the benchmark market for this commodity. Coffee - values, historical data, forecasts and news - updated on June of 2025.

Interactive chart of historical daily coffee prices back to 1969. The price shown is in U.S. Dollars per pound.

Coffee growers raise two species of coffee bean: Arabica and robusta. The former is more expensive, selling for 2.93 U.S. dollars per kilogram in 2018 and projected to increase in price to 4.8 U.S. dollars in 2026. Robusta, named because it can grow at a wider range of altitudes and temperatures, sold for 1.87 U.S. dollars in 2018, projected to sell at 3.9 U.S. dollars per kilogram in 2026. Coffee production Coffee originally comes from Ethiopia, where a significant portion of coffee production continues to take place. The more popular bean, Arabica, takes its name from the Arabian Empire, when coffee consumption spread throughout the Middle East. After overcoming its ban by the Catholic Church, who saw coffee as in intoxicant from the Muslim world, coffee sales per capita are highest in European countries. Major players Starbucks has shaped the modern coffee culture, capitalizing on the Seattle coffee shop scene. This opened gourmet coffee to a wider market, shifting the global demand from cheaper robusta to better-tasting Arabica varieties. This shift has influenced the world coffee market, prompting companies such as McDonalds to open McCafé stores to cater to the evolving tastes of global consumers.

I have gathered every day Coffee Prices information for the last 45 years. I made the dataset as simple as possible and left only two columns with date and coffee price (USD per pound). This data is extremely convenient for beginners and for those who are going to practice data analysis and visualization.

I highly recommend this dataset for practicing with dates formats. I remember myself at the first months of data analysis - the most complicated thing I ever met were date manipulations. You can feel free to practice these manipulations here.

The last thing I want to say is about charts and graphs. I highly recommend you to use line plots and bars. There are not so much sense here in correlations plots or scatters. Just because there are two columns. Feel free to write comments. I always answer all of them and chat with datasets' coders.

Don't forget about inflation!

The H1B Sponsorship Trends linear chart shows the number of H1B cases filed by Coffee Meets Bagel from 2020 to 2023, providing a clear view of filing trends over time. Alongside, the horizontal bar chart titled Distribution of Job Fields Receiving H1B Sponsorship breaks down which roles and industries are most commonly sponsored.

Analyzing Coffee Shop Sales: Excel Insights 📈

In my first Data Analytics Project, I Discover the secrets of a fictional coffee shop's success with my data-driven analysis. By Analyzing a 5-sheet Excel dataset, I've uncovered valuable sales trends, customer preferences, and insights that can guide future business decisions. 📊☕

DATA CLEANING 🧹

• REMOVED DUPLICATES OR IRRELEVANT ENTRIES: Thoroughly eliminated duplicate records and irrelevant data to refine the dataset for analysis.

• FIXED STRUCTURAL ERRORS: Rectified any inconsistencies or structural issues within the data to ensure uniformity and accuracy.

• CHECKED FOR DATA CONSISTENCY: Verified the integrity and coherence of the dataset by identifying and resolving any inconsistencies or discrepancies.

DATA MANIPULATION 🛠️

• UTILIZED LOOKUPS: Used Excel's lookup functions for efficient data retrieval and analysis.

• IMPLEMENTED INDEX MATCH: Leveraged the Index Match function to perform advanced data searches and matches.

• APPLIED SUMIFS FUNCTIONS: Utilized SumIFs to calculate totals based on specified criteria.

• CALCULATED PROFITS: Used relevant formulas and techniques to determine profit margins and insights from the data.

PIVOTING THE DATA 𝄜

• CREATED PIVOT TABLES: Utilized Excel's PivotTable feature to pivot the data for in-depth analysis.

• FILTERED DATA: Utilized pivot tables to filter and analyze specific subsets of data, enabling focused insights. Specially used in “PEAK HOURS” and “TOP 3 PRODUCTS” charts.

VISUALIZATION 📊

• KEY INSIGHTS: Unveiled the grand total sales revenue while also analyzing the average bill per person, offering comprehensive insights into the coffee shop's performance and customer spending habits.

• SALES TREND ANALYSIS: Used Line chart to compute total sales across various time intervals, revealing valuable insights into evolving sales trends.

• PEAK HOUR ANALYSIS: Leveraged Clustered Column chart to identify peak sales hours, shedding light on optimal operating times and potential staffing needs.

• TOP 3 PRODUCTS IDENTIFICATION: Utilized Clustered Bar chart to determine the top three coffee types, facilitating strategic decisions regarding inventory management and marketing focus.

*I also used a Timeline to visualize chronological data trends and identify key patterns over specific times.

While it's a significant milestone for me, I recognize that there's always room for growth and improvement. Your feedback and insights are invaluable to me as I continue to refine my skills and tackle future projects. I'm eager to hear your thoughts and suggestions on how I can make my next endeavor even more impactful and insightful.

THANKS TO: WsCube Tech Mo Chen Alex Freberg

TOOLS USED: Microsoft Excel

DataAnalytics #DataAnalyst #ExcelProject #DataVisualization #BusinessIntelligence #SalesAnalysis #DataAnalysis #DataDrivenDecisions

The PERM Sponsorship Trends linear chart visualizes the number of PERM cases filed by Busybee Roaster Coffee Shop from 2020 to 2023, highlighting the company’s long-term sponsorship patterns. The horizontal bar chart titled Distribution of Job Fields Receiving PERM Sponsorship further categorizes sponsored roles by job type.

The H1B Sponsorship Trends linear chart shows the number of H1B cases filed by Busybee Roaster Coffee Shop from 2020 to 2023, providing a clear view of filing trends over time. Alongside, the horizontal bar chart titled Distribution of Job Fields Receiving H1B Sponsorship breaks down which roles and industries are most commonly sponsored.

The PERM Sponsorship Trends linear chart visualizes the number of PERM cases filed by Coffee C Cafe from 2020 to 2023, highlighting the company’s long-term sponsorship patterns. The horizontal bar chart titled Distribution of Job Fields Receiving PERM Sponsorship further categorizes sponsored roles by job type.

All-Transactions House Price Index for Coffee County, GA was 211.45000 Index 2000=100 in January of 2024, according to the United States Federal Reserve. Historically, All-Transactions House Price Index for Coffee County, GA reached a record high of 211.45000 in January of 2024 and a record low of 67.62000 in January of 1986. Trading Economics provides the current actual value, an historical data chart and related indicators for All-Transactions House Price Index for Coffee County, GA - last updated from the United States Federal Reserve on June of 2025.

All-Transactions House Price Index for Coffee County, TN was 309.50000 Index 2000=100 in January of 2024, according to the United States Federal Reserve. Historically, All-Transactions House Price Index for Coffee County, TN reached a record high of 309.50000 in January of 2024 and a record low of 65.70000 in January of 1986. Trading Economics provides the current actual value, an historical data chart and related indicators for All-Transactions House Price Index for Coffee County, TN - last updated from the United States Federal Reserve on June of 2025.

This graph depicts the number of specialty coffee shops in the United States from 1991 to 2015. In 2015, there were 31,490 coffee shops in the U.S.

More statistics and facts on coffeehouse chains

Coffee shops - additional information

The number of specialty coffee shops in the United States has increased over the last 24 years reaching almost 31,500 establishments in 2015. Starbucks was by far the largest coffeehouse in the United States in 2016. In the same year, the famous coffee chain generated revenues of over 21 billion U.S. dollars, dominating the global, as well as the U.S. market. In 2016, Starbucks was one of the most valuable fast food brands worldwide, second only to global giant McDonald’s.

Other leaders in the global coffee shop industry include the British chain Costa Coffee and McDonald's coffee shop brand McCafe. None of these, however, were the most popular among U.S. consumers. A 2015 survey found that Smoothie King was the U.S. consumer’s favorite chain in the coffee and snack shop category, followed by Krispy Kreme Doughnuts and Peet's Coffee and Tea.

The PERM Sponsorship Trends linear chart visualizes the number of PERM cases filed by Thavorn Llc Dba Magnolia Deseert Bar Coffee from 2020 to 2023, highlighting the company’s long-term sponsorship patterns. The horizontal bar chart titled Distribution of Job Fields Receiving PERM Sponsorship further categorizes sponsored roles by job type.

The PERM Sponsorship Trends linear chart visualizes the number of PERM cases filed by Bayou Grande Coffee Roasting from 2020 to 2023, highlighting the company’s long-term sponsorship patterns. The horizontal bar chart titled Distribution of Job Fields Receiving PERM Sponsorship further categorizes sponsored roles by job type.

The PERM Sponsorship Trends linear chart visualizes the number of PERM cases filed by Melrose Place Coffee Company Dba Alfred Coffee from 2020 to 2023, highlighting the company’s long-term sponsorship patterns. The horizontal bar chart titled Distribution of Job Fields Receiving PERM Sponsorship further categorizes sponsored roles by job type.

Graph and download economic data for Employed full time: Median usual weekly nominal earnings (second quartile): Wage and salary workers: Counter attendants, cafeteria, food concession, and coffee shop occupations: 16 years and over: Men (LEU0254653500A) from 2000 to 2011 about cafeteria, coffee, second quartile, occupation, full-time, males, salaries, workers, earnings, 16 years +, food, wages, median, employment, and USA.

The H1B Sponsorship Trends linear chart shows the number of H1B cases filed by Bellwether Coffee from 2020 to 2023, providing a clear view of filing trends over time. Alongside, the horizontal bar chart titled Distribution of Job Fields Receiving H1B Sponsorship breaks down which roles and industries are most commonly sponsored.

The PERM Sponsorship Trends linear chart visualizes the number of PERM cases filed by Bellwether Coffee from 2020 to 2023, highlighting the company’s long-term sponsorship patterns. The horizontal bar chart titled Distribution of Job Fields Receiving PERM Sponsorship further categorizes sponsored roles by job type.

The H1B Sponsorship Trends linear chart shows the number of H1B cases filed by That Coffee from 2020 to 2023, providing a clear view of filing trends over time. Alongside, the horizontal bar chart titled Distribution of Job Fields Receiving H1B Sponsorship breaks down which roles and industries are most commonly sponsored.

The market size of the coffee and snack shop sector in the United States totaled 68.5 billion U.S. dollars as of August 2024. Meanwhile, the number of businesses reached nearly 78,000 and employment reached over 900,000.