TimeXtender helps US healthcare network transform utilization of staffing resources and facilities

With more than one million patients served annually, our customer is the largest healthcare provider servicing a region of over fifteen thousand square miles and a population of three million, containing eight counties with state-of-the-art technology while supporting residency training programs with more than 700 residents each year.

SUPPORTING RAPID GROWTH AND SUBSTANTIAL INSIGHTS

Several disparate clinical and business systems support these services across multiple hospitals and clinics.  In addition, high growth through mergers, acquisitions, and partnership adds further complexity to the information backbone of the organization.  This results in incomplete and inconsistent information available to manage the efficient utilization of staff and facilities.  When it was realized that the growth had exceeded the operating room capacity, they reviewed the utilization of rooms.  Gathering and compiling the data manually was a time consuming and labor-intensive process, however, they did find that operating rooms were not fully utilized.  It was a clear sign that change was needed, in order to do further analysis.

On a practical level, information was gathered from systems including Cerner Electronic Health Records (containing more than 20-years of accumulated health records), Allscripts EPSi, and Lawson ERP.  The supporting Oracle and Microsoft SQL Server databases contained most of the information, however, common practice was to extract data from reports into tools like Microsoft Excel – all of which impacted timely data analysis.

Transforming the healthcare network’s utilization of resources and facilities required one system of insights that could provide one single version of the truth for improved decision making.

 

ONE DATA ESTATE FOR MULTIPLE DISPARATE DATA SOURCES
The decision makers carefully evaluated several tools and selected TimeXtender as the best solution for transforming the healthcare network’s analytics environment to help improve operational efficiencies. Once TimeXtender was deployed it was used to access the hospital’s Cerner Electronic Health Record application data as well as financial and operational data from other major healthcare information technology vendor products.

TimeXtender enabled the IT team to cleanse, consolidate, and model this disparate data efficiently. Once the complex data is processed it is used to deploy relational models directly to the data visualization front end for business decision makers.

In addition, TimeXtender provides a solid foundation for compliance and helps keep the healthcare network’s patient data secure and in accordance with the Health Insurance Portability and Accountability Act (HIPAA).

A HEALTHY DATA ARCHITECTURE
Implementing TimeXtender empowers business decision makers and brings together people and data for improved streamlined processes, utilization across the hospitals departments, operational effectiveness and new ways to treat patients more quickly.

Now that the analytics environment is backed by TimeXtender, performance is drastically improved without having to manually write and maintain many lines of complex scripting. In addition, the development team’s ability to preview data before further processing enables faster development without overloading the production data sources.

Implementing TimeXtender has enabled a future proof data architecture and it is now positioned well for future migration to the cloud.

More Cases

Colliers International Builds a Data Warehouse Without Programming

Colliers International Builds a Data Warehouse Without Programming

Colliers International Builds a Data Warehouse Without Programming Colliers International is a publicly traded international real estate consultancy that wants to offer forward-looking advice and maximize the value of real estate for real estate owners, real estate...

Cordstrap Safeguards its Data for the Future with TimeXtender

Cordstrap Safeguards its Data for the Future with TimeXtender

Cordstrap Safeguards its Data for the Future with TimeXtender Cordstrap is the global leader in products and systems to protect cargo carried by rail, ship, truck, and air. The company operates three international production centers, has over 500 employees in 22...

The Data Heart of TimeXtender is the Beating Heart of FM Group

The Data Heart of TimeXtender is the Beating Heart of FM Group

The Data Heart of TimeXtender is the Beating Heart of FM Group The FM Group was established in 1968 and is a company in flowers, plants, and accessories. Every day, 1700 employees in 17 countries on six continents work to deliver a wide range of fresh products to over...

TimeXtender Enables Pally Biscuits to Produce Smarter

TimeXtender Enables Pally Biscuits to Produce Smarter

TimeXtender Enables Pally Biscuits to Produce Smarter Pally Biscuits makes over three billion delicious biscuits every year. The company has been around since 1868. From its factory in the Dutch town of Nieuwegein, the biscuits find their way to more than 40...

 

Ready for a demonstration?

X