Uploaded July 2024 | Updated September 2026, 2 days ago
Power BI tutorial where we'll create a health care dashboard for hospital admission scenario where we'll see how many patient are coming for consultation and then how many of them are getting admitted to hospital. Apart from these we'll look at the KPIs like emergency admission, average duration of stay, average wait time and planned admission.
We'll create dynamic chart to evaluate admission by Male, Female and Unknown Gender type. Then we'll create two horizontal bar chart to show average duration of stay and average wait time. Then we'll evaluate emergency admission into various medical specialities vs the wait time in them by using conditional formatting in a tree map chart. Finally we'll create a 100% stack bar chart to show the %of emergency admission, waitlist and other admission type to evaluate each medical department.
Connect with me:
LinkedIn - linkedin.com/in/abhishek-agarwal-9549876
Twitter - https://x.com/agarrwal7
Need advance power bi dashboard training? Contact - Abhishek.agarrwal@gmail.com
Dataset: tinyurl.com/yd65vnf3 (look for dataset sheet in this folder)
Power BI Tutorials sheet: docs.google.com/spreadsheets/d/1UlV8vTxzcCR2WaYUYfL-JI_6ae1aOTPqORU1YjLfuSk/edit?usp=sharing
Power BI tutorial where we'll create a health care dashboard for hospital admission scenario where we'll see how many patient are coming for consultation and then how many of them are getting admitted to hospital. Apart from these we'll look at the KPIs like emergency admission, average duration of stay, average wait time and planned admission.
We'll create dynamic chart to evaluate admission by Male, Female and Unknown Gender type. Then we'll create two horizontal bar chart to show average duration of stay and average wait time. Then we'll evaluate emergency admission into various medical specialities vs the wait time in them by using conditional formatting in a tree map chart. Finally we'll create a 100% stack bar chart to show the %of emergency admission, waitlist and other admission type to evaluate each medical department.
Connect with me:
LinkedIn - linkedin.com/in/abhishek-agarwal-9549876
Twitter - https://x.com/agarrwal7
Need advance power bi dashboard training? Contact - Abhishek.agarrwal@gmail.com
Dataset: tinyurl.com/yd65vnf3 (look for dataset sheet in this folder)
Power BI Tutorials sheet: docs.google.com/spreadsheets/d/1UlV8vTxzcCR2WaYUYfL-JI_6ae1aOTPqORU1YjLfuSk/edit?usp=sharing
![Data Analyst Course for Beginners in [Hindi] - Part 1 #datanalysis #data #datanalytics #training](https://i.ytimg.com/vi/MtFLN4jG9k8/mqdefault.jpg "Data Analyst Course for Beginners in [Hindi] - Part 1 #datanalysis #data #datanalytics #training
Learn about data and data analysis in Hindi. A complete tutorial for absolutely beginners who doesnt know anything about data and want to learn various aspects of data like what is data, how data gets collected, how to analyze data, what happens after the data analysis. All of these topics I have covered with lot of details and example that will help beginners to understand all the topics related to data and data analysis.
To join my live sessions, contact - abhishek.agarrwal@gmail.com")
