9,500 facilities updated, 100 duplicates removed

Overview

The client needed to maintain and improve a database covering schools throughout Australia. The project focused on updating facility information, improving data accuracy and completeness, resolving errors, and removing duplicate records.

We systematically reviewed, collected, and verified database information while addressing discrepancies and system-related issues. The result was a cleaner and more reliable dataset with more complete and up-to-date facility records.

The challenge

Incomplete and inaccurate data — missing or outdated information reduced the reliability and usefulness of the existing database.
Duplicate records — repeated entries created inconsistencies and made the database harder to manage and analyze.
Unresolved errors — discrepancies and system-related issues affected the accuracy and usability of the data.

What we did

1 Reviewed the database — examined existing facility records to identify incomplete, inaccurate, and inconsistent information.
2 Collected and verified data — gathered missing information and cross-checked records to improve accuracy and completeness.
3 Resolved data issues — investigated discrepancies and addressed errors affecting the reliability of the database.
4 Removed duplicate records — identified and eliminated duplicate entries to keep the database clean and consistent.

Results

9,500 facilities updated — improving the accuracy and completeness of the client’s school database.
100 duplicate records identified and removed — reducing inconsistencies and improving database hygiene.
20 system bug reports sent — flagging technical issues affecting database quality and functionality.

Our methodology

How we maintain reliable database data

Reliable databases require an ongoing process of review, verification, and error resolution — not just one-time data collection.

Rigorous data review

Existing records were systematically examined to identify missing information, inaccuracies, discrepancies, and duplicates.

Data collection & verification

Relevant information was collected and verified to improve the accuracy and completeness of facility records.

Error resolution

Identified discrepancies and data issues were investigated and addressed to maintain reliable records.

Continuous database maintenance

Updated and verified information was incorporated into the database to keep the dataset accurate, complete, and usable.

Always responded promptly. Asked for direction when unsure of how to proceed and followed our instructions. Excellent English correspondence!

— Bill Minnis, Publishing Consultant & Founder of Education Today