Data Career Podcast: Helping You Land a Data Analyst Job FAST

Avery Smith - Data Career Coach
undefined
7 snips
Apr 13, 2023 • 15min

54: How to Build Your First Data Analytics Project

Unlock the secrets of landing your first data job with a six-step guide to building an impressive analytics project. Start with choosing the right project and finding a suitable dataset. Dive into defining your project scope and conducting exploratory data analysis. Once you have real insights, learn how to effectively publish your findings. Plus, discover the value of networking and creating a stellar portfolio to stand out in the data field!
undefined
Apr 5, 2023 • 9min

53: Best Data Visualization Books for Beginners 📚

Discover the top five must-read books for anyone starting in data visualization. Explore how 'Storytelling with Data' can enhance your narrative skills. Learn design principles from 'The Big Book of Dashboards.' Uncover the intricacies of effective visuals with 'Envisioning Information.' Delve into the pitfalls of misrepresentation in 'How Charts Lie.' Finally, grasp essential techniques in data presentation through 'Show Me The Numbers.' Perfect for aspiring analysts!
undefined
Mar 29, 2023 • 32min

52: From Teacher to Senior Data Analyst in 100 Days w/ Courtney Ballard

This is the story of how a math teacher transitioned to become a lead analytics consultant at Wells Fargo In this episode of The Data Career Podcast, Avery Smith sits down with Courtney Ballard, one of the bootcamp alumna on how she landed data job from teaching. If you are a Transitioning Teacher looking to explore data, I have a LIVE training to help you on your journey: https://www.datacareerjumpstart.com/teachers 🌟 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:53) - Why Courtney transitioned to data analytics (9:54) - Why it's okay to pivot your career (13:22) - Teachers make great data analysts (17:44) - How Courtney landed her job (23:30) - Why data careers are great for teachers Courtney’s Links: Linkedin: https://www.linkedin.com/in/courtneylballard/ Connect with Avery: 📺 Subscribe on YouTube 🎙Listen to My Podcast 👔 Connect with me on LinkedIn 📸 Instagram 🎵 TikTok Mentioned in this episode:📰 Join 18k Other Analysts in My NewsletterGet 1 weekly newsletter helping you take the next steps in your data career! Check it out: https://datacareerjumpstart.com/subscribe💌 Subscribe To My Newsletter1:1 Coaching w/ AveryI've opened 12 slots on my calendar to do 1:1 coaching calls. What we can do: fix your resume (it may suck), audit your LinkedIn (also may suck), mock interview you (prepare to sweat), or tell you exactly what to do next This is a test. Never done it. Might never do it again. Limited spots. Book now.https://landadatajob.com/coachingday✨ Try Julius!This episode is brought to you by Julius – your AI data analyst companion. Connect to your database and/or business tools, pull insights in minutes–no coding required. Thanks, Julius, for sponsoring this episode. Try Julius at https://landadatajob.com/Julius-DCPhttps://landadatajob.com/Julius-DCP
undefined
Mar 23, 2023 • 18min

51: How to Solve Any Data Analytics Error You Face...

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 error message (3:29) - Step 2: Use Google, Stack Overflow & ChatGPT (5:28) - Step 3: Double check everything! (6:58) - Step 4: Rubber Duck it! (7:58) - Step 5: Read manual & documentation (9:45) - Step 6: Walk away, just walk. (14:19) - Step 7: Turn it off! (12:52) - Step 8: Screenshot & screenrecord it (15:18) -Step 10: Say thank you! Connect with Avery: 📺 Subscribe on YouTube 🎙Listen to My Podcast 👔 Connect with me on LinkedIn 📸 Instagram 🎵 TikTok Mentioned in this episode:📰 Join 18k Other Analysts in My NewsletterGet 1 weekly newsletter helping you take the next steps in your data career! Check it out: https://datacareerjumpstart.com/subscribe💌 Subscribe To My Newsletter1:1 Coaching w/ AveryI've opened 12 slots on my calendar to do 1:1 coaching calls. What we can do: fix your resume (it may suck), audit your LinkedIn (also may suck), mock interview you (prepare to sweat), or tell you exactly what to do next This is a test. Never done it. Might never do it again. Limited spots. Book now.https://landadatajob.com/coachingday✨ Try Julius!This episode is brought to you by Julius – your AI data analyst companion. Connect to your database and/or business tools, pull insights in minutes–no coding required. Thanks, Julius, for sponsoring this episode. Try Julius at https://landadatajob.com/Julius-DCPhttps://landadatajob.com/Julius-DCP
undefined
4 snips
Mar 15, 2023 • 10min

50: FREE 5-Step SQL Course & Project

📤 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:📰 Join 18k Other Analysts in My NewsletterGet 1 weekly newsletter helping you take the next steps in your data career! Check it out: https://datacareerjumpstart.com/subscribe💌 Subscribe To My Newsletter1:1 Coaching w/ AveryI've opened 12 slots on my calendar to do 1:1 coaching calls. What we can do: fix your resume (it may suck), audit your LinkedIn (also may suck), mock interview you (prepare to sweat), or tell you exactly what to do next This is a test. Never done it. Might never do it again. Limited spots. Book now.https://landadatajob.com/coachingday✨ Try Julius!This episode is brought to you by Julius – your AI data analyst companion. Connect to your database and/or business tools, pull insights in minutes–no coding required. Thanks, Julius, for sponsoring this episode. Try Julius at https://landadatajob.com/Julius-DCPhttps://landadatajob.com/Julius-DCP
undefined
Mar 8, 2023 • 36min

49: Navigating Your Data Career Journey w/ Jess Ramos

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 NewsletterGet 1 weekly newsletter helping you take the next steps in your data career! Check it out: https://datacareerjumpstart.com/subscribe💌 Subscribe To My Newsletter✨ Try Julius!This episode is brought to you by Julius – your AI data analyst companion. Connect to your database and/or business tools, pull insights in minutes–no coding required. Thanks, Julius, for sponsoring this episode. Try Julius at https://landadatajob.com/Julius-DCPhttps://landadatajob.com/Julius-DCP1:1 Coaching w/ AveryI've opened 12 slots on my calendar to do 1:1 coaching calls. What we can do: fix your resume (it may suck), audit your LinkedIn (also may suck), mock interview you (prepare to sweat), or tell you exactly what to do next This is a test. Never done it. Might never do it again. Limited spots. Book now.https://landadatajob.com/coachingday
undefined
Mar 2, 2023 • 21min

48: Your Roadmap To Your First Data Job in 2023

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 NewsletterGet 1 weekly newsletter helping you take the next steps in your data career! Check it out: https://datacareerjumpstart.com/subscribe💌 Subscribe To My Newsletter✨ Try Julius!This episode is brought to you by Julius – your AI data analyst companion. Connect to your database and/or business tools, pull insights in minutes–no coding required. Thanks, Julius, for sponsoring this episode. Try Julius at https://landadatajob.com/Julius-DCPhttps://landadatajob.com/Julius-DCP1:1 Coaching w/ AveryI've opened 12 slots on my calendar to do 1:1 coaching calls. What we can do: fix your resume (it may suck), audit your LinkedIn (also may suck), mock interview you (prepare to sweat), or tell you exactly what to do next This is a test. Never done it. Might never do it again. Limited spots. Book now.https://landadatajob.com/coachingday
undefined
Feb 23, 2023 • 34min

47 How She Tripled Her Income in 18 Months w/ Data Analytics, Data Science, & Data Engineering w/ Kedeisha Bryan

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 Join Data in Motion Community 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 🎙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 NewsletterGet 1 weekly newsletter helping you take the next steps in your data career! Check it out: https://datacareerjumpstart.com/subscribe💌 Subscribe To My Newsletter1:1 Coaching w/ AveryI've opened 12 slots on my calendar to do 1:1 coaching calls. What we can do: fix your resume (it may suck), audit your LinkedIn (also may suck), mock interview you (prepare to sweat), or tell you exactly what to do next This is a test. Never done it. Might never do it again. Limited spots. Book now.https://landadatajob.com/coachingday✨ Try Julius!This episode is brought to you by Julius – your AI data analyst companion. Connect to your database and/or business tools, pull insights in minutes–no coding required. Thanks, Julius, for sponsoring this episode. Try Julius at https://landadatajob.com/Julius-DCPhttps://landadatajob.com/Julius-DCP
undefined
Feb 15, 2023 • 39min

46: Landing a Data Analyst Job in 90 Days w/ Stephen Tran

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 bootcampTimestamps:(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 preparedStephen’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:1:1 Coaching w/ AveryI've opened 12 slots on my calendar to do 1:1 coaching calls. What we can do: fix your resume (it may suck), audit your LinkedIn (also may suck), mock interview you (prepare to sweat), or tell you exactly what to do next This is a test. Never done it. Might never do it again. Limited spots. Book now.https://landadatajob.com/coachingday✨ Try Julius!This episode is brought to you by Julius – your AI data analyst companion. Connect to your database and/or business tools, pull insights in minutes–no coding required. Thanks, Julius, for sponsoring this episode. Try Julius at https://landadatajob.com/Julius-DCPhttps://landadatajob.com/Julius-DCP📰 Join 18k Other Analysts in My NewsletterGet 1 weekly newsletter helping you take the next steps in your data career! Check it out: https://datacareerjumpstart.com/subscribe💌 Subscribe To My Newsletter
undefined
Feb 9, 2023 • 14min

45: 3-Step Guide To Building Your First Data Science Project

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: 📺 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?] Mentioned in this episode:📰 Join 18k Other Analysts in My NewsletterGet 1 weekly newsletter helping you take the next steps in your data career! Check it out: https://datacareerjumpstart.com/subscribe💌 Subscribe To My Newsletter✨ Try Julius!This episode is brought to you by Julius – your AI data analyst companion. Connect to your database and/or business tools, pull insights in minutes–no coding required. Thanks, Julius, for sponsoring this episode. Try Julius at https://landadatajob.com/Julius-DCPhttps://landadatajob.com/Julius-DCP1:1 Coaching w/ AveryI've opened 12 slots on my calendar to do 1:1 coaching calls. What we can do: fix your resume (it may suck), audit your LinkedIn (also may suck), mock interview you (prepare to sweat), or tell you exactly what to do next This is a test. Never done it. Might never do it again. Limited spots. Book now.https://landadatajob.com/coachingday

The AI-powered Podcast Player

Save insights by tapping your headphones, chat with episodes, discover the best highlights - and more!
App store bannerPlay store banner
Get the app