Wait times for query results have reduced from 10 minutes to seconds
Data mart refresh times have dropped from 6 hours to 6 minutes
ATLANTA, USA – February 8, 2022 – Exasol, the high-performance Loading...analytics database, today announced 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.
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.” You can find out more about how Exasol is helping deliver actionable insights to Piedmont Healthcare’s leadership and creating better outcomes for over two million patients here.
Exasol was founded in 2000 with the vision to transform how organizations use data. Today, Exasol’s analytics database – the fastest in the world – is trusted by the world’s most ambitious organizations. With offices in several locations across the US and Europe, Exasol is committed to delivering flexible, scalable and powerful analytics solutions to customers wherever they are, in the cloud – public or private – or on-premises.
Exasol – accelerating insights from the world’s data.
Learn more at: www.exasol.com and follow us on social media: LinkedIn and Twitter
About Piedmont Healthcare
Piedmont Healthcare empowers communities to connect with safe and high-quality care, conveniently, every step of the way. Our promise is to make a positive difference in every life we touch and today we are creating a destination known for the best clinicians and a safe one-of-a-kind experience that always puts patients first. Founded in 1905, we are a private, not-for-profit organization with almost 28,000 employees caring for 2.7 million patients across 800 locations and serving communities that comprise 80 percent of Georgia’s population. Piedmont provides safe, convenient and high-quality care across 16 hospitals, 37 Piedmont Urgent Care centers, 25 QuickCare locations, 1,875 Piedmont Clinic physician practices and more than 2,700 Piedmont Clinic members. In 2019, Forbes listed us as one of the Top10 Employers in Georgia, Piedmont became Great Place to Work-Certified™, which was repeated in 2020. In FY 2020, Piedmont provided $466.3 million in uncompensated care and community benefit programming to the communities we serve. For more information, visit piedmont.org.