Power BI Healthcare Analytic Dashboard | Hospital - Clinics Report. Create a Report in Power BI.
Вставка
- Опубліковано 5 лют 2025
- Our other courses are here: pfieuz-schruag...
If you need me to create your Dashboard send WhatsApp Message to: +234 810 6090 365 Business only.
Download the dataset here: drive.google.c...
1. Average Wait Time: Discover how long patients typically wait before their appointments. Uncover patterns and trends that shed light on the efficiency of our healthcare system.
2. Patient Satisfaction: We'll explore the average satisfaction scores given by our patients. Learn about the factors that contribute to a positive patient experience and how we can enhance it.
3. Total Patient Visits Monthly: Get an overview of the ebb and flow of patients through our doors each month. Understand the dynamics of healthcare demand over time.
4. Administrative vs. Non-Administrative Appointments: Delve into the data to distinguish between appointments that involve administrative processes and those that don't. Explore the impact on wait times and patient satisfaction.
5. Referrals and Walk-In Patients: Uncover the balance between patients referred to specific departments and those who walk in without prior referral. How does this impact the overall patient experience?
6. Patient Visits by Age Group and Race: Explore the distribution of patient visits across different age groups and races. Gain insights into the diversity of healthcare needs and preferences.
Join us in decoding the patterns, trends, and valuable insights hidden within this healthcare dataset. Whether you're a healthcare enthusiast, data analyst, or just curious about the inner workings of medical facilities, this video is for you!
Don't miss out on the opportunity to deepen your understanding of healthcare dynamics. Hit the subscribe button, like, and share to stay informed on the latest data-driven content. Let's navigate the healthcare landscape together! #HealthcareInsights #DataAnalysis #PatientExperience #HealthcareTrends
Thank you so much for all the efforts you've put in to create this wonderful tutorial.
🙏 thank you
Dear Friend, your efforts are remarkable, but you can benefit new bees more if you do the module(ing) and later merge, like SDLC, then your outstanding efforts and command will be more appreciated and understood in a order.
Regards
Very informative video. I got to learn many new things through this one video itself. Please keep it up.😇😇😇
Thank you . you can follow our new channel ua-cam.com/video/ttmsv0N2K54/v-deo.html
Watching this channel has been my turning point
Outstanding achievement 🙌
Thank you. Compliment of the season 🎉🎊
That's very informative. Thank you so much, sir. I truly appreciate all the 3 hours and 20 minutes you spent. God bless you.
@@dinahany233 thank you. For more detailed classes check here: datawithdecision.selar.co/y520q1
Woooo thanks a lot for impacting more knowledge into your viewers I pray that Allah continue to elevate you
You deserve 5 star subscribed
Thanks 🙏👍
Thank you for everything .
I have learned a lot from you and I am still learning .
you are talented and a genius ❤❤❤❤😁😁
Thank you for making such an informative video, please keep uploading such kind of videos.
Sure.
@@VinayShukla-pl4ei Thank you. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj
are you sure that admin_flag means that the patient is an admin and not denoting that the patient's admission status, whether they are admitted or not, wouldn't that make more sense? I am confused
Thanks for the VDO Really its very informative. Learnt a lot .🙏
Thanks for learning with me.
This is very informative. Thank you for your time.
I realy wanted to thank you very much and thanks god I learend a lot from this video and started to create my dashboard from only one ( this ) video you had explain.. thanks a lot
Thank you. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj
Do make vedios on making dashboards using Deneb. Also write some complex queries as well asnew visualizations. Your vedios are excellent.
This is really awesome. Thanks for this video. Great Job 👍👍
Thank you.
Thank you so much for your valuable time...this going to be more useful for me❤thank you so much.
Good to know it helps you.
@@datalab365 I have spend 3 days to complete this project... finally it's done
Hi @@datalab365, I am unable to filter month and total patients. Even though I created correct relationship between date table and patients table. Can you help me with this.
Very Detailed Explanation, Waiting for more fun video's.
Surely. Thanks for watching
Thank you
Thank you so much , it helped for my project a lot.
🙏
Thank you for the video, earned my like + subscribe. I will learn a lot from you. Keep up the great job
You're welcome to the channel.
good video. It seems Power BI takes 0 as blank. The avg 4.99 considers all 0 in the calculation while 5.47 ignores all blank and 0. I verified this via Excel.
Was thinking earlier on that you’d want the nulls where a review wasn’t left then you wouldn’t need the calculate function to find the average satisfaction score. This was a data cleaning/transformation issue not really a dax thing
great so far!😍
Thank you
I don't find Format tab in 42:32 in new version of power bi, where to find it?
Thank you a lot!
@@jelenadj7289 Thank you. You can subscribe to our new Data Analytics channel:ua-cam.com/video/4qx-SJc1Xsk/v-deo.htmlsi=7Y1SpDxXXz9Qpdwj
Pls could u explain to %no rating Measure I cant understand it
Finished watching
Weldon, please apply all you have learned on your next project. 👍
I am stuck at that line chart which represents months and Total parients
Maybe you should re watch it again.
i am also struck at that line chart,whenever i pull months in to line chart it shows nothing on x-axis but when i pull this same thing in to matrix rows it shows all months ,i dont know what the problem
Had same issue turned out the way to fix it is go to transform data in home tab. go to your patient dataset and click on the little icon of the date (notice it looks like a table with clock) change it to a date (its date and time originally) you can watch him in min 11:28 so you see what he does. best of luck
@@MohammeddHassan12 Thank you 👍
@@MohammeddHassan12 thank you bro god bless you😭
amazing dashboard really thank you .. but try to make your videos around 1.5 hr max
Noted
Hello please help me out from 1.11.01 . When I’m dragging the total patients it is not responding with the month , only showing total count in a single row without showing any months. I don’t why the relationship not working . What to do?
This is Exactly what I am facing
Try to create new date column in patient table truncating timestamp and build the relationship without the timestamp with date table, it will work.
note to my self "Conditional formatting is only supported with one value and No legends"
at 1:37:25 I am not able to select Values Max Point in Data lable even after selecting and following the earlier step...could you please help
wow, love it learned so many things
🙏🎁
Hi, thanks once more for the best educative project. please help me with dataset, have tried to download from the link but there is only one table available. (Hospital ER.csv)
i think patient_admin_flag, likely to be talking about patient's admission... if the patient is on admission or not
iam not able to extract the AM and PM in the pwer query editor, i dont no whats the problem is
Just watch the way I did it.
Is simple.
Extract the last two characters.
@@datalab365 it's not working, if iam trying to extract the AM and PM data, that before the Time seconds only extract not the AM and PM extracts
Sir from the given dataset hospital there is no AM and PM for extract and please tell us how to add this
@@Allinone-vd7fr yes, it does not have AM/PM column
It doesn't have Am @@datalab365
🙏🙏
🙏❤️🩹
Hello, sir if possible provide case study and end of the conclusion ?
54:31
i typed in the code but its showing error saying "DAX comparison operations do not support comparing values of type Text with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values."
Check the columns you use In your dax. Either of the columns are formatted with the wrong date type other than number
Nice one but AM/PM problem
% No Ratings is 72.69 and not 75 ( cant understand why the DAX gave 75)
not getting green and red points while AM/PM filtering
Hi!
Is this dashboard good enough if I want to apply for data analyst and business analyst jobs?
Another banger 🔥
Thanks brother 🙏
can someone help me out ..... for me in line chart (1.11.17) when i plot my month with the total patient , the line chart dosent form . it gives in x axis as blank . what can i do ?
At the date column, the AM and PM are not showing. Any guidance?
If you extract them in power query you are supposed to see it.
Rewatch the power query transformation I did.
@@datalab365
Thank I’ve been able to do it
I had to customize the date column then change the calendar settings on my pc and restarted the computer before being able to do it. Thanks for your response as well
Could you please help me how you have customized the date column@@gabby_asiedu21
@@gabby_asiedu21 unable to do it
Thanks......I have been trying to change the date format and nothing worked. finally tried this method. I noticed my laptop's date format was in 24Hrs clock, changed and restarted now I am able to read the dataset correctly@@gabby_asiedu21
Still going awesome.
Weldon
Amazing reports. Thank you for ur efforts. Could you plz share link to download dashboard😊
I have a problem in 1:20:23. This is the prompt that I used:
CF Max Point (Month) =
VAR _PatientTable =
CALCULATETABLE(
ADDCOLUMNS(
SUMMARIZE('Date','Date'[Month]),
"@Total_Patients",[Total Patients]),
ALLSELECTED()
)
Error: The syntax for ')' is incorrect.
would you help me with this issue? Thx
Thankful for this project
Line chart for total patient for every month is getting flat line. Please help me with this. I'm stuck here! 🙁
Check for relationship between date table and the FactTable
Try to create new date column in patient table truncating timestamp and build the relationship without the timestamp with date table.
AM and PM don't appear in the column of date if you could help me in that pleas
go to transform and choose data type as datetime and then in formula replace with this. = Table.TransformColumns(
#"Reordered Columns",
{{"date", each DateTime.ToText(_, "dd/MM/yyyy h:mm:ss tt"), type text}}
)
Sir,do more real world project end to end
I will
Wonderfull,, very awesome. Thank you for the valuable insights.
Would it be appropriate to share this completed dashboard on a social network platform to showcase my skills and knowledge gained during the session, with the aim of enhancing my job prospects?
You can share it
Thank You so much.@@datalab365
I dont see the option of "Dont Summarize" at 1.07.32 in my dashboard
Is there.
yeah for me also..did you find any soluntion?
Did you get solution for this ?
I stopped here because of this problem
Help me with this
I followed your steps but there where you said "power BI doesn't recognize true or false" I had to put them in a bracket to make the command hold
That was because your data type is text, you should have changed it to True/False data type in Power Query.
May I know from where did you get the dataset.. like kaggle or dataworld?
my power bi is not showing AM/PM in date coloumn,how to modify it
#edit
there is a way,add new column
= if Time.Hour([date]) < 12 then "AM" else "PM"
Look at what I did, is very easy. Just highlight the column and got to add column the extract, now choose last 2 characters
Do that in power query
Hello data file is not CSV file
Note to my self: Conditional formatting is only supported in charts with one value and No legends
Hey, Thanks for the amazing topic. But the problem is that no AM/PM words are available in the date column. Can you please help me out with that...
Convert it in Excel by using custom formatting like: mmm/ddd/yyyy hh:mm AM/PM.
Good luck.
@@datalab365 thanks buddy...
This was helpful. Thank you for your patience in teaching and replying our questions
😍
Can you share the link of the dashboard please?
At row 356 the patient Gender is "NC".
What about that?
What does NC means, should we remove or change those values @@datalab365
@datalab365 Hi sir thank you for the video, very helpful. From the excel document attached it doesn’t show if it’s AM or PM by default when opened like it does in yours. Can you Please tell me why that is or how I can fix it? Thanks.
It doesn't matter. Open it in power query it will work
Can you create a table of contents with timestamps?
Noted.
Exactly. It helps a whole lot especially when stopping for a while.
Where course have this desing ???
Yes
@@datalab365 thanks for your answer, and i have other question, what is the name for.the course , about this dashboard?
please, can I get the dataset for practice?
Is there in the description box
i am facing problem with date column and not getting AM/PM at the end of each record, follow all steps of yours, please suggest what should i do?
You are to extract it from the Power Query.
Just highlight the date column and go to add column then extract and extract the last 3 characters
上传一个高清的视频可以吗？720p的不清楚。感谢作者，视频很好！！！！amazing！！！
Thank you.
pls include slide 2 in shared ppt file. It will be better if you put .pbix file as well.
😭😅
I can’t see the patients trend in every month it starts from blank, then Jun, jul, nov , dec . Can u please help me with this.
When choose the month from date. (I can see from Jan dec but when I choose total patients then I can’t see from Jan to dec)
Hello, Can you share the pbix file with us , Thanks
Link in the description box
I can't find the BI(Dashboard file .pbix) file there
This is not load to power BI
Average Satisfaction Score =
CALCULATE(
AVERAGE('Patients Dataset' [patient_sat_score]),
'Patients Dataset' [patient_sat_score]BLANK()
)
Couldn't load the data for this visual
MdxScript(Model) (27, 17) Calculation serror in measure 'Calculations [Average Satisfaction Score]: T function AVERAGE cannot work with values of type String.
Sir I am facing the below issue while I am running the query in new measure. Can you suggest how to over come this issue?
Check the patient sat score column, make sure the date type is number and not text.
Do that in Power Query.
With that you will solve the issues
@@datalab365Yeah bro I missed that one thanks for your assistance in this matter...
@@gokulsaravanan1198 you are welcome