Data Management Division, ICTMS
UBID TWG
technologies, applications and practices for the collection, integration, analysis, and presentation of business information. The purpose of Business Intelligence is to support better business decision making
DSWD became part of the Task Force on Big Data for Official Statistics
2016
to generate high quality data with strong spatial dimension and sectoral and socioeconomic disaggregation required in monitoring national development plans as well as the Agenda 2030 on Sustainable Development
AmBisyon Natin 2040
However, in order to make the best out of these technologies, it is important to establish fundamentals for the environment of the data (i.e. data governance, architecture, standards, and management).
Thus, it is important to continue improving our capacity to collect, manage, and secure our data.
But how reliable and accurate are our data?
4 Anchors of Trust on Data and Analytics
Increased productivity between National Project Management Offices (NPMOs), Offices, Bureaus, Services, and Units (OBSUs), and other stakeholders who use beneficiary data in the delivery of their services
Reduced human error when dealing with beneficiary identification and managing information about project and program beneficiaries
Easier identification on whether a client is, or is still, qualified to benefit from one or more DSWD programs
Improved communication from UBID stakeholders
Improved business intelligence on DSWD beneficiary data
Better decision-making on how to improve our services
Meeting with Listahanan and Pantawid
Data Cleansing (Pantawid, NHTO)
Technical Meeting
Sept. 24- Oct. 8
Meeting with UCT, Kalahi, and SLP
Technical Meeting
Sept. 25 - Oct. 18
Data Cleansing (UCT)
Data Cleansing (SLP)
Sept. 25 - Oct. 22
Oct. 28- Nov. 18
Data Cleansing (PMB)
Technical Meetings
Deduplication and Merging
Sharing of Clean Data to ICTMS
Spatial Integration
New Field for UBID on Individual Databases
Dashboard Creation and Continuous Update
CRFs
Format
lat, long
(format) memo, advanced copy
ICTMS
Variable | Definition |
---|---|
LastNameSR | Last name of the individual to be matched |
FirstNameSR | First name of the individual to be matched |
MiddleNameSR | Middle name of the individual to be matched |
FMiddleNameSR | First letter of the middle name of the individual to be matched |
LastNameLR | Last Name of the Listahanan 2* individual |
FirstNameLR | First name of the Listahanan 2* individual |
MiddleNameLR | Middle name of the Listahanan 2* individual |
FMiddleNameLR | First letter of the middle name of the Listahanan 2* individual |
Compute FinalMatchPercentage =
45% * AVERAGE(FirstNameMatchPercentageJW, FirstNameMatchPercentageL) + 53% * AVERAGE(LastNameMatchPercentageJW, LastNameMatchPercentageL) + 1% * MiddleNameMatchPercentageJW + 1% * IsMiddleNameEqual
Variable | Definition |
---|---|
MetaLastNameSR | Result of Metaphone Algorithm on the last name of the individual to be matched |
MetaFirstNameSR | Result of Metaphone Algorithm on the first name of the individual to be matched |
MetaLastNameLR | Result of Metaphone Algorithm on the last name of the Listahanan 2* individual |
MetaFirstNameLR | Result of Metaphone Algorithm on the first name of the Listahanan 2* individual |
Compute FinalMatchPercentage =
45% * AVERAGE(FirstNameMatchPercentageJW, FirstNameMatchPercentageL, FirstHNameMatchPercentageJW) + 53% * AVERAGE(LastNameMatchPercentageJW, LastNameMatchPercentageL, LastHNameMatchPercentageJW) + 1% * MiddleNameMatchPercentageJW + 1% * IsMiddleNameEqual
If FinalMatchPercentage = 100% = DIRECT MATCH
If FinalMatchPercentage = 90-99% = POSSIBLE MATCH
ELSE (<90%), NOT MATCH; UNIQUE