Power BI Healthcare Analytic Dashboard | Hospital - Clinics Report. Create a Report in Power BI.
Вставка
- Опубліковано 21 жов 2024
- 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
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
Thank you so much for all the efforts you've put in to create this wonderful tutorial.
🙏 thank you
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
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 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.
This is very informative. Thank you for your time.
% No Ratings is 72.69 and not 75 ( cant understand why the DAX gave 75)
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😭
Hi!
Is this dashboard good enough if I want to apply for data analyst and business analyst jobs?
Thanks for the VDO Really its very informative. Learnt a lot .🙏
Thanks for learning with me.
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
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
Hello, sir if possible provide case study and end of the conclusion ?
You deserve 5 star subscribed
Thanks 🙏👍
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}}
)
not getting green and red points while AM/PM filtering
Thank you for everything .
I have learned a lot from you and I am still learning .
you are talented and a genius ❤❤❤❤😁😁
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
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 ?
I don't find Format tab in 42:32 in new version of power bi, where to find it?
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
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
Watching this channel has been my turning point
Outstanding achievement 🙌
Thank you. Compliment of the season 🎉🎊
May I know from where did you get the dataset.. like kaggle or dataworld?
Do make vedios on making dashboards using Deneb. Also write some complex queries as well asnew visualizations. Your vedios are excellent.
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.
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?
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)
amazing dashboard really thank you .. but try to make your videos around 1.5 hr max
Noted
This is really awesome. Thanks for this video. Great Job 👍👍
Thank you.
@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
Amazing reports. Thank you for ur efforts. Could you plz share link to download dashboard😊
Thank you so much , it helped for my project a lot.
🙏
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
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
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
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
Can you share the link of the dashboard please?
Nice one but AM/PM problem
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.
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
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.
上传一个高清的视频可以吗？720p的不清楚。感谢作者，视频很好！！！！amazing！！！
Thank you.
please, can I get the dataset for practice?
Is there in the description box
Can you create a table of contents with timestamps?
Noted.
Exactly. It helps a whole lot especially when stopping for a while.
Hello data file is not CSV file
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
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?
note to my self "Conditional formatting is only supported with one value and No legends"
wow, love it learned so many things
🙏🎁
At row 356 the patient Gender is "NC".
What about that?
What does NC means, should we remove or change those values @@datalab365
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
Thank you
Sir,do more real world project end to end
I will
Note to my self: Conditional formatting is only supported in charts with one value and No legends
great so far!😍
Thank you
pls include slide 2 in shared ppt file. It will be better if you put .pbix file as well.
😭😅
Finished watching
Weldon, please apply all you have learned on your next project. 👍
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
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
Another banger 🔥
Thanks brother 🙏
🙏🙏
🙏❤️🩹
Still going awesome.
Weldon
This is not load to power BI
😍