I am going to give you a plan that will be you absolute best shot at getting a Data Analyst job.

For background, I went from Data Analyst to Senior Data Analyst to Data Scientist in just under 3 years. I have also helped a few other people close to me get into the industry.

• STOP working on the machine learning course. It is absolutely useless to you. You don't yet have the qualifications to be a data scientist and 99% of data analyst don't use those skills. Your time is better spent elsewhere.

• FOCUS on getting to advanced or Expert level SQL skills. Can you use Window Functions, correlated subqueries, etc. While many courses teach things out of order, any course the covers that is almost certain to cover everything else you need with SQL. SQL is the most important skill a data analyst can have.

• DEVELOP decent to strong Tableau skills. I generally tell people to get good at either Tableau or Power BI, since those are the two most popular Reporting/Visualization tools in corporate America.

• GET a Tableau certification. You can either get the Desktop Specialist or the new Tableau Data Analyst certification. It doesn't matter. This is just to get you past the HR screener. I am sorry to say that your Google certificate probably doesn't mean much (REGARDLESSS of what YouTube influencers say) because a recruiter in Human Resources has probably never heard of it. Get certified in the tools that the job requires.

• LOOK primarily (maybe even ONLY) at healthcare related companies and positions. Here you are leveraging your healthcare experience. Look especially at HEALTH INSURANCE COMPANIES. That is where I worked. They are some of the largest healthcare companies and hire ton of data analysts since they have a ton of data. Get a list of the 15 largest healthcare companies in the country, the 15 largest heath insurance companies in the country, and the largest healthcare companies locally. Go directly to the "careers" section of their website

• SEARCH for jobs based on skills rather than title. Tons of people have data analyst positions that aren't actually called data analysts. Instead of searching for "data Analyst" search for "SQL Tableau Healthcare". My former company employed HUNDREDS of data analysts, but maybe 4 had the actual name "data analyst."

• CUSTOMIZE your resume to the position. Reading that you applied to 150-200 jobs (and only got one interview) tells me that you 1) are just applying to anything and everything that is a data analyst position and 2) are not customizing your resume.

• EMPHASIZE your experience in healthcare, in your summary statement you could say something like "SQL and Tableau expert with 6 years healthcare experience, transitioning to a data focused role in the healthcare industry...."

• APPLY directly on the company's website whenever possible. If you can avoid applying on LinkedIn or Indeed, or through a contracting company, then go directly to the company. However, if you have to apply through a third party, then do it.

• BUILD a portfolio project with real data. This is more for the interview with the hiring manager, although you can have it listed in the projects section of your resume. What would be a good project? how about one that is healthcare related. Where do you get the data? The Affordable Care Act resulted in a TON of health insurance information being publicly available. Did you know that the premium and deductible rates for every health insurance plan, at every age range, is available online at a government website? That is just one idea. When you talk to the hiring manager, talk about how you managed problems with real data (misspellings, missing data, etc.).

I really hope this helps. Healthcare is one of the most data intensive industries around. You can leverage your prior experience to get your foot in the door.