130 likes | 141 Views
Learn how to establish a new validation routine to ensure optimal data accuracy across statistical domains. Gain insights on international production, complex validation processes, and monitoring performance.
E N D
Re-thinking Data ValidationAnette Morgils Hertz – ahz@dst.dkKatja Overgaard – kao@dst.dkStatistics Denmark
Motivation • Look at data across statistical domains • Special knowledge on international production of large multinationals necessary • Complex and time consuming
Motivation • Given the same resources available – how to establish this new validation routine? • Rearranging our validation routines • Always focus on the errors that matter the most (Key account system) • Monitoring the performance of the validation routines, to ensure they perform optimally (monitoring report)
Agenda • About us • SKV and Validation team • Validation Routines then and now • Monitoring the Validation Routines • Key Account System • Conclusion
About us • What is International Trade in Goods (ITGS)? • Import/Export of goods • Around 9000 commodity codes and 250 country codes • Published monthly • What is International Trade in Services (ITSS)? • Import/Export of services • Around 70 service codes and 250 country codes • Published aggregated monthly and detailed quarterly • What is Balance of Payments • Use data from different sources incl. ITGS and ITSS
SKV and Validation Team • SKV team • SKV Company critical to ourstatistics • Team dedicated to validate the reported data from these companies • Validation team • Responsible for all other validation and communication with the companies
Validation Routines then and now • Old system: 59 different valdation routines • Now: Some validation routines are closed, others rearranged
Key Account System One person = One company
Key Account System Changing weights
Monitoring Validation Routines • Monitoring report • Measuring the quality of a validation routine:
Monitoring Validation Routines • Graphs for comparison • Absolute errors
Conclusion • To spend our resources optimally we must monitor every validation routine • A change of focus is necessary • Start with the potential errors with the biggest impact
Thank you! Anette Morgils Hertz, email: ahz@dst.dk Katja Overgaard, email: kao@dst.dk