The last day of dashboard week consisted of analyzing time related to hours data for Americans. Specifically I focused on the average time spent on parenting activities divided between male and females. So here is the table that was presented on the link:
In order to work with this data, I decided to copy and paste this data on to excel.
From that point onwards, I decided to remove all total columns because I figured those can be calculated further on in Tableau; if I ever needed them. So my idea was to create gender, activities, and weekday/weekends columns.
This is the format in which I rearranged the columns. Although I still needed a gender column and a column for hours. Here I needed to do some Alteryx magic.
Here is the final spreadsheet; the one I wanted to input into Tableau.
After looking at the cleaned data; I decided to focus on the gender aspect of the data. My hypothesis was that because there are more women in the workforce; I believe that dads will take up more of the parenting while moms will take a backseat.
With this hypothesis I decided to create charts that related to this. I created a chart that compared the total number of hours parenting with men versus women.
We see here that women still contribute to more activities as well as see which age group spends time with which parent more.
Then I created a chart that displayed the number of hours per activity by each parent. Here we see again that women still spend more time doing most activities; except when attending children’s events. Here we see dads are more active in this activity.
Finally I wanted to see how a specific time frame affects activities.
Weekdays
—>
Weekends
So the insight from here is that although women still spend more time doing parenting activities on both weekends and weekdays; men make up for lost time during the weekends.
In conclusion, my original hypothesis of there being an even distribution in parenting was wrong. Here we see that traditional gender roles of women contributing to parenting are still prevalent.
