Skip to Content
Author's profile photo Vladimir Erakovic

Data Geek Challenge : UK alcohol consumption statistics

Dataset source:


This is my first encounter with SAP Lumira and I can say that is very interesting working with it (her?). But choosing the right dataset and interesting topic is not easy at all. After several attempts with some other datasets (organic agriculture, statistics of population and few others) I found dataset for very serious issue – alcohol use among population. I tried to find datasets for my country but they probably doesn’t exist so I used United Kingdom data. Usage of alcohol is very high in my country and alcohol related diseases and conditions are constant threats to the health of the population.

In order to use data from Excel file I first got to cleanse the data and divide some Excel sheets in two. This is one of the original sheets:


Then I import cleansed Excel sheets in SAP Lumira and start creating visualizations.

First visualization shows consumption of alcoholic drinks in home from 1992 to 2011 and it is in decline for the last couple of years. Amount is ml per person per week.


Second visualization shows consumption outside the home and it’s in constant decline from 2001.


On next two visualization one can see average weekly consumption of different type of drinks by age groups, for men and for women, respectively.





On this visualization are men and women compared.


And now the ugly part of alcohol usage.

These visualization shows the most common consequences directly or indirectly caused by excessive use of alcohol. The numbers are constantly increasing from one year to another regardless of the fact that consumption decreases. This is due to minority of population who drink to excess.


On every four/five years:


Major findings in overall statistic that I use here, are:

– 64% of men drank no more than 21 units weekly, and 63% of women drank no more than 14 units weekly;

– 61% of men and 72% of women had either drunk no alcohol in the last week, or had drunk within the recommended levels on the day they drank the most alcohol;

– 12% of school pupils had drunk alcohol in the last week. This continues a decline from 26% in 2001, and is at a similar level to 2010, when 13% of pupils reported drinking in the last week;

– Wholly and partially attributable admission rose by 4% from 2010/11 – 2011/12 to 1.22m;

– 90% of respondents had heard of units (up from 79% in 1997) and 63% knew what a unit of each type of drink was (up from 47% in 1997);

– 75% had heard of the daily drinking limits, up from 54% in 1997;

– The number of male deaths increased from 4,439 in 2010 to 4,518 in 2011 and the number of female deaths increased from 2,230 in 2010 to 2,405 in 2011

Advice for the end of this post: drink responsibly or not at all.

Thank you for reading.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Benedict Venmani Felix
      Benedict Venmani Felix

      Nice analysis Vladimir. Especially your inferences from all the analysis.

      Am I seeing bottles in the background or am I drunk. Will check again tomorrow when I am sober 😆



      Author's profile photo Vladimir Erakovic
      Vladimir Erakovic
      Blog Post Author

      Thanks Benedict!

      Author's profile photo Former Member
      Former Member


      it's great to see you here posting with the Lumirians!

      Great job including your data source, I'll add that to our Data List

      The background pictures that you chose to put with your charts, I'm still chuckling over.

      Мој Ћирилица је лош ... Мои русские лучше

      BUT ... Have you checked out

      Maybe we can find some better local stats for you to work with?

      How long did it take you to organize your data, and put the visualizations together?


      Author's profile photo Vladimir Erakovic
      Vladimir Erakovic
      Blog Post Author

      Thanks Bijan! I'll check that site. I found similar one with statistics from Serbia but they weren't much interesting. I'd love to work more with Lumira and I'll try to use it at work with some reports.

      It took me about three hours for all.


      Author's profile photo Jitendra Kansal
      Jitendra Kansal

      great analysis !!!

      Author's profile photo Vladimir Erakovic
      Vladimir Erakovic
      Blog Post Author

      Thank you Jitendra!