The Design and Implementation of Data Visualization for Integrated Referral and Service System

Integrated Referral and Service System (IRS/SLRT) propose to overcome possible fragmentation and lack of coordination of national and local social protection and anti-poverty programs. It also aims to update poverty database infrequently and the regular way by providing local government with tools to encourage better coordination of programs implementation at the local level and to make the programs more responsive and relevant to local needs.In its implementation, IRS built a comprehensive Management Information System (MIS) consisting of several modules, i.e., web-based modules, mobile application module, and dashboards. The dashboard is an essential component in IRS applications since it is one of the tools for monitoring program implementation.This paper describes the design and implementation of the IRS dashboard module that summarizes implementation data from 78 regions until the first quarter of 2018, where authors involved in the design and development of the dashboard of IRS. This paper presents a data visualization approach by utilizing business intelligence and data analytic tools, Tableau, that allows dashboard created and presented effectively with simplifying the staging and ETL process that generally needed in dashboard generation.

I. INTRODUCTION

The Government of Indonesia, under the leadership of Indonesian National Development Planning Agency (Bappenas) and the Ministry of Social Affairs, is creating a program, Integrated Referral and Service System (IRS/SLRT) with the aim of improving coordination and integration of social protection and anti-poverty initiatives at the local level. IRS proposes to address possible fragmentation and lack of coordination of national and local social protection and anti-poverty programs. It also aims to update poverty database infrequently and the regular way by providing local government with tools to encourage better coordination of programs implementation at the local level and to make the programs more responsive and relevant to local needs.