HDX Team 1 - Connected Dream Village

HDX Team 1 - Connected Dream Village

Background

Location

In West Java Province, Located 211 km from Jakarta, Population 1,2M Poverty 9.07% (2019), 10,26% (2020).

Loading map...

{"minzoom":false,"maxzoom":false,"mappingservice":"leaflet","width":"600px","height":"300px","centre":false,"title":"","label":"","icon":"","lines":[],"polygons":[],"circles":[{"text":"","title":"","link":"","strokeColor":"#FF0000","strokeOpacity":"1","strokeWeight":"2","fillColor":"#FF0000","fillOpacity":"0.5","centre":{"lon":107.98177315919,"lat":-6.80987135},"radius":500},{"text":"\u003Cb\u003E\u003Cdiv class=\"mw-parser-output\"\u003E\u003Cp\u003ESumedang Regency\n\u003C/p\u003E\u003C/div\u003E\u003C/b\u003E\u003Cdiv class=\"mw-parser-output\"\u003E\u003Cp\u003EConnected Dream Village\n\u003C/p\u003E\u003C/div\u003E","title":"Sumedang Regency\n","link":"","strokeColor":"green","strokeOpacity":"0.7","strokeWeight":"10","fillColor":"blue","fillOpacity":"0.5","centre":{"lon":107.98177315919,"lat":-6.80987135},"radius":100}],"rectangles":[],"copycoords":false,"static":false,"zoom":9,"defzoom":14,"layers":["OpenStreetMap"],"image layers":[],"overlays":[],"resizable":false,"fullscreen":false,"scrollwheelzoom":true,"cluster":false,"clustermaxzoom":20,"clusterzoomonclick":true,"clustermaxradius":80,"clusterspiderfy":true,"geojson":"","clicktarget":"","imageLayers":[],"locations":[],"imageoverlays":null}

Project Outcome and Output

Project Implementation and Testing

• Develop enterprise service bus (ESB) for data interchange using feeder application

Designing Architecture

Enterprise Service Bus

Enterprise Service Bus (ESB) is a centralized software component that integrates various applications and systems. ESB performs data transformation, message routing between applications, and translates various communication protocols owned by each system. ESB can be implemented using WSO2, an open-source software available in the market.

Feeder App

Feeder App is an application built to bridge data collection from each village application. The data taken from each village application will be sent to the Enterprise Service Bus.

Extract, Transform, and Load (ETL)

The data collected on the Enterprise Service Bus will be standardized and stored with an ETL process. In this process each data will be uniformed, cleaned, and improved data quality. This ETL process can be implemented using Pentaho, an open-source software available in the market.

Data Repository

Any data that has been standardized, whether in the form of relational data, time-series, or documents will be saved to a Data Repository. This Data Repository can be a Data Warehouse, which can be deployed using PostgreSQL or it can also be a Data Lake, which can be deployed in HDFS with Apache Hive.

Dashboard For Decision Maker

Structured data stored in the Data Repository can be displayed in a decision-making dashboard. This dashboard can be built based on the district, budget, or main function. This dashboard can be implemented with Metabase, an open-source software available in the market.

Mockup System

• Feeder app mock up
• Capacity building program & LMS mock up

• Create program of data supplier capacity building

Appendixes

Team Members

1. Aris Winarna
2. Anang Latif
3. Anastasya Yolanda
4. Danny Januar Ismawan
5. Florence Francis
6. I Gusti Ayu Laxmy Saraswaty
7. I Kadek Agus Arya Wibawa
8. Ketut Agus Indra Diatmika
9. Nasir Ahmad
10. Tri Haryanto