Implementing a Statistical Data Warehouse The Case for

Implementing a Statistical Data Warehouse: The Case for a Strong Partnership OECD: Lars Thygesen, Douglas Paterson IMF: Cathy Wright, Patrick Hinderdael Meeting on the Management of Statistical Information Systems (MSIS), Geneva, May 8 -10, 2007

OECD Data Warehouse • • • OECD. Stat established 2004 Access to OLIS (government) 2005 Access via Internet 2006 New dissemination policy 2007 -08 Already shared components with other organisations

The Business Perspective • Same business: production and dissemination of economic data • Much of our data overlap • Both organizations support data sharing via SDMX • Similar organisational structures • Why not combine forces to jointly develop a data warehouse ?

The Business Perspective Better service to data users More cost-effective data work Improved management of data processes Improved provider relations Improved data and metadata management Better documentation, storage, access control, archiving of datasets Improved data quality Better structured career opportunity Enhanced analytical capacity—”all about” analysis

The Technology Perspective • Similar development/integration platform and almost identical runtime environments (MS Windows server and clients, MS SQL Server, MS. NET Framework, MS Office suite) • Collaboration tools (MS Sharepoint and Team Foundation Server) • Align code base, functional requirements, development resources, deployment schedules

OECD Statistical Information System (SIS) Architecture Production Storage Dissemination OECD. Stat Data Production (incl. Stat. Works) Corporate Data Warehouse Online access Web Browser Books Meta. Store Statistical Metadata XML CDs etc.

IMF Information Map Internal User Email Information Portals News Contact List Public Business Partners IMF. ORG Publications Info Diss. Info Exchange Extranets Data Collection Workflows Information Resource Catalog Intranet Directory of Experts Information Standards and Guidelines Economic Data Warehouse Financial and Administrative Data Warehouse Document/Web Repositories IMF-Wide Metadata Standards WEO Data Desk Data STA Data Commercial Data & Documents Other Dept Data Document Stores Dept Docs and Files Multimedia DB FACTS Prod DB i. FIN Prod DB TAIMS Prod Db HR Prod DB Other

IMF Statistical Information Management Environment Data Collection Data Management Statistics EDF National Sources Area Depts ICS (Excel/SDMXML) DMX Excel Aremos External Data Research Aremos OECD Global Insight Haver Analytical Bloomberg Economic Data Warehouse IMF. Stat Data Dissemination EDSS IFS WEO REOs External Data IMF. ORG Statistics Portal Online Databases Data Analysis Publications … Econometric Tools CD ROM Metadata (Meta. Store, DSBB) Supporting Capital and Administrative Projects IT 10117. Net Migration(ICS) IT 10021 ICS IT 10056 SDMX IT 10146 WEO Production Redesign IT 10060 Metadata Exchange IT 10117. Net migration (EDF) #000019 EDF Enhancements #00031 Balance Sheet Approach IT 10112 Financial Soundness Indicators IT 10052 EDF Production IT 10137 Metadata Repository IT 10130 EDW #000030 Economic Data Dissem #000041 Economist Models Suite IT 9009 EDSS IT 9320 Econometric Software IT 10145 High End Computing

Memorandum of Understanding • • Responsibilities and rights Sharing of further developments Pooling of technical resources Similar to Open Source – Open to other partners

Delivering the Data Warehouse Technology – Just one piece of the puzzle Governance Management Mandate INFORMATION MANAGEMENT Work Practices & Training Technology Work Practices

The Outcome to Date • In-depth OECD and IMF collaboration since Dec 2006 – OECD staff at IMF in February • Adoption of IMF. Stat: World and Regional Economic Outlooks, International Financial Statistics databases will go live May 2007 • MOU to be signed shortly • Weekly conference calls • Initiating discussion of plans for joint development of enhancements