theYvonne

View Original

Never Married Is on the Rise

Community Challenge: Makeover Monday 2021 wk 23

My redesign (Tableau File Here):

Reading time:  3 min 27 secs

Outline

See this content in the original post

Data Analysis Summary

There is a rise of both men and women who have never married over time in every age group. As people age, the number of people who have never married decreases but the percentage of unwedded in 2016 is still higher than in 2006.

See this content in the original post

Project Goals

  • Use containers as a color design element

  • Optimize my viz documentation

    • Adding Cmd E info

    • Table of Contents)

  • Complete in a time limit preparing for certification



See this content in the original post

Project Discussion

See this content in the original post

Challenges

Placing each age grouping with gender pairing on one chart created a very messy line chart. The solution - creating a different graph for each age group/gender pair. Then on the dashboard, using containers to create the feel of a small multiple chart. The final challenge - how to make this visual look polished. I also paid attention to the y-axis. The top two charts used the same scale, while the bottom three had a different scale so that differences could seem easier for each grouping. Another thing done to create a cleaner overview is the top charts; the x-axis was hidden.

See this content in the original post

Design Discussion

See this content in the original post

Data

See this content in the original post

Source

Nevermarried.xls extracted from the US Census data is the data source Makeover Monday Challenge 2021 wk 23.

See this content in the original post

Wrangling

The data did not have any missing data points and was a tidy data set. The year field changed to date with a custom year (YYYY) setting. The field Never Married was defined as a number with no decimal points.

See this content in the original post

Code Notes

See this content in the original post

Calculations

No calculations are required with this project.

See this content in the original post

Colors Used

For this viz, I used my typical go-to color for male (#9567FE Medium Slate Blue) and female (#FD6320 Orange Red). When working with gender data, I avoid the blue/pink combo and the bias those colors convey. I then used complementary colors for text, backgrounds, and title for the rest of the viz. I refer to this color palette as Genderly (additional details and tableau code).

See this content in the original post

Tableau Generated Documentation

Using Command + E on the mac for each worksheet, you can get the following formation. Since each sheet is the same, just changing the age filter, I combined all the info.

Dimensions

Age Range has one member per sheet

Sheets: 25-29, 30-34, 25-44, 45-54, 55 +

Gender has two members on this sheet. Members: Men; Women

Year ranges from 2006 to 2016 on sheet.

Measures

Age 25-29: The sum of Never Married ranges from 46% to 71% on this sheet.

Age 30-34: The sum of Never Married ranges from 26% to 46% on this sheet.

Age 35-44: The sum of Never Married ranges from 16% to 27% on this sheet.

Age 45-54: The sum of Never Married ranges from 11% to 17% on this sheet.

Age 55+: The sum of Never Married ranges from 6% to 9% on this sheet.

Data Source:

Sheet1 (Never Married)

Type:

Hyper

Version:

0

Table:

Extract (Extract.Extract)

See this content in the original post

Final Thoughts

See this content in the original post

Project Analysis

More people are getting married later in life, and many people elect not to get married compared to previous years. This trend has a social and economic impact on both individuals and people.

See this content in the original post

Project Creation

I do see an improvement over time with creating a complete viz in a limited time. My next phase of concentration is to working on visual impact, storytelling and documentation.

What do you think? Let me know on Twitter @YvonFitz.


Links & Additional Information

Challenge Information:

Related Post You Might Enjoy

See this gallery in the original post