Data Career Podcast
By Avery Smith - Data Career Coach
Data Career PodcastMay 13, 2021
109: How to Become a Data Visualization Designer & a Creative Data Analyst w/ Alli Torban
This episode features Alli Torban, a leading data information designer, sharing her career journey from a data analyst to teaching data visualization to companies like Google and Moderna.
Alli advises on becoming a data viz designer, emphasizing the significance of data literacy, tool mastery, and building a portfolio with personal projects.
Connect with Alli Torban :
🧙♂️ Ace the Interview with Confidence
📩 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:
(08:16) Alli's Transition to Freelance and Starting Her Own Company (17:40) Advice for Aspiring Data Visualization Designers (21:42) Unlocking Creativity with Practical Inspiration and Prompts
Connect with Avery:
🎵 TikTok
108: Data Analyst Mock Interview
In this episode, Avery conducts mock data analyst interview sessions with two participants, Richard and Joey, employing a newly developed tool called Interview Simulator.
The interview scenarios are designed to replicate real-life interviews. They aim to prepare aspiring data professionals for upcoming job interviews by showcasing examples of good practices and areas for improvement.
🧙♂️ Ace the Interview with Confidence
📩 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:
(01:40) - Tell Me About Yourself (05:31) - Explain SQL Window Function (09:55) - How Many Meeting Rooms
Connect with Avery:
🎵 TikTok
107: Interview Prep - Practice Mock Interview - Listen to Practice Before Your Interview
This is a mock job interview in which Avery the interviewer asks a series of common but important questions to gauge the interviewee's fit for a new company with a dynamic environment.
Questions cover reasons for seeking a new job, decision-making examples, handling deadlines, dealing with difficult co-workers, problem-solving skills, adapting to change, plans, and salary expectations.
🧙♂️ Ace the Interview with Confidence
📩 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:08) - Getting to Know You: Background and Aspirations (01:25) - Decision Making and Problem Solving in the Workplace (02:15) - Handling Deadlines and Difficult Co-workers (03:58) - Adapting to a New Company's Challenges (05:48) - Future Goals and Salary Expectations
Connect with Avery:
🎵 TikTok
106: Want to Stand Out as a Data Analyst? Master Data Storytelling w/ Brent Dykes
Join Avery on the latest episode of the Data Career Podcast as he sits down with Brent Dykes, the genius behind 'Effective Data Storytelling'. 🎙️
Discover the six game-changing elements of a data story, learn from the most common mistakes, and uncover the secrets to captivating your audience with every data presentation! 💡
Don't miss out on Brent's practical tips for transforming dull data into captivating stories – tune in now and take your data career to new heights! 🔥
✉️ Discover what we wish we knew about landing the dream job
🤖 Data Analytics Answers At Your Finger Tips
Connect with Brent Dykes:
📙 Get the Effective Data Storytelling book
🤝 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:
(03:57) Dive into Audience Psychology! (12:51) Master the Six Essential Elements! (19:08) Avoid Common Storytelling Mistakes! (26:52) Ace Job Interviews with Storytelling!
Connect with Avery:
🎵 TikTok
105: Do You Have to Be Good at Statistics to Be a Data Analyst w/ StatQuest Josh Starmer PhD
In this episode of the Data Career Podcast, Avery chats with Josh Starmer, PhD, also known as StatQuest on YouTube, about the common fear of math and statistics, and how to overcome it.
They delve into Josh's journey from hating math to becoming a beloved statistics YouTuber, his unique approach to making complex statistical concepts accessible, and the importance of understanding one's learning style.
✉️ Discover what we wish we knew about landing the dream job
🤖 Data Analytics Answers At Your Finger Tips
Connect with Josh Starmer PhD:
📘 Get StatQuest Illustrated Guide to Machine Learning
🤝 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:
(01:54) - Learning Styles and Overcoming Math Fear (07:03) - The Illustrated Guide to Machine Learning: A Must-Read (21:55) - The Practicality of Statistics: Learning by Doing (28:07) - The Birth of StatQuest: Transforming Teaching with YouTube (33:27) - Learning in Public: The Impact of Sharing Knowledge
Connect with Avery:
🎵 TikTok
104: Breaking into Sports Analytics w/ Ken Jee
In this episode of the Data Career Podcast, Avery interviews Ken Jee.
They delve into Ken's unique path into sports analytics, starting from his personal experience as a golfer and his curious inquiry that led to an internship and gradually crafted a niche in sports data science.
✉️ Discover what we wish we knew about landing the dream job
🤖 Data Analytics Answers At Your Finger Tips
Connect with Ken Jee
▶️ Ken Jee Official Youtube Channel
▶️ Ken's Nearest Neighbors Podcast
🏀 The Exponential Athlete Podcast
🤝 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:
(09:54) Deep Dive into Golf Analytics (18:16) Ken's Personal Journey into Sports Analytics (24:49) Breaking into Sports Analytics (29:16) The Power of Networking and Creating Opportunities
Connect with Avery:
🎵 TikTok
103: Conquering Your Fear of Becoming a Data Analyst w/ Erick Cuentas
In this episode of the Data Career Podcast, Avery interviews Eric Cuentas, a chemical engineer who turned into a data analyst and career coach.
They discuss obstacles when pursuing career goals and highlight the importance of determining genuine motivations to align with prospective roles.
They also discuss practical ways to overcome fear in the career transition process, emphasising the essentiality of consistent networking and the crucial role of resumes in the job application process.
✉️ Discover what we wish we knew about landing the dream job
🤖 Data Analytics Answers At Your Finger Tips
Connect with Erick Cuentas:
🤝 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:
(04:36) - Eric's Unique Career Journey (10:01) - Overcoming Fear in Career Transition (24:34) - The Importance of Job Titles in Career Progression (26:09) - The Job Search Process: Common Mistakes (28:15) - The Reality of Job Rejections (31:37) - The Impact of Networking in Job Search (37:41) - The Impact of Consistent LinkedIn Engagement
Connect with Avery:
🎵 TikTok
102: Exposing How Alex The Analyst Became a Data Analyst (And The Most Popular Data YouTuber)
Hear the story of Alex The Analyst like you've never heard it before. In this episode, Avery Smith sits down with Alex Freberg, more commonly known as Alex the Analyst to discuss his journey from no technical background to data analyst superstar. They talk about Alex's journey from a recreational therapy degree to learning what data analytics is. They also cover what matters most when getting hired as a data analyst. Is it technical skills like SQL and Python? Or is it something much simpler?
Connect with Alex the Analyst :
✉️ Discover what we wish we knew about landing the dream job
🤖 Data Analytics Answers At Your Finger Tips
🤝 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:
(6:01) Alex's Data Career Journey (11:50) Alex's First Portfolio (17:53) Alex's Advice on Getting Hired & Interviews (27:10) How to Become an Analyst in 7 Days
Connect with Avery:
🎵 TikTok
101: Expert Data Analytics Panel Tells All (100th Episode Celebration)
The 100th celebration episode of the Data Career Podcast features a special panel interview conducted by Avery Smith with prominent data content creators, including Ken Jee, Monica Kay Royal, Richad Nieves-Becker, and Elijah Butler.
Recorded in Charleston, South Carolina, this milestone episode dives into personal experiences in the data field, the relationship with AI, favorite data learning resources, and interview tips.
The discussion provides a unique mix of backgrounds, offering perspectives on succeeding in data careers, the impact of AI, and the importance of continuous learning.
Connect with the panels on LinkedIn:
🤝 Connect with Monica Kay Royal
🤝 Connect with Richad Nieves-Becker
✉️ Discover what we wish we knew about landing the dream job
🤖 Data Analytics Answers At Your Finger Tips
🤝 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:
(06:05) - Diving into the Panel: Introductions and Insights (09:33) - Exploring Favorite Data Tools and Facing AI Threats (16:58) - Learning Resources and Books for Aspiring Data Professionals (23:26) - Interview Tips: From Connection to Confidence
Connect with Avery:
🎵 TikTok
100: Job Hunt OS Launch w/ Asa Howard
Unlock the secret to job hunting success with JobHuntShortcut.com – land interviews without drowning in resumes, learn effective networking, and get $70 off today!
Connect with Asa Howard on LinkedIn.
99: Is a Data Analyst Bootcamp REALLY worth it? w/ Melissa Kings
This episode of the Data Career Podcast features Melissa Kings, a former teacher who transitioned into data analytics through the Data Analytics Accelerator bootcamp.
Melissa shares her journey, from deciding to switch careers to successfully landing job offers upon completing the bootcamp.
Melissa highlights the various aspects of the bootcamp, including doing projects, developing portfolios, involved networking, and the positive impact of the supportive community within the bootcamp.
Connect with Melissa Kings :
✉️ Discover what we wish we knew about landing the dream job
🤖 Data Analytics Answers At Your Finger Tips
🤝 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: (04:58) - Melissa's Background and Transition into Data Analytics (11:16) - The Power of Networking and Proactive Job Hunting (18:29) - The Importance of Networking in Career Advancement (19:36) - The Journey Through the Data Analytics Accelerator Program (23:52) - The Value of Community in Learning and Career Transition (30:25) - The Impact of the Data Analytics Accelerator Program
Connect with Avery:
🎵 TikTok
98: Day in the Life of a Data Analyst With Non-Technical Background w/ Paul Ahlstrom
In this episode of the Data Career Podcast, Avery talks with his childhood friend, Paul Alstrom, about his journey into data analytics from a non-technical background.
Paul emphasises the importance of networking, understanding the business, and getting the requirements right at the start.
They also explore the day-to-day life of a data analyst, how to make yourself useful to the business, as well as how to manage senior stakeholders.
Connect with Paul Ahlstrom:
✉️ Discover what we wish we knew about landing the dream job
🤖 Data Analytics Answers At Your Finger Tips
🤝 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:
(14:31) - The Importance of Networking in Job Hunting (22:44) - Understanding User Behavior through Data (23:12) - The Role of SQL in Data Analysis (23:25) - Business Use Cases for Data Analysis (27:55) - The Art of Reporting in Data Analysis (29:14) - The Importance of Asking the Right Questions (31:17) - The Role of Communication in Data Analysis (31:46) - The Power of Iterative Analytics (39:47) - Understanding the Business Context in Data Analysis
Connect with Avery:
🎵 TikTok
97: Winning with Data Science; A Handbook for Business Leaders w/ Akshay Swaminathan
In this podcast episode, Avery talks with Akshay Swaminathan, co-author of the book 'Winning with Data Science: A Handbook for Business Leaders.
They discuss the vague terms often thrown around in the data science industry and underline the importance of understanding these terms in order to make effective business decisions.
Swaminathan highlights the need to leverage data science in healthcare and real estate.
The episode covers various aspects of data analysis, including prediction, association, and description.
Connect with Akshay Swaminathan :
📘 Learn About Winning with Data Science
✉️ Discover what we wish we knew about landing the dream job
🤖 Data Analytics Answers At Your Finger Tips
🤝 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:
(12:14) - The Value of Data Science in Business (14:57) - The Role of Data Science in Problem Solving (20:36) - Understanding the Difference Between Data Science and Data Analytics (25:39) - The Importance of Framing Business Questions for Data Science (30:48) - The Power of Meeting Business Needs with Data Science: A Real-Life Example (38:26 ) - The Limitations of Data Science
Connect with Avery:
🎵 TikTok
96: What is Python & Why Should I Care? w/ Python Expert Michael Kennedy
Avery talks with Michael Kennedy about the many ways Python is used.
Michael hosts the Talk Python to Me podcast, is an expert in Python, and explains how experts use Python in various fields.
The episode also discusses beginners who want to learn and use Python, including choosing an IDE and focusing on projects.
Connect with Michael Kennedy
🐍 Learn About TalkPython Podcast
🤝 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:18) - Python vs Other Programming Languages (17:15) - The Future of Python and Its Applications (32:06) - How the Rockband Weezer uses Python
Connect with Avery:
🎵 TikTok
95: Nick Desbarats: How to Create Effective Data Visualization
Join us for a thorough discussion with data visualization expert Nick Desbarats. We will focus on creating charts and visualizing data.
Nick is a well-known instructor in the field of data & has taught many data professionals worldwide about visualizing data and designing dashboards.
In this episode, Nick explains how the choice of chart type affects how we understand data. He also discusses his recently published book, 'Practical Charts.'
Connect with Nick Desbarats :
🎒 Learn About Practical Reporting
📚 Purchase Practical Charts books
👍🏽 Leave your review and download the bonus:
🤖 Talk to AveryGPT for your data job hunt tips
🤝 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: (03:42) - The Importance of Choosing the Right Chart (11:39) - The Ethics of Data Visualization (24:03) - Understanding Less Common Chart Types (33:02) - The Spray and Pray Chart Method
Connect with Avery:
🎵 TikTok
94: Positive Affirmations for Aspiring Data Analysts [Listen Daily]
Tune in to this inspiring podcast episode filled with positive affirmations specially tailored for YOU, aspiring data professionals.
The episode seeks to motivate and mentally uplift listeners, encouraging you to embrace your potential in the field of data analysis.
Apart from helping deal with stress, anxiety, perfectionism, and imposter syndrome, let’s appreciate life's simple joys, promote confidence, and encourage problem-solving and personal growth.
🤝 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
Connect with Avery:
🎵 TikTok
93: I want to be a Data Analyst, but don’t have experience
In this episode of the Data Career Podcast, we include a variety of listener questions, shedding light on topics like the future of data engineering, requirements for becoming a data analyst, showcasing data cleaning proficiency in Excel, and securing data analyst internships.
Also discusses the significance of storytelling and views on Power BI versus Tableau & the impact of AI on data analysis roles.
Tune in now!
👍 Leave your review and download the bonus!
🤝 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:
(02:10) - What’s the future of data engineering in 2024? (03:06) - Do you need a degree to become a data analyst? (04:57) - How to showcase Excel skills? (07:22) - How to land data analyst internships? (10:10) - What are the main technical skills required to land your first data job? (14:40) - Have you worked with many teachers looking to make a career transition? (16:24) - How to get a data analyst job for people with no work experience? (25:13) - Can you suggest SQL and Excel videos for data analysis? (28:46) - Do you think the data analysis industry is saturated? (28:21) - Do you find data analysts transferring to becoming a data scientist or a data engineer?
Connect with Avery:
🎵 TikTok
92: What is Linear Programming? (A Glimpse to What I Did as a Data Scientist at ExxonMobil)
In this episode, we dive deep into linear programming and its applications in various business scenarios.
We discuss its powerful use in optimizing critical business decisions and also touch on how it was utilized in crucial roles at ExxonMobil to maximize refinery profits.
Tune in to uncover how linear programming can be a game-changer in your data career journey.
🌟Leave your review and download the bonus!
🤝 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:
(05:32) - Introduction to Linear Programming (09:28) - Understanding Linear Programming (12:12) - Applications of Linear Programming (14:55) - Maximizing and Minimizing in Linear Programming (18:43) - Applying Linear Programming to Business (33:20) - Using Linear Regression to Determine Slopes (35:06) - A Real-World Application
Connect with Avery:
🎵 TikTok
91: If I Wanted to Become a Data Analyst In 2024, This is What I'd Do [FULL BLUEPRINT]
This is the blueprint to becoming a data analyst & I will walk you through the levels step-by-step to becoming one this year.
Follow this blueprint, and I promise you can become a data analyst.
If you’d like more of my free resources, including a more in-depth webinar where I talk more about projects & networking, click the link to the descriptions.
Practice SQL with :
🤝 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:
(00:08) - Level 1
(04:20) - Level 2
(06:15) - Level 3
(07:50) - Level 4
(09:10) - Level 5
(13:05) - Level 6
(15:30) - Level 7
(18:20) - Level 8
(19:42) - Level 9
(21:50) - Level 10
Connect with Avery:
🎵 TikTok
90: 2024 New Year Resolutions: 3 Things You Need to Become a Data Analyst
89 The Fastest Way to ACTUALLY Get Hired as a Data Analyst with NO Work Experience
In this episode, Avery & Rho discuss challenges faced while applying for a data career job and how to overcome them.
In the episode, Rho shares critical insights into the importance of effectively presenting your skills, the significance of your resume, networking, and how continuous learning helps you face the evolving challenges in the data space.
Listen to find out how Rho turned every challenge into an opportunity, ultimately landing a role as a senior analytics engineer.
Connect with Rho Lall :
🤝 Connect on Linkedin 🎒 Learn About Free Interview Challenge: 7 Interviews in 7 Days
🤝 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:
(07:33) - The Journey to Becoming a Data Analyst (18:06) - The Hiring Ladder (25:05) - Building Confidence for Job Interviews (26:03) - Understanding the Hiring Process (28:10) - Overcoming Analysis Paralysis (30:30) - The Two Questions That Matter in Hiring
Connect with Avery:
🎵 TikTok
88: How to Work with Recruiters as a Data Analyst ft. Hire-Fit
How can you work with a recruiter in your data journey? Listen to find out!
Katie and Bobby from Hire-Fit share their insights on creating a killer LinkedIn profile, tailoring your resume to stand out, and making human connections that will make a lasting impression on hiring managers.
Listen if you want a leg-up in the job hunt!
Connect with HireFit:
🗄️ Join FREE SQL hands-on workshop this December!
⭐ Leave a Podcast review & get your bonus!
🤝 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:19) - Recruiters Don’t Want to Help: myth or truth
(28:47) - LinkedIn is KING for recruiters & applicants
(35:48) - Work smarter, not harder in your job search
Connect with Avery:
🎵 TikTok
87: Becoming a Data Analyst with Elijah Butler
Join TikTok star, Elijah Butler, a Data Analyst at Humana, as we discuss his journey into data analytics, share valuable insights about the importance of networking, and ponder over the necessity of a master's degree in the field.
The episode provides an interesting blend of professional and personal life experiences and is packed with valuable advice for anyone aspiring to advance their career in data analytics. Don't miss out on these insights!
Connect with Elijah Butler:
🗄️ Join FREE SQL hands-on workshop this December!
⭐ Leave a Podcast review & get your bonus!
🤝 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:
(8:37) - Elijah's Journey becoming a data analyst
(17:00) - Networking matters more than you think
(21:00) - Master the tools
(35:11) - Book recommendations
Connect with Avery:
🎵 TikTok
86: SQL Simplified: For Data Beginners
SQL is the most important data skill you can learn on your journey. And it doesn’t need to be complicated. In this episode, dive into a short SQL introduction, basic SQL commands and know how SQL can help you land your data job.
Tune in now!
🗄️ Join FREE SQL hands-on workshop this December!
⭐ Leave a Podcast review & get your bonus!
🤝 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:
(06:01) - How to get better in SQL
(08:41) - SQL commands to know
(20:48) - Come join FREE SQL hands-on Workshop
Connect with Avery:
🎵 TikTok
85: Landing a Job as an Immigrant w/ Daniel Botero
Join Avery Smith with Daniel Botero, an expert in helping international STEM students navigate the job market in the US, as they discuss the challenges and strategies for landing a job as an immigrant in the data career field.
Tune in to gain valuable insights and tips for success in this competitive job market.
Don't miss out on this enlightening conversation, available now on the Data Career Podcast!
Connect with Daniel Botero:
▶️ 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:
(05:20) - The job market is tough
(20:13) - Ask for advice, not referral
(35:58) - Hiring is like investing, be the best investment
Connect with Avery:
🎵 TikTok
84: Presenting for Data Analysts w/ Hana M.K.
Join Avery Smith as he chats with data visualization expert Hana M.K. about the importance of presentation skills for data professionals in this engaging episode of the Data Career Podcast.
Discover how Hana helps data professionals improve their presentation abilities and land their dream jobs as she shares valuable insights and resources.
Don't miss out on this episode filled with tips, advice, and inspiration to become a skilled data presenter – tune in now to the Data Career Podcast with Avery Smith and special guest Hana M.K.!
Connect with Hana M.K.:
🤝 Connect on Linkedin 🛣️ Download Data Presentation Roadmap
🎧 The Art of Communicating Data Podcast
🎒 Learn About the Trending Analytics
🤝 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:
(09:33) - Start practicing your presentation NOW
(19:46) - The SECRET of presenting data effectively
(29:05) - No one WANTS to see your code. Show this instead.
Connect with Avery:
🎵 TikTok
83: Building Data Analytics Projects w/ Matt Mike
Join Avery Smith as he chats with data analytics expert Matt Mike about the secrets to building impressive data analytics projects.
In this episode, Matt Mike shares valuable insights on the importance of creating unique projects and why building from scratch challenges you to become a true expert in the field, helping you stand out and speak passionately about your work in interviews.
Don't miss out. Tune in now!
Connect with Matt Mike:
▶️ Subscribe to Youtube Channel
🎒 Learn About Data Skills Tracker
🤝 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:
(03:00) - Matt’s story from teaching to data
(20:23) - Building Personal Projects
(35:55) - LinkedIn networking is essential for data job hunting.
Connect with Avery:
🎵 TikTok
82: Mastering Data Analytics with Excel w/ Matt Brattin
Join host Avery Smith, with Excel expert Matt Brattin about mastering data analytics with Excel in this episode of the Data Career Podcast.
From customizing shortcuts to leveraging advanced functions, Matt shares tips and tricks to take your Excel skills to the next level.
Get insights from an industry pro and boost your chances of landing your dream data job.
Tune in now!
Connect with Matt Brattin:
▶️ Subscribe to Youtube Channel
🎒 Learn About the Excel 4 Academy
🤝 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:
(07:53) - 5 Concepts of Excel you should know
(20:35) - Top Excel Shortcuts
(26:54) - Can you make a dashboard in Excel?
(30:20) - Excel is like Thor’s hammer
Connect with Avery:
🎵 TikTok
81: Zero to Data Analyst: Tim Beecher’s Journey from Locksmith to Data
Join Avery Smith with special guest Tim Beecher to discuss his incredible journey from a locksmith to a successful data analyst in this inspiring episode of the Data Career Podcast.
Discover how Tim's determination, networking skills, and project-based learning led him to a fulfilling career and learn valuable tips on how to make a similar transformation in your life.
Don't miss this opportunity to gain insights and practical advice from Tim's experiences - tune in now!
💼 Connect with Tim Beecher on Linkedin
🤝 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:
(09:27) - Why data analytics
(10:18) - Get paid to learn data
(24:14) - Using your network to land a job
(36:04) - Day in the life as a Marketing Data analyst
Connect with Avery:
🎵 TikTok
80: Become a Data Analyst in 90 Days
In this episode, Avery shows you how you can become a Data Analyst in just 90 days.
Join him as he debunks the myths, provides practical advice, and inspires you to achieve the seemingly impossible.
You got this. Tune in and level up your data career today!
🤝 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:
(05:44) - Stop thinking small
(06:40) - Speed is key
(15:12) - Portfolio, experience, shadowing, learn from others
Connect with Avery:
🎵 TikTok
79: From Construction to Data Analytics (Jordan Temple's Story)
Join Avery Smith and Jordan Temple in this episode of the Data Career Podcast.
Jordan shares his insights on breaking into the data industry with a non-technical background, leveraging skills in Power BI and the power of a solid online presence.
Tune in now to gain inspiration and guidance for your data career journey.
Connect with Jordan Temple:
🤝 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: (07:02) - Excel + Power BI
(12:20) - Landing a job with a DM
(15:10) - Hybrid > Remote
Connect with Avery:
🎵 TikTok
78: Data Consulting w/ Leon Gordon
Join Avery for a captivating episode with Data Consulting expert Leon Gordon, to delve into the world of data consulting and the skills needed to excel in this field.
Don't miss out on this fascinating conversation filled with valuable insights and advice for data professionals looking to make a difference as consultants.
Tune in now to better understand the data consulting industry and how you can navigate your way to a successful career!
Connect with Leon Gordon:
🤝 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:
(5:56) - Data Consulting
(9:45) - Power BI
(25:00) - Data Projects
Connect with Avery:
🎵 TikTok
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]
🎙️ 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