Data Career Podcast
By Avery Smith - Data Career Coach
Data Career PodcastMar 22, 2023
77: Data Visualization Tips w/ Tableau Expert Andy Kriebel
Join me with Tableau expert Andy Kriebel about data visualization tips! 📊
Andy shares his expertise to help you level up your data skills, from creating purposeful dashboards to the power of dot maps.
Tune in now and take your data visualizations to the next level! 🎧
Connect with Andy Kriebel:
▶️ Subscribe to Youtube Channel
🤝 Ace your data analyst interview with the interview simulator
📩 Get my weekly email with helpful data career tips
📊 Come to my next free “How to Land Your First Data Job” training
🏫 Check out my 10-week data analytics bootcamp
Timestamps:
(11:15) - When dealing with time series, your best friend is the versatile line chart 📈
(13:34) - Dive into dot maps for super-detailed visualizations 🌍
(17:30) Want to compare rankings over time? Bump chart!📊📈
(21:10) Keep your graphs simple and spiced up with context📉
(26:45) Dashboards should tell a story; ensure they have a purpose and context to keep folks engaged. 📋💡
(34:27) Prepping for an interview? Be chatty, be prepared with your interviewers. 🗣️🤝
Connect with Avery:
🎵 TikTok
76: How We Use AI as Data Analysts w/ Luke Barousse
In this episode of the Data Career Podcast, I sit down with Luke Barousse, a data analyst and data star on YouTube, to discuss the impact of AI on the role of data analysts.
We delve into the question of whether AI will replace data analysts or enhance their work, sharing insights and perspectives on the topic.
Connect with Luke Barousse:
📩 Get my weekly email with helpful data career tips
📊 Come to my next free “How to Land Your First Data Job” training
🏫 Check out my 10-week data analytics bootcamp
Timestamps:
(05:22) - ChatGPT Code Interpreter
(09:09) - Will AI Steal Your Job?
Connect with Avery:
🎵 TikTok
75: Want to be a Data Analyst? Learn These Skills w/ Luke Barousse
What skills should you learn when studying to be a Data Analyst?
Join me with data legend Luke Barousse to discuss where you should focus your time.
Is it Python? Is it SQL? Is it Excel? Is it Power BI?
Listen to find out 👀
Connect with Luke Barousse:
📩 Get my weekly email with helpful data career tips
📊 Come to my next free “How to Land Your First Data Job” training
🏫 Check out my 10-week data analytics bootcamp
Timestamps:
(03:42) - Analyzing 1.2M data jobs (DataNerd.tech)
(06:21) - The most important data skills
(12:13) - More senior skills
(22:52) - Data job titles
Connect with Avery:
🎵 TikTok
74: How to Ace The Data Science & Analytics Interview w/ Nick Singh
Join me with data interview expert Nick Singh to discuss how to ace your data science and analytics interviews, from preparation tips to tackling SQL technical questions, in this must-listen episode of the Data Career Podcast—you won't want to miss it!
Connect with Nick Singh:
🎁 Free SQL Tutorial from Data Lemur: https://datalemur.com/sql-tutorial
📕 Buy "Ace the Data Science Interview" book
👔 Get a discount on my data interview prep course: https://www.datacareerjumpstart.com//interview
📩 Get my weekly email with helpful data career tips
📊 Come to my next free “How to Land Your First Data Job” training
🏫 Check out my 10-week data analytics bootcamp
Timestamps:
(16:10) - 📊 Best interview tips
(36:30) - 🔄 Mock interview practice
Connect with Avery:
🎵 TikTok
73: I Have Good News for Aspiring Data Analysts
Join me in this week's episode as I share real success stories from participants in the Data Analytics Accelerator program. 🧑🏽🎓
These are REAL stories from REAL people like you, going through their journey. Some of their wins are big like data analyst job offers. Others are small and just include posting on LinkedIn or reaching out to a recruiter.
Featuring tips on resume and LinkedIn profile optimization that led to interviews and job offers, proving that small changes can make a big impact in your data career journey—tune in now!
📩 Get my weekly email with helpful data career tips
📊 Come to my next free “How to Land Your First Data Job” training
🏫 Check out my 10-week data analytics bootcamp
Timestamps:
(02:55) - 📊 The Job Market is HARD.
(04:58) - 💼 Story 1: Interviews
(7:33) - 👩💻 Story 2: Quick Wins
(09:25) - 💌 Story 3: Cold Messaging
(10:36) - 💰 Story 4: Senior Job Offer
(13:40) - 🚀 Story 5: Small Wins
(14:37) - 🎓 Story 6: Job Offer
Connect with Avery:
🎵 TikTok
72: What Is People Analytics? w/ Serena Huang
Want to know what it takes to land your dream data analytics job?
Dr. Serena Huang, an ex-PayPal Analytics Executive, spills the beans and shares invaluable tips on standing out in the hiring process. 🫘
She also discusses what People Analytics is & how to learn more.
Whether you're a new grad or a seasoned professional looking to make a career transition, this episode has got you covered!
Tune in now and unlock the possibilities. 🎧
📩 Get my weekly email with helpful data career tips
📊 Come to my next free “How to Land Your First Data Job” training
🏫 Check out my 10-week data analytics bootcamp
Connect with Dr Serena Huang:
🌐 Website
⏯️ Linkedin People Analytics Course I
⏯️ Linkedin People Analytics Course II
Timestamps:
(04:58) - 🚀 What is People Analytics
(17:09) - 🌟 Keys to getting hired in data
(25:06) - 📊 What makes a good data team
Connect with Avery:
🎵 TikTok
71: Get Hired as a Data Analyst w/ Hiring Manager Andrew Madson
In this episode, Andrew Madson, an experienced data analytics professional & hiring manager, shares valuable insights and tips on transitioning into the field of data analytics. 💠
We discussed what ACTUALLY gets you hired, how to make good data projects, & how to pivot into the data field.
Whether you're just starting your data career journey or looking to make a pivot, this episode is a must-listen! 🎧
📩 Get my weekly email with helpful data career tips
📊 Come to my next free “How to Land Your First Data Job” training
🏫 Check out my 10-week data analytics bootcamp
Timestamps:
(03:46) - 📈 The Surprising Skill You Need
(13:20) - 🎙️ Make Your Data Projects Clear
(20:28) - 🔍 Data Skills You Should Know
(29:11) - 🌐 Networking: Your Gateway to Career Success!
Connect with Avery:
🎵 TikTok
70: He’s Hired 30 Data Analysts; Here’s What You Should Know
Join me and the man who has interviewed 300 data analysts, Jesse Morris, in this episode as we discuss what it is like to get hired as a data analyst.
Throughout the episode, Jesse imparts golden nuggets of wisdom, shedding light on what employers seek in prospective candidates, why being a data analyst is awesome, and what tools you should use along the way.
Tune in now! 🎧
📩 Get my weekly email with helpful data career tips
📊 Come to my next free “How to Land Your First Data Job” training
🏫 Check out my 10-week data analytics bootcamp
Timestamps:
(05:53) - The Data Analyst Hiring Process 💎
(17:48) - Attitude, passion, & communication > Technical Skills 😎
(25:03) - Things you can do to stand out in the job hung 📈
(31:44) - Volunteering for a non-profit can help you land a job 🤝
Connect with Avery:
🎵 TikTok
69: Skills, Networking, Portfolio: How Brad Yarbro Landed a Data Job
In today's episode, I had the privilege of interviewing the incredible Brad Yarbro, a senior data scientist at Protective Life. 🎙️
His journey from an economics student to a data professional is beyond inspiring.
Listen and get inspired to kickstart your own data career! 📊💼
📩 Get my weekly email with helpful data career tips
📊 Come to my next free “How to Land Your First Data Job” training
🏫 Check out my 10-week data analytics bootcamp
Timestamps:
(05:18) - 🌟 Gain Work Experience: Opportunities for Students!
(12:18) - 💼 From Analyst to Supply Chain Guru: A Journey
(16:37) - 📊 Data Pros Unite: Meet the Data and Business Teams
(22:06) - 📸 Quality Analysis with Cutting-Edge Tech in Defense
(29:12) - 💡 Data Career Advice: Networking Leads to Success
Connect with Avery:
🎵 TikTok
68: Difference between Data Science and Data Analytics
Don't miss it!
📩 Get my weekly email with helpful data career tips
📊 Come to my next free “How to Land Your First Data Job” training
🏫 Check out my 10-week data analytics bootcamp
Timestamps:
(00:56) - Predictive Analytics: Foreseeing the Future 🔮📈
(01:43) - Diagnostic Analytics: Unraveling "Why" 🕵️♂️🔍
(02:10) - Analytics in Book Sales 📚📊
(03:09) - Data Scientists: Masters of Prediction 🧠🎯
(03:56) - Decoding Data Analytics vs. Data Science 🗝️💻
(05:26) - Gateway to Success: Landing a Data Job 🚪💼
Connect with Avery:
📺 Subscribe on YouTube
🎙Listen to My Podcast
👔 Connect with me on LinkedIn
🎵 TikTok
67: Hiring Manager’s Secrets to Getting The Job as a Data Analyst w Megan McGuire
🕵️♂️ Curious about the mysterious hiring process of a data career? Find out how Megan McGuire narrows down candidates and assesses skills in the podcast. Get insider knowledge on code assessments, interviews, and what it takes to land the dream data role! 💪📈
📊 Come to my next free “How to Land Your First Data Job” training
🏫 Check out my 10-week data analytics bootcamp
Timestamps:
(02:14) - The Value of Junior Analysts
(12:12) - Curiosity and Problem Solving in Data Analytics
(21:46) - Be the perfect candidate for specific company rather than a pretty good candidate
(24:15) - How drive, experience and upskilling set up interviewee success
(28:59) - Show off your skills with your Tableau Public or GitHub Profile
(36:53) - Rejections aren't necessarily your fault
Connect with Avery:
🎵 TikTok
66: The Naked Truth about Data Careers w/ Data Manager Marijn Markus
In this episode, Marijn Markus & I talked about what it is ACTUALLY like being in the data field, how he transitioned from social science to data science, & discuss some real-world data use cases.
Marijn also shared his experience managing data teams, what makes a good junior hire, why you might not need machine learning, & much, much more.
You don’t want to miss this episode!
📊 Come to my next free “How to Land Your First Data Job” training
🏫 Check out my 10-week data analytics bootcamp
Connect with Marijn: https://www.linkedin.com/in/marijnmarkus/
Timestamps:
(4:40) - Diverse backgrounds matter for programming and stats! (17:42) - Model explanations matter for business (21:00)- The real reason why generative AI became big in December (25:24) - Focus on what you know, not what you don't know (30:14) - You can't control the interview session? Think again!
65: From Music Sheet to Spreadsheets: Erin Shina’s 90-Day Transformation from Music to Financial Data Analyst
Join us as we interview my bootcamp student Erin Shina who recently pivoted her career from music therapy to a financial analyst role at Fortune 50 company Humana.
🏫 Check out my 10-week data analytics bootcamp
📊 Come to my next free “How to Land Your First Data Job” training
Timestamps:
(2:49) - Hybrid work is the new norm, combining office and remote setups. 💼🏠
(6:00) - A supportive boss is crucial in advancing your data career. 👩💼🚀
(9:00) - Music therapy offers a fulfilling career path in healthcare. 🎵⚕️
(10:11) - Discover how the Data Analytics Accelerator helped Erin secure a data job. 📊🔍
(14:16) - Showcase your project effectively to increase your interview chances. 📂🎯
(17:25) - Put extra effort into crafting an impactful resume. 📄💪
(21:41) - Your current network could become a valuable referral for your next job opportunity. 🌐🔗
Connect with Avery:
🎵 TikTok
64: Data Portfolios, Data Analyst Interviews, and Data Storytelling: Ask Me Anything
In this episode, Avery took a unique approach by going live on LinkedIn and letting the audience ask any question they wanted.
Join us as we dive deep into Avery's insights and practical tips to help you navigate the world of data.
🏫 Check out my 10-week data analytics bootcamp
📊 Come to my next free “How to Land Your First Data Job” training
Timestamps:
(3:09) - What should I have on my portfolio?
(05:24) - How to build a project?
(06:11) - How to stay organized?
(07:08) - Starting w/ Data Science Projects
(16:00) - How to become a better storyteller?
(21:18) - What to do if you're not landing any interviews?
Connect with Avery:
🎵 TikTok
63: I’ve Taught 1,028 People Data Analytics (here’s what I’ve Learned)
Over the past 5 years, I’ve taught 1000’s about data analytics.
What have I learned as a teacher?
Where have I seen the most success?
What’s the biggest secret to people who succeed?
In this episode, I’ll share it all :)
🏫 Check out my 10-week data analytics bootcamp
📊 Come to my next free “How to Land Your First Data Job” training
Timestamps:
(3:30) Journey: Teaching data analytics full-time for the past year and a half. 📊
(8:58) Lesson: Skills alone aren't enough to land data jobs. 🎓
(13:06) Focus: Guiding students to low-barrier, rewarding data positions. 🔍
(18:25) Success: Marketing, portfolio, and networking are crucial for data job seekers. 🌟
Connect with Avery:
🎵 TikTok
62: Unleash Your Data Superpowers with Dummy Projects
Unravel the secret sauce behind starting with dummy projects and paving your way to extraordinary success.
Come and join Avery answered Muhammad’s question on how to get create good data portfolio, and how dummy projects are helpful for upskilling.
📊 Come to my next free “How to Land Your First Data Job” training
🏫 Check out my 10-week data analytics bootcamp
Timestamps:
(5:06) - Stepping stone: Dummy projects lead to advancement. 💡
(6:20) - Explore: Find intriguing online project ideas. 🌐
(6:45) - Learn: Embrace initial challenges for growth. ⚽
(7:20) - Mindset: Start, improve, conquer data projects. 🚀
(8:00) - Resources: YouTube, webinars, podcast - career boost.
Connect with Avery:
🎵 TikTok
![61: Inside My Data Bootcamp: A Sneak-Peak of the Data Analytics Accelerator [Members Only]](https://d3t3ozftmdmh3i.cloudfront.net/staging/podcast_uploaded_episode400/14459089/14459089-1688245249216-020dc752a2b16.jpg)
61: Inside My Data Bootcamp: A Sneak-Peak of the Data Analytics Accelerator [Members Only]
🎙️ Get ready for an exclusive, behind-the-scenes episode! 🚀
Dive into our members-only content, where you'll learn and gain invaluable insights on the expectations, workings, and fantastic resources of our data career bootcamp.
Take advantage of this incredible opportunity!
📊 Come to my next free “How to Land Your First Data Job” training
🏫 Check out my 10-week data analytics bootcamp
Timestamps:
(3:28) - 🏗️ Laying the Foundation: Build your data career from scratch!
(4:54) - 🤝 Community Support: Join a like-minded community to land data jobs!
(7:10) - 🎯 Learn and Upskill: Master data at your own pace!
(9:20) - 🙌 Stay Accountable: Achieve your data goals with our support!
(10:57) - ❤️ Love Data Work: Experience the thrill of working with data!
(11:52) - 🌍 Make an Impact: Change the world with the power of data!
(12:33) - 💰 Lucrative Careers: Earn big with your data skills!
(12:46) - ⏰ Flexible Work: Work on your terms!
(16:28) - 🎮 Project Power: Boost your skills with hands-on projects!
(21:57) - 🤝 Network for Success: Unlock data job opportunities through networking!
Connect with Avery:
🎵 TikTok
60: Underrated or Overrated with Shashank Kalanithi - AI, Power BI, Cold Messaging & More!
What does data engineer @ShashankData think about AI, Power BI & Cold Messaging?
Listen to find out 👆
Subscribe to Shashank's Channel: https://www.youtube.com/@ShashankData
📊 Come to my next free “How to Land Your First Data Job” training
🏫 Check out my 10-week data analytics bootcamp
Connect with Avery:
📺 Subscribe on YouTube: youtube.com/c/AverySmithDataCareerJumpstart/videos
🎙 Listen to My Podcast: podcasts.apple.com/us/podcast/data-career-podcast/id1547386535
👔 Connect with me on LinkedIn: linkedin.com/in/averyjsmith/
📸 Instagram: instagram.com/datacareerjumpstart/
🎵 TikTok: tiktok.com/@verydata
59: Will AI Replace Data Analysts?
Will AI replace data analyst? Is it going to happen? Has it already happened?
In this episode, I wanted to dig into if I actually think that's going to be the case.
📊 Come to my next free “How to Land Your First Data Job” training
🏫 Check out my 10-week data analytics bootcamp
Timestamps:
(01:00) - Brace yourself: AI has ARRIVED! 🤖
(01:44) - Is your data analyst job in jeopardy? AI vs. Human Skills 💼
(02:54) - The art of data analysis using AI 🚀
(03:29) - AI is just a tool 🧮
(04:01) - AI is just like Google 🔓
(05:55) - Job Security? Get good at AI 🌟
(07:18) - Humans make decisions ✨
(08:00) - Join the Ultimate Data Bootcamp! 📚💪
Connect with Avery:
🎵 TikTok
58: The Easiest Place To Land Your First Data Job
Don't overlook the hidden gem right in front of you: internal positions.
Landing an internal job is easier than going through the external route.
🌟 Join the data project club!
📊 Come to my next free “How to Land Your First Data Job” training
🏫 Check out my 10-week data analytics bootcamp
Timestamps:
(0:00) - The Best Place to Land Your First Job
(2:58) - How I Landed My First Data Job
(7:11) - Your Company Has a Data Team?
(10:22) - Network Inside Your Company
(12:54) - Use data at your current position
(14:01) - Attend Data Events
Connect with Avery:
📺 Subscribe on YouTube
🎙Listen to My Podcast
👔 Connect with me on LinkedIn
🎵 TikTok
57: Want to Become a Data Analyst? Start here.
This is the most upvoted post in the r/datanalysis history, full of advice and a roadmap to becoming a data analyst.
Join me as I'm going to be diving into what their advice was and if I agree or disagree with it.
🌟 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:52) - Do I need a degree?
(1:34) - Is Google Data Analytics Cert enough?
(3:39) - Will my degree help me?
(5:54) - What do I need to learn?
(8:07) - Do certifications matter?
(9:01) - Can I get a job right away?
(10:36) - Is having a degree is enough?
(11:41) - Build a strong foundation
(11:58) - Get hands-on experience
(12:21) - Build your network
(12:40) - Should You Get a CS Degree?
(13:09) - Should I learn Machine Learning
(13:54) - Build a portfolio
(14:31) - Create a personalized resume
(14:51) - Practice every day
(14:59) - Have the right attitude
(15:20) - Applying for the jobs
(16:13) - Be very patient
Connect with Avery:
📺 Subscribe on YouTube
🎙Listen to My Podcast
👔 Connect with me on LinkedIn
🎵 TikTok
I Just Had a Baby (Small Favor)
56: What is Data Project Club? And why should you join?
Stop being left behind by not building data project.
It can be intimidating to build a real-world data project alone.
But why be alone when you can be with us in the Data Project Club?
Come join me talking about cool Data Project Club, that can help you show your skills, build your project and expand your data network.
“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:00) - Projects Are The Cheat Code
(1:55) - Why data project are your career accelerator?
(3:37) - Show Your Skills > Tell Your Skills
(3:43) - Doing data projects is FUN!!!
(4:37) - Come join The Data Project Club
(5:51) - Practice. Build Connect.
(7:01) - My Bootcamp
(7:30) - Data Project Club Perks
(10:48) - Data Project Club Tiers
Connect with Avery:
🎵 TikTok
55: Land Data Job With No Degree w/ Teshawn Black
If you find yourself in a situation where you don't have a college degree, I want you to know it is possible to land a data job.
In this episode, Teshawn Black shares his experience landing data contracts at Google & LinkedIn despite having no certifications.
“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
Teshawn’s Links:
https://www.tiktok.com/@the6figureanalyst
https://app.mediakits.com/the6figureanalyst
Timestamps:
(6:29) - Providing value is KEY!
(10:49) - We don’t have tomorrow, so live today
(13:43) - Understand what company looks for
(17:05) - Learn to communicate effectively
(19:14) - Working contract jobs is a blessing
(20:17) - Always market yourself
(22:33) - Ask the budget first
(25:07) - Is job security really SECURE?
(27:35) - We are all expendable
(29:32) - Focus on data cleaning & data manipulation
(30:42) - Don’t skip Excel!
Connect with Avery:
🎵 TikTok
54: How to Build Your First Data Analytics Project
Building data analytics projects is the key to landing your first data job.
Here’s a 6-step guide to doing your first project.
“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:43) - Step 1: Deciding What Project To Do
(4:00) - Step 2: Finding a Good Data Set
(5:30) - Step 3: Defining the Project
(6:32) - Step 4: Exploratory Data Analysis
(9:16) - Step 5: Real Analysis
(11:04) - Step 6: Publish the project
Connect with Avery:
🎵 TikTok
53: Best Data Visualization Books for Beginners 📚
If you want to learn data visualization, here are the best 5 books you should read.
Get the books via links down below.
“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:34) - Book 1: Storytelling with Data
(1:50) - Book 2: The Big Book of Dashboards
(2:51) - Book 3: Envisioning Information
(4:12) - Book 4: How Charts Lie
(5:14) - Book 5: Show Me The Numbers
Mentioned Links:
📚 Storytelling with Data: https://amzn.to/3n2rDwJ
📚 The Big Book of Dashboards: https://amzn.to/42nBmO4
📚 Envisioning Information: https://amzn.to/3yN8a5z
📚 How Charts Lie: https://amzn.to/3luqQ77
📚 Show Me The Numbers: https://amzn.to/3FxgeuW
Connect with Avery:
🎵 TikTok
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
“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:
🎵 TikTok
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.
“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:
🎵 TikTok
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.
“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:
🎵 TikTok
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.
“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?)
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
“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?)
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.
“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?)
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.
“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:
(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?)
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.
“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?]
44: From a Teacher to a Data Analyst w/ Chris French
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.
“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:
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:
- 📺 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?
43: Should You Accept The Data Analytics Job Offer?
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.
“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:
- 📺 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?)
42: How Cold Messaging Helped Me Land His First Data Analytics Job w/ Asa Howard
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.
“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:
- 📺 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?)
41: What I Wish I Knew...
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?
40: Best Project For Data Science
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 and review the podcast to help against the war against the algorithm
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
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?
39: No Data, No Machine Learning
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 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?
38: Masters in Data Analytics From Georgia Tech: Is It Worth It?
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 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?
37: Building Fun Data Science Projects (Interview with Kyle Pastor a.k.a. DataStuffPlus)
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.
Want a free guide to get your data journey started? Get a free data roadmap here.
Ready to jumpstart your data career? Try the #21DaysToData Challenge.
36: Become A Data Scientist In 2022
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 Scientist Story
Rather watch this as a YouTube video? Check it out (and subscribe).
Want to jumpstart your data scientist journey in 2022? Check out The #21DaysToData Challenge: https://www.datacareerjumpstart.com/21daystodata
If you listen to this podcast regularly, please subscribe and leave a rating; it helps other people like you find the podcast, and supports the show, and it is free!
35: 20 Red Flags For a Tech Job
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 finding this podcast helpful, and want to help so others can listen, leave a rating and review
34: 2021 Review + 21 Days to Data Challenge
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 Georgia Tech
- 20 days with youth group in Dominican Republic
- Launched Data Career Jumpstart
Please subscribe to the podcast, and leave us a review! It means the world to me!
33: Cleaning Data with Susan Walsh (The Classification Guru)
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.facetpublishing.co.uk/page/detail/between-the-spreadsheets/?k=9781783305032
32: Down With Big Data, Up With The Data Rebels
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
31: Data Management 101 with Georgia Firican
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!
30: Ask Me Anything - July 26, 2021
WE COVERED ALL SORTS OF QUESTIONS! Data engineering, data science masters, forecasting, and much more!
29: How 1 Tweet Landed Her Dream Job with Emily Vu
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/@itsemvu?lang=en
Check out Emily's custom resume Kofi: https://ko-fi.com/emilyvu/commissions#buyCommissionModal
Want to break into data science? Check out online bootcamp Data Career Jumpstart - https://www.datacareerjumpstart.com - where I help you learn data science, and build a personal brand by focusing on projects and building an online portfolio.