Exposing How Alex The Analyst Became a Data Analyst

Hear the story of @AlexTheAnalyst 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?
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 Alex the Analyst :
🤝 Follow on Linkedin: / alex-freberg
▶️ Subscribe on KZbin: / @alextheanalyst
🎒 Learn About Analyst Builder: www.analystbuilder.com/?via=a...
✉️ Discover what we wish we knew about landing the dream job: www.datacareerjumpstart.com//...
🤖 Data Analytics Answers At Your Finger Tips: www.datacareerjumpstart.com/a...
🤝 Ace your data analyst interview with the interview simulator: www.datacareerjumpstart.com/i...
📩 Get my weekly email with helpful data career tips: www.datacareerjumpstart.com//...
📊 Come to my next free “How to Land Your First Data Job” training: www.datacareerjumpstart.com/t...
🏫 Check out my 10-week data analytics bootcamp: www.datacareerjumpstart.com/daa
Connect with Avery:
📺 Subscribe on KZbin: / averysmithdatacareerju...
🎙 Listen to My Podcast: podcasts.apple.com/us/podcast...
👔 Connect with me on LinkedIn: / averyjsmith
📸 Instagram: / datacareerjumpstart
🎵 TikTok: / verydata

[@carlostakashima8804]

I’ve been applying for Data jobs for over 6 months now, and not one interview. I actually worked as a data analyst for an organization within a detention facility for a year, 3 years back. Got let go because of COVID restrictions for civilians inside the facility. Been working on gaining certifications, learning SQL and Tableau, but no luck. I’ve recently signed up for Alex’s analyst builder, it’s a really cool platform and much more practical than other courses I’ve paid for. It’s a great field, but there’s so much competition out there and a bit disheartening 😔. Alex’s story gives me hope.

[@sammiesmith3454]

once you make it to an interview, being liked is what will get you the job. getting the interview is the hardest part honestly.

[@v-7815]

Yes and no. You have to have AT LEAST a bit of technical knowledge.

[@PPCCO.]

If you only hire people that you like, there's no way you can create the best team possible. It relies too much on your personal experience, and unless you are well traveled, it would become a fallacy due to the limited data set known as a bias. There has to be a balance: You need extroverts, introverts (who are typically numbers driven), and in between. Problem solving as a team is about the ability to tackle problems from different angles, that the next person may not be able to see. There are prerequisites such as math, SQL, python, advanced math etc. Then there is the critical thinking aspect of problem solving, the ability to connect dots from different points of references. Great interview so far.

[@averysmith]

I agree that it takes a balance! But he said "people that you like" not "people like you". So you can easily like an introvert if you are an extrovert or vice-versa. No one wants to work with someone they don't like. But I get your point!

[@andyn6053]

I started as a data analyst at H&M. But the career opportunities here are terrible. It's more difficult to move to a Data Scientist role internally than leaving and get a Data Scientist role externally. Whatever u do, stay away from H&M!

[@avgspacelover]

why so

[@future_teknokrat7585]

Most tech channels focus on skills gap. Truth is, 50-75% of the decision is subjective and is not made by the person interviewing you, but their input is heavily weighed. Being percoe5as being liked, a sense of a team player, and able to learn quickly on the job will get you over the hump more than skills.

[@Qristin101]

I loved this video so much because it is a true unconventional career story. Most times I watch such videos its something like "How I got a job without a computer science degree" then they mention they have a degree in aeronautical engineering or something.

[@averysmith]

lol my degree is in chemical engineering 🤣

[@aurygabrielasuarez]

Very interesting! Loved this conversation 🙌🏼

[@YerBoyTroy]

Alex is going to become a legend in the industry down the road. I can see it. The guy does such important work for the field

[@nunya530]

Being an introvert is not something you have to work through and doesn’t inherently mean you are nervous in interviews. What does being outgoing even mean in the context of work as a Data Analyst? Instead of assuming introverts don’t have a place on your team maybe consider how the traits of an introvert can bring value to a team.

[@marcink6879]

Introversion or extroversion doesn't actually determine your social and/or communication skills. It's more of a preference over how do you recharge your batteries. And yes, communication is very important in data jobs. You work with a client, either internal or external, so you need to be able to discuss business requirements and present the results of the work, as well as build relationships so you are recognized and rewarded fairly as a specialist. You don't need to change your personality to be an effective communicator. But you do need to work on your soft skills.

[@manfred9020]

This is gold... I thought he had a degree in social science but nope.... Pff the Goat for sure 🐐🐐

[@averysmith]

🐐🐐🐐

[@Aftab_Ahmad_ajk]

Very informative podcast. Sql and excel two most important tech. Skills are discussed.

[@averysmith]

Glad you enjoyed it!

[@andyn6053]

I lied an got a job as Data analyst without ever used SQL and power bi.

[@gamist8166]

What did you use/know before? Maybe the statistics knowledge?

[@averysmith]

Hahaha I love it

[@tonyivy6076]

How were the first few months without having any of that knowledge?

[@jt9058]

How did the job go???

[@vitoc.1535]

Great interview really enjoyed it!

[@averysmith]

Glad you enjoyed it!

[@MS-wy4sb]

Hahaha. I Iaughed in understanding at the part of meeting a girl, need to make money. That's what happened to me. Also, realized the current industry I'm in (contract manufacturing) is a bad fit for me. Not enough pay, too stressful, burns people out. I'd rather have more control over my time, make more, and be able to spend my time with my girlfriend. This pivot is proving to be difficult, and it will be worth it.

[@PowerGurhl]

I almost did this for a data engineering role but I didn’t want to have to deal with lack of knowledge so I didn’t 😢 even though the recruiter called me and all and they really needed someone. I only knew the basics from software engineering

[@AniGuli]

Great video!

[@averysmith]

Glad you enjoyed it!!!! Thanks for the comment.

[@apamwamba]

Hiring process is not 100% super!! I like that

[@averysmith]

Exactly!

[@balford2112]

thank you!

[@averysmith]

You're welcome!

[@adekoyasamuel8788]

Great content as always👏🏼! Still watching though. I might just stick to video content rather than Spotify.

[@averysmith]

it's fun to have the video huh!

[@adekoyasamuel8788]

@@averysmithyes it is actually. Listened to almost all through Spotify.

[@SanguinariVampire]

I learned SQL, Xcel, and Tableau but I still didn't apply for a job I was scared because I didn't know Python. So now I'm doing a 14-month Python course. Hope after this to find a job...

[@theruler9999]

14 months?!! Is this like bootcamp or masters program ?

[@sam_Invincible]

I did a bootcamp that lasted like 3 months, no need for 14 buddy

[@SanguinariVampire]

Is a master program

[@theruler9999]

@SanguinariVampire makes since, but why not applied for a job if you have all these skills even if it's for entry level and pick up from there while you go on?

[@theruler9999]

@samishamroukh6069 that's great man, hope you got your feet on the ground with this one?

[@recalc]

Really inspiring conversation! thank you Avery -- but really SQL is boring? Come on!

[@averysmith]

🏃‍♂️💨💨💨