1 of 9

Tableau �Capstone Project

United Way of Greater Atlanta

Data Analytics, Emory University Continuing Education

Presented By:

Alice Ejemole

2 of 9

The Child Well-Being Index and �Why it Matters:

What is the Child Well-Being Index:

The United Way, along with partners developed a multi-dimensional method to further understand and calculate the well-being of children at neighborhood, county, and regional levels.

Why does the Child Well-Being Index Matter?

There cannot be a flourishing community when a considerable number of children within the metro communities experience restricted resources and limited opportunities for transforming their futures.

3 of 9

Tableau Capstone:�Data Used

13 Metro Counties:

Butts

Cherokee

Clayton

Cobb

Coweta

Dekalb

Douglas

Fayette

Fulton

Gwinnett

Henry

Paulding

Rockdale

776 Data Observations:

Family Index
Community Index
Child Index
Overall Child Well-Being Index

Data Generated From:

U.S. Census
Georgia Department of Education

4 of 9

Digging Deeper: �Questions to Answer using Tableau

Which counties have the highest overall CWB index?

Which counties has the lowest overall CWB index?

Do the Family, Child, and Community indexes correlate in any way?

Which high needs neighborhoods can the United Way invest their resources and efforts?

There is significant research that demonstrates that the status of the community, including diversity, income and community resources, have a significant impact on the experiences and life outcomes of children.

With the child well-being correlating closely with the quality of life and continuous growth of metro communities and a high number of Georgia children living in communities with low or lower than average indexes, focusing on the overall health, education, and well-being of the imminent generation of children is key.

With the data provided, we developed a series of questions:

-Which counties has the highest overall CWB index? And what similarities do they share? With attributing sub-domains 🡪 Child Index, Community Index, and Family Index

-Which county has the lowest overall CWB index? With the same attributing domains🡪 Child Index, Community Index, and Family Index

-Do the sub-domains correlate in any way?

-Specifically, which high needs neighborhoods can the United Way invest their resources and efforts🡪 Why?

Taking a look at the Tableau Dashboard, we will highlight where United Way needs to focus their efforts across the 13 metro counties. **PAUSE SCREEN & MOVE TO DASHBOARD**

5 of 9

6 of 9

7 of 9

8 of 9

Executive Summary

Child Index is the lowest observed sub-index amongst all counties.
Being that there is a direct correlation seen between the Child Index and Overall Child Well Being Index, data supports the idea that improving the Child Index will improve the Overall Child Wellness Index.
Recommendations target improving the negative indicators affecting the Child Index and child education.

9 of 9

Recommendations for the United Way

Focusing on Negatively Impacting Indicators:

Promoting job training and upskill groups for teens focusing on technical skills, self-regulation, and financial literacy.
Health & Nutritional aid programs and support groups for expecting mothers

Improving Education Focused Indicators:

Set benchmarks to consistently assess growth amongst low performing counties.
College application assistance and helpline
Implementing student mentorships programs
Financial aid for below poverty first generation college students