📤 In this episode, Avery’s going to walk you through how you can teach yourself SQL for FREE with this awesome 5-step course.

🌟 Join the data project club!

“25OFF” to get 25% off (first 50 members).

📊 Come to my next free “How to Land Your First Data Job” training

🏫 Check out my 10-week data analytics bootcamp

Timestamps:

(0:24) - What is SQL?

(1:08) - Step 1: Download Datasets

(2:03) - What is CSV files?

(2:44) - Step 2: Setup SQL environment with the dataset

(3:37) - Step 3: Learn SQL for free with W3Schools

(4:50) - Step 4: Come up w/ probing questions for your data

(6:09) - Step 5: Write up your findings

(7:00) - Project Write-up Platform

Mentioned Links:

Kaggle: https://www.kaggle.com/datasets

bit.io: https://bit.io/

W3Schools: https://www.w3schools.com/sql/

Connect with Avery:

📺 Subscribe on YouTube

🎙Listen to My Podcast

👔 Connect with me on LinkedIn

📸 Instagram

🎵 TikTok

Mentioned in this episode:

Build Your Data Portfolio

We will build your data portfolio site for you for $1. All you need to do is go to MyDataFolio.com/build and enter your LinkedIn URL. Wait 30 seconds. And BOOM! You have a portfolio! Try it.

$1 Data Portfolio

📰 Join 18k Other Analysts in My Newsletter

Get 1 weekly newsletter helping you take the next steps in your data career! Check it out: https://datacareerjumpstart.com/subscribe

💌 Subscribe To My Newsletter

In this episode, Avery & Jess dive deep into the world of data careers and discuss tips and tricks to network effectively, switch jobs, and stay focused on your career goals.

🌟 Join the data project club!

“25OFF” to get 25% off (first 50 members).

📊 Come to my next free “How to Land Your First Data Job” training

🏫 Check out my 10-week data analytics bootcamp

Timestamps:

(8:01) - Difference between risk analyst & data analyst

(9:56) - Does a math degree help in the data field?

(12:52) - You hate your job. What do you do?

(17:05) - It’s OK to job hop!

(18:07) - The best time to switch job

(20:06) - Not landing job opportunities? Do this!

(22:44) - Learn less. Apply more.

(25:15) - Know your data term to land the job!

Jess Ramos Links:

Linkedin: https://www.linkedin.com/in/jessramosmsba/

Instagram: https://www.instagram.com/jessramosdata/

Linkedin Course: https://www.linkedin.com/learning/preparing-for-your-analytics-job-interview/data-analytics-from-initial-interest-to-job-interview

Practical Advice for Perfecting the Data Resume: https://gumroad.com/a/51884243/vijuf

Connect with Avery:

📺 Subscribe on YouTube: https://www.youtube.com/c/AverySmithDataCareerJumpstart/videos

🎙Listen to My Podcast: https://podcasts.apple.com/us/podcast/data-career-podcast/id1547386535

👔 Connect with me on LinkedIn: https://www.linkedin.com/in/averyjsmith/

📸 Instagram: https://www.instagram.com/datacareerjumpstart/

🎵 TikTok: [https://www.tiktok.com/@verydata](https://www.tiktok.com/@verydata?)

Mentioned in this episode:

📰 Join 18k Other Analysts in My Newsletter

Get 1 weekly newsletter helping you take the next steps in your data career! Check it out: https://datacareerjumpstart.com/subscribe

💌 Subscribe To My Newsletter

Build Your Data Portfolio

We will build your data portfolio site for you for $1. All you need to do is go to MyDataFolio.com/build and enter your LinkedIn URL. Wait 30 seconds. And BOOM! You have a portfolio! Try it.

$1 Data Portfolio

The demand for data professionals continues to rise, and with this roadmap, you can break into the data field and kick-start your career in 2023.

📊 Come to my next free “How to Land Your First Data Job” training

🌟 Join the data project club!

“25OFF” to get 25% off (first 50 members).

🏫 Check out my 10-week data analytics bootcamp

Timestamps:

(1:07) - Different background, different roadmap

(3:18) - Ultimate roadmap to land your first data job

(4:18) - You need these 3 skills to be marketable in data space

(8:51) - Stop learning. Start applying

(10:52) - Prove your skills by doing portfolio projects

(12:25) - Network is your net worth

(13:38) - This is how you grow your Linkedin network

(16:00) - Do it scared, what’s the worst thing that could happen?

Connect with Avery:

📺 Subscribe on YouTube: https://www.youtube.com/c/AverySmithDataCareerJumpstart/videos

🎙Listen to My Podcast: https://podcasts.apple.com/us/podcast/data-career-podcast/id1547386535

👔 Connect with me on LinkedIn: https://www.linkedin.com/in/averyjsmith/

📸 Instagram: https://www.instagram.com/datacareerjumpstart/

🎵 TikTok: [https://www.tiktok.com/@verydata?](https://www.tiktok.com/@verydata?)

Mentioned in this episode:

📰 Join 18k Other Analysts in My Newsletter

Get 1 weekly newsletter helping you take the next steps in your data career! Check it out: https://datacareerjumpstart.com/subscribe

💌 Subscribe To My Newsletter

Build Your Data Portfolio

We will build your data portfolio site for you for $1. All you need to do is go to MyDataFolio.com/build and enter your LinkedIn URL. Wait 30 seconds. And BOOM! You have a portfolio! Try it.

$1 Data Portfolio

This is the story of how a warehouse worker pivoted into a senior data engineer in just 18 months while tripling her salary.   In this episode of The Data Career Podcast, Avery Smith sits down with Kedeisha Bryan on how she landed a data job and tripled her income in only 18 months.

🌟 Join the data project club!

“25OFF” to get 25% off (first 50 members).

📊 Come to my next free “How to Land Your First Data Job” training

🏫 Check out my 10-week data analytics bootcamp

Kedeisha’s Links:

Connect on LinkedIn

Timestamps:

(9:19) - Why you need a sponsor in your life

(11:21) - You need common ground to network genuinely

(27:02) - Tired of sending job applications? Network instead

(30:16) - Know that this is a long game

Connect with Avery:

📺 Subscribe on YouTube: https://www.youtube.com/c/AverySmithDataCareerJumpstart/videos

Mentioned in this episode:

📰 Join 18k Other Analysts in My Newsletter

Get 1 weekly newsletter helping you take the next steps in your data career! Check it out: https://datacareerjumpstart.com/subscribe

💌 Subscribe To My Newsletter

Build Your Data Portfolio

We will build your data portfolio site for you for $1. All you need to do is go to MyDataFolio.com/build and enter your LinkedIn URL. Wait 30 seconds. And BOOM! You have a portfolio! Try it.

$1 Data Portfolio

Stephen shared his incredible journey from tech support to a successful data analyst in only 3 months! Learn the key skills & strategies that helped him make the transition.

📊 Come to my next free “How to Land Your First Data Job” training

🏫 Check out my 10-week data analytics bootcamp

Timestamps:

(10:16) Your personalized project is critical to landing a data job (11:23) You're missing out if you don't use the filter feature (14:17) Get your mentor and fix your resume! (17:29) It's hard to help you if you don't have a portfolio (23:33) Don't be afraid of the job ads requirement (36:15) Luck favors those who are prepared

Stephen’s Links: 

Connect on Linkedin: https://www.linkedin.com/in/stephentran96/

Connect with Avery:

• 📺 Subscribe on YouTube: https://www.youtube.com/c/AverySmithDataCareerJumpstart/videos
• 🎙Listen to My Podcast: https://podcasts.apple.com/us/podcast/data-career-podcast/id1547386535
• 👔 Connect with me on LinkedIn: https://www.linkedin.com/in/averyjsmith/
• 📸 Instagram: https://www.instagram.com/datacareerjumpstart/
• 🎵 TikTok: [https://www.tiktok.com/@verydata?](https://www.tiktok.com/@verydata?)
• 
  

Mentioned in this episode:

Build Your Data Portfolio

We will build your data portfolio site for you for $1. All you need to do is go to MyDataFolio.com/build and enter your LinkedIn URL. Wait 30 seconds. And BOOM! You have a portfolio! Try it.

$1 Data Portfolio

📰 Join 18k Other Analysts in My Newsletter

Get 1 weekly newsletter helping you take the next steps in your data career! Check it out: https://datacareerjumpstart.com/subscribe

💌 Subscribe To My Newsletter

You just learned SQL or Python, or Tableau. But you don’t know how to build your data science project? In this episode, Avery shares a 3-step guide to building your first data science project.

🌟 Join the data project club!

“25OFF” to get 25% off (first 50 members).

📊 Come to my next free “How to Land Your First Data Job” training

🏫 Check out my 10-week data analytics bootcamp

Timestamps:

(1:28) - Art is theft, and so is the data science project

(4:02) - Find ideas on Towards Data Science Medium

(5:32) - Read a few articles to get inspiration

(6:05) - Avery’s strategy is doing 30 projects in 30 days

(9:08) - How academia finds inspiration to write

(11:01) - Take Avery’s project, replicate and do it

Mentioned Links:

Building 30 Data Science Projects in 30 days: https://youtu.be/kKmA9ihIg20

30 Data Science Projects Resources: https://www.datacareerjumpstart.com/30projectsresourcesignup

I Used Data Science to UNCOVER McDonald’s Healthiest Meal: https://youtu.be/3bbFc1225-4

Connect with Avery:

Mentioned in this episode:

Build Your Data Portfolio

We will build your data portfolio site for you for $1. All you need to do is go to MyDataFolio.com/build and enter your LinkedIn URL. Wait 30 seconds. And BOOM! You have a portfolio! Try it.

$1 Data Portfolio

📰 Join 18k Other Analysts in My Newsletter

Get 1 weekly newsletter helping you take the next steps in your data career! Check it out: https://datacareerjumpstart.com/subscribe

💌 Subscribe To My Newsletter

Do you need to be active on Linkedin to land a data job? What should you post or even do on the platform?

In this episode, Avery sits down with teacher turned Data Analyst Chris French to discuss how he landed his first data job leveraging Linkedin.

🌟 Join the data project club!

“25OFF” to get 25% off (first 50 members).

📊 Come to my next free “How to Land Your First Data Job” training

🏫 Check out my 10-week data analytics bootcamp

Chris’s Links:

Connect on LinkedIn

Timestamps:

(9:07) - How Chris grow Linkedin from 20 followers to 20,000 followers

(13:19) - His content types that gain attention

(18:02) - What Chris would do differently to do the job search

(23:29) - Technical skills vs soft skills

(26:53) - Before land data job, analyze your process first

Connect with Avery:

Mentioned in this episode:

📰 Join 18k Other Analysts in My Newsletter

Get 1 weekly newsletter helping you take the next steps in your data career! Check it out: https://datacareerjumpstart.com/subscribe

💌 Subscribe To My Newsletter

Build Your Data Portfolio

We will build your data portfolio site for you for $1. All you need to do is go to MyDataFolio.com/build and enter your LinkedIn URL. Wait 30 seconds. And BOOM! You have a portfolio! Try it.

$1 Data Portfolio

You just got the data job offer. Should you accept it or not? In this episode, Avery discusses what pros and cons are there and deciding on accepting the job offer.

🌟 Join the data project club!

“25OFF” to get 25% off (first 50 members).

📊 Come to my next free “How to Land Your First Data Job” training

🏫 Check out my 10-week data analytics bootcamp

Timestamps:

Timestamps:

(0:58) - Jay got a data job offer but was in a dilemma

(2:22) - Your past experience is ALWAYS relevant in the data world

(2:59) - Job offer pros to look out

(4:03) - Job offer cons to be aware of

(5:57) - Avery takes on deciding job offer

(7:53) - Job offer is beyond salary but perks & benefits

Connect with Avery:

Mentioned in this episode:

Build Your Data Portfolio

We will build your data portfolio site for you for $1. All you need to do is go to MyDataFolio.com/build and enter your LinkedIn URL. Wait 30 seconds. And BOOM! You have a portfolio! Try it.

$1 Data Portfolio

📰 Join 18k Other Analysts in My Newsletter

Get 1 weekly newsletter helping you take the next steps in your data career! Check it out: https://datacareerjumpstart.com/subscribe

💌 Subscribe To My Newsletter

Can cold messaging really land you your first data job? Even without experience? In this episode, Avery sits down with logistics Data Analyst Asa Howard to discuss how he landed his first data job with a simple cold messaging strategy.

🌟 Join the data project club!

“25OFF” to get 25% off (first 50 members).

📊 Come to my next free “How to Land Your First Data Job” training

🏫 Check out my 10-week data analytics bootcamp

Asa’s Links:

Timestamps:

(3:22) - Asa realizes he needs a career pivot

(5:21) - What a Solutions Engineer does (Logistics Analyst)

(10:21) - System he used to land his job

(14:24) - Cold message template you can steal

(18:01) - What tools he uses on day to day

(24:37) - Google Sheets vs Excel

Connect with Avery:

Mentioned in this episode:

📰 Join 18k Other Analysts in My Newsletter

Get 1 weekly newsletter helping you take the next steps in your data career! Check it out: https://datacareerjumpstart.com/subscribe

💌 Subscribe To My Newsletter

Build Your Data Portfolio

We will build your data portfolio site for you for $1. All you need to do is go to MyDataFolio.com/build and enter your LinkedIn URL. Wait 30 seconds. And BOOM! You have a portfolio! Try it.

$1 Data Portfolio

Welcome to the show notes! 🎉 I always put interesting things in the show notes, so make sure you check them every episode! 

In today's podcast episode, I'll be sharing a recording of a seminar I gave this week to about 50 undergraduate students, specifically in the chemical engineering program at the University of Utah.

I'll be talking about: 1) what I wish I knew while I was in college and trying to break into data science 2) how data science can be applied in industrial systems and engineering

Although this was given to a live audience, I do think a lot of the advice you might find applicable to you and your situation.

Want to come to my project analyzing Ken Jee's YouTube data? Register here: https://www.linkedin.com/video/event/urn:li:ugcPost:6899114723149705216/

If you want a free way to kickstart your analytics career, check out my free 33-page PDF giving you an introduction to everything you need to know: https://www.datacareerjumpstart.com/roadmap

If you’re just starting out, you can check out my 21 Day To Data Challenge: https://www.datacareerjumpstart.com/challenge

Want to learn data science while building your portfolio? Check out Data Career Jumpstart: https://www.datacareerjumpstart.com/data-career-jumpstart-course

MORE DATA ANALYTICS CONTENT HERE:

📺 Subscribe YouTube: https://www.youtube.com/c/AverySmithDataCareerJumpstart/videos

🎙Listen to My Podcast: https://podcasts.apple.com/us/podcast/data-career-podcast/id1547386535

👔 Connect with me on LinkedIn: https://www.linkedin.com/in/averyjsmith/

📸 Instagram: https://www.instagram.com/datacareerjumpstart/

👾Join My Discord: https://www.datacareerjumpstart.com/discord

🎵 TikTok: https://www.tiktok.com/@verydata? 

Mentioned in this episode:

Build Your Data Portfolio

We will build your data portfolio site for you for $1. All you need to do is go to MyDataFolio.com/build and enter your LinkedIn URL. Wait 30 seconds. And BOOM! You have a portfolio! Try it.

$1 Data Portfolio

📰 Join 18k Other Analysts in My Newsletter

Get 1 weekly newsletter helping you take the next steps in your data career! Check it out: https://datacareerjumpstart.com/subscribe

💌 Subscribe To My Newsletter