226: 10 Things I Wish I Knew When Starting as a Data Analyst

Help us become the #1 Data Podcast by leaving a rating & review! We are 67 reviews away! The top data teams stopped doing grunt work. Here’s what they do instead.🚀 Try Lookout from RudderStack 👉 https://www.rudderstack.com/product/lookout/?utm_source=influencer&utm_medium=social&utm_campaign=CMPGN_1_LL&raid=3c6fc5bbcb78f555d376da286bf7c9fd💌 Join 33k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://datacareerjumpstart.com/newsletter🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://datacareerjumpstart.com/training👩‍💻 Want to land a data job in less than 90 days? 👉 https://datacareerjumpstart.com/daa👔 Ace The Interview with Confidence 👉 https://datacareerjumpstart.com/interviewsimulator⌚ TIMESTAMPS 00:00 – Meet Lookout from RudderStack00:33 – The problem it’s built for05:39 – Watch it answer the question07:33 – Work on what gets you promoted🔗 CONNECT WITH AVERY 🎥 YouTube Channel 🤝 LinkedIn 📸 Instagram 🎵 TikTok 💻 Website

Help us become the #1 Data Podcast by leaving a rating & review! We are 67 reviews away! If I had to start over in 2027, here’s exactly what I’d do. 💌 Join 33k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://datacareerjumpstart.com/newsletter🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://datacareerjumpstart.com/training👩‍💻 Want to land a data job in less than 90 days? 👉 https://datacareerjumpstart.com/daa👔 Ace The Interview with Confidence 👉 https://datacareerjumpstart.com/interviewsimulator⌚ TIMESTAMPS 00:00 – Learn Excel, Tableau & SQL02:51 – Break the circle of doom06:24 – Make your projects public08:00 – Hack your resume and LinkedIn11:09 – Take interview actions🔗 CONNECT WITH AVERY 🎥 YouTube Channel 🤝 LinkedIn 📸 Instagram 🎵 TikTok 💻 Website Mentioned in this episode:💙 Thank you for subscribingYouTube Channel

Help us become the #1 Data Podcast by leaving a rating & review! We are 67 reviews away! Vivek went from electrical engineer to senior data analyst, and networking is what got him there. Here’s the whole story.💌 Join 33k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://datacareerjumpstart.com/newsletter🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://datacareerjumpstart.com/training👩‍💻 Want to land a data job in less than 90 days? 👉 https://datacareerjumpstart.com/daa👔 Ace The Interview with Confidence 👉 https://datacareerjumpstart.com/interviewsimulator⌚ TIMESTAMPS 00:00 – He got left on read for a year02:42 – Why he left engineering11:15 – Research engineer vs engineering analyst20:27 – Luck you create yourself26:21 – Senior analyst, fully remote31:18 – His advice🔗 CONNECT WITH VIVEK🤝 LinkedIn: https://linkedin.com/in/vivekpoovathoor/🔗 CONNECT WITH AVERY 🎥 YouTube Channel 🤝 LinkedIn 📸 Instagram 🎵 TikTok 💻 Website Mentioned in this episode:💙 Thank you for subscribing & leaving a reviewThanks to YOU we recently became the most popular data podcast out there. Thank you so much for listening. If you haven't subscribed yet, hit subscribe. It costs $0. If you enjoy the show, leave us a 5-star rating on Spotify or Apple. It helps people like you find the show AND it helps us land better guests. Thank you so much for your support.

Help us become the #1 Data Podcast by leaving a rating & review! We are 67 reviews away! This is pretty much everything you need to know when landing your first data job. Comment what you’d like me to go deeper on. Hope it helps.💌 Join 33k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://datacareerjumpstart.com/newsletter🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://datacareerjumpstart.com/training👩‍💻 Want to land a data job in less than 90 days? 👉 https://datacareerjumpstart.com/daa👔 Ace The Interview with Confidence 👉 https://datacareerjumpstart.com/interviewsimulator⌚ TIMESTAMPS 00:00 – Why become a data analyst03:48 – What to learn07:50 – Get paid to learn on the job12:10 – The formula to getting hired13:30 – The SPN Method (skills, projects, network)16:24 – Networking🔗 CONNECT WITH AVERY 🎥 YouTube Channel 🤝 LinkedIn 📸 Instagram 🎵 TikTok 💻 Website Mentioned in this episode:⚡️Discover top data analyst roles from leading companiesFindADataJob.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 are trying to get hired.⚡️Discover top data analyst roles from leading companies💙 Thank you for subscribing & leaving a reviewThanks to YOU we recently became the most popular data podcast out there. Thank you so much for listening. If you haven't subscribed yet, hit subscribe. It costs $0. If you enjoy the show, leave us a 5-star rating on Spotify or Apple. It helps people like you find the show AND it helps us land better guests. Thank you so much for your support.

Help us become the #1 Data Podcast by leaving a rating & review! We are 67 reviews away! Watched an ex-Google analyst break down why AI hasn’t replaced data analysts. I show you where I agree and where I don’t.💌 Join 33k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://datacareerjumpstart.com/newsletter🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://datacareerjumpstart.com/training👩‍💻 Want to land a data job in less than 90 days? 👉 https://datacareerjumpstart.com/daa👔 Ace The Interview with Confidence 👉 https://datacareerjumpstart.com/interviewsimulator⌚ TIMESTAMPS 00:00 – AI didn’t kill the job02:45 – Big Tech isn’t the real market09:15 – The hype doesn’t match the data16:45 – Where AI guessed wrong19:03 – The analysts at risk20:27 – What makes you irreplaceable📺 Watch Sundas’ original video 👉 https://youtu.be/r4lEzAM3VOY🎙️ Listen to Out of the Office with Sundas 👉 https://open.spotify.com/show/5yBNLUp8oRPDXoLTkvaBku🤝 Connect with Sundas on LinkedIn 👉 https://www.linkedin.com/in/sundaskhalid/🔗 CONNECT WITH AVERY 🎥 YouTube Channel 🤝 LinkedIn 📸 Instagram 🎵 TikTok 💻 Website Mentioned in this episode:💙 Thank you for subscribing & leaving a reviewThanks to YOU we recently became the most popular data podcast out there. Thank you so much for listening. If you haven't subscribed yet, hit subscribe. It costs $0. If you enjoy the show, leave us a 5-star rating on Spotify or Apple. It helps people like you find the show AND it helps us land better guests. Thank you so much for your support.

Help us become the #1 Data Podcast by leaving a rating & review! We are 67 reviews away! Follow this free bootcamp to become a data analyst!If you want extra help, consider The Accelerator: DataCareerJumpstart.com/daa💌 Join 33k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://datacareerjumpstart.com/newsletter🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://datacareerjumpstart.com/training👩‍💻 Want to land a data job in less than 90 days? 👉 https://datacareerjumpstart.com/daa👔 Ace The Interview with Confidence 👉 https://datacareerjumpstart.com/interviewsimulator⌚ TIMESTAMPS 00:00 – Welcome to the Bootcamp01:57 – How to Become a Data Analyst25:51 – What Data Tools to Learn34:15 – How to Get Paid To Learn43:57 – Entry Level Data Jobs54:33 – What Do Data Analysts Do?1:05:09 – Data Analyst Salaries1:24:36 – How to Get Every Data Tool1:45:03 – Excel 1012:24:45 – SQL 1012:37:27 – SQL Project2:43:48 – Data Storytelling3:16:12 – Tableau 1013:52:33 – Tableau Project4:04:21 – Power BI Project4:12:36 – Python 1014:29:27 – Python Project4:35:54 – R Project4:41:54 – Current Job Market4:52:09 – AI & The Future of Data5:01:24 – Best Way to Find Jobs5:09:57 – Update Your Resume5:44:06 – Create a Portfolio5:53:51 – How to Apply to Jobs6:34:12 – Interview Practice6:44:42 – How to Get Hired6:57:27 – Next Steps🔗 CONNECT WITH AVERY 🎥 YouTube Channel 🤝 LinkedIn 📸 Instagram 🎵 TikTok 💻 Website Mentioned in this episode:💙 Thank you for subscribing & leaving a reviewThanks to YOU we recently became the most popular data podcast out there. Thank you so much for listening. If you haven't subscribed yet, hit subscribe. It costs $0. If you enjoy the show, leave us a 5-star rating on Spotify or Apple. It helps people like you find the show AND it helps us land better guests. Thank you so much for your support.Early Black Friday Sale: Data Analytics AcceleratorOur early Black Friday sale for the Data Analytics Accelerator is live this week only. Join Avery’s data analyst bootcamp and get a discount plus a bunch of bonuses to help you land your first data job. Check out the Black Friday deal here:https://datacareerjumpstart.com/daa

Help us become the #1 Data Podcast by leaving a rating & review! We are 67 reviews away! Emily Oster is a Harvard trained economist who built a career on making decisions when the data is bad or missing. I asked her how she does it.💌 Join 33k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://datacareerjumpstart.com/newsletter🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://datacareerjumpstart.com/training👩‍💻 Want to land a data job in less than 90 days? 👉 https://datacareerjumpstart.com/daa👔 Ace The Interview with Confidence 👉 https://datacareerjumpstart.com/interviewsimulator⌚ TIMESTAMPS 00:00 – Let the decision lead the data04:03 – Instagram isn't evidence08:39 – What to do when there's no data10:57 – Your family is a small business14:33 – Right decision vs right process30:21 – The New York test score error39:00 – Rapid fire myths🔗 CONNECT WITH EMILY📚 Expecting Better: https://a.co/d/00ExVFqN📚 Cribsheet: https://a.co/d/09rGjGjs📚 The Family Firm: https://a.co/d/08RaAOBh📈 Emily's artifact: https://claude.ai/code/artifact/ecaef324-0efe-401a-9fca-d5d2816e88ee📊 Education Substack: https://substack.com/@statetestscoreresults🤝 LinkedIn: https://www.linkedin.com/in/emilyoster📸 Instagram: https://www.instagram.com/profemilyoster/🐦 X: https://x.com/ProfEmilyOster💻 Website: https://parentdata.org/🔗 CONNECT WITH AVERY 🎥 YouTube Channel 🤝 LinkedIn 📸 Instagram 🎵 TikTok 💻 Website Mentioned in this episode:Early Black Friday Sale: Data Analytics AcceleratorOur early Black Friday sale for the Data Analytics Accelerator is live this week only. Join Avery’s data analyst bootcamp and get a discount plus a bunch of bonuses to help you land your first data job. Check out the Black Friday deal here:https://datacareerjumpstart.com/daa💙 Thank you for subscribing & leaving a reviewThanks to YOU we recently became the most popular data podcast out there. Thank you so much for listening. If you haven't subscribed yet, hit subscribe. It costs $0. If you enjoy the show, leave us a 5-star rating on Spotify or Apple. It helps people like you find the show AND it helps us land better guests. Thank you so much for your support.

🗺️ Want a FREE roadmap built for you, not by AI? 👉 https://dataanalystroadmap.com Help us become the #1 Data Podcast by leaving a rating & review! We are 67 reviews away! I tested GPT-6 Astra on the one question I know best. It got the skills right and almost everything else wrong.💌 Join 33k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://datacareerjumpstart.com/newsletter🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://datacareerjumpstart.com/training👩‍💻 Want to land a data job in less than 90 days? 👉 https://datacareerjumpstart.com/daa👔 Ace The Interview with Confidence 👉 https://datacareerjumpstart.com/interviewsimulator💼 Ready to get your projects off your computer? 👉 https://mydatafolio.com⌚ TIMESTAMPS 00:00 – GPT-6 Astra is here02:15 – Excel and SQL first07:45 – Start networking early10:54 – Learn by doing14:03 – The worst advice in the plan🔗 CONNECT WITH AVERY 🎥 YouTube Channel 🤝 LinkedIn 📸 Instagram 🎵 TikTok 💻 Website Mentioned in this episode:💙 Thank you for subscribing & leaving a reviewThanks to YOU we recently became the most popular data podcast out there. Thank you so much for listening. If you haven't subscribed yet, hit subscribe. It costs $0. If you enjoy the show, leave us a 5-star rating on Spotify or Apple. It helps people like you find the show AND it helps us land better guests. Thank you so much for your support.Early Black Friday Sale: Data Analytics AcceleratorOur early Black Friday sale for the Data Analytics Accelerator is live this week only. Join Avery’s data analyst bootcamp and get a discount plus a bunch of bonuses to help you land your first data job. Check out the Black Friday deal here:https://datacareerjumpstart.com/daa

Help us become the #1 Data Podcast by leaving a rating & review! We are 67 reviews away! Former LinkedIn exec explains why mass applying with AI is getting you nowhere. I asked him what works instead.🧑‍💼 See 60+ recruiters who are hiring data analysts right now 👉 https://findadatajob.com/recruiters💌 Join 33k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://datacareerjumpstart.com/newsletter🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://datacareerjumpstart.com/training👩‍💻 Want to land a data job in less than 90 days? 👉 https://datacareerjumpstart.com/daa👔 Ace The Interview with Confidence 👉 https://datacareerjumpstart.com/interviewsimulator⌚ TIMESTAMPS 00:00 – The AI arms race04:33 – What are we solving for?10:57 – Referrals were 10x in 201621:12 – Anyone can refer anyone22:18 – Elevator pitch or questions?36:36 – Is AI useless in the job search?42:24 – Quality beats volume🔗 CONNECT WITH JEREMY🤝 LinkedIn: https://www.linkedin.com/in/schifeling/📚 Check out Jeremy's books 👉 https://www.amazon.com/stores/author/B00AB7IEX2🔗 CONNECT WITH AVERY 🎥 YouTube Channel 🤝 LinkedIn 📸 Instagram 🎵 TikTok 💻 Website Mentioned in this episode:Early Black Friday Sale: Data Analytics AcceleratorOur early Black Friday sale for the Data Analytics Accelerator is live this week only. Join Avery’s data analyst bootcamp and get a discount plus a bunch of bonuses to help you land your first data job. Check out the Black Friday deal here:https://datacareerjumpstart.com/daa💙 Thank you for subscribing & leaving a reviewThanks to YOU we recently became the most popular data podcast out there. Thank you so much for listening. If you haven't subscribed yet, hit subscribe. It costs $0. If you enjoy the show, leave us a 5-star rating on Spotify or Apple. It helps people like you find the show AND it helps us land better guests. Thank you so much for your support.

Help us become the #1 Data Podcast by leaving a rating & review! We are 67 reviews away! Mason went from teaching middle school choir to a financial analyst job at Humana in 40 days. I asked him how.💌 Join 33k+ aspiring data analysts & get my tips in your inbox weekly 👉 https://datacareerjumpstart.com/newsletter🆘 Feeling stuck in your data journey? Come to my next free "How to Land Your First Data Job" training 👉 https://datacareerjumpstart.com/training👩‍💻 Want to land a data job in less than 90 days? 👉 https://datacareerjumpstart.com/daa👔 Ace The Interview with Confidence 👉 https://datacareerjumpstart.com/interviewsimulator⌚ TIMESTAMPS 00:00 – Choir teacher to Humana09:03 – Teaching stopped working12:33 – Go meet people16:12 – Apply before you feel ready20:06 – Fake it a little24:30 – Get a referral🔗 CONNECT WITH MASON🤝 LinkedIn: https://www.linkedin.com/in/mason-rice-a98559330/🎵 Follow his new choir, Voices of Kentuckiana 👉 https://www.instagram.com/voicesky/🔗 CONNECT WITH AVERY 🎥 YouTube Channel 🤝 LinkedIn 📸 Instagram 🎵 TikTok 💻 Website Mentioned in this episode:Early Black Friday Sale: Data Analytics AcceleratorOur early Black Friday sale for the Data Analytics Accelerator is live this week only. Join Avery’s data analyst bootcamp and get a discount plus a bunch of bonuses to help you land your first data job. Check out the Black Friday deal here:https://datacareerjumpstart.com/daa💙 Thank you for subscribing & leaving a reviewThanks to YOU we recently became the most popular data podcast out there. Thank you so much for listening. If you haven't subscribed yet, hit subscribe. It costs $0. If you enjoy the show, leave us a 5-star rating on Spotify or Apple. It helps people like you find the show AND it helps us land better guests. Thank you so much for your support.