Power BI Healthcare Analytic Dashboard | Hospital - Clinics Report. Create a Report in Power BI.

[@k-concepts1574]

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

[@krishna6296]

Thank you so much for all the efforts you've put in to create this wonderful tutorial.

[@datalab365]

🙏 thank you

[@ragnarlodhbrok1684]

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

[@dinahany233]

That's very informative. Thank you so much, sir. I truly appreciate all the 3 hours and 20 minutes you spent. God bless you.

[@datalab365]

@@dinahany233 thank you. For more detailed classes check here: datawithdecision.selar.co/y520q1

[@Sanakhan-sr2ub]

Watching this channel has been my turning point Outstanding achievement 🙌

[@datalab365]

Thank you. Compliment of the season 🎉🎊

[@sulaimontoheeb-x2b]

Woooo thanks a lot for impacting more knowledge into your viewers I pray that Allah continue to elevate you

[@VinayShukla-pl4ei]

Thank you for making such an informative video, please keep uploading such kind of videos.

[@datalab365]

Sure.

[@datalab365]

@@VinayShukla-pl4ei Thank you. You can subscribe to our new Data Analytics channel:kzbin.info/www/bejne/aqLbXoaAmJaLqc0si=7Y1SpDxXXz9Qpdwj

[@kaustubhpasalkar6797]

Very informative video. I got to learn many new things through this one video itself. Please keep it up.😇😇😇

[@datalab365]

Thank you . you can follow our new channel kzbin.info/www/bejne/qqXQpKlmg5d-a5Y

[@rohithreddy5201]

I don't find Format tab in 42:32 in new version of power bi, where to find it?

[@bennicbennic]

This is very informative. Thank you for your time.

[@AhmedSalah-p7q]

Thank you for everything . I have learned a lot from you and I am still learning . you are talented and a genius ❤❤❤❤😁😁

[@ahmedkahie4475]

You deserve 5 star subscribed

[@datalab365]

Thanks 🙏👍

[@sravaniram-zb2pd]

Thank you so much for your valuable time...this going to be more useful for me❤thank you so much.

[@datalab365]

Good to know it helps you.

[@sravaniram-zb2pd]

@@datalab365 I have spend 3 days to complete this project... finally it's done

[@sarika7914]

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.

[@SrijanDeb12]

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

[@hawsawi56]

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

[@datalab365]

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

[@mirzafarhan7883]

Thanks for the VDO Really its very informative. Learnt a lot .🙏

[@datalab365]

Thanks for learning with me.

[@RyanHuang-cb6of]

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.

[@BradleyAidanJohnson]

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

[@davidacevedo1984]

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

[@MohammeddHassan12]

Thank you for the video, earned my like + subscribe. I will learn a lot from you. Keep up the great job

[@datalab365]

You're welcome to the channel.

[@funshojegsin5431]

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."

[@datalab365]

Check the columns you use In your dax. Either of the columns are formatted with the wrong date type other than number

[@LS8636]

This is really awesome. Thanks for this video. Great Job 👍👍

[@datalab365]

Thank you.

[@sivakannan3652]

iam not able to extract the AM and PM in the pwer query editor, i dont no whats the problem is

[@datalab365]

Just watch the way I did it. Is simple. Extract the last two characters.

[@sivakannan3652]

@@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

[@Allinone-vd7fr]

Sir from the given dataset hospital there is no AM and PM for extract and please tell us how to add this

[@learngerman773]

@@Allinone-vd7fr yes, it does not have AM/PM column

[@Me189-pm]

It doesn't have Am ​@@datalab365

[@johnwesleybilla92]

I am stuck at that line chart which represents months and Total parients

[@datalab365]

Maybe you should re watch it again.

[@alihassan-ce5ws]

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

[@MohammeddHassan12]

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

[@datalab365]

@@MohammeddHassan12 Thank you 👍

[@TheZozoba]

@@MohammeddHassan12 thank you bro god bless you😭

[@saifilicious1749]

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?

[@samsonadeniyi9531]

This is Exactly what I am facing

[@piyushtaragi8589]

Try to create new date column in patient table truncating timestamp and build the relationship without the timestamp with date table, it will work.

[@NehaSoni-pe6ri]

Very Detailed Explanation, Waiting for more fun video's.

[@datalab365]

Surely. Thanks for watching

[@deblinaroy6271]

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! 🙁

[@datalab365]

Check for relationship between date table and the FactTable

[@piyushtaragi8589]

Try to create new date column in patient table truncating timestamp and build the relationship without the timestamp with date table.

[@fathimathfathima-u6y]

Do make vedios on making dashboards using Deneb. Also write some complex queries as well asnew visualizations. Your vedios are excellent.

[@yatinkande1263]

Thank you so much , it helped for my project a lot.

[@datalab365]

🙏

[@gabby_asiedu21]

At the date column, the AM and PM are not showing. Any guidance?

[@datalab365]

If you extract them in power query you are supposed to see it. Rewatch the power query transformation I did.

[@gabby_asiedu21]

@@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

[@deepasangavi6081]

Could you please help me how you have customized the date column​@@gabby_asiedu21

[@snehalkumar4388]

@@gabby_asiedu21 unable to do it

[@harikrishnannair7653]

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

[@snehalkumar4388]

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"

[@datalab365]

Look at what I did, is very easy. Just highlight the column and got to add column the extract, now choose last 2 characters

[@datalab365]

Do that in power query

[@AkshataAgine]

I dont see the option of "Dont Summarize" at 1.07.32 in my dashboard

[@datalab365]

Is there.

[@RealmShiftGamer]

yeah for me also..did you find any soluntion?

[@supriyamamillapalli2799]

Did you get solution for this ? I stopped here because of this problem Help me with this

[@Zoza0905]

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 ?

[@abdeljalilsekal6366]

AM and PM don't appear in the column of date if you could help me in that pleas

[@SankalpSahu-i6d]

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}} )

[@vivekjoshi3769]

Hi! Is this dashboard good enough if I want to apply for data analyst and business analyst jobs?

[@jannat30]

% No Ratings is 72.69 and not 75 ( cant understand why the DAX gave 75)

[@vedantkhapekar8527]

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...

[@datalab365]

Convert it in Excel by using custom formatting like: mmm/ddd/yyyy hh:mm AM/PM. Good luck.

[@vedantkhapekar8527]

@@datalab365 thanks buddy...

[@joyce3029]

This was helpful. Thank you for your patience in teaching and replying our questions

[@montassarbellahjaaouane8291]

Thank you

[@ranaasad6887]

great so far!😍

[@datalab365]

Thank you

[@myafricaculture]

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)

[@user-uo4yf9eo9q]

not getting green and red points while AM/PM filtering

[@raushanpandey4553]

Amazing reports. Thank you for ur efforts. Could you plz share link to download dashboard😊

[@RehabRamdan-c5e]

Pls could u explain to %no rating Measure I cant understand it

[@rojalibiswal8975]

Hello, sir if possible provide case study and end of the conclusion ?

[@jelenadj7289]

Thank you a lot!

[@datalab365]

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

[@alaael-shami1385]

amazing dashboard really thank you .. but try to make your videos around 1.5 hr max

[@datalab365]

Noted

[@POOJABORHADE-e4j]

May I know from where did you get the dataset.. like kaggle or dataworld?

[@dailylyricshub]

wow, love it learned so many things

[@datalab365]

🙏🎁

[@Ankit-rv2my]

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?

[@datalab365]

You are to extract it from the Power Query.

[@datalab365]

Just highlight the date column and go to add column then extract and extract the last 3 characters

[@alpeshprajapati1]

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?

[@datalab365]

You can share it

[@alpeshprajapati1]

Thank You so much.@@datalab365

[@jumpropemonk7703]

Another banger 🔥 Thanks brother 🙏

[@chaithrajagannathachary]

@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.

[@datalab365]

It doesn't matter. Open it in power query it will work

[@olukunlelaniyi1276]

i think patient_admin_flag, likely to be talking about patient's admission... if the patient is on admission or not

[@vanshikagupta8676]

Can you share the link of the dashboard please?

[@norbertonyach]

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

[@datalab365]

That was because your data type is text, you should have changed it to True/False data type in Power Query.

[@mkbg2832]

🙏🙏

[@datalab365]

🙏❤️‍🩹

[@SandipanSarkar-c8v]

Finished watching

[@datalab365]

Weldon, please apply all you have learned on your next project. 👍

[@vicenteantoniomagallanesju5289]

Where course have this desing ???

[@datalab365]

Yes

[@vicenteantoniomagallanesju5289]

@@datalab365 thanks for your answer, and i have other question, what is the name for.the course , about this dashboard?

[@sanjivanibansode2444]

Hello data file is not CSV file

[@torgbenujemima6406]

please, can I get the dataset for practice?

[@datalab365]

Is there in the description box

[@ranaasad6887]

Still going awesome.

[@datalab365]

Weldon

[@mmb040]

Nice one but AM/PM problem

[@thanuzzthanu2771]

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)

[@AntonioNunnally]

Can you create a table of contents with timestamps?

[@datalab365]

Noted.

[@saloriasaxon7323]

Exactly. It helps a whole lot especially when stopping for a while.

[@ShawnZhang-qc4lt]

上传一个高清的视频可以吗？720p的不清楚。感谢作者，视频很好！！！！amazing！！！

[@datalab365]

Thank you.

[@CPSB-gh3sd]

note to my self "Conditional formatting is only supported with one value and No legends"

[@norbertonyach]

At row 356 the patient Gender is "NC".

[@datalab365]

What about that?

[@ragnarlodhbrok1684]

What does NC means, should we remove or change those values @@datalab365

[@gokulsaravanan1198]

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?

[@datalab365]

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

[@gokulsaravanan1198]

​@@datalab365Yeah bro I missed that one thanks for your assistance in this matter...

[@datalab365]

@@gokulsaravanan1198 you are welcome

[@CPSB-gh3sd]

Note to my self: Conditional formatting is only supported in charts with one value and No legends

[@HarpreetSingh-s4smarty]

Hello, Can you share the pbix file with us , Thanks

[@datalab365]

Link in the description box

[@HarpreetSingh-s4smarty]

I can't find the BI(Dashboard file .pbix) file there

[@mubashirshaikh2538]

pls include slide 2 in shared ppt file. It will be better if you put .pbix file as well.

[@datalab365]

😭😅

[@pantomima5841]

😍

[@asp4628]

Sir,do more real world project end to end

[@datalab365]

I will

[@sanjivanibansode2444]

This is not load to power BI