Yeah, we really do...am happy I found you. I will love u b my mentor as a Healthcare analyst. Still waiting for your course. Can't wait

One question, is have MBA in Healthcare necessary as a health care analyst

@@stevetheanalyst No i dont think its necessary

yess sir

PT here.

Have you guys joined any academy or any certifications?

Thanks Esther! Glad it was easy to follow!

That's awesome, I also did data abstraction. Glad you're enjoying the videos!

Sure thing! Good luck! Fingers 🤞

Ditto.

@Cloak2248 Thank you for your kind words! I am working on a website to store my tutorials and am collecting testimonials. Would it be okay if I list your comment as a testimonial on my website?

Glad you're liking it!

Same. If you want you can checkout my channel, i have SQL projects on healthcare data.

Yes he is the best youtuber from whom i learned many new concepts. If you want you can checkout my channel, i have projects on healthcare data.

Will do!

Thank you!

Glad it's been helpful!

Thank you!

Glad you're liking my videos, welcome to the channel!

Thanks @sebastianquirarte6705!

Glad they were helpful!

Thanks @Vikramhhj! Yup, I can definitely do SQL + PowerBI videos in the future!

Sure thing!

Glad my videos have been helpful!

Yeah bro he hasn’t heard of Nepal. Lol what even?! 😂😂

Great idea! I'll add it to my list. Will also be doing a Q&A in the near future that might be a good opportunity for this.

Glad you liked it!

Yup, I'll be doing some more of these videos in the future! In the meantime, I have this one if you haven't seen it already: kzfaq.info/get/bejne/iLGCe9Kr1LnQhp8.html, an ED dashboard tutorial. Although, it isn't based off of the more realistic-looking synthea data. Will make a dashboard off of the Synthea data soon!

If you are looking for data entry jobs, look for job titles like: "data abstraction". Not a lot of experience needed other than Excel experience, (and ideally, a Bachelor's degree)

Hi Steve, great question! The course will be a 10-12 week program, designed to build all the skills you need to become a data analyst in healthcare. It will be more focused on writing queries in SQL, creating dashboards in Tableau, and networking to land your first job. I haven't decided yet if I'll include Excel; while Excel is a great first tool to learn in data analytics, I find myself using SQL and Tableau much more often. Usually, when I do work in Excel, it's to simply reverse-engineer the manual processes that other people maintain so that I can learn how to replace that manual process with an automatic one. So I'm considering having a section where I talk about that. I hope that's helpful!

@@DataWizardry that really helped. Pls when is it coming and is it affordable. Cos I need it

@@stevetheanalyst At this point, I'm still doing research on what a good price will be. What I'll probably do is start small and have a beta testing where I'll release it at a cheaper price for a small group of people (maybe 10 to 20 people), that group would take the class, provide feedback to me, and then I would tweak it, make it better, and then release the final version with improvements. This cheaper, initial round would probably be sometime in September this year.

@@DataWizardry hope to be part of the few people selected

@@stevetheanalyst Sure! Feel free to send me an email: sqlsorcery@gmail.com and I'll email you when it's ready!

You can access the lesson files by providing your email here: datawizardry.academy/sql-basics-healthcare/

Can you please share the datasets with me if you received it from Josh or his team?

There will be! I'll be doing another video soon where I'll talk about joins, and relationship cardinality (one to many, one to one, etc.). I also plan to do a third video where I apply all of the sql concepts and build a dashboard in Tableau. Maybe sometime later this month.

@@DataWizardry thanks a lot !!

I would say, any of these is fine to learn on. Once you've learned one SQL language, you've pretty much learned them all. There's only slight differences between the languages, but you should be easily able to pick up other languages very quickly once you've learned the first.

iam not accessing the text files to fill our empty tables!! i cant access the website where the data is, i will be happy fro your reply

Hi Dominic, there's a file that you have to download from the mitre corporation and then interact with using a command prompt. I'll do a video on it in the future! But if you want to learn more, I would recommend checking out the synthea git hub wiki.

Hello, A couple users have reported the connection to pgAdmin lost error, so I'll take a look at this and get back to you with my findings. It seems like this is a bug some people are experiencing with a newer version of PgAdmin. If I can't find a resolution, then I'll post a follow-up video that shows you how to install a different graphical user interface (GUI). In the meantime, you could try: 1. Closing and rebooting Postgres (make sure you're logged into your server, and there isn't a red x anywhere on the left panel) 2. Reinstalling Regarding the header issue. That is going to be locked by default, and you won't be able to adjust that. So I don't think that is causing the issue.

Alright. Thankyou very much.

@@florenceosuagwu2422 If you're still having issues, what I would do is: first check what version of PgAdmin you're using. Then uninstall PgAdmin, and install a different version. Here is the link: www.pgadmin.org/download/ I was using version 7.2 and it was working for me. If you are using Windows as your operating system, what you need to do is go to add or remove programs, then go to PostgreSQL to initiate the uninstall process, and as you're doing the uninstall, click the uninstall individual components option, and only click PgAdmin. What that will do is just remove PgAdmin, but not the PostgreSQL. I hope that's helpful!

Hi Yang, once you sign up for the lesson files, the email that gets sent should give you instructions for 2 steps: 1. Unzip the folder (which only contains 3 files, patients, conditions, immunizations) 2. Follow this link for encounters (it's really big, so I had to put it in dropbox): www.dropbox.com/scl/fi/914gq2qrej6enwwaoc5vp/encounters.txt?dl=0&rlkey=uwc55hnx2d16kmcuvvampefkb Try step #2 to download the remaining file.

@@DataWizardry Josh can you please create a dropbox of all the text files. I tried following your instructions but never got an email with lesson files.

Aiming for a beta version in late Sept, early Oct.

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

Hi @queenylau4400, I don't think I've used power query before, but my understanding is that it's sort of like a data prep tool that can be used in Microsoft products like PowerBI, so cleaning and prepping the data before it gets ingested into a reporting tool. Data cleaning can be handled in lots of ways, and there's lots of tools for that. Personally, I usually use SQL for most of my cleaning, and Python for difficult cases that aren't easily handled by SQL. But powerquery might also be a suitable option as well. I could definitely check it out and do a video about it in the future, thanks for the suggestion!

Hi. Please can you help me to know how to get datasets? I couldn't find them. 😢

Hi @KeddyWairimu, For me to better assist, can you provide an example of what disrepancy you are seeing? (Maybe you could provide a specific row of data, and the columns you are looking at?)

Hi @rosemandjeck6551 , you receive the lesson files by submitting your email here: datawizardry.academy/sql-basics-healthcare/

Hello, You dont need to click the header option. It's off by default. Also, the email that you received should explain how to get the encounters data; its a separate link to dropbox.

If you signup here, you will get an email with instructions: datawizardry.academy/sql-basics-healthcare/

You can download those files by registering with your name and email here: datawizardry.academy/sql-basics-healthcare/

Sure, here is the link to my github page: github.com/Data-Wizardry/SQL-Webinar-1

Maybe try this? stackoverflow.com/questions/67973596/in-pgadmin-4-utility-not-found

Thank you very much! I was finally able to import the data, though there is a new problem, at "options", I cannot turn on "header", like it is defaulted to ”off“, and i cannot click it@@DataWizardry

@@zhidaobu4179Yes, that's normal. You should be able to proceed with the full tutorial without clicking the header button.

That's difficult to answer, because HIPAA can be complicated. If you store real data on a relational database management system, it doesn't matter if it's PostgreSQL, Sql Server, Oracle, Snowflake, BIgquery, there needs to be policies around only giving people access only on a need to know basis. A compliance officer can help advise on these matters.

You dont need the header.

The encounter file is not missing; rather, in the same email that you receive, there is a seperate hyperlink to a drop box file containing the download. I had to do it this way because the data is too big to send via email.

Hello, Send me an email at sqlsorcery@gmail.com, and I'll try to help as best as a I can.

I'm guessing what's happening is, you're only seeing a small preview of the entire dataset. The default options are setup so that you only see 1000 rows at a time unless you scroll all the way down to the bottom, and ICU encounters aren't as frequent in this dataset. If you want to verify how many rows of each encounter type you have in your dataset, you could try running a query like this select description, count(*) from encounters group by description order by description Do you see ICU show up on that list? I get 162.

I also encountered some loading issues when first starting pgAdmin4, so I downgraded it to v7.3 and then right-clicked and "ran the program as an administrator" to start using pgAdmin4 - unsure if that's why I'm facing this issue afterward.

Hi @kanainoue8328, for the header, was the circle blue, and on the right? Or was the circle white and on the left? For mine, I found that the header button was frozen on the right position with the blue. So if yours was the same, then I think you're okay. But for the other issue, that's weird, feel free to email me with some screenshots of the loading issues at: sqlsorcery@gmail.com, and I can troubleshoot.

@@DataWizardry Hi Josh, thank you so much for your super quick response and my apologies for my delayed reply. These were resolved! My “Header” button option was frozen and white with the circle on the left (the button cannot be adjusted). But as you posted on your pinned comment, I realized I can still perform other regular basic SQL functions that you went over in this video with the same number of rows. The only exception I noticed is that some of the columns don’t have the proper gray borders around the queried columns/tables, but that's pretty minimal and doesn’t affect any command or calculations up until now. Re: the loading issue, although it didn't work out at first, I Googled and found out someone else having the same problem suggested using a downgraded version. So I downloaded the downgraded version (v7.3), and that worked! It would just say "pgAdmin 4v7" as its app name on my computer. But thanks a lot for being resourceful and your quick response! :)

Yes, the stuff that I'm doing in PostgresSQL is also do-able in MySQL. However, the syntax will be different.

Are you using a Mac? To be honest, I'm not good with the command line either! I believe this step is purely optional for Mac users; what it allows you to do is write SQL from the command line if you wanted. But we won't be doing this in the current tutorial. We'll be using PgAdmin instead. So feel free to skip this step.

You don't need vs code for this. PgAdmin is good enough. Though you could link up vscode to postgres if you wanted to.

​@DataWizardry Ok, thanks. I tried connecting it to vs code earlier, but it was a bit confusing for me as a newbie.

There should be a first email that gives you a button that you have to click (checks to make sure your account isnt a bot). Did you receive that first email? It might have gone to spam, or the promotions folder.

@@DataWizardry I checked my spam as well but didn't receive any emails.

I tried sending it to your email manually. Can you look again? Also look in the promotions folder as well.

@@DataWizardry I got only one email in my promotions folder. But I still don't have those datasets.

@@RashmiTari The instructions to download the data are in that email.

Hello, I think the reason you are seeing this error in MySQL is because it stores dates differently than Postgres. I would recommend following the steps to download PostgreSQL in the tutorial, and then trying to upload to that instead. That way, if you are still coming across errors, I can assist in troubleshooting the error, as we'll both be working off of the same SQL language.

When you get the process failed error, click on the button "View Processes". There should be a table that pops up, go to the thing that looks like a sheet of paper (when you hover over it, it should say "view details"), click on that paper icon, the bottom box should give you an error message, and another thing that says Context. Copy all that and paste it here, and I might be able to troubleshoot.

Hi@@DataWizardry , also getting this error. The error message is: ERROR: invalid input syntax for type date: "N" CONTEXT: COPY conditions, line 1, column stop: "N"

Nevermind I realised was supposed to be \N not

I'm not sure I understand, can you send me a screenshot at sqlsorcery@gmail.com? I can better assist if you can send me screenshots.

You don't need to worry about the header option if you are importing the txt files. It will be locked by default. You should be able to import without enabling the header option.