This week’s Makeover Monday challenge was based on an article, pointing out that US American women work more hours than their European counterparts.
Sounded interesting, and as a fan of working efficiently to avoid overtime wherever possible, I decided to have a look at this data set to see if some women really seem to work ‘more’ than others (or just longer hours).
Sidenote: I’d love to get into a bigger dataset about this which includes work force efficiency, because hours worked to me is not a good indicator of being productive, efficient and ‘working hard’, but for now ‘work hours’ are all I had to play with.
The original article focused on US women compared to European women. My first issue with the analysis is the term ‘European women’. Well, Europe is pretty big and includes a lot more than Germany and France. While US women have a higher percentage of those working 40+ hours per week compared to GER and FRA, Eastern Europe has the highest percentage of those working long hours.
Subsequently I wanted to look at the data globally and focus on the countries that have the highest percentage of 40+ hour weeks.
My second issue was that the article had huge potential but didn’t really dig into the data further and therefore would have not provided comprehensive information for the reader. I don’t claim that my analysis does that, but I wanted to at least visualise the whole dataset to put things into perspective.
Finally, I found that adding the OECD average as a trend line would help people’s understanding, rather than just having it as as a row (in my case) or column (in the original article) to give people a benchmark.
Without further ado, here is my dashboard on Tableau Public…