HDX Team 1 - Connected Dream Village

HDX Team 1 - Connected Dream Village

Identification

Background

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

Logical framework Matrix

Logical Framework Approach is a good analytical tool in the assessment, follow-up and evaluation of a project using a logical approach. The logical approach in this case is to build a hierarchy of logical frameworks that are oriented towards project goals to help clarify project or program objectives, identify causative relationships between inputs, processes or activities, outputs, outcomes and impacts. In table below showing the logical framework matrix of this project.

Timeline

Timeline is a written document that contains information about the plan of work or project implementation schedule, when each stage of work must begin and be completed and it also contains information about the stages of work sequentially. The timeline is an important document that guides the team’s work steps so that the project can be managed and monitored properly. In this project, we divide the work plan into 3 major stages, namely: identification stage, problem and objective analysis stage, and lastly project outcomes and output stage. The details of this project plan and timeline can be seen in the table below.

Resources

As an effort to overcome the problems that occur in this project and meet the program targets, there are resources needed, namely:

1. Human resources. Human resources involved in the success of this project must have adequate competencies such as qualified data collector, data verifier and data operator, qualified planner (Bappeda as the owner of this project) and qualified programmer and developer.
2. Logistic. Intended logistic means village funs that allocated to employ qualified data operator.
3. Skill. In order to have a competent human resource requires qualified skills. Through capacity building program for data collector, data verifier and data operator, it is expected to produce skillful human resources.
4. Knowledge. Knowledge that is important to understand in this project is to build awareness of the importance of the success of this project for improving the village quality of life.
5. Tool. The tools needed to support the success of this project are regulations and implementation of reward and punishment system

Project Implementation and Testing

• Beneficiaries data bridging through feeder application

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

Designing Architecture as below:

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 Application

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.

File:FeederApp.png

Data page on Prodeskel application

File:FeederApp2.png

Data feeder application and Prodeskel have been synchronized

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