Sign up to receive our monthly newsletter, and get the latest insights, tips, advice, and all the resources you need to unleash the power of your data.
We’re here to be a resource for you. Whether that’s behind the screens during a virtual webinar or in person at workshops, trade shows, and user groups, we love to equip you with analytics best practices and BI expert insight.
To thrive with your data, your people, processes, and technology must all be data-focused. This may sound daunting, but we can help you get there. Sign up to meet with one of our analytics experts who will review your data struggles and help map out steps to achieve data-driven decision making.
+1 312 878 6600 Mon-Fri 8:30am-5:30pm CT
Thanks for your inquiry! Someone will be in touch shortly.
AAOS’s mission is to improve orthopaedic care through the collection, analysis, and reporting of actionable data. We seek to be the National Registry for orthopaedics through comprehensive data and technology resulting in optimal patient outcomes.
With their significant member growth over the past five years, the Registry recognized the need to improve the accessibility and quality of their data. They found it challenging to handle the added procedures from new hospital network or ambulatory surgery center participants. Data were being uploaded via Excel on a nightly basis, and the IT staff was burdened with performing data validation which oftentimes took up to one week to complete. These manual data processes were slowing the progress of the Registry, and some reporting was inaccurate, prompting inquiries from participants about data accuracy.
The IT Department at AAOS was tasked with building a universal solution that could support the growing number of procedures and assessments that needed to be logged into the Registry.
AAOS engaged Analytics8 to build an Operational Data Store to expedite the data collection process. We first migrated all Registry data from various sources, including SQL servers, mySQL databases, Excel files, and industry-specific tools. We then developed a solution that automates the processing, auditing, and storage of incoming data from two major file sources: Procedure and Assessment. The new solution handles peak days where AAOS receives up to 40+ files containing 10,000+ records! This data store feeds the portal solution that is used by AAOS’s internal team and all Registry members.
We then automated the manual process of checking files for correct field formatting and then sorting them into proper folders for processing. We developed internal reports with clear messages that indicate all errors associated with a record to help quickly identify and fix rejected records. And, the AAOS IT staff can now access in-depth detail reports for all jobs run, which include run times and number of records processed/updated/rejected.
Besides relieving an overburdened IT staff, the new data automation capabilities allows AAOS to focus its efforts on expanding the Registry and attracting more users.
For the IT staff, automated data prep and staging has vastly improved their efficiency
The Registry itself has become more beneficial to its members because it contains more patient and procedural information, giving medical providers enhanced benchmarking data to measure their own performance and identify areas for improvement. Additionally, administratively, it’s easier for medical providers to review and validate the data they upload which creates a more reliable Registry.
Overall, there are now over 1,000 participating institutions in the Registry, which is a 13% year-over-year increase over 2016 and a 58% increase over 2015. With this increased participation, AAOS is achieving their mission to improve orthopaedic care through the collection, analysis, and reporting of actionable data.
Sign up to meet with one of our analytics experts who will review your data struggles and help map out steps to achieve data-driven decision making.