1 Reply Latest reply on Dec 22, 2012 7:37 AM by Jonathan Drummey

    Forecasting Gross Revenue / Staffing Needs

    Mark Jackson

      Has anyone attempted to use Tableau to do predictive analytics for staffing or expected gross revenue? I was thinking about using historical data (like the chart below) to more accurately forecast gross revenue using in-house patients and principle ICD9 diagnosis. This could also potentially be used to anticipate staffing needs if pathways are pretty standardized. I'm wondering if anyone has had tried anything like this.

       

      In the chart below, each line shows a running sum of average charges over the course of the patient stay. Each line represents a different ICD9 DX code. My thought was to export this in a cross tab and join it to my current census to create the forecast. I'd have to do some additional estimates for future admissions by ICD9 DX to get a more complete picture.

      Average Expected Charges.jpg