Data Wizardry
Data Wizardry
  • 29
  • 310 685
Tableau Project: How Satisfied are Patients with Their Hospitals?
In this 3-part series, I show you how to build a super cool Tableau dashboard that looks at how satisfied patients are with their hospitals in the United States. This comes from a public dataset called HCAHPS that looks at over 3000 hospitals in the United States.
Video 1: I give you some context about what HCAHPs is, and how it fits into value-based purchasing.
th-cam.com/video/Yq2AesmjSxw/w-d-xo.html
Video 2: you learn how to clean the data in SQL to prepare it for Tableau.
th-cam.com/video/6YwwHfxAfZI/w-d-xo.html
Video 3: you take the finished dataset, and build a Tableau dashboard with it that you can show off in your own portfolio!
th-cam.com/video/9bzu2CxqgcI/w-d-xo.html
// LESSON FILES
To get emailed the data files that you will need for this lesson, sign up here:
datawizardry.academy/hcahps-patient-satisfaction-dashboard/
// FREE WEBINAR!
In this 1-hour webinar, I lay out a roadmap for you to learn how to become a data analyst, and gain healthcare domain knowledge:
datawizardry.easywebinar.live/event-registration
// BECOME A CLINICAL DATA ANALYST!
My course teaches you everything you need to know in just 10-12 weeks:
datawizardry.academy/clinical_analytics_accelerator/
// FURTHER READING & RESOURCES
hcahpsonline.org/
hanys.askflorence.org/Data//Content/EFI/referenceGuide/VBP-2024.pdf
www.qualityreportingcenter.com/globalassets/2022/03/iqr/hvbp_fy2024_qrg_vfinal508u.pdf
// ABOUT DATA WIZARDRY:
Hey I'm Josh! I've been a data analyst in the healthcare industry since 2015. Join me as I teach you how to get a job as a data analyst. I do SQL, Python, Tableau, and Networking tutorials.
🔴 TH-cam: youtube.com/@DataWizardry
🟢 TikTok: tiktok.com/@data.wizardry
🔵 LinkedIn: linkedin.com/in/joshuamatlock/
🔗 Website: datawizardry.academy
#sql #tableau #dataanalytics #dataanalyst #healthcaretechnology #healthcare #career
มุมมอง: 3 215

วีดีโอ

Data Cleaning Project: Patient Survey Data
มุมมอง 4.1K6 หลายเดือนก่อน
In this 3-part series, I show you how to build a super cool Tableau dashboard that looks at how satisfied patients are with their hospitals in the United States. This comes from a public dataset called HCAHPS that looks at over 3000 hospitals in the United States. Video 1: I give you some context about what HCAHPs is, and how it fits into value-based purchasing. Will release March 23rd, 2024 th...
Value Based Purchasing: How Hospitals are Graded on Quality & Safety
มุมมอง 1.1K6 หลายเดือนก่อน
In this 3-part series, I show you how to build a super cool SQL Tableau dashboard that looks at how satisfied patients are with their hospitals in the United States. This comes from a public dataset called HCAHPS that looks at over 3000 hospitals in the United States. Video 1: I give you some context about what HCAHPs is, and how it fits into value-based purchasing. Will release March 23rd, 202...
4 Types of Healthcare Data Analysts Should Know
มุมมอง 12K10 หลายเดือนก่อน
In this lesson, I teach you the essential types of data you will encounter as a data professional in healthcare, whether you're a data scientist, data engineer, data analyst, etc. If you would like to learn even more, check out my website to download a free PDF that explores EHR data in detail. (This is a text lesson from my upcoming clinical analytics accelerator class). ➡️ FREE DOWNLOAD Healt...
Ask a Healthcare Data Analyst - Questions and Answers
มุมมอง 7K11 หลายเดือนก่อน
Today I answer your questions about being a clinical data analyst, and landing a job in the healthcare industry! Thank you so much for your questions! ➡️ FREE DOWNLOAD: SQL Basics in Healthcare: datawizardry.academy/sql-basics-healthcare/ 00:00 - Intro 00:35 - Public Speaking 03:45 - Tech Tools 06:35 - Stakeholders 10:38 - Medical Code Concepts 13:00 - Working Remote 14:10 - CPHQ Certification ...
Learn Tableau Basics in 1 Hour - With Healthcare Data 💊
มุมมอง 37Kปีที่แล้ว
In this lesson, I teach you the basics of navigating Tableau, and how to create basic visualizations to put into a dashboard, using mock healthcare data. Tableau is a critical skill for data professionals, whether you're a data analyst, data scientist, or data engineer. This is actually part of my clinical analytics accelerator course (datawizardry.academy/clinical_analytics_accelerator/). I ho...
💻 Build this Flu Shots Dashboard with SQL and Tableau!
มุมมอง 15Kปีที่แล้ว
In this tutorial we build a SQL extract to plug into Tableau so that we can build a flu shots dasboard! This is a good example of how I might approach a project in my day to day work. To follow the SQL tutorial, check this video out if you haven't already, as you will need it to install PostgreSQL, pgAdmin, and the data files for this lesson: th-cam.com/video/ef4CAu-OwvM/w-d-xo.html If you woul...
Are you making this #1 SQL Error?
มุมมอง 2.3Kปีที่แล้ว
Today I talk about SQL cardinality, which defines the relationships between two SQL tables in a database. We explore how this can lead to repeat rows which can inflate your data later on, when you plug the data into a dashboard or do analysis. Note, all patient data contained within this video is fake, and generated by Synthea. Error @6:11 a many to many will cause extra rows as well. Many to m...
SQL Joins Made VERY SIMPLE!
มุมมอง 4.2Kปีที่แล้ว
Whether you're a data analyst, data scientist, or data engineer, it's vital to understand how joins work in SQL, as it's foundational to how databases work! Watch this video as I explain the core concepts using healthcare data! Part 1 in a series of 3 videos: Video 1: SQL Joins Video 2: SQL Cardinality Video 3: SQL Tableau Portfolio Project If you would like to follow along using the fake patie...
👉 SQL Basics with Healthcare Data | 1 Hour
มุมมอง 41Kปีที่แล้ว
Learn the basics of SQL in this 1 hour tutorial! We will be using a modified version of Synthea, a synthetic patient database. We will also be using a free type of SQL called PostgreSQL to learn how to upload, and query patient data. Update: the header option 16:57 is going to be frozen when you import the txt files. You do not need to click on the header. It will be 'off' by default. 💻 This li...
ETL Made Simple | What Data Analysts Should Know
มุมมอง 13Kปีที่แล้ว
As a healthcare data analyst, I'm often tasked with importing data from external sources. Today, I break down the ETL process as simply as possible, where data gets extracted, transformed, and imported to an environment like SQL. You may also benefit from this video if you are a data engineer, or data scientist! ➡️ FREE DOWNLOAD: SQL Basics in Healthcare: datawizardry.academy/sql-basics-healthc...
Learn How to Become a Healthcare Data Analyst with This Guide
มุมมอง 46Kปีที่แล้ว
Learn How to Become a Healthcare Data Analyst with This Guide Are you looking for a healthcare data analytics roadmap? Look no further! Today I'm breaking down my top tips for becoming a healthcare data analyst (AKA Clinical Data Analyst). 👉 Click here to learn SQL Basics in Healthcare: th-cam.com/video/ef4CAu-OwvM/w-d-xo.html 💊 Want to become a Clinical Data Analyst? Check out my Clinical Anal...
Build an Emergency Room Dashboard in Tableau | Healthcare Data Analyst Portfolio Project
มุมมอง 27Kปีที่แล้ว
Build an Emergency Room Dashboard in Tableau | Healthcare Data Analyst Portfolio Project
Portfolio Ideas for Healthcare Data Analysts that will LAND YOU A JOB!
มุมมอง 18Kปีที่แล้ว
Portfolio Ideas for Healthcare Data Analysts that will LAND YOU A JOB!
ULTIMATE Data Analyst Salary Negotiation Guide
มุมมอง 1.9Kปีที่แล้ว
ULTIMATE Data Analyst Salary Negotiation Guide
Healthcare Data Analyst Career Tips | How to Excel in your Industry
มุมมอง 3.9Kปีที่แล้ว
Healthcare Data Analyst Career Tips | How to Excel in your Industry
Being a Data Analyst in Healthcare isn't for Everyone
มุมมอง 7Kปีที่แล้ว
Being a Data Analyst in Healthcare isn't for Everyone
How I Became a Data Analyst in Healthcare
มุมมอง 21Kปีที่แล้ว
How I Became a Data Analyst in Healthcare
The BEST Industry for Data Analysts
มุมมอง 5Kปีที่แล้ว
The BEST Industry for Data Analysts
Python Tutorial: Programming a Retirement Calculator for Beginners
มุมมอง 1.2Kปีที่แล้ว
Python Tutorial: Programming a Retirement Calculator for Beginners
SQL Interview Questions Practice 1 - Filters with Multiple Steps
มุมมอง 1.2Kปีที่แล้ว
SQL Interview Questions Practice 1 - Filters with Multiple Steps
What it's like to be a Healthcare Data Analyst
มุมมอง 17Kปีที่แล้ว
What it's like to be a Healthcare Data Analyst
How to Become a Data Analyst: Part 2 - Getting a Job
มุมมอง 2.4Kปีที่แล้ว
How to Become a Data Analyst: Part 2 - Getting a Job
Building Nintendo Switch Dashboard in Tableau - Tutorial
มุมมอง 1.2Kปีที่แล้ว
Building Nintendo Switch Dashboard in Tableau - Tutorial
Deadly Data: Creating Pareto Charts in Tableau
มุมมอง 1.8Kปีที่แล้ว
Deadly Data: Creating Pareto Charts in Tableau
How to Become a Data Analyst: Part 1 - Skill Development
มุมมอง 4.3Kปีที่แล้ว
How to Become a Data Analyst: Part 1 - Skill Development

ความคิดเห็น

  • @fatimaa-q6f
    @fatimaa-q6f วันที่ผ่านมา

    Thanks

  • @fatimaa-q6f
    @fatimaa-q6f วันที่ผ่านมา

    Thanks

  • @dylanmariano6993
    @dylanmariano6993 2 วันที่ผ่านมา

    Do you consider yourself a Reporting Analyst? This is a common title for me to stumble upon in my search for Healthcare Data Analyst positions. Thanks!

  • @GauravLakshmipathy
    @GauravLakshmipathy 3 วันที่ผ่านมา

    Hey Josh!. Can i get more details on how to get EPIC certification? How to find hospitals sponsoring for EPIC?

  • @ph1lny3
    @ph1lny3 4 วันที่ผ่านมา

    I'm having two problems with a similar dashboard I'm building. I'm doing a broader quality dashboard that works with star ratings (which would be the closest equivalent to patient satisfaction), and I think I know how I can build it. However, 1. According to our wiki, the content is deprecated as of 2020, which means maintaining it will be an uphill battle. There are a lot of workbooks for this source, no wonder they dropped it. 2. CMS Star Quality Review is nebulously tucked into our Oracle Health data objects. I've seen it in the Cerner wiki, but I cannot find it in any of our available views on the server.

  • @fazdatasciencetechcodingml5662
    @fazdatasciencetechcodingml5662 5 วันที่ผ่านมา

    Great breakdown

  • @josephbennett7162
    @josephbennett7162 9 วันที่ผ่านมา

    This guy Claritys

  • @jhonfir2235
    @jhonfir2235 12 วันที่ผ่านมา

    Nice to see this Tutorial,

  • @elizabethacosta-rayos6061
    @elizabethacosta-rayos6061 14 วันที่ผ่านมา

    Can a nurse with a BSN become a data analyst without going back to college?

    • @DataWizardry
      @DataWizardry 7 วันที่ผ่านมา

      Absolutely. As long as you have the tech skills and a portfolio.

  • @brandongreen8895
    @brandongreen8895 16 วันที่ผ่านมา

    Also, is your course only for breaking into clinical postions? I want to break into a tech analyst role

    • @DataWizardry
      @DataWizardry 16 วันที่ผ่านมา

      Great question The class is mostly geared towards people that want to become data analysts that work in hospitals. Here are more details: datawizardry.academy/clinical_analytics_accelerator/

  • @brandongreen8895
    @brandongreen8895 16 วันที่ผ่านมา

    For your course is it ok if we have. macbook ? I have been having trouble getting an sql server on my macbook

    • @DataWizardry
      @DataWizardry 16 วันที่ผ่านมา

      Yes, but instead of using SQL Server, we use PostgreSQL, which is compatible with Macbooks

  • @nithya8121
    @nithya8121 17 วันที่ผ่านมา

    why can't we upload the same in mysql?

    • @DataWizardry
      @DataWizardry 17 วันที่ผ่านมา

      You could if you wanted to. The syntax will just be different.

  • @chiomaozurumba2060
    @chiomaozurumba2060 19 วันที่ผ่านมา

    An error message popped up ' the PgAdmin 4 server could not be contacted' after I completed the download

    • @DataWizardry
      @DataWizardry 16 วันที่ผ่านมา

      There might be a bug in the latest version of PgAdmin. Are you using windows? If so Try this here: th-cam.com/video/9w5zrGqeXBU/w-d-xo.html If that doesn't work, you could also try uninstalling PgAdmin, and then downloading and older version of PgAdmin and installing that instead.

    • @chiomaozurumba2060
      @chiomaozurumba2060 12 วันที่ผ่านมา

      @@DataWizardry Yes. Im using windows.

    • @DataWizardry
      @DataWizardry 12 วันที่ผ่านมา

      @@chiomaozurumba2060 Ok. Did you follow the video that I linked in the reply? (th-cam.com/video/9w5zrGqeXBU/w-d-xo.html)

  • @shanthankasula5503
    @shanthankasula5503 19 วันที่ผ่านมา

    where to download the dataset

    • @DataWizardry
      @DataWizardry 16 วันที่ผ่านมา

      Link should be in the description

  • @yadavmahendra6161
    @yadavmahendra6161 21 วันที่ผ่านมา

    I hold a b pharm degree wanted to become a data analyst what to do ? where can i learn start from scratch any suggestions???

  • @faacam
    @faacam 23 วันที่ผ่านมา

    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

  • @GideonDodziNuvor
    @GideonDodziNuvor 24 วันที่ผ่านมา

    This is a great help - thank you

  • @igbegrowth4442
    @igbegrowth4442 หลายเดือนก่อน

    Thanks for this video

  • @akaneokita
    @akaneokita หลายเดือนก่อน

    Thank you❤gonna try this

  • @JalalUddin-nn3yb
    @JalalUddin-nn3yb หลายเดือนก่อน

    Would u plz generous enough to suggest effective Healthcare bootcamp or certification coures.

    • @DataWizardry
      @DataWizardry หลายเดือนก่อน

      Sure, the only one I know of is my course. Here it is if you're interested: datawizardry.academy/clinical_analytics_accelerator/

  • @psinka1292
    @psinka1292 หลายเดือนก่อน

    amazing, thank ou so much. do you have any sample python etl code you could share?

  • @jezdel6298
    @jezdel6298 หลายเดือนก่อน

    👏👏👏. Thank you so much for this tutorial.

  • @TalKhg
    @TalKhg หลายเดือนก่อน

    Hi Good morning! Thank you for your insight into this field. I have recently graduated this past June from medical billing and coding program and I am CPC certified. Previously I’ve trained as a medical assistant. I have decided to further my education and obtain my associates degree in health information technology. Graduating from medical billing and coding gave me an advantage because i was able to bypass any requirements and be placed directly into the program. Also, I have already taken the majority of the classes for health information technology in The medical coding program so I’m half way through. My goal is to work as a coder while in the program and after I graduate, I would love to work as a Healthcare data privacy analyst. Will this be feasible for me with only my associates in HIT and my CPC. I will continue to develop skills in SQL, Python & Tableau as needed. Great content btw, I’m a new subscriber.

  • @ezhankhan1035
    @ezhankhan1035 หลายเดือนก่อน

    This is a great help - thanks!

  • @haley5803
    @haley5803 หลายเดือนก่อน

    Thank you so much for making this! Extremely helpful.

  • @S.Kaimal
    @S.Kaimal หลายเดือนก่อน

    If I manually create age bins (e.g., 0-5, etc.) as a dimension and then plot it against a measure (row count), the result is a bar chart that displays the frequency of data within those bins. However, if I choose age, Tableau automatically determines the bins based on the data's distribution and creates the histogram. Thank you for this amazing presentation! ❤❤

  • @lilrabbitcuz
    @lilrabbitcuz หลายเดือนก่อน

    Hello, I was able to follow your steps up until importing the condition text file. I have downloaded them on to my Mac M1 but unable to import the text file. What I tried doing is manually typing the path in the file name box and then click ok but after I do this I get the Copying table data public.conditions on database Postgres and server pg15 It also says no such file or directory. When I click on the file button the files are greyed out and I am not able to upload them. Please advise

  • @ThapeloMakgoa
    @ThapeloMakgoa หลายเดือนก่อน

    josh i cant find the immunization table

  • @Kingco245
    @Kingco245 หลายเดือนก่อน

    Hi Josh, I want to become a healthcare data analyst and I have zero experience in healthcare 😩. But I know Excel and SQL. I am thinking of applying for a master’s in Health Informatics. Do you think this can give me the domain knowledge and analytical skills needed in healthcare?? Thanks!

    • @DataWizardry
      @DataWizardry หลายเดือนก่อน

      Health informatics is a solid choice. One of the smartest data analysts I know has a Masters in Health Informatics. That said, Masters degrees are expensive, and there are ways you can get experience instead of enrolling in a program. You could try landing a data-adjacent job like: program coordinator, research coordinator, etc. where they use things like Excel and SQL. You could work in a position like that for maybe 6 months, then start applying for data analyst positions.

    • @Kingco245
      @Kingco245 หลายเดือนก่อน

      You don’t know how much it means to me that you are replying, man🥲. Thanks! Navigating these things is easier with some guidance. Do you mean getting the named jobs in the healthcare industry to get some healthcare experience?

    • @Kingco245
      @Kingco245 หลายเดือนก่อน

      Again, I live in Nigeria but have always dreamed of practicing in the U.S., that is why I want to take the Master’s study route. I cannot afford the expensive tuition, but I cannot fold my hands and let my dreams die either. I am hoping to get a scholarship for my studies and I know God won’t let me down. With that out of the way, if you think there is a cheaper or easier-to-finance degree that facilitates the same purpose, I'm happy to hear it.

  • @sumitnerkar4101
    @sumitnerkar4101 หลายเดือนก่อน

    Josh Please problem Statement of the Project

  • @Kingco245
    @Kingco245 หลายเดือนก่อน

    What is epic, mate?

    • @DataWizardry
      @DataWizardry หลายเดือนก่อน

      Epic is a popular Electronic Medical Record system used in the United States. It has the biggest marketshare out of all the EMRs, and is used at many hospitals (Cerner is the other big one).

    • @Kingco245
      @Kingco245 หลายเดือนก่อน

      Thanks!! I’m thankful for finding your channel; I subscribed immediately! I want to pursue a master’s program in the U.S to become a healthcare data analyst. Do you think I should go for health informatics or health analytics?

  • @SayingsShrine
    @SayingsShrine หลายเดือนก่อน

    Hi Josh, I completed my Doctor of Pharmacy degree in India and recently finished my Master’s in Health Informatics. For the past year, I have been trying to find a healthcare data analyst job, but unfortunately, I am still searching as I don’t have any experience. Could you please provide any suggestions for job searching for freshers like me?

    • @DataWizardry
      @DataWizardry หลายเดือนก่อน

      My advice would be to start networking. Heres one example of networking: You probably know a lot of classmates and professors from your PHD. Try reaching out to them; have a coffee chat with them to see what advice they have for you. One of them is bound to know someone who works in analytics that may help you land a job.

  • @ΚωνσταντίνοςΡουσοχατζάκης
    @ΚωνσταντίνοςΡουσοχατζάκης หลายเดือนก่อน

    Thanks a lot about this video. I want to learn healthcare data analytics and to find a job (remote is better) in this field. I studied mathematics and medicine (undergraduate) and I don't know how to find the right way and root to work as a healthcare data analyst. I want you opinion and your advice. Thanks a lot! A lot of greetings from Crete!

  • @Edeborr
    @Edeborr 2 หลายเดือนก่อน

    Could anyone in the comment section please confirm if data analyst in healthcare can be done remotely

    • @DataWizardry
      @DataWizardry หลายเดือนก่อน

      It's pretty common. I've been fully remote since 2020.

    • @Edeborr
      @Edeborr หลายเดือนก่อน

      @@DataWizardry I appreciate you

  • @Edeborr
    @Edeborr 2 หลายเดือนก่อน

    Thanks for your videos!!!

  • @MelissaRodriguez-yq7ek
    @MelissaRodriguez-yq7ek 2 หลายเดือนก่อน

    I am curious to know how does one account for the null values in hcahps_answer_percent, num_completed_surveys, survey_response_rate_percent in the hcahps dataset?

  • @2thepoint88
    @2thepoint88 2 หลายเดือนก่อน

    May God bless you and grant you health wealth and success ameen regards.

  • @nikkitheevixen
    @nikkitheevixen 2 หลายเดือนก่อน

    Thank you for this video! Super helpful.

  • @shaktimaan7963
    @shaktimaan7963 2 หลายเดือนก่อน

    Hi If I want to add this project in my resume, is there some way to add numbers to my bullet points, can I quantify this project so that it would look more impactful? Thanks for this amazing tutorial though❤

  • @KeertiReddyResapu
    @KeertiReddyResapu 2 หลายเดือนก่อน

    where can i see the data file

  • @JEREMIAHOKEDINACHI
    @JEREMIAHOKEDINACHI 2 หลายเดือนก่อน

    You are too good brother. I am loving this. My background is Healthcare Management.

  • @MelissaRodriguez-yq7ek
    @MelissaRodriguez-yq7ek 2 หลายเดือนก่อน

    Hello, so I have completed this project and would love to put this on my portfolio for recruiters as a data cleaning project. However, I am curious from where this specific dataset came? Also, was it also precleaned?

    • @DataWizardry
      @DataWizardry 2 หลายเดือนก่อน

      Yes, I did some pre cleaning steps before the video. The data comes from data.cms.gov. It's the HCAPS dataset.

    • @MelissaRodriguez-yq7ek
      @MelissaRodriguez-yq7ek 2 หลายเดือนก่อน

      @@DataWizardry Ok, thanks so much! Your videos have inspired me to give clinical analytics a try. :D I am also curious to know what is the difference between a clinical data analyst, and a health informatics analyst?

  • @eldhenfajardo2204
    @eldhenfajardo2204 2 หลายเดือนก่อน

    amazing presentation, thanks!

  • @AmandaAndreano-o4p
    @AmandaAndreano-o4p 2 หลายเดือนก่อน

    I was this video through my college class at Bryan University. if you didn't know your famous :) These videos are amazing! You speak my language!

    • @DataWizardry
      @DataWizardry 2 หลายเดือนก่อน

      Awesome! Glad to know my videos are useful!

  • @humanearth_
    @humanearth_ 2 หลายเดือนก่อน

    This is exactly what I need 😢

  • @MpumehS
    @MpumehS 2 หลายเดือนก่อน

    Thank you for the tutorial, I'm having issues accessing the dataset. I've signed up on the website, however, I'm not receiving the email with the link to the dataset.

    • @DataWizardry
      @DataWizardry 2 หลายเดือนก่อน

      I think I saw your email, and you should have a new email reply with instructions.

  • @Wds__wsd
    @Wds__wsd 2 หลายเดือนก่อน

    Hi this is the error I got. Can you please help me? When trying to create the table at the end Column “provider_ccn” specified more than once

  • @marwanelsadat2349
    @marwanelsadat2349 2 หลายเดือนก่อน

    Perfect, thank you