DELIVERING VALUE TO THE BUSINESS FASTER WITH DATA WAREHOUSE AUTOMATION
Kristen Byers, Director, Clinical Software Development, MEDASSETS, INC.
John Stassi, Senior Director, Software Development, MEDASSETS, INC.
Healthcare analytics projects are often derailed because building the integrated data sets that serve the analytics, (i.e.. the data warehouse, or other semantic layer data) often takes too long. And once built, the data-side implementation is too hard to change. MedAssets faced the challenge of blending source data from more than 10 transaction systems into a single analytics platform for customer access and clinical research after a series of acquisitions. The data represented clinical activity and supply acquisition for hundreds of acute hospitals and thousands of providers in other settings. In building the data warehouse, MedAssets faced many challenges including receiving the same clinical encounter from multiple sources and source systems that were changing to meet requirements for the new larger organization. MedAssets will detail how they used an agile development methodology and an automated approach to guide data warehouse construction while facing very aggressive timelines.