Data-Related Financial Analytics

Singletrack Analytics can assist your financial team in dealing with analyses involving large data sets that require tools and techniques outside of the usual financial analyst’s skill set. 

The Challenge:

Most healthcare financial analyses can be handled using spreadsheets.  Occasionally, however, hospitals face an analysis that relies on massive amounts of data that cannot be efficiently accommodated by normal spreadsheet techniques.  These often get handled by some suboptimal process, such as breaking down the data into components, analyzing it in pieces and then attempting to put the results together.  The result is often less than desirable.

The Singletrack Solution

Singletrack understands healthcare finance, and also the techniques for handling large data sets.  We can work independently or with your finance team on a project or ongoing basis to apply the appropriate database tools to these large databases, building summarization tables with intermediate calculations that will extract the necessary information.

Examples include  

Demographic data sets – Hospital marketing departments frequently must analyze their hospital’s market share from massive databases (several hundred megabytes is not uncommon) provided by government agencies.  Singletrack designed a database to hold, filter and summarize the data based on simple user controls, and linked the resulting data into an Excel spreadsheet.  This allowed the user to work with the full scope of the data using familiar tools.

Payer contract simulation – Payers proposed changes to inpatient and outpatient payment models, moving from per diems and percentages of charges to DRGs and APGs.  Simulating these changes required selectively merging, filtering and summarizing data using techniques that are not easily implemented in spreadsheets.  Singletrack built database models that could perform these analyses and allowed the hospitals to evaluate the bottom-line effect of the changes in payment.