Let's face it; data analytics can sometimes be a real pain in the spreadsheet. You spend hours analysing data, writing code, and crafting reports, only to have one mystery bug stop your work from progressing. I'll show you my 10-step guide for solving ANY data problem. 🌟 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: (2:19) - Step 1: Copy your er...
Mar 23, 2023•18 min
📤 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 ...
Mar 15, 2023•9 min
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) ...
Mar 08, 2023•35 min
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 ...
Mar 02, 2023•20 min
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 ...
Feb 23, 2023•33 min
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 t...
Feb 15, 2023•39 min
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 Medi...
Feb 09, 2023•14 min
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 C...
Feb 01, 2023•31 min
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 ...
Jan 26, 2023•10 min
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: Connect on LinkedIn Waitlist for Google Sheets course Timestam...
Jan 18, 2023•33 min
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...
Feb 22, 2022•50 min
In this episode, I’ll explain what THE best project you can do for data science and how you can accomplish it. I’ll give you my 5 step recipe for making a great data science project so you can find a data analytics job. If you need to find datasets, check out Kaggle.com and Google Dataset Search Engine Want to build more projects for your portfolio? Check out my course, Data Career Jumpstart: https://www.datacareerjumpstart.com/data-career-jumpstart-course ✅ If you liked this video, please rate ...
Feb 14, 2022•11 min
In this episode, I explain the importance of having data before starting a machine learning project by sharing a story of freelancing in data science LAST DAY TO JOIN 21 DAYS TO DATA: https://www.datacareerjumpstart.com/challenge 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 Want to learn data science while building your portfolio? Check out Data Caree...
Feb 07, 2022•9 min
In this podcast, I give my opinion if YOU should do the Masters in Analytics from Georgia Tech (OMSA). I’ll share my experience, what I thought was good, and not so good, and help you make your decision! Watch this episode on YouTube: https://www.youtube.com/watch?v=dpVNRB67-So&t=1s 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 start...
Jan 31, 2022•15 min
In this episode, I interviewed Kyle Pastor (aka @DataStuffPlus 70K followers on Instagram). We chatted about how Kyle got started with data, why he runs his Instagram, and why he does fun data projects. When breaking into data, it’s always important to have a portfolio of projects to show off, and who knows, these projects could turn into businesses, job offers, or sponsorship opportunities. You can follow Kyle’s writing and tutorials on his Medium . Also, don’t miss Kyle’s data viz Instagram . ...
Jan 24, 2022•55 min
In this video, I wanted to recap the necessary ingredients to becoming a data scientist in 2022. I highlight the data paths you can take, the technical data analytics skills you should learn, and also highlight how I think 2022 will be different. (0:39) What Is A Data Scientist? (1:31) 4 Ways To Break Into Data (2:44) Data Scientist Requirements (3:20) Proving Your Skills (4:08) Finding An Opportunity (5:12) What Should You Focus On Learning? (7:05) How Will 2022 Be Different (8:45) My Data Scie...
Jan 17, 2022•10 min
In this episodes, I’ll cover 20 red flags to check before taking a job in the tech industry 🚩🚩🚩 Your job is half of your waking hours, so it’s important to understand what you’re getting into before accepting a job. Going through this simple checklist could save you a lot of headache down the road. Listen to hear some things to look out for. Want me to answer one of your questions? Submit it on my Discord Want some help finding a tech job? Schedule a 1:1 call with me. SUBSCRIBE! If you’re fin...
Jan 10, 2022•17 min
Welcome to 2022! 🎉 Thank you so much for listening! In this episode, I review 2021, discuss goals, and introduce a new challenge! Check out The 21 Days To Data Challenge: https://www.datacareerjumpstart.com/Challenge New Data Career Podcast episodes EVERY Monday morning Here’s what I did in 2021: Quit my job Snow Data Science Consulted for 15 businesses Ran 50 miles, 60k elevation = 11 peaks Ran a marathon Sold a house, bought a house Interned with the Utah Jazz Graduated with masters from Geor...
Jan 03, 2022•15 min
Data is an unbelievable asset, but needs to be cleaned, or it is useless. In this episode, we hear from Susan Walsh, The Classification Guru, on how she runs a data cleaning business. We learn what data cleaning is, how it's useful, and what's important to have structured data. Enjoy! Enter The Twelve Days of Data Christmas Giveaway: https://www.datacareerjumpstart.com///giveaway Connect with Susan Walsh : https://www.linkedin.com/in/susanewalsh/ Between the Spreadsheets Book: https://www.facetp...
Dec 03, 2021•48 min
I'm tired of data elitism. I want to be inclusive. If you are in the data space, join me in being inclusive. Join me on the journey at DataCareerJumpstart.com Mentioned in this episode: ⚡️Discover top data analyst roles from leading companies FindADataJob.com is a great place to look for data jobs at any point in your data journey, so check it out. I built it so you can skip the spam and see legit, curated data jobs. Updated daily. No login, no paywall. Just real jobs for real job seekers who ar...
Oct 29, 2021•9 min
We talked to George Firican from Lights on Data about all things data governance and management. Check out their YouTube ! As always, please leave a review and subscribe to the Data Career Podcast! Mentioned in this episode: ⚡️Discover top data analyst roles from leading companies FindADataJob.com is a great place to look for data jobs at any point in your data journey, so check it out. I built it so you can skip the spam and see legit, curated data jobs. Updated daily. No login, no paywall. Jus...
Oct 05, 2021•46 min
Join host Avery Smith on this episode of the Data Career Podcast for an exciting 'Ask Avery' session! We cover various topics, including the roles and differences between data analysts, data engineers, and data scientists, as well as transitioning careers, essential skills for data engineering, forecasting techniques, and more. f you have questions about data visualization, Python, or breaking into data science, this episode has got you covered. Tune in for valuable insights and professional adv...
Sep 23, 2021•31 min
Emily Vu changed her life with a Tweet she thought meant nothing. That tweet ended up being seen by millions, inspiring hundreds, opening dozens of doors, and eventually landed to an internship and full-time job offer from tech giant, Spotify. In this episode, Emily and I discuss how she used the internet and a personal brand to overcome a non-tech background, to land awesome tech jobs. Follow Emily on Twitter: https://twitter.com/emvutweets Follow Emily on TikTok: https://www.tiktok.com/@itsemv...
Sep 15, 2021•1 hr 1 min
Ways to learn more from Lillian: Data Science for Dummies Launch Party : Data Science For Dummies, 3rd Edition hits the streets in September, 2021 – but not without a proper launch party to celebrate. You’re invited! RSVP here: https://businessgrowth.ai/ The Data Entrepreneur’s Toolkit: A recommendation set for 32 free (or low-cost) tools & processes that'll actually grow your data business (even if you still haven’t put up that website yet!). https://www.data-mania.com/data-entrepreneur-too...
Aug 15, 2021•53 min
Connect with Florin Badita: https://www.linkedin.com/in/baditaflorin/ Want to break into data science? Check out my new course coming out on August 18th: Data Career Jumpstart - https://www.datacareerjumpstart.com Subscribe on YouTube: https://www.youtube.com/channel/UCuyfszBAd3gUt9vAbC1dfqA Mentioned in this episode: ⚡️Discover top data analyst roles from leading companies FindADataJob.com is a great place to look for data jobs at any point in your data journey, so check it out. I built it so y...
Jul 27, 2021•58 min
Connect with Dustin Schimek! https://www.linkedin.com/in/dustinschimek/ Want to break into data science? Check out my new course coming out later this summer: Data Career Jumpstart - https://www.datacareerjumpstart.com Subscribe on YouTube: https://www.youtube.com/channel/UCuyfszBAd3gUt9vAbC1dfqA Want to leave a question for the Ask Avery Show? Written Mailbag: https://forms.gle/78zD544drpDAcTRV9 Audio Mailbag: https://anchor.fm/datacareerpodcast/message Mentioned in this episode: ⚡️Discover top...
Jul 22, 2021•1 hr 1 min
In this episode, I interview Mark Freeman and talk about how he transitioned from public health to data science! We talk about what worked well in his journey, and what didn't, including a $20,000 investment gone sideways. Mark also gives some amazing LinkedIn job hacks! Connect with Mark on LinkedIn: https://www.linkedin.com/in/mafreeman2/ Check out opening's at Humu (Mark's company): https://boards.greenhouse.io/humu Want to break into data science? Check out my new course coming out later thi...
Jul 17, 2021•1 hr 2 min
In this episode, I talk with Andreas Kretz ( https://www.linkedin.com/in/andreas-kretz/ ) who is an amazing resource for the data engineering community. He runs an incredibly affordable data engineering bootcamp called Learn Data Engineering ( https://learndataengineering.com ) and also has an extensive YouTube ( https://www.youtube.com/channel/UCY8mzqqGwl5_bTpBY9qLMAA ). We talked about how Andreas got started with data engineering, why he like it so much, and how others can get started. I also...
Jul 12, 2021•1 hr 5 min
In this episode, I talk to Matt Blasa ( https://www.linkedin.com/in/mblasa/ ) about how he does data science freelancing. We also talk about online portfolios, data governance, and why he posts on LinkedIn. Enjoy! 🎙 PLEASE FOLLOW & SUBSCRIBE TO THE POD Want to break into data science? Check out my new course coming out later this summer: Data Career Jumpstart - https://www.datacareerjumpstart.com Want to leave a question for the Ask Avery Show? Written Mailbag: https://forms.gle/78zD544drpD...
Jul 07, 2021•43 min
Matt Francsis (https://www.linkedin.com/in/matthewfrancsis/) joined the show today and talked about his journey from geology to data science. He talked about how a data science bootcamp and a "stepping-stone" job that utilized his geology background, ended up helping him break into the field completely. Want to break into data science? Check out my new course coming out later this summer: Data Career Jumpstart - https://www.datacareerjumpstart.com Want to leave a question for the Ask Avery Show?...
Jul 01, 2021•1 hr 1 min
