{"id":5023,"date":"2010-07-02T15:57:00","date_gmt":"2010-07-02T22:57:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2010\/07\/02\/how-often-are-patients-coming-back-a-healthy-powerpivot-study\/"},"modified":"2024-01-22T22:50:12","modified_gmt":"2024-01-23T06:50:12","slug":"how-often-are-patients-coming-back-a-healthy-powerpivot-study","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2010\/07\/02\/how-often-are-patients-coming-back-a-healthy-powerpivot-study\/","title":{"rendered":"How often are patients coming back? A healthy PowerPivot study"},"content":{"rendered":"
As was recently observed by web analytics and download feedback, there is a lot of interest in PowerPivot within the Healthcare industry.\u00a0 A recent blog posting noted that healthcare was the top industry when viewing PowerPivot Interest by Industry<\/a>.\u00a0 One of the key reasons is that while healthcare systems have a lot of data (i.e. patient transactional data), it is often left to the analyst using Excel to understand the meaning behind all of this information.<\/p>\n How often are patients coming back?<\/b><\/p>\n A common question in hospital settings is that once a patient who has stayed at a hospital leaves (i.e. discharged from the hospital), how often are they coming back to the hospital (i.e. readmitted to the hospital).\u00a0 This type of re-admission analysis is very important because it ultimately allows analysts to determine why patients are coming back to the hospital within a set number of days of being discharged.<\/p>\n Healthcare Readmission Analysis Example Scenario<\/b><\/p>\n Below is an example screenshot of obfuscated sample readmission data from a healthcare customer.\u00a0 As you can see, there are some large disparities between department discharges (in blue) and the re-admission rates (in red).\u00a0 For example, while the pulmonary department has relatively few discharge cases, they have the highest re-admission rate near 35%.\u00a0 Meanwhile, internal medicine has the largest number of discharges, yet one of the lower readmission rates.<\/p>\n