amyguan-dataviz-portfolio
| home page | data viz examples | critique by design | final project I | final project II | final project III |
Portfolio
This is my public portfolio for Telling Stories with Data at CMU!
Web page URL:
https://ag035.github.io/amyguan-dataviz-portfolio/
This repository:
https://github.com/ag035/amyguan-dataviz-portfolio
About me
Hi! I’m Amy Guan. I was born and raised in Ningbo, a vibrant city on the east coast of China. At 16, I moved to the other side of the world - Ottawa - for high school and began my journey as an international student and traveler.
In college (Bryn Mawr College, PA), I developed an interest in comparative politics and international affairs. This brought me to Carnegie Mellon University, where I’m pursuing a Master’s in Public Policy and Management. My focus is on equitable social policies, such as housing and health. My past research includes racial exclusion laws and policies affecting the AAPI community, and their repealing process.
Outside my program, I enjoy cooking, learning the ukulele, and watching thriller series.
What I hope to learn
I’m taking Telling Stories with Data because I believe data visualization and story telling are just as important as data processing itself. Below are some specific skills I hope to develop:
- Learning to use tools like Tableau and Excel to prepare and visualize data effectively
- Understanding how design elements could help conveying clearer messages from data
- Developing the ability to identify narratives in news or articles that use data to tell stories
Additionally, my goals include:
- Building a presentable portfolio for future job searches
- Using the skills acquired from this class to bridge the gap between people and data, making information more accessible to non-technical audiences
Portfolio
In-Class Dataviz 1: Urban Mobility Readiness
Examples
Practice: Government Debt
Assignment: Visualizing overnment Debt
Assignment 3&4: Critique by Design
For this assignment, make sure you set up and link to a new page. This page is linking to a new Markdown document called critique-by-design.md.
Final project
Here it might be helpful to include a high-level description of your final project.
Part I
Summary
Korea’s pronatalist policies: a failing formula? Lessons from Sweden South Korea faces a severe demographic challenge, with its fertility rate dropping to the lowest in the world despite extensive government policy efforts. Pronatalist policies, including parental leave, childcare subsidies, and financial incentives, have not reversed the numbers. This project explores South Korean’s efforts, their effectiveness, and policy solutions based on Sweden’s successful model.
Outline
1. Introduction
Fun fact: South Korea had more pet strollers sold than baby strollers. (picture)
Overview of Korea’s declining fertility rate.
Introduce Sweden as a counterexample: once faced a similar issue, how did they reverse the trend.
2. DataViz: Korea’s declining birth rate
idea 1: korea’s fertility rate dropping
idea 2: interactive timeline of Korea’s policy efforts vs. birth rate trends
idea 3: comparative of Korea and Sweden fertility rate
3. What has Korea tried
side by side comparison of policy and their actual impact on fertility
examples: maternity and parental leave policies, financial incentives and subsidies
4. What Sweden did differently
organize by factor
factor 1: equal parental leave policies (dataset found: parental leave for fathers)
factor 2: higher representation of women in government and workplace leadership (dataset found: Proportion of seats held by women in national parliaments (%))
factor 3: possibilities of losing job or professional opportunities due to pregnancy
5. The missing pieces in Korea’s approach (key takeaways)
6. Implications
I’m not urging for higher fertility rate through this project as an end goal - women should have full autonomy over their reproductive choices. However, a persistently low birth rate can serve as a signal that systemic barriers, such as workplace policies, gender norms, and childcare access, made parenthood an unattractive option for many. If more women feel empowered, supported, and able to handle career and family without significant personal or financial strain, a higher fertility rate may naturally follow as an indicator of improved conditions rather than an objective itself.
7. Call to action
Poll: what do you think is the biggest barrier to having more children in korea?
policy recommendations.
Sketches
Data
Approach
The data sources for this analysis are drawn from the World Bank Gender Dta Portal, a widely recognized public accessible data source of global gender-related statistics. The data set on adolescent fertility rates (births per 1000 women aged 15-19) and total fertility rates provide a foundational approach to understand trends in childbearing in South Korea and its peer countries.
Additionally, the length of parental leave and government’s role in administering maternity leave benefits help assess the structural support provided to working parents.
Data on the proportion of seats held by women in national parliaments and the female to male labor force participation ratio explains gender equality in political and economic spheres.
Current Sources
Adolescent fertility rate (births per 1,000 women ages 15-19). (n.d.). World Bank Gender Data Portal. Retrieved February 4, 2025, from https://genderdata.worldbank.org/en/indicator/sp-ado-tfrt
Fertility rate, total (births per woman). (n.d.). World Bank Gender Data Portal. Retrieved February 4, 2025, from https://genderdata.worldbank.org/en/indicator/sp-dyn-tfrt-in
Length of parental leave (calendar days). (n.d.). World Bank Gender Data Portal. Retrieved February 4, 2025, from https://liveprod.worldbank.org/en/indicator/sh-par-leve
Proportion of seats held by women in national parliaments (%). (n.d.). World Bank Gender Data Portal. Retrieved February 4, 2025, from https://genderdata.worldbank.org/en/indicator/sg-gen-parl-zs
Ratio of female to male labor force participation rate (%). (n.d.). World Bank Gender Data Portal. Retrieved February 4, 2025, from https://genderdata.worldbank.org/en/indicator/sl-tlf-cact-fm-zs
The government administers 100 percent of maternity leave benefits (1=yes; 0=no). (n.d.). World Bank Gender Data Portal. Retrieved February 4, 2025, from https://genderdata.worldbank.org/en/indicator/sh-mmr-leve-gt
Delivery
I might create an interactive website to present my content, which will stay accessible to broader readers after class. I’m considering using Shorthand.
Part II
Part III
Part III(final-project-part-three)
Creating tables
You can build tables like this:
| Name | Type of pet | Favority activity 1 | FA 2 | FA 3 | FA 4 |
|---|---|---|---|---|---|
| Eli | cat | Sleeping | Eating | Being pet | Plotting to overthow dog empire |
| Howard | dog | You | You | You | Eating |
| Frankenstein | fish | Swimming | Eating | Blowing bubbles | Forgetting |
An easy-to-use template generator tool can be found here
Setting up a separate page
So here’s the code you’ll need to add to your own site to create a second page.
- First, create a new page in your repository (for example, dataviz1.md)
- Next, add a link to that page by inserting the following into your readme.md page:
[title](dataviz) or [dataviz](https://cmustudent.github.io/portfolio/dataviz.html) or [CMU](https://www.cmu.edu)
Any of those formats will work. Here’s some examples of working links:
[title](dataviz) = title
[dataviz](https://cmustudent.github.io/portfolio/dataviz.html) = dataviz
[CMU](https://www.cmu.edu) = CMU
Make sure to check these from your publicly accessible URL to make sure they’re working correctly (not from the preview tab).
Looking for more? A nice Markdown guide can be found here
References
List any references you used here.
AI acknowledgements
If you used AI to help you complete this assignment (within the parameters of the instruction and course guidelines), detail your use of AI for this assignment here.
- I used ChatGPT to resize the image of In-class Dataviz #1.