Cost analysis by hospital
To broaden your analysis on hospital comparisons, you have been requested to calculate a new metric for the average cost per discharge and use this to gain insights into cost variability by hospital and region.
The leadership has also tasked you with assessing this new metric by some suspected drivers of high cost. You will evaluate patient mortality risk, severity of illness, diagnosis description, and disposition to identify any factors that stand out.
We do not recommend doing so, but if you lost progress, you can load the solution workbook of the previous exercise 1_5_initial_comparison_of_hospitals_solution.pbix
from the Exercises folder.
This exercise is part of the course
Case Study: Analyzing Healthcare Data in Power BI
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
