Using Administrative Data to Improve data quality in the ABS Business Register 30 September 2019 ABS Business Register evolution 1970s ABS BR established use of ATO tax data to update ABS BR ID: 1032113
Download Presentation The PPT/PDF document "Expert Group of Business Register" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
1. Expert Group of Business RegisterUsing Administrative Data to Improve data quality in the ABS Business Register30 September 2019
2. ABS Business Register evolution 1970s• ABS BR established• use of ATO tax data to update ABS BR1980s• ABS / ATO joint project on use of tax data• Electronic file of Group Employers • Profiling introduced1990s2000s• 2001 Tax Reform: ABN, GST and BAS introduced • 2001 Current tax extract designed 2010s• 2017 Whole of Gov (WoG) Admin Business Registry Modernisation commences2020s• WoG approaches 1950s- Sample surveys introduced1960s• 1969 Integrated Economic CensusFuture• WOG Business Registry (admin) consolidation • Common Frame introduced
3. Relationship building 27/09/20193
4. Emerging statistical requirements Case study 1: Improving data quality in the finance sector Exercise to improve sector coding. Old method: on balance algorithm using ATO dataNew method: reviewed using new data sources to define statistical units and apply sector codes Business Income Tax (BIT) data from ATO Managed Funds data from the Australian Securities Investment Commission (ASIC) Financial entity sector information from the Australian Prudential Regulatory Authority (APRA) 27/09/20194
5. Emerging statistical requirements Case study 2: Globalisation indicators Exercise to level of foreign ownership indicator New method: used foreign shareholding from BIT company records to identify levels for Type of Activity Unit. Still need a source for partnerships and trustsStill need a source for outward investment 27/09/20195
6. Data quality issue strategies – scope, design, assemble 27/09/20196Is the data fit for purpose? ABS Case Study: Sector coding method using the new data sources - Developed over two years - Internal review Alignment of scope, coverage, conceptsABS Case Study: ABR locations data has incomplete coverage Project to supplement ABR data Work with ABR longer term ABS Case Study: ATO concepts do not align with ABS for sector, public / private, NPI, legal entity- Use ATO as starting point and use other information to apply “on balance” algorithm, plus manual review (small number of instances) Quality of CodingABS Case Study: Work with ATO to apply industry code at sourceImportance to ATOTraining, feedback, assistance
7. Data quality issue strategies – Acquire 27/09/20197Unexpected changes to administrative data ABS Case Study: Managing regular deliveriesRegular discussions, encourage early advice on change Discuss impacts with ATO to understand causeResupply file Roll back to historical classification Administrative data ceasesABS Case Study: Data items no longer available Advance warning – can advocate or plan alternative Unexpected – discuss, plan way forward, alternate datasets Business continuity plan
8. Data quality issue strategies – Compile, validate and disseminate 27/09/20198Quality targetsABS Case Study: Application of quality gates - Checks to ensure expectations have been met - includes quality measures, traffic lights and accountabilities for sign off Clearance ABS Case Study: Endorsement of Common Frame for releaseClearance report with key movements, issues or changesClearance meeting attended by key stakholders Impact analysis prior to the clearance meeting
9. Data quality issue strategies – Evaluate27/09/20199Review of ProcessesABS Case Study: Improved way to transfer ATO data to ABS- Joint review of processes and agreement to change - Implementation after testing and parallel run Review of datasets ABS Case Study: Improved ATO extract (file format and content)Joint project – senior endorsement Joint working group to design and implement file
10. Thank youFurther details: luisa.ryan@abs.gov.au27/09/201910