December 22, 2010
The Cola Wars: Don’t Take on Coke
bar chart
,
coca-cola
,
dual axis
,
line chart
,
Richard Branson
,
scatterplot
,
tableau
,
tableau public
,
Virgin Cola
3 comments
There’s been a buzz around town about the increase in Coke’s (NYSE: KO) stock price over the past several months. Coke is THE symbol of Atlanta, so naturally there’s a huge interest in their success and the demise of the main competitor.If I may digress, you can pinpoint the turnaround on March 5, 2009 with Muhtar Kent’s inspiring letter to shareholders. Mr. Kent’s first job with Coke was in 1978 as a driver and he has risen steadily through the system to CEO and is deservedly compensated quite handsomely ($19.6M in 2008, $14.8M in 2009). According to the AJC, this could buy you 1.5 personal jets, 109.5 houses and 192.25 luxury SUVs.
When measuring Coke’s performance there’s only one large competitor (yes, I’m intentionally NOT mentioning their name). I created the dashboard below to do some basic analysis, plus I wanted to get some practice with parameters in Tableau.
- The New Coke disaster in 1986 didn’t hurt as much as you would be led to believe by the media (it tasted terrible!)
- Coke’s stock is up 85% from a two-year low point in March 2009
- Strictly based on price, Coke has been getting killed by its main competitor since 2003, but has effectively closed the gap
- When I looked at closing price and shares traded vs. the main competitor, it looks like there is an inverse relationship. I created the dual axis chart as another way to make this comparison
Finally, I was given a 6-pack of glass bottles to share over the holidays. There is a photo contest for the best holiday celebration including these Cokes. Any ideas?
Shake Up Christmas!
Subscribe to:
Post Comments
(
Atom
)
Excellent dashboard, Andy. This is a superbly executed business dashboard - some really nice touches. I love the icons for selecting the brand, plus everything is tidily organised.
ReplyDeleteKeep up the great work!
Beautiful and informative. I'm inspired! Thank-you.
ReplyDeletePerfect, user friendly and design encourage to play with data.
ReplyDelete