Learn how to design impactful, user-friendly Excel visual dashboards in hours.
Healthcare organizations need the power of data analytics, adaptable reporting, and visualizations now more than ever. PDS will show proven approaches that leverage your current Excel skills and pave the way to providing timely, dynamic visualizations to meet the current – and rapidly evolving – needs of today’s challenging healthcare environment. When needs are critical, and resources are constrained, see how Excel’s flexibility can be enhanced using simple design techniques to produce new cost-effective, insightful reporting. This Webcast will showcase proven Excel dashboard designs that can be implemented today to identify financial and performance improvement opportunities in hospitals and practices.
Originally presented on June 17, 2020, by Practical Data Solutions’ Scott Everitt, MBA, Vice President of Analytic Solutions and Michele Perry, Vice President of Service Delivery & Web Analytics.
Managing your revenue cycle is critical to the financial health of your organization. The goal is simple—ensure that all entitled revenue has been accurately captured, billed and collected. The revenue cycle creates massive amounts of data transactions which require appropriate staging and modeling to uncover lost revenues, understand denials and identify performance improvement opportunities. Learn how visual analytics can help identify performance gaps and focus leadership to drive and improve your organization’s financial performance.
Topics Include:
Understanding measurable revenue drivers
Concisely communicating the cost of poor performance
Visualizing opportunities and successes
Techniques to visualize data quickly
Best practices that drive actionable results
Originally presented on March 18, 2020.
About the Speakers:
Scott Everitt, MBA, has spent over 19 years in the healthcare industry, holding key leadership positions in finance, clinical operations, revenue cycle management, patient access and physician practice management. Scott has achieved significant success in his role as Vice President of Healthcare Solutions by helping clients improve operational and financial efficiency.
Kelly Constantinetis started in August of 2014 as a Senior Business Intelligence Analyst with PDS. Starting her career in hospital finance over 18 years ago, Constantinetis has since served in a variety of roles within the healthcare industry including physician practice finance, operations, application support and analytics. Constantinetis has a bachelor’s degree in Finance from Castleton University.
Managing medical practices is challenging even in the best of times. But what happens when situations outside of our control force temporary but significant changes upon us? Health systems, hospitals, and clinics need to be among the most stable of businesses no matter what the circumstances in order to best serve patients and the community’s urgent needs. The recent events of COVID-19 have illustrated the need to be adaptable in times of crisis. External changes may force us to modify how we do business for several days, in the case of extreme weather or natural disasters, to several months, in the case of the current pandemic. As leaders in these organizations – and indeed, in our communities – how can we best position ourselves to navigate through these turbulent times?
The key to being able to lay out a path forward, and to predict the obstacles that lie ahead, is leveraging analytical tools to help understand the wealth of data contained within a practice’s systems. Good strategy comes from good information and through analysis of just a few key metrics, we can forecast the road ahead and plan the most effective route. The following is a discussion of the key measures to understand when formulating your strategy.
Scheduling Statistics:
Critical events will likely cause a great deal of variability in your schedules. In many cases, no-shows and short-notice cancellations will spike as patients are unable to get to the clinic. In other cases, emergency demand for care will go up. Often, different specialties will see widely varied impacts. Understanding each provider’s availability per session, or in some cases, even by hour, is the key to setting clinic staffing ratios to maximize throughput while minimizing exposure, understanding which non-urgent appointments can be delayed to free up emergency appointment time, and maintaining that critical and comforting presence for patients who depend upon your services.
Key patient access metrics to pay attention to include:
Percentage of provider’s templated time booked and time available by hour
Provider frozen/held time by hour
Upcoming counts of scheduled appointments by visit type
Same Day cancellation rates and no-show rates
Average clinical cycle times (to minimize waiting room exposure)
Cashflow and Reserves:
No matter the impact crisis situations have on patient volumes, these events almost always place a strain on the organization’s cash position. Cash can be impacted by events preventing patients from getting to their scheduled appointments and impacting the practice’s monthly productivity. Extreme high-volume events may require immediate cash outlays for supplies and staff for services which will not be reimbursed for 30-60 days. Whether the crisis increases or decreases volume, the financial footing of the practice needs to be strong.
Key Cash metrics executives and management need to be aware of to maximize their financial position:
Fixed expenses and the volumes required to meet those levels
Variable expenses and the impact of spikes or dips in demand
Available cash and current assets in hand available to meet these needs.
Accurate AR valuation
Current cashflow trends and timelines:
Charge lag
Claim drop lag
1st Insurance payment lags
Zero balance lag
Expected Reimbursement:
It can be difficult to predict the full financial impact of these critical events, but with a strong set of analytical tools, it is possible to model what a practice can expect to be paid for any spikes in services rendered, forecast lost revenue from services canceled or delayed, and even predict the impact of anticipated denials from the payers. Moreover, good analytics will highlight if more will be required from the standpoint of patient collections from deductibles and coinsurance, higher true Self-Pay or Medicaid volumes, and overall reimbursement trends by individual payer. Being able to model this information with a high level of detail will assist the finance team in dynamic budgeting and forecasting the overall financial position of the practice once things return to normal.
Key metrics for the reimbursement team to focus on include:
Payer mix by provider
Expected reimbursement by procedure or payer
Anticipated denials common during times of crisis:
Registration denials due to the inability of patients to provide current insurance
Authorization denials
Additional information denials due to lack of documentation time by providers
Recovery rates for stated denials
Self-pay collection rates at the time of service and through the billing office
Probability of collection by balance, age, and payer
What is predictable about the business of healthcare is its unpredictability. When a significant crisis occurs, leadership cannot rely on the same monthly management dashboards and reports to drive them successfully through a rapidly changing world. Using strong analytical tools, an organization can use their data in a new way in order to plan for challenges and implement a strategic plan of action. Strong, thoughtful leadership in difficult times is what will keep an organization on solid financial footing, allow physicians and staff to provide excellent care, and inspire the confidence in your patients that you will be there for them when they need you the most.
Written by: Scott Everitt, MBA, VP of Healthcare Solutions at Practical Data Solutions
The Financial Conference is always a great opportunity to connect with healthcare professionals to share the latest in analytics and the challenges organizations are facing today. This conference always sparks great discussions on strategies to run a more profitable and efficient organization. During these great discussions, PDS was able to share how our solutions can help with financial management, payer contracting analysis, business intelligence and revenue cycle management best practices.
Learn about a data mart approach to building healthcare data warehouses to optimize data analytics and reporting without needing a long-term plan or large capital investment. Following best practice data modeling, “data mart” designs can help you build leverageable data sets to optimize reporting, blend data and correlate answers efficiently. Webinar will discuss the pitfalls of poor data modeling and the advantages of following best practice structures to build data marts that can be joined and reused to drive higher-level thinking. Results come from staging data effectively.
Webinar covers:
A best practice incremental approach to data modeling
The importance of designing data correctly
Understanding effective strategies for data modeling
Challenges and costs associated with poor data design
Delivering results through best practice data marts
Originally presented on Feb 26, 2020 by Practical Data Solutions’ Scott Everitt, PDS Vice President of Healthcare Solutions, and Sean Phipps, PDS Senior Programmer.
MicroStrategy World is always one of our favorite conferences. Michele Perry, PDS VP of Service Delivery & Web Analytics, enjoyed the opportunity to collaborate with Ronald Lettieri, Associate Director of Finance & Analytic at SUNY Stony Brook Medicine. Michele and Ron hope that by sharing how powerful organization-wide self-service analytics can be, they’ll inspire other organizations to embrace the benefits of federated analytics. Beyond their presentation, Michele, Ron, and all attending members of the PDS team greatly enjoyed learning valuable information about what’s happening at the forefront of analytics technology during their attendance.
Learn about the challenges of merging healthcare data from multiple software systems and about the need to build robust data models from the ground up so that users have full access to slice, dice, and drill to detail-based data with a few clicks.
Most organizations facing the challenge of blending data have either merged with a healthcare entity that uses a different billing system or are in the process of switching systems while concurrently reporting on the old system for a period of time.
During this webinar, you will see examples of data analytics reporting, blended data visualizations, as well as gain insight into PDS’ best practice, incremental approach, to ensure data is modeled appropriately for short-term and long-term success.
Originally presented on January 22, 2020 by Practical Data Solutions’ Russell Hendrickson, CEO, and Michele Perry, Vice President of Web Analytics.
November 12th-14th, clients joined us at Disney's Coronado Springs Resort | Orlando, FL for 3 days of focused healthcare analytics training, discussions and networking. Our motto is “Your data empowered…” but for 3 days, it was all about our clients empowered. The one-on-one time with customers…invaluable.
Our first day was all about PDS iMPower and PDS Dash – an exchange of best practices and keys to success. Tuesday evening, we enjoyed a networking reception.
We decided to take a more collaborative approach in 2019; after all, “Exchange Forum” was in the name. The second day of the conference focused on round-table discussions; clients learned from each other while PDS staff added their expertise to the conversation. Wednesday night we enjoyed Epcot and the spectacular evening fireworks. This morning, we continued the round-table discussions and then forum wrapped up after a delicious lunch together.
The 2019 PDS Conference was all about sharing our ideas, our time, and an experience. Our clients and the PDS Team truly made the magic happen, and Disney’s beautiful Coronado Springs Resort was surely a plus.
We hope to see you at a future PDS user conference!
Learn how to analyze denials to determine causes, complications, and costs associated with the most common healthcare denied claims.
Claims denial rates in recent studies range from 6% to 21% of revenue collections within physician practices. While many of these denials can be effectively appealed and recovered, it's time-consuming, expensive, and can have a dramatic effect on cashflow and reimbursement rates.
In this webinar, we discuss data analytics techniques and how the visualization of data can provide a focused, insightful view of denials. We show how the use of strategic reporting and dashboards can prevent denials caused by in-house staff, documentation issues, and common charge entry or coding errors. Using initiatives brought into focus with data analytics tools, practices can realize substantial cost savings and improve operating efficiencies.
Originally presented on October 30, 2019 by Practical Data Solutions' Scott Everitt, MBA, Vice President of Analytic Solutions, and Becky Cook, Executive Consultant.
As we return to the Northeast from Orlando, we hope you enjoyed visiting us at the 2019 Revenue Integrity Symposium and that you might have even learned something! If we missed you, we hope to catch you at a future conference.
PDS staff enjoyed their experience at MGMA19 with three days sharing best practices in healthcare management. If you missed us, feel free to navigate to our webinar page to learn more about who we are, what we do, and how we do it. We look forward to seeing you at future conferences.
Learn about patient access healthcare data analytics reporting and visualizations using Tableau, MicroStrategy, and Microsoft PowerBI.
The goal of any patient access initiative is fairly simple – to find capacity. Are your providers scheduling efficiently? Are they offering services at times and locations convenient for patients? How long does it actually take for a patient to get an appointment? Answering these questions is the key to achieving the goal.
In this webinar, gain insight into how to move from tables and queries to visually appealing interactive dashboards. Learn to identify areas with the greatest opportunities to increase capacity and improve patient access. Understand how incorporating data from external datasets for visualized reports tells the whole story and provides a focus for enhancement initiatives.
Originally presented on August 14, 2019 by Practical Data Solutions’ Scott Everitt, MBA, PDS Vice President of Analytic Solutions.
Learn how to analyze denials data using analytics and visualizations to recover lost healthcare revenue.
In recent studies, claims denial rates ranged from 6% to 21% of revenue collections within physician practices. What is often not included in these rates are the hidden denials lurking within the details of the billing and reimbursement systems. Applying analytic techniques and visualization of data provides a focused view of denials and allows for the development of strategies to treat those reasons and quantify the results of recoveries and lost revenues.
In this webinar, we demonstrate how to analyze denials to determine causes, complications, and projected recoverable revenue. Using visualizations to illustrate causes and outcomes engages staff to become sleuths looking for new solutions.
Originally presented on June 19, 2019 by Practical Data Solutions’ Russell Hendrickson, CEO, and Becky Cook, Executive Consultant.
View our latest Webcast on YouTube! 
Managing medical practices is challenging even in the best of times. But what happens when situations outside of our control force temporary but significant changes upon us? Health systems, hospitals, and clinics need to be among the most stable of businesses no matter what the circumstances in order to best serve patients and the community’s urgent needs. The recent events of COVID-19 have illustrated the need to be adaptable in times of crisis. External changes may force us to modify how we do business for several days, in the case of extreme weather or natural disasters, to several months, in the case of the current pandemic. As leaders in these organizations – and indeed, in our communities – how can we best position ourselves to navigate through these turbulent times?
The Financial Conference is always a great opportunity to connect with healthcare professionals to share the latest in analytics and the challenges organizations are facing today. This conference always sparks great discussions on strategies to run a more profitable and efficient organization. During these great discussions, PDS was able to share how our solutions can help with financial management, payer contracting analysis, business intelligence and revenue cycle management best practices.
As we return to the Northeast from Orlando, we hope you enjoyed visiting us at the 2019 Revenue Integrity Symposium and that you might have even learned something! If we missed you, we hope to catch you at a future conference.
PDS staff enjoyed their experience at MGMA19 with three days sharing best practices in healthcare management. If you missed us, feel free to navigate to our webinar page to learn more about who we are, what we do, and how we do it. We look forward to seeing you at future conferences.