Piedmont Healthcare sees 1000x analytics performance improvement

Exasol says that long-term customer Piedmont Healthcare has seen outstanding performance gains since migrating off its SQL Server-based systems in 2017. Moving from SQL to Exasol has brought up-to a 1000x boost in analytics performance and allowed the company to expand its Tableau Server active users per core to over 3x what is normally possible. Wait times for complex query results have reduced from 10 minutes to seconds, while data mart refresh times for some large self-service sources have dropped from 6 hours to 6 minutes while at the same time removing date limit constraints.

  • Wednesday, 9th February 2022 Posted 4 years ago in by Phil Alsop

Piedmont Healthcare’s old analytics platform, based on a Microsoft SQL Server data warehouse, was not keeping up with growth. In order for Piedmont Healthcare to continue delivering the excellent care the group is known for to its more than two million patients across 16 hospitals with more planned for 2022, faster access to accurate data was needed.

 

“With Exasol I don’t have to anticipate all the ways a user might want to query the database,” said Mark Jackson, Executive Director of Business Intelligence at Piedmont Healthcare.

 

Today, Piedmont Healthcare has around 1.8 trillion data points in Exasol production tables and 15TB of clinical, operational and financial data stored on its Electronic Healthcare Record system and other information streams. With Exasol, the BI team has been able to develop a faster, more reliable data layer feeding Tableau. This allows the team to ask more queries, test more assumptions, automate more reports, and deliver results to those that need them much sooner.

 

“We built a comprehensive metric framework with anomaly detection, full record level detail and logic transparency on top of Exasol at a pace of about 20 new metrics per month,” said Mark Jackson. “That is one thing that would have never been possible with our previous technology.” 

An examination of how Atlassian’s Rovo and Teamwork Graph introduce AI-driven automation into...
Discover how Gamma Communications fosters relationships and supports charity at its annual Padel...
Belden expands its portfolio with new products and enhancements to strengthen IT/OT networks,...
Exploring the challenges faced by IT leaders in deploying AI, with emphasis on the essential role...
Bull and Hon Hai Technology Group (Foxconn) have announced a collaboration focused on the...
The new Vector Core Compute (VC2) platform combines technologies from SambaNova, Intel and NVIDIA...
VAST Data and Megaport collaborate to streamline AI workloads across hybrid and multicloud...
The DCA and the Carbon Trust are partnering to drive sustainable growth and transition to Net Zero...