Problem Statement
Recent Covid-19 Pandemic has raised alarms over one of the most overlooked areas to focus: Healthcare Management. While healthcare management has various use cases for using data science, patient length of stay is one critical parameter to observe and predict if one wants to improve the efficiency of the healthcare management in a hospital.
Suppose you have been hired as Data Scientist of HealthMan– a not for profit organization dedicated to manage the functioning of Hospitals in a professional and optimal manner.
As a snowflake developer/ consultant, you are helping the data analytical team to explore the dataset using snowflake , history data is loaded and current data is loaded with snowpipes into database , Merge all the datasets based on the common key and create a single table and check for noise or missing data.
See project presentation here
For more detailed documentation and project walk-through, refer this report