Power BI Dashboard for Healthcare Analytics: Full Tutorial | How to use Power BI Desktop

[@tamamhadibay]

Hi, thank you for the amazing tutorial. Only thing, I guess, your average room charge measure would be more logical if you did below: Avg Room Charge = [Total Room Charges] / SUM(visits[Length of Stay])

[@datalab365]

👍

[@AbdurRahman-ko9kr]

You are truely a super hero , Mr. Omeiza !

[@IfeanyiNwosu]

This is actually AMAZING, learnt couple of things, I never knew I could do in PowerBI and to think I followed you from start to end, Built the dashboard correctly , very interactive

[@datalab365]

Thank you

[@isiomalisaclement6254]

Liked before even watching. I already know it will be amazing. Thank you good sir.

[@datalab365]

You're the best!

[@vishnupp5944]

Amazing work, please do more design of professional dashboard

[@shridharchoppara1342]

The date format in the vists.csv file is in 2 formats 02-12-2024 & 2/13/2024. I am unable to sort this on power query or excel hence my power BI dashboard doesn't show the same number as your video, please advice.

[@Zovic_Kiddies]

Fill up the blank column first with a dummy date eg 06/06/2009. Split the column. Rearrange to Day, month and year. Merge the 3 columns using / as the seperator. Replace dummy columns to null. Successful change to date data type. This worked for me

[@DatawithHimanshu]

Man you are doing great job. Thank you.

[@datalab365]

Thank you

[@kayodeanjorin8914]

I will recreate this I have learned so much from u Thnaks

[@igbegrowth4442]

This video is so so insightful, thanks.

[@y.hidayat7391]

I have learned a lot from you and from this channel ❤... thank you and keep going.

[@datalab365]

Happy to hear that!

[@yakaba]

Thanks for this video. 'Average Billing Amount per Visit' should use number of visits, unless you want 'Average Billing Amount per Patient'. Notwithstanding it is a great video, I will subscribe to your page and watch your other videos. Aavoo Adai!

[@monsuratafolabi9164]

Hi, thank you for the amazing tutorial. However, i am unable to use the azure visual and i have a power bi service account. Any help will be appreciated. Thank you

[@datalab365]

Try to update your power BI to the latest one

[@MaiNguyen-xe2sf]

@@datalab365 it said that I should contact my tenant admin to fix it. I've searched guide to open the Admin portal but can't find it in my windows. Thanks for more hint.

[@myanyeinchan7984]

Thank you so much for your tutorial . I learn so many from you. But, I have same problem and I ask Google before I did not see this comment. It said that I need to have pro license. Is it true?

[@rakeshkumarjha6965]

You are doing a great job dear when will you come with second part of that with more interactive images of doctors? Please upload it i am eagerly waiting for it. Thank you showing so much advance things.

[@datalab365]

@@rakeshkumarjha6965 very soon

[@ihiabeadams8475]

Hello, wonderful job you're doing here. I was following along until I got stuck, my admitted and discharged dates are 100% empty in power querry , hence it gives incorrect values for the length of stay in power bi Please how do I resolve this?

[@Kingsley002]

filter the empty date rows out. i solved mine

[@datalab365]

Thank you for the response. You can subscribe to our new Data Analytics channel:kzbin.info/www/bejne/aqLbXoaAmJaLqc0si=7Y1SpDxXXz9Qpdwj

[@ihiabeadams8475]

@@Kingsley002 Thank you.

[@sundayamoo84]

Thanks for this video, i leant a lot new there. Pls can you share Link to create power Bi account?

[@datalab365]

kzbin.info/www/bejne/Zp-VcqtseM-ppZo

[@parthibanravichandran4069]

Hi, I have one question what if charges of room is varying depends of type rooms they stay then how will you calculate the staying charges for dashboard.

[@Suma7777-qh4nn]

I want tablue vedio will u share it

[@desmondmartins4963]

This is beautiful

[@datalab365]

Thank you

[@ankuroberoi017]

Power B tutorial is very amazing, please share the link of the screen recorder with me, I also want to download it.

[@datalab365]

@@ankuroberoi017 search for ocam on Google

[@sharabarathan3433]

Your multicard properties are so much different than the default Multicard properties. Is that custom multi card?

[@datalab365]

Is same thing.

[@Marichka008]

Why did you create a JPEG file in PowerPoint for the background? Couldn't we have just chosen a fill color and that's it?

[@datalab365]

@@Marichka008 of course you can, is optional. You can be as creative as you want. 👍

[@asharkhan3065]

Hi, thanks for the wondeful project! I have one question though. Why my length of stay is not showing up correctly when I apply day filter but they are exactly same as yours when I apply month filter? Any idea why its happening? Thanks

[@datalab365]

Check your measure

[@Marichka008]

I'm stuck on the bookmarks thing. I've been redoing it for an hour, but something is wrong. What's actions after ordering OPEN and CLOSE? Could you sent your file Power BI?

[@Marichka008]

Please

[@opejoseph6814]

Love this!

[@datalab365]

Thank you

[@Marichka008]

Why do you have both bottoms "Go to LIGHT Mode"?

[@datalab365]

😱

[@mrbartuss1]

Ad. Total Room Charge 1) Why do you created calculated column? They should be avoided, because they can slow the report refresh 2) To calculate Length of Stay +1 should be added to ensure that both the admission and discharge dates are included in the stay duration

[@datalab365]

Please listen to my explanations. I use the calculated column to show a row by row example which I did not use in the report. What I used was measure not calculated column.

[@mrbartuss1]

@@datalab365 So why did you leave Length of Stay as a calculated column?

[@datalab365]

@@mrbartuss1😱 You can not create Length of stay as a measure because we need to use it for calculating total Room charges where you will have to use an iterator function to scan the table row by row. Please, show me how you can better create Total Room charges without the length of stay calculated column I add.

[@mrbartuss1]

@@datalab365 Here it is: Total Room Charge = SUMX ( visits, VAR LengthOfStay = DATEDIFF ( visits[Admitted Date], visits[Discharge Date], DAY ) + 1 VAR DailyRate = visits[Room Charges(daily rate)] RETURN LengthOfStay * DailyRate )

[@mrbartuss1]

@@datalab365 What about that? Total Room Charge = SUMX ( visits, VAR LengthOfStay = DATEDIFF ( visits[Admitted Date], visits[Discharge Date], DAY ) VAR DailyRate = visits[Room Charges(daily rate)] RETURN IF ( LengthOfStay > 0, ( LengthOfStay + 1 ) * DailyRate ) )

[@vijayakumark6875]

When i try to create length of stay column....im getting vales 200,275 ,28 like that please somebody help me

[@kapur.betzy2023]

How did you calculate Average Room Charge please

[@datalab365]

Average Room Charge = DIVIDE( [Total Room Charges], [Total Patients] )

[@gogineniramgopal8853]

Anyone please tell is there any website like Kaggle to get datasets for practice?

[@datalab365]

@@gogineniramgopal8853 go to Maven analytics or use gpt4 to generate your desired dataset.

[@abdelrahmanabdou8905]

Great video! How did you remove the separator lines on the KPI card at the top?

[@datalab365]

I will show you in my next upload

[@arfanislamabir]

How can we get the second screen? like the second page you created

[@datalab365]

Will be rolling out a new video on that soon.

[@arfanislamabir]

@@datalab365 thank you

[@vijayakumark6875]

When I use calendarauto function it is throw me error like.... function can not find a base coloum of data time type in the model... please somebody help me

[@datalab365]

Convert the date data type to date. If the date is text or other data type it will give you errors

[@vyetundebello810]

@@datalab365 I have the same issue too, tried to convert the data type at the power query level.

[@Chouchou_melun]

I had thesame problem but did the conversion of date under the table visit from text to date and the problem wa solved .

[@AishaMumin-fr5bo]

Hello Mr. Ismaila, How can I create a link to store my images and use the link inside Power BI Desktop instead of importing raw images, which won't be dynamic? Thank you. Hoping to hear from you.

[@datalab365]

Sorry for the late reply. I have made a video about it, is on the channel. You can subscribe to our new Data Analytics channel:kzbin.info/www/bejne/aqLbXoaAmJaLqc0si=7Y1SpDxXXz9Qpdwj

[@user-lj4np4he8b]

Hi Sir, In this video initially the project screen shows about financial analysis, trend analysis, provider analysis here you have done report development only for Provider Analysis rest of 2 not done is there any other video to watch other 2 projects, could you please help me regarding this.. How many parts do we have for this project pls revert me as soon as possible..

[@datalab365]

All is now available. You can subscribe to our new Data Analytics channel:kzbin.info/www/bejne/aqLbXoaAmJaLqc0si=7Y1SpDxXXz9Qpdwj

[@ibrahimabdallah5969]

Amazing.....How can i get the dataset please ?

[@datalab365]

@@ibrahimabdallah5969 please check the description box the link is there.

[@P005Y]

Date Format Error is happening when trying to convert Admission and Discharge Date type to Date , Cannot retrieve Date Values , Data values in the date coloumn in the raw files need to be cleaned

[@datalab365]

Change the region of the data form either UK to US the other way round. It depends on your location

[@mrbartuss1]

47:25 Isn't that Average Billing Amount per Patient, not per Visit?

[@tamamhadibay]

Yes, it should have been simply as below. Avg per visit = [Total Billing Amount] / COUNTROWS(visits)

[@taibatabowaba9828]

@@tamamhadibay just average(total billing amount) would surfice for this.

[@user-xk7li8mg4b]

go on bro ❤

[@datalab365]

Thank you.

[@user-gi5hf9ux6i]

How to get power bi free sign in option

[@piyug6810]

Plz make vedio in simple English language.

[@datalab365]

I will thank you 🙏

[@hilariocarlos05]

Hi Mr.! I would like to translate this dashboard for Portuguese

[@desmondmartins4963]

Try Google translate but I don't know if there is a smoother way of doing it rather than copy and paste

[@edikanebu-nkamado5063]

Bro, do you do private tutorials?

[@datalab365]

Not any more. Too much work. Thank you.

[@timianalytics7150]

Bro how do you do it, this is too consistent

[@Safa_TN]

👍🌹

[@sonalirajput417]

hi if I am changing the data type in the visit file 50% data shows error can you tell me if should i proceed with this or what

[@datalab365]

Change the date to your region date format.

[@Maverick00777]

@@datalab365 i am also facing the same issue. same error persists even after changing the date according to region. please help. i am unable to proceed.

[@vijayakumark6875]

When i try to create length of stay column....im getting vales 200,275 ,28 like that please somebody help me

[@shaizanansari5275]

did you get the solution for this ? I am also facing the same problem

[@minhanhphan9327]

go to Options and setting -> Options -> Regional Settings (current file) -> change to US