1 / 4

Enhancing Data Management Efficiency through NAWWE Implementation at BEA

Learn how BEA improved data submission processes by transitioning from spreadsheets to a relational database using NAWWE. This case study explores the benefits, feedback from OECD, and future plans for streamlined data management.

selia
Download Presentation

Enhancing Data Management Efficiency through NAWWE Implementation at BEA

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. BEA Experience with NAWWE Brent R. Moulton OECD, Working Party on National Accounts Paris November 4, 2009

  2. Background • Since BEA’s first submission of SNA 93 data in 2000, the data submission has been based on spreadsheets with a gradual increase in details and metadata. • Process involved exporting data to spreadsheets—a time-consuming and often error prone process. • Before exporting to Excel, data were stored in time-series databases (Aremos and Fame).

  3. BEA implementation of NAWWE • To translate from these time-series databases to a relational database, we used NAWWE start-up files to reorganize the data. • In the process of reorganizing the data, several smaller time-series databases were consolidated. • An SQL relational database was constructed using NAWWE table codes to form the core identities. • A test submission was provided for 2000–2007. After OECD provided feedback, we resubmitted in mid-2008.

  4. Comments and plans • BEA intends to continue its participation in NAWWE with our upcoming submissions. • BEA received useful feedback from OECD. • Timely communication and participation by other statistical offices would be useful. • Transforming our time-series data into a relational database allowed BEA to identify redundancies and inconsistencies.

More Related