An Open Data Platform for Vital Strategies - a global public health organization

Key facts

Brief summary of the project

The project offers a compelling case for how open data portals can provide easy access to data-driven insights, helping organizations to advance public health policies and practices worldwide.

Problem

Vital Strategies had a challenge to solve - how to provide easy access to complex public health data that is often difficult to navigate and visualize. The lack of accessibility to large quantities of public health data is a significant challenge, leading to more time spent searching for data than analyzing it. This hinders the efforts of organizations like Vital Strategies, which require data-driven insights to advance public health policies and practices.

Need

Vital Strategies wanted to provide an easy-to-use platform that could offer users high-quality, visually-appealing data-driven insights. With the goal of improving data accessibility and reducing the time spent searching for information, Vital Strategies sought a solution that could not only meet their requirements but also be scalable and easily customizable.

Solution

The custom open data portal developed by Datopian provides an easy-to-use solution for accessing and visualizing complex public health data. By customizing the default CKAN UI, we created visually-rich dashboards and easy-to-use Query Tools with multiple forms of visualizations. Popular libraries like Plotly, Leaflet, and DataTables were used to create interactive and customizable data visualizations. With a clean and organized interface, the portal makes sharing public health data visually easy and enjoyable for both admins and public users.

Main technologies & tools used

Context

See in HackMD.

Vital Strategies is an international nonprofit that assists governments by designing easily scalable solutions to address the many challenges found in—and around—public health. These public health systems can cover a wide range of areas related to health. From food safety regulations, to handling the data that leads to creating those regulations and policies. Their main mission is to:

They work with governments all over the world, with offices in:

• New York, United States
• Addis Ababa, Ethiopia
• Paris, France
• Jinan, China
• São Paulo, Brazil
• New Delhi, India
• Singapore

The situation

See in HackMD

The purpose of this project was to build a portal with the tools to help users easily access and visualize public health data. A common problem with large quantities of data is often a lack of accessibility. This project was born out of the need to improve that, and to allow the public, researchers, and government officials to focus more on their own work and goals (and less time on searching for—and visualizing—data).

The criteria

See in HackMD

The criteria for this project were clear, minimal, and focused. The two main requirements were:

• compelling, visually-rich dashboards presenting data-driven insights on broad topics
• easy-to-navigate Query Tools to quickly answer questions with data, using multiple forms of visualizations

The solution

See in HackMD

To improve navigation and improve accessibility, customizations were implemented to override the default CKAN UI. The home page is now minimal and focused for both admins and public users, only displaying the groups found on the portal:

CKAN groups are used to organize Query Tools. Navigating to a group will result in the list of relevant Tools:

Finally, once a Tool is selected, its visualization dashboard is shown:

To handle the creation of visualizations and their dashboards, a few different (JS) libraries were used. In very early versions, D3 was used for rendering bar, line, and pie charts, but Plotly proved to fit the demands of the project much better. For maps, Leaflet was used, and DataTables handles tables.

There are a wide range of chart types. Admins can choose from bar, horizontal bar, stacked bar, stacked horizontal bar, line, area, scatter, spline, donut, and pie. As previously mentioned, maps and tables are also available. For each of these visualizations, multiple customization options were implemented in the UI.

On top of all of that, the project continues to evolve and improve, always striving to make the experience better for data consumers.

The outcome

See in HackMD

The current iteration of this project makes it easy to share public health data visually. It offers a comprehensive list of options to clearly highlight the most important aspects of data. With clean and organized visualization dashboards, the experience as a public user is just as pleasurable as that of an admin.

What’s next?

See in HackMD

For now, there’s no end in sight. Organizations continue to discover and choose this project. With a growing user base, there is no shortage of new features and improvements. The experience is consistently decreasing the time spent on achieving goals for both the admins creating the visualizations and the public users consuming them.