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.
There have been some Tableau forum questions that I've seen regarding financials forecasting, that's about it. Besides setting up the algorithms, the key question seems to be how much the data is padded in SQL vs. padded in Tableau.