The SDG Progress Dashboard is the Government of Tripura’s public portal for tracking state data against the 17 UN Sustainable Development Goals. Published by the Directorate of Economics & Statistics in Agartala, it brings together indicator data reported by state government departments and presents it goal by goal and district by district. Meta Mint designed and built the dashboard as a working data application rather than an information website.
The challenge
Statistics on the Sustainable Development Goals come from many separate departments, each responsible for its own indicators. A state dashboard therefore serves two quite different audiences. Department officers need a controlled way to submit figures and have them checked before anything is made public. Planners, researchers, journalists and citizens need to find a single indicator quickly, see how it has moved from year to year, and compare one district with another.
The data also has to be reusable. Anyone analysing it will want to download the underlying tables or pull them into their own tools, and every published figure should sit within the UN goal and target structure, so readers can relate state data to national SDG reporting.
Our solution
The dashboard Meta Mint built offers three ways into the data — by goal, by indicator and by district — backed by a department-side workflow and an open data service.
- Goal pages. Each of the 17 goals has a page with the UN goal statement, the SDG targets it covers and a table of indicators showing unit, latest value and reporting year.
- District profiles. Every one of Tripura’s eight districts has a profile with a year-wise trend chart, a breakdown of indicators by score band, a goal-wise bar graph and an indicator-by-indicator table of normalised scores.
- Data completeness matrix. The Analytics page shows, goal by goal, how many indicators have verified data, colour-coded against stated thresholds.
- Department login with verification. Departments sign in to submit data, which passes through a maker-checker review before publication.
- Open data and API. Visitors can download the indicator summary and verified observations as Excel files and an annual progress report as a PDF, while a documented REST API serves goals, indicators and summary counts, with token-based access to observations.
How we delivered it
Page addresses mirror the data model: goals live at paths such as /goals/SDG-03 and districts are keyed by district code, as in /districts/TRP-WTR, so any goal or district can be linked to directly. The portal is served over HTTPS, the open data is published under India’s NDSAP licence, and the API documentation states separate rate limits for public and authenticated requests.
