Popularity of Tea, Coffee, Beer and Wine – Visualization

Share on facebook
Share on twitter
Share on linkedin
Share on reddit
Share on email

If number of searches were an indicator for gauging the popularity of a drink between Tea, Coffee, Beer and Wine then who wins the contest?

Let us analyze who wins the popularity contest by comparing the number of searches for each of the terms.

Data collection method: Each of the keywords Tea, Coffee, Beer and Wine were used with Google Trends to extract the weekly data and then plotted as below. Year 2015 is excluded due to partial year.

Which drink is gaining popularity and which is losing?

A simple group bar chart trended over years should give a clear picture for the winners and losers.

Image

 

As can be seen by the super imposed trend lines, Tea and Beer have been gaining increasing popularity whereas Coffee has been on the decline since 2012. The popularity of wine has been on the decline since 2005 and has found a constant level since 2011-2012

Let us flip the dimensions and view them as a stacked area chart

Image

There was a dip in the overall popularity of the four drinks as seen by the trough between years 2007 through 2011.

Now let us aggregate the searches by Quarter and see if there are any cyclical patterns

Image

Interestingly all the peaks on the above chart occur during the 4th quarter of every year.

Let us zoom in and see it by the month.

 

Image

Interestingly, we see there is a peak for roughly every 1 or 2 months interval.

And finally the searches by each week

Image

 

Click here to view the interactive popularity of searches between Tea Coffee Beer and wine

Custom Reports and Dashboards

We will build you a set of custom reports and dashboards
Best Offer

The Core Tools

Create dashboard for any Database

Data Visualizer and Dashboard Application
SALE
This is the best dashboard software for its price. One good thing we did was to hire their consulting services to build few dashboard prototypes and provide some quick dashboard training.
- Terry Seal, IL
We evaluated Xcelsius and Qlikview and the cost for organization to implement dashboards was quoted over 10,000 USD. For fraction of the above quoted price, we were able to buy the licenses for the web based dashboard software and get some free training. This is truly a dashboard software for small businesses like us.
IT Manager of a Trucking company, OH