ETL Made Simple | What Data Analysts Should Know

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-basi...
// 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.
To learn more about my upcoming clinical analytics accelerator course, check out: datawizardry.academy/accelera...
🔴 UA-cam: / @datawizardry
🟢 TikTok: / data.wizardry
🔵 LinkedIn: / joshuamatlock
🔗 Website: datawizardry.academy
#dataanalytics #dataanalyst #sql #etl #healthcaretechnology #data #datanerd

[@richard34urp]

We must protect this guy at all cost. He’s throwing amazing real life specific knowledge. Thank you Sir!

[@ericaleverson9430]

I am a data analyst who wants to go back into the healthcare domain. I'm over here binging on your videos to prepare me for my upcoming interview. Thank you for this content!!

[@DataWizardry]

Hi Erica!
Glad these have been useful for you. Good luck on your interview!

[@konata_fan]

Estos videos me han ayudado a cambiar mi realidad laboral. Muchas gracias por este canal.

[@dk_analytics]

Another clear and simple healthcare analytics video. Glad I'm building my portfolio with your help! I did a large ETL Project between different EHR systems a few years ago as a medical scribe when my clinic was being integrated into a large hospital system

[@DataWizardry]

Thanks Danial!

[@harrylinn8249]

I really appreciate it. I am facing a hard time to differentiate what is ETL and what is data wrangling. Now, I think I start to see the whole picture but still need a lot of reading and watching videos. LOL

[@maxes26a95]

Such a uefull video for a beginned analyst. Thank you sir!

[@DataWizardry]

Sure thing!

[@cherry6280]

Really awsome content. I learned something

[@GameFuMaster]

1:54 however... you can always fit anything through the square hole

[@nanbress7175]

Love your use of text animation and icons/graphics. What programs and tools do you use to generate and edit these? Do you ever make high level, short videos to disseminate your key findings to internal stakeholders? Can video-making skills be part of the portfolio for a data analyst in health care given the trend toward passive learning?

[@DataWizardry]

Hi @nanbress7175, for these videos I use camtasia for video editing, and canva for my images/animations.
It's not common to share short videos with your stakeolders using these tools (at least in my experience, i havent done this), usually you are just presenting the results in a live dashboard.
I suppose you could though if you wanted to make a tutorial about a particular tool or dashboard for somebody at your work.
I wouldn't use it to disseminate analytical findings though, as video editing already takes a good portion of time, in addition to the analytical work it entails.

[@cali4484]

🤢