Methodology
Data Gathering
Data from numerous sources is placed in a common database. These include;
- Surveyor General cadastre for the Council�s particular area.
- Deeds Register data is matched to each property.
- Municipal Assessment Rates data is matched to the above using any common field.
- Municipal GIS (if available) is matched to the above using any common field.
- Municipal billing data for each Utility
- Other municipal databases that have a common key match.
Data Matching
The above data is matched to achieve a single, accurate database.
- Mismatched data is identified, examined and corrected
- Geographic locations
- Language (i.e. school vs. skool)
- Typos
- Data that cannot be reconciled is listed for further examination
- A gap analysis lists all data missing from the various fields
Data cleansing
- Missing and mismatched data is compared to additional databases.
- Additional missing data is sourced.
Data analysis
Various analytical techniques are used to uncover anomalies for further investigation.
- Municipal Rates on Erfs
- Utility Basic charges per utility
- Utility Tariff inconsistency
- Utility Consumption inconsistency
- Plus numerous other techniques
Verification of findings
- Telephone & Email
- Meter readers
- Installation staff
- Physical inspection
Action to correct anomalies proved
- Notice to Valuation Department stating findings
- Notice to relevant Utility Department stating findings
- Notice to Billing Department stating findings
- Notice to Municipal manager
- Notice to Project Director
Final Handover and debtors collection
- Conversion of all data to Municipal required electronic format
- Deliver data to required Departments
- Assist with transfer of data to the universal Municipal database chosen by Council, as required.
- Assist with the collection of new, improved and arrear revenue collected.
