Data Restructuring for the Administration for Community Living

New Editions provided data design and governance, program evaluation, and analytical support to the Office of Performance and Evaluation (OPE) in the Administration for Community Living (ACL). ACL's mission is to maximize the independence, well-being and health of older adults, people with disabilities across the lifespan and their families and caregivers. OPE coordinates a range of data collection and analysis activities and disseminates data through a variety of modalities, including the AGing, Independence, and Disability (AGID) Program Data Portal.

Under the ACL Data Restructuring I (2018-2019) and ACL Data Restructuring II (2019-2021) projects, New Editions partnered with ACL to: 

  • Assess the ACL and Census datasets hosted on the AGID Program Data Portal;
  • Engage stakeholders inside and outside of ACL to compile information about AGID user needs;
  • Identify practical, efficient, and statistically sound approaches for linking those datasets, to permit analysis of ACL data across years, and across datasets/programs;
  • Develop and test a restructured relational database linking those datasets;
  • Create an operational approach that will allow for linking additional datasets in the future;
  • Develop the foundational requirements for the next iteration of the AGID system (AGID 2.0).

New Editions’ team of data analysts, system designers, and data scientists produced deliverables to inform and facilitate development of a revised data portal for ACL, including:

  • Dataset-level and variable-level documentation;
  • SQL Server database for testing and demonstrating data linkages;
  • Aligning measures document defining valid linkages between datasets and offering recommendations for improving linkages;
  • Foundational requirements for AGID 2.0, including business requirements, user stories, process flows, and proofs of concepts for the new system.
Focus or Topic