Data Analysis

• Discovery: Exploring the data to understand its sources, structure, and potential issues 

• Cleaning: Correcting errors, handling missing values, and removing irrelevant information 

• Structuring: Organizing the data into a desired format 

• Enriching: Adding values from other datasets or metadata to the database 

• Validating: Checking the accuracy and consistency of the data 

• Publishing: Exporting the cleaned and validated data in a format that's ready for analysis 

I augmented the original wage dataset by reducing it from its span of 1979 to 2020.

• Compose research questions

• Wrangle data

• Add supplemental columns (i.e., calculated fields or use of DAX)

• Choose visualization tool

• Choose chart type(s)

• Apply principles and elements of good design

• Export / publish dashboard

• Summarize and report findings

The reasoning behind not showing food cost (and or housing cost) as a percentage of overall expenses is because it is a moot point. Food and housing are the base physiological needs upon which all other needs rest.  Yes, we need healthcare but without good, clean food and a safe place to live, that perfect health will quickly deteriorate. Even the desire to have children or care for family is forfeited because safety and physiological needs supersede all else.

See Maslow's hierarchy of needs [https://miro.medium.com/v2/resize:fit:1400/1*4_OyStsRWAgZbyA6RuYkIQ.jpeg].

It has already been proven that "housing first" is the best was to combat homelessness and unemployment.

Recommendations

The data shows that subsidized housing on a sliding scale (a tier system) is a more tailored solution for food subsidies and apartment rental rates in the States.

It is impossible to bring every citizens' income above the median or pay everyone a livable wage based on the way income is distributed in the private sector at this time. An example of this tier system at work can be seen here: 'Japan's Housing for the Middle Class' https://youtu.be/Ave4FiC2k8I?si=VMdY6Yr2K9P0C0mG