- Видео 31
- Просмотров 364 045
Data Wizardry
США
Добавлен 4 янв 2023
Hey everyone, my name is Josh Matlock. I am a data analyst in the healthcare industry, and have been doing this for 8 years. Check out my channel for data career advice, and sql, tableau, and python tutorials with a healthcare focus!
Note: all data I display in my videos are either publically available (i.e. containing no protected health information - PHI), or is synthetically generated (i.e. fake).
Note: all data I display in my videos are either publically available (i.e. containing no protected health information - PHI), or is synthetically generated (i.e. fake).
How I use ChatGPT as a Data Analyst
Generative AI like Open AI's ChatGPT can make your job as a data analyst much easier! However, before you use ChatGPT, you should have some understanding of how it works, and its proper use in analytics. I break down how I use generative AI as a clinical data analyst, and some pitfalls to avoid as well.
00:21 - What is ChatGPT?
02:03 - How ChatGPT Works
06:00 - LLMS
08:02 - Clinical Analytics Free Webinar
09:11 - How I Use ChatGPT as a Data Analyst
14:03 - Pitfalls of ChatGPT
19:55 - Closing Thoughts
// FREE 1 HOUR DATA ANALYTICS WEBINAR!
I provide a curriculum on how to become a clinical data analyst. Check it out here:
datawizardry.easywebinar.live/event-registration
// BECOME A CLINICAL DATA ANAL...
00:21 - What is ChatGPT?
02:03 - How ChatGPT Works
06:00 - LLMS
08:02 - Clinical Analytics Free Webinar
09:11 - How I Use ChatGPT as a Data Analyst
14:03 - Pitfalls of ChatGPT
19:55 - Closing Thoughts
// FREE 1 HOUR DATA ANALYTICS WEBINAR!
I provide a curriculum on how to become a clinical data analyst. Check it out here:
datawizardry.easywebinar.live/event-registration
// BECOME A CLINICAL DATA ANAL...
Просмотров: 1 312
Видео
Soft Skills 101 For Data Analysts: SDLC
Просмотров 1,1 тыс.2 месяца назад
Want to know what separates good data analysts from AMAZING data analysts? Hint: it's not necessarily your mastery of hard skills like SQL, Tableau, ETL, etc. Instead it's all about the soft skills. In this video, I break down a framework called the Software Development Life Cycle (SDLC), to help you hone your data analytics soft skills quickly. 00:00 - 04:11 - What is SDLC? 04:11 - 07:30 - Ste...
Tableau Project: How Satisfied are Patients with Their Hospitals?
Просмотров 4,2 тыс.8 месяцев назад
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. ruclips.net/video/Yq2AesmjSxw/ви...
Data Cleaning Project: Patient Survey Data
Просмотров 5 тыс.8 месяцев назад
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 ru...
Value Based Purchasing: How Hospitals are Graded on Quality & Safety
Просмотров 1,4 тыс.8 месяцев назад
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
Просмотров 16 тыс.Год назад
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
Просмотров 8 тыс.Год назад
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 💊
Просмотров 42 тыс.Год назад
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!
Просмотров 17 тыс.Год назад
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: ruclips.net/video/ef4CAu-OwvM/видео.html If you woul...
Are you making this #1 SQL Error?
Просмотров 2,7 тыс.Год назад
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!
Просмотров 5 тыс.Год назад
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
Просмотров 47 тыс.Год назад
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
Просмотров 18 тыс.Год назад
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
Просмотров 53 тыс.Год назад
Learn How to Become a Healthcare Data Analyst with This Guide
Build an Emergency Room Dashboard in Tableau | Healthcare Data Analyst Portfolio Project
Просмотров 31 тыс.Год назад
Build an Emergency Room Dashboard in Tableau | Healthcare Data Analyst Portfolio Project
Portfolio Ideas for Healthcare Data Analysts that will LAND YOU A JOB!
Просмотров 21 тыс.Год назад
Portfolio Ideas for Healthcare Data Analysts that will LAND YOU A JOB!
ULTIMATE Data Analyst Salary Negotiation Guide
Просмотров 2,1 тыс.Год назад
ULTIMATE Data Analyst Salary Negotiation Guide
Healthcare Data Analyst Career Tips | How to Excel in your Industry
Просмотров 4,2 тыс.Год назад
Healthcare Data Analyst Career Tips | How to Excel in your Industry
Being a Data Analyst in Healthcare isn't for Everyone
Просмотров 8 тыс.Год назад
Being a Data Analyst in Healthcare isn't for Everyone
How I Became a Data Analyst in Healthcare
Просмотров 23 тыс.Год назад
How I Became a Data Analyst in Healthcare
Python Tutorial: Programming a Retirement Calculator for Beginners
Просмотров 1,3 тыс.Год назад
Python Tutorial: Programming a Retirement Calculator for Beginners
SQL Interview Questions Practice 1 - Filters with Multiple Steps
Просмотров 1,3 тыс.Год назад
SQL Interview Questions Practice 1 - Filters with Multiple Steps
What it's like to be a Healthcare Data Analyst
Просмотров 19 тыс.Год назад
What it's like to be a Healthcare Data Analyst
How to Become a Data Analyst: Part 2 - Getting a Job
Просмотров 2,5 тыс.Год назад
How to Become a Data Analyst: Part 2 - Getting a Job
Building Nintendo Switch Dashboard in Tableau - Tutorial
Просмотров 1,3 тыс.Год назад
Building Nintendo Switch Dashboard in Tableau - Tutorial
Deadly Data: Creating Pareto Charts in Tableau
Просмотров 1,9 тыс.Год назад
Deadly Data: Creating Pareto Charts in Tableau
How to Become a Data Analyst: Part 1 - Skill Development
Просмотров 4,6 тыс.Год назад
How to Become a Data Analyst: Part 1 - Skill Development
Hi, Please share the dataset
Yooooo he passed away...This is iNSANE. Josh was an AMAZING teacher.
I have 8 years as a Physical Therapist Assistant including hospital and EPIC use as a clinician. The documentation and patient loads in outpatient and hospital setting were just too much for me to handle and I left the field and retired my license. I have been working for over a year now running a machine in a factory that folds and glues food grade boxes like take out containers. At first it was AWESOME because I never had paperwork, no meetings to attend, and no life or death choices to make like in a hospital (even PTA's get to do CPR if in the right place at right time). I have since experienced excessive depression, anxiety, and PTSD exacerbated by loud factory noises and constant deadline pressure. I decided 2 weeks ago to begin pursuing data analysis and your videos have helped me feel more confident about pursuing healthcare statistics. Cheers 😀
*J-CO walks into building* *Imperial trooper music playing overhead*
are nodes useful for tracking data lineage?
Thank you for the tutorial, extremely helpful.
Hi sir ...iam madhukar...,B.pharmacy graduation 12 year career gap...any possibility in health care data analytics as a fresher.... please give me suggestions...👏
I really need more of these.
Hello, Am I eligible for Healthcare Data Analyst as An Arts Student? I earned an IBM Data Analyst Certificate and am familiar with Excel, SQL, Power BI, and Python. Thank you.
بقوة الله حصلت على هدف الوظيفة بالمسمى الوظيفي الي تمنيته بالمكان الي رغبت فيه ،،كيف كان حصولي على هذا الهدف سهل ومبارك لك الحمد و الشكر يارب .. اليوم الأول ✅
I could not locate the data set for this tutorial. I did notice your vague instruction on prior comments below.
I can't find the dataset used for the tutorial. Please help
Hi, thank you so much for the informative video. My question is do you also recommend stuff to the hospital based on the data visualization, or you just handle them the visualization of the medical data and they decide what to do with this information? Do you conduct a research in these reports, besides the visualization of the medical data?
I'm BCA student,hw to join health care data analytics.
Thank you for this amazing tutorial...
Thank you so much for such detailed and easy to understand video. Great tutorial!
Please I’m lost, my hospital_beds_prep as () code isn’t working Keeps saying error
Do you think within 5-10 years, AI will replace analysts?
Thank you so much for great video. You are very good at explanation.Great help.😊
Please is there a reason I can’t use MySQL?
Hello, amazing video! I do however have a question for you. Where can I find the fresh data. Is there specific govt. website you got this from? Also, is this real or mock data that you are using? Thanks.
I have a degree in nutrition, but I’ve been working in an unrelated field for some time. Recently, I developed an interest in data analysis, particularly in the healthcare sector. Do you think it’s possible for a foreigner, like myself (I’m Brazilian), to secure a remote data analysis job in the U.S.?
Hi Josh, thanks for this video. Question -why do you not include ; at the end of your statements?
How do you get epic certified
I'm BCA student , I eligible for the course.please reply
So after all that in the maintain and support does it get to a point where the dashboard gives the information that they need what happens next? Or you got always something in point to work
Please share health care data analysis courses provided platform s.I expect you, thank you.
Just wanted to let Josh’s fans know that he passed away in early November 2024. He was so happy to share his wealth of knowledge, and I’m glad folks can continue to benefit from it.
What happened to him?
Complete freak accident, a tree fell on his car. Both him and his wife were killed 😢 I only found the channel 5 minutes ago - so tragic to learn this. RIP Josh
Seriously 😢
No 😭😭 RIP. I love his videos
I absolutely enjoy the way you teach.
Hi, can you create a detailed video on RWE claims database analysis?
Thanks Josh. Ur videos are inspiring. I would love to take the full course but i am having financial constrain. Can i get financial aid. I already got training in mysql, powerbi and excel. I want to work with healthcare data
where to get conditions.txt file
What would you recommend certification wise just a data analytics or ?
cannot access your dataset. can you please provide a github/ google drive link?
Send me an email at Josh@datawizardry.academy and I can help.
How can I be an Epic Certified?
Found a post you made on Reddit. Been watching your content a lot the last couple days! I’m studying to be a data analyst and considering the healthcare industry. You’ve been a huge help in my research. Thank you!
it seems like the the databases you linked is no longer available. do have another link to access it?
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
Not able to connect to server Admin please Advice
I just got a job as a pharmacy data analyst. Im an 8 years experienced pharmacy technician (CPhT) w/ a BS in Health Information Management (HIM)
Congrats!
What was your educational background? programming or management information systems?
Neither; I earned a Masters in Health Administration, and started as a quality consultant (though knew some Excel and Tableau). Then the data analyst in my department retired, and I took her place and learned SQL
thank you for making you content im a current biomedical engineering student who wants to get a 2nd degree in data science and AI your videos help so much
Haha! Lazy until that QA sends a msg ;)
This series is great and we need part 3. Thank you so much. Watching from Egypt
Hello sir, I'm an ex lab technician. Now I'm learning data analysis. I've done two courses from google, Data analysis and Advanced Data Analysis. Now I'm pursuing another course, that is 'AI in Healthcare ( Stanford's)' from Coursera. What do you think sir? Will these courses helps me start my career as Healthcare Data Analyst.
I have a degree in Nutrition Health Science. Do you think learning and getting the Google data analytics certificate is worth it? Will my degree with the certificate help me get a job in healthcare data analytics (obviously have various projects as well to show experience)?
I am leaning towards Data Analyst in the Healthcare domain. Thank you for sharing your knowledge.
I cant find the data in your website.
Theres a few files you will need, so they get emailed to you with instructions by signing up here: datawizardry.academy/sql-basics-healthcare/
Hi Josh, Hopefully you still operate this channel or perhaps someone else could assist. I attempted to follow along with the video. When you were in github and selected "copy raw contents", on my side it read "copy raw file". When I attempt to import the data, my downloads list as "Create_New_Tables.sql", instead of downloading the individual .txt files(conditions, Patients, etc.). The data is not loading into the tables. :( Any idea for a work around or where I went wrong?
Hello! I found your content on tiktok and later on reddit and your “How I became a Healthcare Data Analyst” and “Healthcare Data Analyst Roadmap” posts were so inspirational because I am currently in the same situation!! 😭 I am finishing up my physiology degree (hoping to squeeze in a Stats minor in this last year), but I am now looking to switch to data analysis and it seems my next step should be finding a data related healthcare job. I was wondering if you could explain a bit more about the roles you recommended (Project assistant, program coordinator, research coordinator, data entry/abstractor) like what the roles entail and which would be most relevant to data analysis? I also completed EMT and Medical Assistant coursework, do you think it would be helpful to work a bit as either of those or just go straight for data related jobs since I am locked into data analytics at this point?
Of the jobs that you mentioned, project assistant or research coordinator/assistant can be particularly good precursor jobs for analytics if they involve SQL, Redcap, Excel, PowerBi or Tableau. So look for those keywords in the job description. The roles will vary a lot. The ones you want will involve building surveys, collecting and managing data from surveys. Working with spreadsheets. Doing data entry, etc. Usually fpr supporting research studies of quality improvement projects. If you dont feel ready to apply to data analyst positions yet, these precursor jobs can be a good launchpad. Especially if you volunteer to work on more analytical projects in your first job. Having clinical experience like being a medical assistant might help, but most of my colleagues dont have any direct clinical experience.
@@DataWizardryThank you so much for the help!! I ended up finding a couple data visualization internships which I will be applying for soon. So I’ll definitely be using your tips to learn a few tech skills and interview well 😁