Tableau visualisation showing activity types across six strategic pillars

The challenge

The UN Country Team needed fragmented initiative information structured consistently and communicated clearly for strategic consultation and leadership decision-making.

My role

I owned requirements translation, data preparation, dashboard development, and the leadership narrative. A colleague led most of the data collection, and we co-developed the alignment and comparison logic.

From fragmented data to leadership insight

  1. Coordinate

    Clarify leadership information needs and collaborate with colleagues around the initiative data.

  2. Prepare

    Remove duplicates, standardise labels, and restructure columns in the Excel master dataset.

  3. Align

    Co-develop a consistent comparison structure for mapping initiative descriptions, tags, and organisations against national-priority categories.

  4. Visualise

    Build the Tableau dashboard and translate the structured data into accessible alignment views.

  5. Communicate

    Develop a concise data story and present the resulting insights directly to the UN Resident Coordinator.

Tools & Methods

Tools and technology

  • Microsoft Excel
  • Tableau
  • Generative AI

Methods

  • Requirements gathering
  • Data cleaning and standardisation
  • AI-assisted classification
  • Collaborative analysis
  • Dashboard development
  • Data storytelling
  • Executive presentation

AI as augmentation

Generative AI supported roadmap planning, suggested candidate patterns between initiative records and national-priority categories, and assisted with occasional Tableau learning and troubleshooting. Final alignment decisions remained human-led; the comparison logic was co-developed with a colleague.

Deliverables

A cleaned Excel dataset, an initiative-to-priority alignment structure, a Tableau dashboard, and a concise leadership data-storytelling presentation.

Outcome

The project created a more centralised and visual way to understand UN Country Team contributions and their alignment with Viet Nam’s national priorities. It supported strategic UN–Government consultation and enabled leadership-ready reporting, including a presentation to the UN Resident Coordinator.

Continue reading

TARA: English reading from classroom need to pilot

View next project