Build an Emergency Room Dashboard in Tableau | Healthcare Data Analyst Portfolio Project

[@DataWizardry]

👉 60 Minute SQL Lesson with healthcare data files for FREE! datawizardry.academy/

[@dannyhulk11]

This is my best data analysis channel so far!

[@faacam]

thank you for the great video, extremely helpful, *just for my ref 🙏 - 5:50 gender % - 6:00 avg patient satisfaction score - 7:40 avg patient wait time - 8:41 avg satisfaction and avg patient waittime number title - 10:51 area graph: no of patient over time based on age group - 11:10 calculation age group - 12:55 - 16:43 heatmap days; waittime - 20:15 bargraph race - 21:47 referred

[@oseikwamejones9019]

You have earned a new subcriber. Thank you for your kindness and selflessness. You were concise and clear. Much love.

[@pluderr3947]

Hey Data Wizardry, I just found out about your channel and I just wanted to say that you’ve been such a huge help! Especially with this video, you deserve so much more recognition and I hope you will get it soon. Without you, I wouldn’t have known what domain of analytics I wanted to go into, so for that I really appreciate you. I have followed the entire video from start to end and mine looks so good! I’ve learned so much from this video. Thank you.

[@DataWizardry]

Awesome! Glad my video was helpful, and welcome to the channel!

[@TheNotoriousBaller]

Super helpful! Starting an analytical job in healthcare tomorrow. Thank you

[@DataWizardry]

Congrats!

[@2cupcakes1jar45]

Thank you so much for taking your time out to share and teach us! I'm a new subscriber, and following along on your videos! You're my new professional mentor! Thank you for sharing this gift, you're changing our lives!!!

[@DataWizardry]

Happy to help!

[@laraedotson9587]

I really need more of these.

[@ayeshanaeem7965]

Thank you for the tutorial, extremely helpful.

[@HephzibahBlessy-q3h]

Thank you so much for great video. You are very good at explanation.Great help.😊

[@osmondanokwulu5384]

This is really great. Thank you very much for this. I'm now your secret mentee 😊. Highly interested in Health Data Analytics. I'm in the field by education and training.

[@Samone8428]

I'm so excited to try this!

[@ZeppelinRunner]

Hey! I just watched this and followed along to make my first data visualization! I'm hoping to continue to build more to break into healthcare data analytics. Thank you so much for the guidance!

[@DataWizardry]

Awesome! Happy to help. Will try to think of more projects like these for future videos!

[@chadleever492]

Great content! My brain has been compressed down to the size of a tiny raisin. It fell out of my head. I ate it, and it was yummy. I feel better now I think.

[@longeveningatthedunes]

Huge Thanks!! You make it so easy to follow along, probably the best follow-along project video I came across in all of KZbin! So I finally brought myself up to make my first vizz and am now super proud :) Put it on my Tableau public. I want to put a link to this YT video within the viz too, along with the credit, if that's ok? Will be happy to see more of these videos, practical follow-alongs are the best!

[@DataWizardry]

Sure, I appreciate the shoutout! Thanks @janarutkowska5204! Glad you find it useful, will be making more soon.

[@aravindvasudev7921]

This video was extremely helpful. Thank you very much!

[@torque6389]

Incredibly helpful! Thank you!

[@aquacanleo8303]

You are AMAZING ♥

[@lucindahiwat9216]

Please can we have more of these

[@DataWizardry]

Will do!

[@tabassumhebbalkar]

Thank you so much! Great Help :)

[@DataWizardry]

Happy to help!

[@Aaryansh2568]

Love this project a lot .Thank you so much Also cany you make more videos like this please

[@DataWizardry]

Will do! Am working on a class soon where I will have more projects like this!

[@kanainoue8328]

This is so helpful -- thank you so much!! 👏🙏 Just curious - For 13:01, can I not take the "Patient Age" variable and change it to "Count" for my rows? When I tried that, the line graph result seems to be the same as when you pulled the "Patient Id" count as your row, but just wondering if the alternative way would cause any error in interpretations. (Like I noticed that the row heading would then be changed to "Count of Patient Age," which doesn't sound quite right.) Also, I found something odd in my Patient Race bar graph that my label "498" at the tip of the Native American group at the bottom wouldn't show up for some reason while all other labels for other racial groups did show up after making a duplicate of the "Patient Id CNT" pill to the "Label" box. I also tried enlarging the width of the fields label column but it still didn't work...

[@DataWizardry]

When I do counts, I typically will do one of two things, 1. I'll either use the thing that uniquely identifies every single row (a primary key, which can never be empty), or 2. I'll create a calculation in Tableau that stores a value of 1, and what that will do is just put 1 in every single row. Whichever of those two columns I count on, Tableau will then count every single row. I suppose you could count on age here if you wanted to. You would just need to make sure that there are no missing birthdates in the dataset, which would result in a blank value and give you a lower count that what you actually have. Regarding the missing 498, it's probably missing because the graph had a small width in the bars. When that happens, Tableau tries to hide it to make it more visually readable. There's a couple ways around that. The easiest way is to play with the bar width while lowering the font size, and usually that makes it re-appear. Another way is to go to the Label button (looks like a square with a 'T' under 'Marks'), and click the button that says 'Allow Labels to Overlap with Marks' and this overrides the space limitation issue, forcing it to appear. I hope that's helpful.

[@kanainoue8328]

@@DataWizardry Hi Josh, yes this is really helpful! Thank you so much! Thanks to you, I've finished building my own Tableau dashboard following your video, and I added a data source section to mention the RWFD's ER dataset, but I feel odd not to credit or mention you/your video on my dashboard. So I thought it would be worthwhile asking if you have a preference for citations or mentions to your channel/video on my dashboard in the source/note section?

[@DataWizardry]

@@kanainoue8328 Credit is optional, but if you want to give a shoutout, it would be much appreciated! If you do, doesn't have to be anything fancy, just a "Inspired by Data Wizardry" or something like that.

[@jonathanchung3330]

Hey I love your content and it's really helped me in getting to know the DA field more. A quick question. I'm at 29:05 of the video and when I right click, there's no format option. Would you know why this is the case?

[@DataWizardry]

Hello! I think I see what the problem is. Try viewing this image I uploaded: imgur.com/a/fsQ9EV6 Right click within the white border. If it's even a tiny bit outside of that white border, you won't see the format option. The reason (I think) is because the format option that you see is reserved for worksheets. whereas the space outside that white border is either the title of the worksheet (which, when you right click, will say 'format title'), or the container of the worksheet, which has its own formatting section under the 'layout' tab on the left side panel. I hope that's helpful!

[@jonathanchung3330]

@@DataWizardry Hey I figured out what was wrong. For some reason it doesn't work when I use it on the web version of tableau public so I downloaded the desktop version and it worked! Thanks again for your help and all your content! :)

[@DataWizardry]

@@jonathanchung3330 Thanks Jonathan! Glad you got it figured out! Yeah the web version is sometimes a little buggy.

[@NocturneTheatre]

Thank you for this tutorial! I'm considering using buttons as filters, allowing nine charts to display in three containers: "by hour", "by day of week", and "by month", with toggles for "average wait time", “average satisfaction score”, and "count", where the buttons would affect all three charts. This seems efficient and clean, but do you think it might be too complex for recruiters or a real workplace setting? Would simplicity be better? I’ve been going back and forth on this for hours 😂

[@DataWizardry]

Sounds awesome, I think you should definitely give it a try! It would be great for a portfolio project, and would be good to get the practice building something with these more complex features. If it's a real life work setting though, I usually start simple, and then make my dashboards more complex depending on the needs of the person that I'm working with. If I do end up making something complicated, I try to have documentation or notes somewhere about the complicated stuff I'm building into the dashboard so that if someone else has to maintain the dashboard, it won't be too difficult for them.

[@morilea]

it seems like the the databases you linked is no longer available. do have another link to access it?

[@DataWizardry]

Can you try this one and let me know if it works? data.world/markbradbourne/rwfd-real-world-fake-data/workspace/file?filename=Hospital+ER.csv

[@ankuroberoi017]

Hi, Please share the dataset

[@drishtisinghal9528]

Hey amazing video!! thank you so much!! Where can I get the data file so that I can practice myself

[@senyotsedze3388]

I think the "Patient's Admin Flag" is just to identify if the admitting patient has a certain behavioral issue or exhibit some level of violence so people treating can be cautious.

[@kateguadarrama2413]

What would you do about the null records in patient_sat_score for statistical analysis?

[@DataWizardry]

You could create a calculation that measures the % of null instances over time in a line graph if you wanted to see the response rate of people taking some survey. Then if the % that we see is consistenly below target, the people that monitor patient survey data might come up with a strategy to raise engagement rates, and see if it had any effect on the line graph.

[@Jamila91100]

Hi Thanks for this video ! Do those working in Health care data work 9-5 or can they work 12 hour shifts since they work in the Hospital ?

[@DataWizardry]

I dont think 12 hour shifts are very common. At least, I havent seen this. They are very office-y 9-5 jobs

[@emmanueloware5958]

Hi, quick question....the containers you placed on the sheets after adding the background colors were transparent. My containers have a white background although I specifically choose "none" for the background of my horizontal container. can you help?

[@DataWizardry]

Hello. Can you tell me the exact point of the video (the number of minutes and seconds into the video) where you encountered this problem?

[@M_le-n4r]

Hi, I also wanted to ask about all the nulls in the patient satisfaction score. Theres a large percent of it missing. The median (5.0 and mean (4.99) are very close. Would you fill with the median since it is right in the middle?

[@DataWizardry]

I wouldn't worry about the large volume of nulls. In reality, a small % of your patients are going to be filling out a patient satisfaction survey. Though it might be a good idea to call out the small sample size on the dashboard if this were a real-life setting. For the data that we do have, the decision to use median vs mean will depend on the siutation. I usually use median if there are some very large outliers that could cause the mean to be misleading.

[@shanthankasula5503]

where to download the dataset

[@DataWizardry]

Link should be in the description

[@psachidanandapatro9242]

can you share the dataset file that you downloaded fake one

[@DataWizardry]

Sure, here is the link: data.world/markbradbourne/rwfd-real-world-fake-data, You just need to pick the one that says "Healthcare - Emergency Room"

[@shaikhkashif9973]

Bro I'm trying to dld the given file data but its unable to dld

[@DataWizardry]

For this tutorial, you have to go to this link: data.world/markbradbourne/rwfd-real-world-fake-data, find the link that says "February 28 - Healthcare - Emergency Room". Then it should take you to a website called data.world, where you will need to create a free account. Should be able to access it then.

[@TheRobarbie]

I could not locate the data set for this tutorial. I did notice your vague instruction on prior comments below.