Inspiration

While exploring the OECD wellbeing dataset, I realized how often job and expansion decisions overweight pay and ignore essentials like work–life balance, safety, education, housing, and long-term wellbeing. Putting these side-by-side changed how I think about taking a job abroad and how companies should assign work, design policies, and choose locations.

What it does

Where People Thrive is a six-chart, linked dashboard that shows where people—and businesses—can thrive.

Wellbeing Choropleth — global context via life satisfaction/overall wellbeing.

Income ↔ Life Expectancy (bubble) — prosperity vs longevity; bubble size = employment rate.

Safety ↔ Education (bars) — trade-offs between secure environments and human capital.

Work–Life ↔ Job Satisfaction (heatmap) — burnout risk vs happiness at work.

Wellbeing Trends (lines) — momentum/resilience over time for major economies.

Inequality & Pipeline (stacked bars) — gender wage gap + youth NEET. All visuals share Country/Year filters and cross-filter each other, with OECD averages as subtle benchmarks.

How I built it

Data prep: OECD long table → latest-year snapshot per country/measure → wide table for comparisons.

Signal hygiene: reversed “negative” metrics (e.g., homicides, long hours, pollution) so higher = better; standardized units/labels.

Scoring (optional): z-scores by theme (wellbeing, income, work–life, safety, education, employment, housing, civic) with a weighted composite to create directional “best vs worst” lists.

Visualization: Plotly Studio using description-based prompts; consistent color logic, tooltips (Country, Year, Measure, Unit), and a narrative layout (Map → Relationships → Trade-offs → Culture → Trends → Inequality).

Challenges I ran into

Missing values & mixed years across indicators; solved with a “latest available” rule and visible year labels.

Metric comparability (different units/scales); solved via z-scores and reversing negatives.

Naming drift in measures; handled with regex mapping into clear domains.

Keeping it explainable while compact; solved with concise annotations and OECD benchmark lines.

Accomplishments that I'm proud of

A coherent story across six charts that executives can grasp in minutes.

Cross-filtering that makes exploration natural and reveals outliers quickly.

Turning multi-dimensional social indicators into decision hooks (hiring, site selection, benefits policy).

A clean visual identity (dark/light variants, world-map motif, subtle arrow path) that feels presentation-ready.

What I learned

Context beats single metrics: relationships (income ↔ longevity, hours ↔ satisfaction) drive better decisions.

Narrative order matters: arranging views from macro → micro improves comprehension and retention.

Small UX details—consistent units, reversed negatives, clear tooltips—build trust.

What’s next for Where People Thrive: OECD Wellbeing Dashboard

Add cost-of-living, taxation, visa openness, internet speed, childcare & mental-health access to form a fuller Talent Attractiveness Index.

Provide weight sliders so leaders can re-rank countries by their priorities (e.g., pay 40%, work–life 30%).

Generate country one-pagers (PDF) and an API export.

Explore forecasting & scenarios (e.g., “What if long hours drop by 10%?”) to quantify policy and HR impacts.

Built With

  • chatgpt
  • duckdb
  • googlecolab
  • plotly
Share this project:

Updates