Skip to Content

Dataset source: https://catalogue.ic.nhs.uk/publications/public-health/alcohol/alco-eng-2013/alc-eng-2013-tab.xlsx

Publication: https://catalogue.ic.nhs.uk/publications/public-health/alcohol/alco-eng-2013/alc-eng-2013-rep.pdf

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:

/wp-content/uploads/2013/10/a8_307620.jpg

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.

/wp-content/uploads/2013/10/a1_307621.jpg

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

/wp-content/uploads/2013/10/a2_307781.jpg

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

Men:

/wp-content/uploads/2013/10/a3_307782.jpg

Women:

/wp-content/uploads/2013/10/a4_307783.jpg

On this visualization are men and women compared.

/wp-content/uploads/2013/10/a5_307790.jpg

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.

/wp-content/uploads/2013/10/a6_307791.jpg

On every four/five years:

/wp-content/uploads/2013/10/a7_307792.jpg

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.

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. 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 😆

    Cheers!!!

    Benedict

    (0) 
  2. Irshaad Bijan Adatia

    Vladimir!!!!

    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 http://webrzs.stat.gov.rs/WebSite/Default.aspx

    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?

    -Bijan

    (0) 
    1. Vladimir Erakovic 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.

      Vladimir

      (0) 

Leave a Reply