Community Challenge: Makeover Monday 2021 wk 23

My redesign (Tableau File Here):

theYvonne MOM 2021 wk 23 Never Married On The Rise.jpg

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.

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


Whether it was work, marriage, or family, I’ve always been a late bloomer.
— Sigourney Weaver, Actress

Project Discussion

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.

Design Discussion

Data

Source

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

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.

Code Notes

Calculations

No calculations are required with this project.

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).

Genderly Grid.jpg
Location
Hex Code
Name
Male#9567FEMedium Slate Blue
Female#FD6320 Orange Red
Title#4E5057 Davys Grey
Line#4D6B9 Pale Spring Bud
Footer#919584Artichoke
Text#584B53Dark Liver
Background Viz#FFFFFFWhite
Background Chart#4D6B9 Pale Spring Bud 25 % Opacity

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)

Final Thoughts

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.

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

Previous
Previous

IronOcean Palette

Next
Next

Genderly Palette