Transforming Complex Data into Strategic Infographics for a Leading National University
Project Owner
Directorate of Partnership and Global Relations UGM
Brand & Experience
Overview
This project involved the development of comprehensive infographics to visualize a prominent national university's partnership activities, commissioned by their Directorate of Partnership and Global Relations. The main objective was to transform complex, raw data from multiple Excel sources into clear, impactful visual stories—covering collaboration statistics, SDGs-based partnerships, funding distribution down to the faculty level, and more. The infographics were designed to support strategic communication and decision-making for both internal and external stakeholders.
Impact
Enabled the university to communicate partnership achievements and funding distribution more effectively to stakeholders.
Supported data-driven decision making by presenting complex data in an accessible, visual format.
Enhanced the institution’s ability to showcase its alignment with SDGs and global collaboration goals.
Improved transparency and accountability in partnership reporting.
Approach
Data-Driven Storytelling: Focused on extracting key insights from raw Excel data and translating them into compelling visual narratives.
Stakeholder-Centric Design: Collaborated closely with the Directorate to ensure the visuals addressed their communication needs and strategic objectives.
Iterative Visualization: Developed multiple infographic drafts, incorporating feedback to ensure clarity, accuracy, and visual appeal.
Process
Data Collection & Understanding
Received and reviewed raw partnership data in Excel format from the Directorate.
Conducted data cleaning and validation to ensure accuracy and consistency.
Insight Extraction & Structuring
Identified key metrics: number of partnerships, SDGs alignment, funding breakdown by faculty, and other relevant indicators.
Structured data to highlight trends, achievements, and areas of impact.
Infographic Design & Development
Created easy-to-read Excel summaries for internal use.
Designed visually engaging PowerPoint infographics tailored for both internal presentations and external reports.
Iterated on design based on feedback from the Directorate to ensure alignment with the institution’s branding and communication goals.
Delivery & Implementation
Delivered final infographics and supporting files for use in official reports and presentations.
Provided guidance on how to update and maintain the visuals for future reporting cycles.
See More Our Works
