The Use of Administrative Data in Social Statistics in Denmark – Towards More Cooperation and

1. The Use of Administrative Data in Social Statistics in Denmark – Towards More Cooperation and Integration Mogens Grosen Nielsen and Ole Schnor Statistics Denmark IOAS Conference Shanghai, 14-16 October 2008

2. Benefit, management, organisation and technology • Full benefit from the use of administrative sources requires alignment of management, organisation and technology • Alignment requires appropriate decision on the degree of standardisation and integration. • Examples on integration 1) Implementation of registerstrategy in Social Statistics 2) Documentation on care of elderly people Manage- ment / goals ? Technology, data, processes, staff etc

3. Integration and standardisation • Integration is high if we share concepts and data. • Standardisation is high if we follow a shared model for the workprocesses. • High or low integration and standardisation: Depends on skills, opionions, history, culture etc. - what is appropriate • Decision at Statistics Denmark for Social Statistics: First high integration then focus on standardisation for selected processes

4. Procesmodel with focus on population-, income-, employment-, education- and welfare-statistics visions and goals Implementation

5. Visons / goals for the current iteration Improved quality and cooperation via: A) Systematic knowledge management B) Data foundation that are • Coherenct (concepts, variables, data, Data on the Internet vs. service) • Stable (shared data must be fixed) • Documented (foucus on documentation of shared data) • Flexible (easy to connect/disconnect data) • Secure (flexible and fast solution)

6. Lessons learned and perspectives for the future Lessons learned • Ensure learning and commitment both from top and bottom • Start with problems in the day-to-day production. • Use small manageable projects including extensive evaluation • Include experience and former solutions both in order to benefit from history but also to ensure commitment Perspectives for the future • Flexible, fast and easy ways to create new statistics that fulfills demands • More focus on knowledge management including documentation

7. Documentation on care of elderly people

8. Care of the elderly…the use of new technology

9. The administrative care-systems • Today 96 out of 98 municipalities are using electronic care-systems • In 2009 all municipalities will be using electronic care-systems • The systems are based on the Personal Identification Number • Detailed information on each visit of home help

10. The great idea ! • The Government wants to improve the documentation on local administration! • So why not use the data from the administrative care-systems? • Statistics Denmark are responsible for collecting, validation and publication

11. Statistics Denmark collects the data Care-systems in the municipalities

12. Statistics Denmark collects the data Transportation of standardised XML-datafiles Care-systems in the municipalities Statistics Denmark New software Validation Monthly basis from each municipaliti

13. Statistics Denmark collects the data Transportation of standardised XML-datafiles Care-systems in the municipalities Statistics Denmark New software Validation Monthly basis from each municipaliti Social Statistical database

14. Lessons learned and perspectives for the future Lessons learned • The quality of data are varying between the municipalities • It is important to agree on unambiguous data definitions between the political players Perspectives for the future • Fully integrated electronic system to collect all kinds of data from the administrative systems in the municipalities • New projects are expected to benefit from lessons learned in the project Documentation on care of elderly people

15. THANKS FOR YOUR ATTENTION