
Challenge
The client grappled with operational challenges such as Length of Stay (LoS) optimization.
The Solution
We recommended the target values required to achieve specific KPI goals after conducting a predictive and correlation analysis.
Technologies Used

SQL

PySpark

Python

Power BI

Azure DevOps

Azure Synapse

Azure ML Flow

Azure Data Lake Storage Gen2

Databricks
Impact by the NUMBERS
5-18%
improvement in LoS at varying facilities
10%
improvement in transfer rates over 4 months
60%
reduction in the time taken for analysts to identify key trends