Alex The Analyst March Livestream!

Alex The Analyst

Come ask me anything in my Weekly Q/A!  In this weekly series you can come and ask me questions about all things Data, Analytics, Tech, or anything else you could want.  Get 1 Week Free for New Members! https://analystbuilder.com?promo=1WeekFree  Already a Member? Get 35% off any purchase with code: 35OFF ____________________________________________   SUBSCRIBE! Do you want to become a Data Analyst? That&#039;s what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content! ____________________________________________   RESOURCES:  Coursera Courses: 📖Google Data Analyst Certification: https://coursera.pxf.io/5bBd62 📖Data Analysis with Python - https://coursera.pxf.io/BXY3Wy 📖IBM Data Analysis Specialization - https://coursera.pxf.io/AoYOdR 📖Tableau Data Visualization - https://coursera.pxf.io/MXYqaN  Udemy Courses: 📖Python for Data Analysis and Visualization- https://bit.ly/3hhX4LX 📖Statistics for Data Science - https://bit.ly/37jqDbq 📖SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij 📖Tableau A-Z - http://bit.ly/385lYvN  *Please

Transcript

00:00:01um hello hello hello what's going on everybody i am uh making sure really quickly before we

00:00:09start things off i'm making sure that this is working uh it has a delay of like 10 seconds

00:00:16my lips seem awful pink i don't know if that's just me uh it definitely could be

00:00:24um looks like we're good to go

00:00:29um so what we're going to be doing today is pretty simple uh it's actually very simple

00:00:34you guys are just going to ask questions and we're going to chat uh and that's it that's all

00:00:38we're doing today i don't have any huge agenda um but uh i have been doing live streams since last

00:00:48year i stopped for a while uh over the let me get this going i stopped for just a little

00:00:55bit

00:00:55over the christmas time winter time because it was i just had too much on my plate with my kids

00:01:00being at home and uh and everything like that and so i am back i am uh i'm just pulling

00:01:10this over so

00:01:10i can see the chat while we're here there we go all right let me pull this up um but

00:01:19as long as uh as long as we're back let's get this going uh you can ask as many questions

00:01:27as you

00:01:28would like does not mean that i will answer every single one of them typically how this goes is it

00:01:35starts off a little slow you best to answer questions like at the beginning but then hey

00:01:41everybody but then as more people start showing up uh it gets pretty crazy and then it's kind of hard

00:01:49to answer them all so i'm gonna do my absolute best now this is a good question uh this is

00:01:54from

00:01:55i think it's a long name i can't say the whole thing but it says i'm planning to learn data

00:02:00analysis

00:02:00is it a good time to switch jobs to data analysis that's a you know that's kind of a more

00:02:07complex answer

00:02:08i would say that if you are already in a job where there is the ability to switch over more

00:02:13to the

00:02:13data side it can be a great time because so many companies right now are investing in data related

00:02:19things right they're investing in their data infrastructure they're investing in these new

00:02:22ai tools they've never used them before they don't know how they're going to work so if you have

00:02:27some insight in this if you've used them before uh they can it can be a great time to transition

00:02:32the only caveat to that or maybe not even a caveat the other side of that is

00:02:37let's say you're right out of college and you don't have any skills and you're just now learning

00:02:43sequel and like that's all you have it's a pretty tough job market just trying to get a job like

00:02:49right out of college this is a tough job market that that's what i would say is where i would

00:02:55hope

00:02:55most people aren't right now because that is definitely a tough place to be hey everybody i see

00:03:02more people coming in we're just doing q a feel free to ask a question i have my chat right

00:03:07over here don't spam please don't spam we always have an issue with people spamming

00:03:12um and then i have to block you and i don't want to do that i don't want to be

00:03:15that guy um

00:03:20let me let me read this i just answered that one so i need to find or go to the

00:03:24next one

00:03:25it what's the difference between a data and data analyst and a business analyst now i have a whole

00:03:29video on this um here's what i'm going to say i'm actually going to kind of take this in a

00:03:34different direction the future of data jobs is doing a lot more things than just you know one

00:03:42specific thing and this was even true back when i first started back in like 2017 i was a data

00:03:48analyst but i was working and doing some data engineering work i was also doing some data

00:03:52science work um these roles are not you know purely independent anymore and they haven't been for a long

00:04:00time and so when i think about a data analyst and a business analyst i typically think of a data

00:04:07analyst is more technical focus they'll work on internal teams whereas a business analyst might

00:04:12work a little bit with the internal teams but they're more client facing they're not digging into

00:04:16data they're not doing a ton of data cleaning they might do queries here and there dig into a little

00:04:21bit of data but they're getting you know they're trying to understand what the business user or the

00:04:27client or the manager whoever wants and they kind of translate that to where they'll hand it off to

00:04:31someone else um so a business analyst tends to be not as technical but with just the change in

00:04:39how things are going especially how ai is kind of changing things i would expect that business

00:04:45analysts and data analysts are going to eventually do a lot of similar work where business analyst has to

00:04:51come more to the more technical side um but that's just my opinion we'll see how it plays out

00:05:00um let's see hi i live in the uk i want to be a data analyst analytic engineer or a

00:05:05data engineer

00:05:05but there's no junior job or market which one is good for wasting for wasting the time to be done

00:05:13which one is good or are you wasting the time to be done no i don't think any of those

00:05:18jobs are a waste

00:05:19of time anything i actually really firmly believe um and i've talked to a lot of other people who

00:05:25share my sentiments this isn't just my opinion but i firmly believe that there's going to be a huge

00:05:30explosion of jobs in the data world in all sorts of different areas um and this is going to happen

00:05:38over

00:05:38a long time but i don't think we're going to see a dramatic drop in data jobs anytime soon

00:05:45um i it really is dependent on where you live like if you're in ireland there's not going to be

00:05:51a lot

00:05:51of jobs in ireland or if you're like in the middle of nowhere there's not a lot of jobs and

00:05:56if you are

00:05:56remote and you're trying to get a remote job you're competing against a lot of people who are also

00:06:01trying to get a remote job that makes it a little tricky um i've always i've been saying this especially

00:06:07for the past probably three years right since about 2023 i've been saying that remote jobs are going to

00:06:13become incredibly difficult to get and if you have the ability to move to a metropolitan area even on

00:06:20the outskirts of a metropolitan area and you are you know you have skills in this area you are going

00:06:27to get a job 10 times faster and the reason being is a lot of companies are not doing or

00:06:31not wanting

00:06:32remote people anymore we've been seeing this as a big trend more companies are bringing people back

00:06:37into person because they want to make sure that they're doing their job and not wasting time at home

00:06:41and you know there's also other reasons but that's like one of the big ones and so um if you

00:06:47have the

00:06:47ability and you have the skills and you're able to you know go somewhere into a metropolitan area

00:06:52there's so many jobs available but it is hard for and i'm going to go off on a small tangent

00:06:57it is

00:06:58actually really hard right now to get good talent and that sounds really counterintuitive because there

00:07:04are so many people in the space who are wanting to get jobs you'd think wow there's an abundance

00:07:08of people who are super good at this but the reality is is that it's actually really tough to

00:07:14find good talent very very tough and i have a recruiter friend who you know works on this stuff

00:07:20and he's like this is the hardest time for recruiters to find good talent more than any other

00:07:27time before because it's so easy to create a fake resume or fake skills or whatever it is we're

00:07:33finding real genuine talent when they get into interviews and you can interview well and you can

00:07:38actually answer the questions without you know being so obvious that you don't know anything

00:07:43it's becoming really hard and so if you actually do have the skills and you actually do have the talent

00:07:49then doing that what i was just talking about is a hundred percent going to be a big

00:07:55differentiator and allow you to get a job faster um what uh let me think let me see i see

00:08:02i'm i

00:08:03have to go back a little bit for questions uh let me see i'm learning data analysis through your

00:08:10videos do you think as a fresher i can get a job the answer is yes it is harder now

00:08:14um simply because

00:08:16there's so many people trying to break into it but even today like if you go and take the data

00:08:21analyst boot camp which i'm about to revise that whole thing i'm about to add like six or seven hours

00:08:26it's gonna be like a 31 hour boot camp because i have made a lot of different series um even

00:08:33if

00:08:34you take that whole thing you're gonna have all the skills that you need genuinely you're gonna have

00:08:39all the projects you're gonna create a portfolio you're gonna be ready um but you know you have to

00:08:46also understand how to interview and you have to really understand how to apply you can have you can

00:08:51be the smartest person in the world and be the best analyst in the world but if you don't know

00:08:56how to

00:08:56market yourself and you don't know how to put yourself out there it's gonna be really hard to

00:08:59get your resume or you in front of someone right to get a job so absolutely you can learn enough

00:09:06just

00:09:07through my videos on youtube um and you can get a job and i i'm not just saying that because

00:09:13i think

00:09:13that it's because i've had like hundreds of people over the past several years reach out to me saying

00:09:17i literally only took your videos on youtube i built this and then i got this job and so it

00:09:22100

00:09:23is a real thing um pratik 9001 is it pot is it possible to make a few guided projects involving

00:09:32sql python and power bi yes it is possible and it's already done just go into my youtube channel type

00:09:38in

00:09:39alex the analyst sql project alex analyst power bi project alex the analyst python project and they will

00:09:45come up i have tons of them so yes absolutely um and someone else was saying love the new projects

00:09:52that you added on the analyst builder would love to see sports related projects in the future that's

00:09:57kishore or kisher um absolutely uh if you haven't already those projects are completely free it's just

00:10:02a projects page on analyst builder.com and i make those projects so i go and i source the data

00:10:08um i build

00:10:10out this scenario for you to build um and they're really cool they're you know good projects to test

00:10:17out and some are very easy and some are much more difficult and so you can kind of challenge yourself

00:10:22depending on your skill level can you give a roadmap of a student studying data science as a course in

00:10:28a college no i don't really know what um data science is not like that's not my expertise i actually

00:10:34worked on a data science team for a while um and so i know a lot about data science but

00:10:39that's not

00:10:40my expertise like i don't feel confident giving you like a roadmap or something but there's lots of

00:10:44roadmaps out there um that people have made videos on so you know go check those out um suggest some

00:10:51data analytics portfolio projects um obviously like i was just saying i already have a ton of projects

00:10:58guided projects where you can watch me do it there's the data sets you can follow along and you can

00:11:02build

00:11:02those those are great um i have a lot of projects like i said on analystboulder.com or through my

00:11:06full courses so you can go take those but if i'm just like spitballing here projects off the top of

00:11:11my head i think would be really good today um i like seeing personally when people like source their

00:11:18own data which is they actually go and they scrape the data from the internet or they collect the data

00:11:23themselves through like personal use or sports or something like that and they're collecting it

00:11:27themselves and then they have to transform that data and then they need to actually build something

00:11:32with it rather you're creating some type of like web app um that that you know hits off your data

00:11:37and

00:11:38you're you know creating something or you're building out like a visualization uh or a dashboard or something

00:11:43like that those are great projects in terms of the domain it's up to you right you can have great

00:11:49financial projects with banking data great healthcare projects with like patient data you can have company

00:11:55financial data um there's a million projects uh that are out there let's keep going down let's keep

00:12:01going down oh it skipped down again let me see all right so this is a good question hi alex

00:12:10tuned in

00:12:10from kenya here hey hey from kenya uh it says i love your content please comment on data analysis and

00:12:16consulting as freelancing option in 2026 so as you guys may or may not know i do what's i do

00:12:24consulting

00:12:25like i have a consulting part of my business where people reach out to me and they're consulting me about

00:12:29all sorts of things um but i would also consider some of that work freelancing and this that market

00:12:36is very much changing specifically with specifically freelancing right freelancing tended to be

00:12:45at a lot smaller companies um you weren't getting a lot of freelancing work at like google right you're not

00:12:51getting freelancing work because they can hire the absolute top of the line people locally and they're

00:12:58going to have a thousand people waiting for them and they can pay top dollar freelancing tended to be

00:13:02smaller companies doing smaller projects that they just didn't want to pay a full-time employee for

00:13:09um and give me one sec i gotta take a sip because i'm getting dehydrated

00:13:16not dehydrated my throat just gets sore when i talk a lot so the freelancing space is becoming a lot

00:13:25more

00:13:25competitive because so many people are just plugging all these things into ai and then they're spitting

00:13:30it out without actually understanding it and so what i've heard from other people who are freelancers

00:13:35who've been doing freelancing for a while four or five years is they've reached out to me they're like

00:13:40alex how do i make myself more competitive in this market because what's happening is is their

00:13:44freelancing clients who they've had for a few years are going and trying to do it themselves

00:13:49they're having issues then they come back to them and he has to clean it up he has to go

00:13:53and figure

00:13:53out all the issues they're handing off like half-baked projects um and what that tends to do and that

00:14:00is

00:14:00just a theme that people have been reaching out to me in the freelancing space what that tends to do

00:14:05is it frustrates people more than anything because it's just unnecessary competition which leads to

00:14:11you know not good quality work um and so what all i'm trying to say is is for somebody who's

00:14:19just

00:14:19starting out who's never gotten a freelancing client before you're like i just want to try freelancing

00:14:24it's gonna be quite difficult um you know i always recommend freelancing or trying to get to know

00:14:31somebody or reaching out to somebody on linkedin that you know you've been commenting on their

00:14:37things for a while like create these personal connections so that when you reach out and you

00:14:41know they're posting about hey i'm having an issue with this so does anyone know you can reach out and

00:14:44say hey that's something i know how to do um that's like a good in right for people who are

00:14:50just starting

00:14:50out but that is something that is happening more and more is people who are already freelancing

00:14:57are getting clients who are dropping and then coming back and they're saying hey we tried this

00:15:02we're we tried to use you know what are the new ones claude co-work claude uh what's it uh

00:15:10codex right from open ai we've tried to use these tools and they spit out a bunch of numbers that

00:15:15looked really good and then when we went back and checked them they weren't accurate or you know

00:15:19their recommendations didn't make a lot of sense for for like a business perspective a lot of that has to

00:15:24do by the way with infrastructure with you know semantic layers that most companies have no idea

00:15:31what they are or you know prompting abilities or you know if you're using some type of markdown file

00:15:37to create uh some context they're just they most people don't know anything about those things

00:15:43and so it's causing a lot of just issues in the freelancing space so what i would say is if

00:15:51you're

00:15:51trying to get into it don't just like quit your day job and like dive into consulting and freelancing

00:15:57slowly do this get a connection try to get a client reach out to people on linkedin um if you

00:16:03see somebody posing hey i need somebody who knows how to do this if you know how to do that

00:16:06reach out

00:16:06to them um this is how you can get clients for sure let me see um i'm gonna i'm gonna

00:16:17ask this

00:16:17question i don't know if i even have an answer it says do you know mayanmar yes i know mayanmar

00:16:21it

00:16:21says i want to be a data analyst so i learned your series and i attended uni eiu and data

00:16:27analyst all

00:16:27in one class but i don't have confidence what should i do actually i do have an answer for this

00:16:33so this is what's called imposter syndrome right you're just starting out some i mean imposter

00:16:38syndrome can last a long time i i had it for like even three or four years after i started

00:16:43because the the difficulty in which i was working was constantly increasing and i was like man i'm

00:16:50i'm behind i don't know uh what i'm doing but um all that being said it's usually just a confidence

00:16:58issue because you've never done it before you haven't gotten into a full-time role and so you're

00:17:03not confident in your abilities and that's perfectly normal um i myself encountered that for many years

00:17:09uh and you're just in that learning process where you're going from academia and learning how to do

00:17:14things like theoretically and maybe building some small projects to the real world and the real world

00:17:19is very different than just like you know youtube videos and you know other stuff where the data is

00:17:25curated and so what i will say is is just give yourself time right work on projects use real data

00:17:33go to

00:17:34like data.gov i have a whole video on best places to find data sets um but do these things

00:17:41get that

00:17:42first job push yourself so that when you get that first job you can learn learn learn learn learn and

00:17:48you build your confidence through ability right it's usually that gap between you know where you're

00:17:55currently at in the real world and that gap is scary uh because it is very different and so um

00:18:01yeah

00:18:02give yourself time give yourself time all right let me go to the next question

00:18:10which of the it says this is from ali olatunde which of the following derivative roles can one

00:18:18own slash build like an app or something um so i built a lot of things for past and the

00:18:26client for

00:18:27clients i built stuff for myself i currently have data products um so data can be used in a thousand

00:18:33different ways just so you know but like the main ones that you would think of are things like um

00:18:38you

00:18:39take data and you're scraping it from everywhere or you have a data set and you can make that publicly

00:18:46available through like an app and somebody can go into your app and you can display and and show the

00:18:51data in a lot of different ways where people can you know look at it for free maybe it's a

00:18:55free app

00:18:56or it's a paid app where it's specific to like a niche that people would find value in it and

00:19:00they

00:19:00want access to data and that's like the simplest version of some type of app um it's just getting

00:19:06people access to data um where they can access themselves you built in like you know a post grace

00:19:11database and you're hitting off of it and the client can use filters and stuff super simple you can

00:19:16also make a a customer or it's like a user facing app where you have dashboards and reports and um

00:19:25you know graphs and visualizations where this is more like an educational thing um people can learn

00:19:32about different stuff and you use data that way um in the cons it's very different depending on your

00:19:41client base all right if you want to go towards corporations or you want to go to towards like

00:19:45individual users whether you want to um you know go towards a specific niche there's a million different

00:19:52options out there but um do some research do some research out there because there's so many

00:19:58topics on that exact thing i'm just spitballing off the top of my head

00:20:04this is a good question hey alex can i start consulting as a fresh graduate or do i need

00:20:08one to two years of experience for that will clients believe a fresher um i always i i used to

00:20:14think fresher was a funny word because i'd never heard of it i always called it like a junior or

00:20:17a

00:20:17beginner um but in most parts of the country they call it or most parts of the world they call

00:20:21it a

00:20:21fresher um and so i've gotten used to that but i always i still kind of i like like saying

00:20:27it out

00:20:27loud because i never say it in my day-to-day life but a fresher so beginner um in my

00:20:33opinion

00:20:33it is extremely difficult if you don't have experience because here's what a client wants

00:20:39right let's say a client spins up some app this is just a random person out there and they're like

00:20:43wait a second i know nothing about the clients who are buying this i have no strategy i don't know

00:20:48how to look into this data i've tried plugging into ai and like but it just doesn't make sense

00:20:52um and i need somebody who knows more than me they're most likely not going to want a beginner who

00:20:58doesn't know more than them right they're going to want someone who has experience already doing

00:21:02this and that's why they're paying money for it otherwise they just do it themselves and so it is

00:21:07very difficult now i myself started doing consulting um maybe about four years maybe it's

00:21:14four to five years in um i started doing some consulting on the side and the only reason i

00:21:19started doing that is because i started a youtube channel people started reaching out to me watching

00:21:23my videos i mean like hey i'm having this exact issue and i don't know how to solve it could

00:21:28you

00:21:28consult with me and i would be like yeah for sure that sounds great and so um that's like think

00:21:34about

00:21:34it from like a client perspective i probably am not going to hire me myself i'm not going to hire

00:21:38a beginner um consulting wise right i might for like a full-time job um so i can train them

00:21:44and

00:21:45i can get them up and running and they can stay with me for a long like three four years

00:21:48but a

00:21:48freelancing or consulting job is temporary you just want someone who's an expert in that area

00:21:51so what i what i would say is is gain experience in a domain um if you and actually i'm

00:21:59going to make

00:21:59one small caveat some consulting companies like uh tcs or accenture they will hire um sometimes

00:22:07beginners um and they want them to be mentored by like a mid-level or a senior level analyst for

00:22:15example and they want that so that they can buy and get them cheap essentially and then train them

00:22:22for like a couple months and then they consult them out at a higher rate and they make money off

00:22:27that

00:22:27so there are a lot of consulting companies that actually will hire beginners so that is one small

00:22:32one small caveat all right let me get down

00:22:46this is an interesting question um i can't it's 9061 it ends in 906 it's just really long i can't

00:22:52uh read

00:22:52it all alex i have seven years of experience working in a support project in india i'm currently

00:22:58learning data analyst skills and planning to switch from a c from a sequel back-end support role to a

00:23:04data analyst role um there wasn't a question there but oh wait i guess the next one um i'm focused

00:23:10on

00:23:10sql excel power bi for now with python as optional could you please advise where i should focus more

00:23:16so um if you already have experience like in some other technical role that is amazing because you

00:23:22at least have some understanding of like how to work with clients um you understand some

00:23:26technical things like sql like if you're working as a uh what was it called sql back-end support

00:23:31you're probably qaing a lot of things you're getting a lot of requests you're in sql a lot

00:23:36so you understand databases and data types and things like that invaluable like amazing experience

00:23:41that's fantastic um if you know sql excel and power bi what i would recommend is start

00:23:48going a little beyond just the basics right most companies now are not building on-prem servers

00:23:56all right if you look at the data and i did a whole video on this if you look at

00:23:59the data

00:23:59there actually are more companies going on-prem now than you know uh in the past like 10 years but

00:24:05that's more for security reasons but online like in the cloud is growing even faster um so percentage

00:24:11wise the cloud is outpacing any on-prem servers that they're going to use so just knowing sql is great

00:24:17learn how to use sql in azure aws google cloud um then go into tools like snowflake and databricks

00:24:25this is like you're look at like uh looking at these jobs as like a percentage is how i like

00:24:31to

00:24:31look at it is right now you have the skills and those are great skills and you're opening yourself

00:24:38up with your experience to like 50 60 70 of jobs um out there especially with your experience but now

00:24:45you want to open yourself up to new experiences and to grow your skills and do all these things so

00:24:50you want to add more skills that are really marketable right now and things like databricks

00:24:55snowflake aws azure those ones specifically are so incredibly valuable to companies and i remember when

00:25:01i was interviewing back at amerisource bergen and i was the hiring manager people who knew azure already

00:25:08were at the top of my list because we had had people come in um who didn't know azure and

00:25:14then

00:25:14you have to train them and it takes a long time but if i have somebody who can hit the

00:25:17ground running

00:25:18i don't have to explain you know how our azure data factory is set up they're going to be able

00:25:22to look

00:25:22at it and know it's invaluable and it really is and so learn those skills um and then within them

00:25:29there's going to be ai tools that you can start learning and how they connect to the databases and how

00:25:34they use them what i have been liking the most in my opinion and i'm not sponsored by them in

00:25:39any way

00:25:39but i've been talking a lot about databricks recently because i personally think databricks is

00:25:44one of kind of the forerunners of adding ai and agentic ai really well into their platform other

00:25:50platforms have done it but not really well and so uh you know databricks would be one that i would

00:25:56learn myself all right let me go to the next one

00:26:01i just skipped down i'm sorry i just skipped like a bunch

00:26:06hey my mods here

00:26:09i'm i i know your real name but i don't want to give out your real name but if you

00:26:13want to post

00:26:13it you can uh but it's taki616b that's his username all right i'm not giving out his real name out

00:26:19here

00:26:19but he's in here if you guys are spamming you guys are out of here he doesn't mess around

00:26:26all right no more games i'm just messing but hey good morning thanks for joining i appreciate it

00:26:35um let's see it says this is from lavani aganta1422 hi alex currently i'm working with an insurance

00:26:44company where it's not all related to tech role and i've decided to switch my career by learning

00:26:48data analyst skills how do you suggest this is like the ideal situation i'm not even joking

00:26:54so over the course of the past six years of doing this on youtube this has been probably the most

00:27:00efficient way to switch into a tech or data role and it's being within a company you have the drive

00:27:07you have the skills the company has a need and you fill that need i have seen this well probably

00:27:13over

00:27:14a thousand times of people reaching out to me saying this exact scenario and they're like i got a job

00:27:18i got this job so you were in like a perfect place typically here's what here's what happens is

00:27:25somebody is in it can be any role within the company genuinely but they see a need they're like

00:27:30you know oh we have all this data in excel and we're having issues because the data is over here

00:27:34and over here and over here and i go to my boss and i said hey you know i've been

00:27:38learning all this

00:27:39stuff about sql databases about this or that can i take this on as a project like i'll do it

00:27:44just as

00:27:45part of my role you don't have to give me a new title just let me let me try then

00:27:49they put it all

00:27:50in there they show their boss and they're like hey look what i did and the boss is really impressed

00:27:54and they're like hey boss i really would like to take on this as like i want to be the

00:27:59owner of this

00:28:00i set up these databases i know them better than anybody i can help with managing these databases

00:28:05and helping our you know people who you know use this data i can help them understand the data and

00:28:13get

00:28:13you know run queries and all these things typically that's how it happens i've heard that exact story

00:28:20hundreds of times so if i were you and you're learning these business skills and you're at an

00:28:25insurance company look for like a gap where's where are the issues right find an issue and fix that

00:28:31issue that is how you become helpful that's how you get new jobs so for example you're working in

00:28:36insurance and you know you keep getting these similar requests maybe you want to build some type of

00:28:42automation right especially with like python and you know a lot of automate easy easy things to

00:28:50automate that have just been done a million times you can automate a lot of things with python even

00:28:54just go and like use chat gbt to build out like a proof of concept um and have it write

00:29:00the code it's

00:29:01going to get you 90 the way there you're going to automate something but then it's not going to work

00:29:05for this other thing it's not going to work for this document or this excel but then you you show

00:29:10it

00:29:10as a proof of concept you bring it to your boss say hey imagine if you know all this processes

00:29:14that

00:29:14we do by hand every single month i can just run it through my code it's going to do it

00:29:19for us and

00:29:19they're going to be like this is amazing could you do it for this project could you do it for

00:29:24this one

00:29:24could you do it for this one you're going to say yes and then after a little while once you

00:29:27start

00:29:27doing it for a few of them you're like hey boss i really like this but it's a lot of

00:29:32work i think that

00:29:34i would like to do more of this than what i'm currently doing because i think this is more

00:29:38exciting to me i enjoy this more and i think i would be more helpful to the company in this

00:29:44area

00:29:44can i have a you know change my job to more of a data analyst role or whatever title you

00:29:50think is

00:29:51appropriate that is like that's how you do it um that's just one example but there's a thousand

00:29:56examples of things that are going to be wrong or have issues with companies right um so you know

00:30:03think about your company think about what the issues are and try to solve it

00:30:07um can i review live this dashboard and rate it from one to ten uh i don't know if i

00:30:16can do that

00:30:17i mean i have this set up i would just need to configure some stuff not this time i will

00:30:22set up

00:30:22something for next time i'm i use like obs for my streaming i will i should do that that'd be

00:30:28fun

00:30:28i'll do a whole live stream on like reviewing stuff projects uh stuff i'll do maybe my next

00:30:33live stream so just come to the next one i think i'll i'll do that um this is a good

00:30:39question all

00:30:40right let me take a sip of water i'm also like looking at myself on youtube i'm like super bright

00:30:49but in real life and on my obs i'm like normal i look normal but over here i look like

00:30:55it's like

00:30:55like the sun is shining in my face all right this question says there are too many data analyst

00:31:02tools out there nowadays databricks snowflakes snowflake claude what are the what are the

00:31:08most key tools that you recommend learning apart from sql python and power bi that is

00:31:15a lot of questions summed up into one because this is the issue with anybody out there not even just

00:31:21beginners experienced people like myself there are so many tools you don't need all the tools

00:31:28i'm just going to tell you this you don't need all the tools i'll give you an example at my

00:31:34old job

00:31:35we use azure we use databricks within azure and then we use power bi we were a microsoft shop

00:31:43those are like our main of course then there's sql and like excel and i use uh some python and

00:31:48r

00:31:49but those were like the main things that we used and for my job within that company that's all i

00:31:55needed to know i wanted to become an expert in those tools so i then don't have to then go

00:32:00and learn

00:32:01snowflake or you know aws or you know whatever tool after tool after tool because that's what my business

00:32:09actually needs that's what the company actually needed and so what people do typically do is they

00:32:14spread themselves really thin and they learn just the surface level of each and they don't

00:32:19actually master any of them so i would find the tools in your industry so for example um in healthcare

00:32:26which is you know a really big industry that's what i worked in for a long time in healthcare um

00:32:32the

00:32:33most popular tools were azure aws tableau and power bi right that's four tools there's a lot to them

00:32:40there's a lot of complexity in depth but that's what i would focus on i wouldn't be learning google

00:32:43cloud platform that was a niche product for us in my domain um but google google cloud platform might

00:32:51be more popular in finance so then you focus on google cloud platform but you can research this

00:32:55right there's data out there you can go and you can say hey within this industry what are the most

00:33:00popular tools to learn for data analysts and then you know ask around maybe go on linkedin say hey i'm

00:33:07i'm trying to figure out what tools to focus on what tools do you use the issue with any of

00:33:13this

00:33:13by the way is that there are going to be proprietary tools that aren't out there for you to just

00:33:18learn

00:33:18so you have to learn fundamentals understand how databases work understand how cloud platforms work

00:33:23understand how compute works start understanding how ai is integrated into these systems understand

00:33:28understand semantic layers understand um you know how data is transferred from one place to another

00:33:34do people use fivetran do they use just database connectors these are things that like are really

00:33:41hard to know about if you're just starting out because you know you've never done it before and

00:33:46that's not your fault but you don't need to know every single tool you really need to know the

00:33:53fundamentals of these tools um and how they work and so if i were you if i'm saying all these

00:33:58things

00:33:58if i were you you have no idea um you don't even know what domain you want to get into

00:34:03you're not sure i would take uh if i were you you know all these like base tools i would

00:34:09be learning

00:34:10azure first then i would go and i would learn aws and then i would learn databricks that's what i

00:34:16would

00:34:16do genuinely if i were you today i learn azure aws and databricks and lucky for you i have free

00:34:25um

00:34:27entire tutorials series of like four or five six videos for each of these tools and for databricks i'm

00:34:33coming out with one for etl so learning how to create data pipelines and create automations

00:34:37within databricks so i'm going to come out with that in like two months so uh with all that being

00:34:43said i hope that answered that question um what's the right time to get a certificate from analyst

00:34:49builder before you before or after your boot camp um so i have my free data analyst boot camp on

00:34:54youtube

00:34:55and it is the best free resource in the world i'm going to be adding to it by the way

00:35:00it's going to go

00:35:00from like 20 i think three hours to like 31 or 32 hours it's gonna be nuts um that is

00:35:07completely

00:35:07free and it is a fantastic resource analyst builder goes up a notch it's more advanced projects i go a

00:35:14lot more in depth to different topics um and you just understand the fundamentals so much more as well

00:35:19as just more advanced projects um and so what i would say is is if you're on you know youtube

00:35:26and

00:35:26you're starting to get a hang of it but you're like you know i i kind of want to dig

00:35:30into this

00:35:30more that's when you go to analyst builder and yes that's a paid platform that's my platform it's

00:35:35like has elite code style um questions page has all of my full courses um and i have a link

00:35:43down below

00:35:43if you guys and now i have don't always plan on talking about it but if you want to sign

00:35:49up you can get

00:35:49a week free and try it out or if you already uh if you just want to buy something you

00:35:53can get 35

00:35:54off any purchase even lifetime which is the best deal in the stinking world um it really is all that

00:36:01being said is analyst builders like the more advanced version of my data analyst boot camp

00:36:06and just goes a lot more in depth into so many other things um and so it's it's a better

00:36:12learning

00:36:12experience as well because it's all on one platform and and it's it's pretty great

00:36:18all right let me read through next questions

00:36:23all right so this is this is like a question i've been getting more and more and more

00:36:28it's hi alex i'm a college student can you recommend skills that i need to learn

00:36:32a lot of the things i've been talking about if you've been listening still apply to you um

00:36:37if you're in college this is a very weird weird weird time to be like entering the workforce in

00:36:44like a year or two because of everything that's happening with ai it's just it's a lot of causing

00:36:50a lot of uncertainty um and the reason for that is because companies don't know like is all these

00:36:57promises with ai going to happen within the next year or two if so i don't want to hire on

00:37:01a bunch of

00:37:01people um and be really overextended um and a lot of them a lot of people as well um sorry

00:37:09somebody

00:37:09donated something i oh my goodness matthew i thought it was a question uh i'll get back to you

00:37:15in a second matthew he's one of my mods as well he sends me five bucks for the uh for

00:37:22to get wendy's

00:37:23he says burgerflation i i don't think they have their i don't know if they have their five dollar

00:37:27i thought i don't know if they got rid of it now they have the six dollar biggie bag that

00:37:31i've been

00:37:31getting but listen i appreciate it very kind of you matthew um all right back to the question though

00:37:40um it's just a tough job market right so if i were like if i were in college today i

00:37:48would be very

00:37:48discouraged just genuinely uh it's a tough job market um we re every company in the stinking world over

00:37:55hired in like 2020 to 2022 every company and so now they're streamlining they're trying to get

00:38:01you know their profit margins even higher believe it or not um but with ai i actually think there's

00:38:07a lot of opportunity and there's going to come a lot of change in the next several years and with

00:38:12that i think the tools to know are more cloud-based which are much easier to have ai integrations into

00:38:19um and then a lot of the fundamentals right you need to know how to work with databases you have

00:38:24to

00:38:24understand things like data types and you know how to transform and clean data um and those things

00:38:30are like super important but learning tools like azure aws databricks snowflake like those types of tools

00:38:37in my opinion those are the tools of the future like i have invested my personal time to learn them

00:38:44more

00:38:44because i have clients who i'm consulting with who that they're migrating all their data to those

00:38:50platforms they have whole entire on-prem infrastructure that is just not working for

00:38:55them and then they're trying to run all these ai models and they're like why not just go to a

00:38:59one

00:38:59stop shop and so this is happening this transformation is happening and so i would say learn learn those

00:39:05tools i think those are like the best tools to learn right now um and i have whole series on

00:39:11youtube for

00:39:11free and you can go and take them like i just just it they're free it just takes time so

00:39:17learn azure aws

00:39:19and databricks um and i'll have a snowflake series later this year um for data analysts

00:39:26alex can you add a french language option to your videos for french speakers if possible i've looked

00:39:30into this um on youtube i don't know how that works but like on my unlike analyst builder um i

00:39:38it

00:39:39we've looked into it and it hasn't worked perfect and so uh we haven't rolled anything out um on that

00:39:45so probably not if i'm being honest probably not it's probably going to stay in english as of for

00:39:50right now until that technology becomes a little bit easier to like use and actually implement

00:39:57um

00:40:00hi alex i'm curious to see how you think someone without a degree might be able to find a role

00:40:05in

00:40:05this market this actually um over the years i've had so many people who like graduated just from

00:40:11high school and they landed data analyst jobs at one of my best success stories i guarantee you he's

00:40:16not on here listening right now but um he was a mentee of mine back in like 2022 um his

00:40:22name is

00:40:22sergio he may have said i posted about him every so often on linkedin um his story and he's let

00:40:29me share

00:40:30this uh before so i know he won't mind but his story was he was a warehouse worker he was

00:40:35very

00:40:35smart but you know wanted to get into data analysis but didn't know how um and didn't have a just

00:40:42high

00:40:43school degree no college and um so i had like a mentor program i tried to make it it was

00:40:48like 75 a

00:40:49month i was trying to make it as humanly affordable as possible that was when i was just starting out

00:40:53um and so he was like one of my i think he was maybe my one of my first mentees

00:40:58that i took on

00:40:59and i helped him try to like you know hone his skills get his resume in order um you know

00:41:06build

00:41:06projects build a website and got everything going and then i saw i told him i was like here's what

00:41:10you need to do you have to be really shameless and you need to start reaching out to recruiters

00:41:15you need to start they're gonna ghost you and you need to keep reaching out to them

00:41:20create a spreadsheet work with seven eight nine any recruiter who will work with you and then you

00:41:25keep that information and you message them once a week saying hey i'm still looking for a role you

00:41:29know do you have anything for me and nine times out of ten they'll say no but eventually you'll get

00:41:33one so he gets his first you know job at this small company he does really good he learns for

00:41:37like a year then he gets another job for like a year and he's learning so much on the job

00:41:42and then

00:41:43the year after that he gets a job at paypal where uh he's still working i just talked to him

00:41:47like

00:41:47last month um and so he's working at paypal no degree um no background in this but it's absolutely

00:41:54possible but it takes a lot of work it that's just the truth of it and so um if you

00:42:00have no degree

00:42:00that's okay right build out your skills take my data analyst roadmap uh data boot camp that's on

00:42:07youtube um build those projects build those skills build the resume start reaching out to recruiters i

00:42:14have a whole video on that it's in the boot camp of how to reach out to recruiters what to

00:42:18say

00:42:18um and do these things and you will have a good chance of landing a job um it just takes

00:42:25a lot of

00:42:26work and i will say let's say there's i have 1.3 million subscribers out of those 1.3 million

00:42:33um who

00:42:34are actively looking for job let's say that's half let's say it's like 600 000 people looking for jobs

00:42:39right now only probably like five percent so that's maybe like 30 000 people are actively

00:42:47really working hard and doing the steps that i've told them to do to land a job so you think

00:42:52your

00:42:52competition is like millions of people it's more it's a lot smaller because most people give up very

00:42:58quickly um and most people just they don't have confidence that's going to work and so they do it for

00:43:05like a couple weeks they don't get any callbacks and they give up they don't actually reach out

00:43:10to recruiters one-on-one they don't create their own portfolio they don't do the things that they

00:43:14should to increase their chance of getting a job and then they get frustrated and they stop that's

00:43:18just what i see i've seen it time and time again um my friend i've never seen you live stream

00:43:25i want

00:43:25to thank you so much you made my career now i'm still liking my first job and i'm on track

00:43:29as a

00:43:29freelance data analyst hey congratulations that is 3bd zero underscore two awesome awesome that's

00:43:36great work i love to hear that that's like my favorite thing is when people say stuff like that

00:43:41um because i just like when people get jobs that's like my favorite thing give me a second i'm gonna

00:43:45take a sip of water um i see more people asking about tools what should they be learning what should

00:43:54they be learning what should they be learning take my data analyst boot camp um everything in my data

00:43:59analysis boot camp just take the whole thing um and then once you're done with that take my data

00:44:04brick series and you're good to go that's what i would do that's my advice to everyone out there

00:44:10um this is an interesting one gal gal pew hi alex i'm a biotechnology student and i'm looking forward

00:44:17to learning data analytics which field of data analysis do you think i could apply my degrees related

00:44:21to many fields health included um i worked with many people who who had like biotechnical background

00:44:28i worked on the pharmaceutical side of healthcare so i worked it was i was in a very niche thing

00:44:35so

00:44:35just take it with a grain of salt but i worked in um uh a specialty physician uh what was

00:44:43it called

00:44:43specialty physician something i can't remember it was like spo or operations or something we worked with

00:44:49really specific hospitals and clients who were developing new medicine that had never been

00:44:58developed before and they were doing double blind studies and we would analyze the data and give them

00:45:01back the data and really it was mostly in oncology so cancer and um oncology and hematology so blood

00:45:09disorders so cancer study and hematology and blood disorders and the medicine that they were coming out

00:45:14with um was really niche and really specific and so we worked with a lot a lot of biotechnical um

00:45:20people

00:45:21who were specifically working on like the chemical um the compounding and stuff side so um there are

00:45:29niches for your expertise that get paid very well um and these people are all on the data side by

00:45:35the way

00:45:36like this your your background they had worked in labs and they worked in research um and then they were

00:45:42like hey you know what i really like about all this it's actually the data side and so they go

00:45:46into

00:45:46the data side and those are the people who i worked with and so data wise um understanding how

00:45:53uh geez now i'm blanking on the word um what are health databases what are those called

00:46:00i'm totally blanking on this i've worked with them for so long um

00:46:06it's like on the top of my let me google this i feel so terrible i'm gonna i'm just literally

00:46:11gonna google health healthcare database give me a sec healthcare database what is this called

00:46:20once i see it i'm gonna like lose my mind an ehr an electronic health record system yes so things

00:46:28like epic and all uh not alter x um i mean epic i worked in a ton now give me

00:46:35a sec i'm looking

00:46:36this up ehr systems because now i'm totally blanking on all of these i'm this is wild

00:46:43uh top systems because now i'm like totally blanking um okay eclinical works next gen athena health

00:46:54um epic those are all ones that i've worked in there's other ones here that i haven't used before

00:46:59um epic is a super popular one so epic by the way has a whole accreditation it's like a certificate

00:47:06program um i went through that many years ago back when we were working a ton in epic systems and

00:47:12so

00:47:12you can go through that yourself you can go and take their program um having that certification

00:47:17actually in the healthcare world when they're working within these companies is actually kind of

00:47:23nice um so all that being said is you actually have a lot of possibilities if you target specific

00:47:30companies look at um look at companies like cardinal health mckesson and um it's now called sincora

00:47:40used to be america's bergen that's where i used to work it's called sincora those are the big three

00:47:44for pharmaceutical distribution companies and they are always looking for people that have your

00:47:50background um but usually with some experience i don't know if you have experience or not but

00:47:54it looks like you're a student but if you have even experience with like an internship that is like

00:47:59good experience so um you know take that into consideration take that into consideration i threw a

00:48:06lot at you because that's my domain like i understand that domain really well um so i hope i hope

00:48:12that was

00:48:12helpful all right i'm catching up to some stuff um all right let me look at questions it is

00:48:209 35 we are rocking and rolling uh we have so much time left we still have 30 minutes uh

00:48:26because i

00:48:26started early because i you know just got excited you said country um this is oh wait you're asking

00:48:37you're talking to someone in the chat um by the way a lot of what i because i just saw

00:48:43country but

00:48:44a lot of the job market is unfortunately very dependent on where you live

00:48:50in the united states there is an abundance of data jobs we are just like a tech hub um and

00:48:56in parts

00:48:57of asia big tech hubs as well you you don't see it as much in a lot of europe but

00:49:04i've worked with

00:49:05people in um oh not latvia um lithuania uh romania lithuania london um or other parts of the uk

00:49:18um i've worked with a lot of people in these countries it's just not as concentrated as

00:49:23widespread as in the us and there's a lot of jobs actually in india as well so um you know

00:49:30just taking

00:49:31into consideration where you live it does play a difference in the job market for sure all right

00:49:37i'm looking at more questions let me see melody vibes underscore 37 hey alex i recently started

00:49:47learning data science i'm done with python basics tell me what to and where to do lots of exclamation

00:49:53points um okay you're also spamming a lot matthew it says it says it in his name i'm not trying

00:50:01to give

00:50:02out people's identities out here or taki one of my mods might block you listen but i still answer

00:50:07i'm still gonna answer it but just watch out um data science is not my specialty i worked on the

00:50:13data

00:50:13science team for like three years um and so i understand it well but it's not my area of

00:50:18expertise like i don't know it as well as you know kenji or um i'm blanking on uh but if

00:50:25you go in like google

00:50:26or youtube uh say you know data science tutorials follow those people's advice more than my own so

00:50:32i'm not going to give you advice just because i don't feel confident that's going to be better than

00:50:35what they have um so you know take that with a grain of salt um oh my my stream is

00:50:44lagging just a

00:50:45little bit i'm using a new camera by the way it's a mirrorless and i'm trying this for the first

00:50:50time

00:50:50and so i don't know how this is sounding

00:50:57i feel like this is out of sync

00:51:01that's not good anyways i'm going to keep going i feel like the audio is not in sync with my

00:51:08face oh am i not live let me go live let me see i mean i'm just going to see

00:51:13real quick

00:51:13this isn't new i'm testing this out so i'm trying something new let's see what's happening

00:51:21oh it is synced up okay i was wrong hey listen i was wrong all right looks like my audio

00:51:27and my

00:51:27visual are synced up that's good yeah tell them matthew matthew laid down the hammer can we connect

00:51:37with you on linkedin please absolutely i love connecting with people on linkedin um i get

00:51:43so many requests per day though i think i have like 430 000 people following me on linkedin it's

00:51:48too many and i can only have 30 000 connections so i don't accept connections unless i know you like

00:51:54okay let's say i just met you and you said hey i'm gonna follow you on linkedin i'll go and

00:51:57follow

00:51:58you back or you send me a message saying hey alex i watch your youtube channel want to connect i

00:52:03will

00:52:03then accept your connection as well but i don't just accept if you just connect with me i don't accept

00:52:08it because i get i get literally hundreds a day so i can't i just don't um i don't accept

00:52:12it if

00:52:13there isn't a message or i didn't just meet you and then you know um i i got it um

00:52:21christopher

00:52:24atkinson 65 hi alex thank you for the live stream is there any advantage to doing your data analyst

00:52:28bootcamp before jumping into analyst builder no no if you so data my data analyst bootcamp is like

00:52:37it one fantastic resource i wish i had it analyst builder is basically the data analyst bootcamp but

00:52:43like on steroids um it has built-in you know questions and practice has more advanced projects

00:52:50it goes more in depth to everything so if you go on it if you take the data analyst bootcamp

00:52:55and then you also take all of my courses which my courses cover other things that aren't in the bootcamp

00:53:00but if you take everything then you're going to get like 50 of it will be repeat

00:53:04then 50 is new and so then it's like i already know this i just need to skip ahead to

00:53:09things i

00:53:09don't know and you know you don't want to do that so if you have the money right analyst builder

00:53:14is a

00:53:14paid platform um if you want to take my full courses you want to take we have a data analyst

00:53:18roadmap on

00:53:19there there's a whole elite code style questions page to and um a general technical questions to

00:53:24practice for interviews if you want to do that and you have like you're like okay i want to do

00:53:29it

00:53:30use my code 35 off it's down in the description because i want you to get it cheaper and get

00:53:34access

00:53:34to it um it's like 20 bucks a month after the 35 off it's like 20 bucks um and you're

00:53:40gonna get

00:53:41like the best learning experience of any platform uh it's pretty it is really awesome so and there's

00:53:48also a free week trial if you want to try just a trial of the platform um down in the

00:53:51description

00:53:54um but yeah that's my that's my opinion

00:54:01let's see

00:54:05this is a good one i'm 19 years old do you think i have a chance of being accepted i

00:54:10always

00:54:10thought that companies wouldn't trust someone under 20 with their data um it has more to do

00:54:15i mean listen i am not i'm no dummy okay if you're 20 years old there is going to be

00:54:22a perception

00:54:22against you hey this guy's super young but if you can show that you really know what you're talking

00:54:26about i don't care me personally this isn't everybody but me personally you can be 20 years

00:54:31old and you could be a whiz and you can just be really smart um and i would absolutely trust

00:54:36you

00:54:36you know but you have to prove that right there is going to be a slight stigma against someone who's

00:54:41younger that's just that is going to happen um i i see taki 616b one of my mods he's saying

00:54:51you need

00:54:51window you need windows and a little bit of linux i don't actually know what he's referring to

00:54:56because i um and not i didn't see the question but i want i want to touch on this real

00:55:01quick

00:55:02i recently about two weeks ago switched over to a mac i'm running on a mac right now i have

00:55:09been a

00:55:09windows user for over 10 years

00:55:16i am learning a lot a lot i myself am not a linux user i actually tried linux a while

00:55:23back i wasn't

00:55:25smart enough for it linux is too complex for me i probably could do it now because five years ago

00:55:29i'm i

00:55:30know it way more than i knew five years ago but here's what i'm going to say if you want

00:55:36to if

00:55:37you are going to be like at a microsoft shop a microsoft laptop is genuinely the best uh because

00:55:42you just have easier access easier integration with all of microsoft like when i was working back

00:55:48at america's bergen we were a microsoft shop only we had power bi um we had azure we had one

00:55:55drive

00:55:56all these tools are integrated it was great i really did like it but in as technology has advanced

00:56:06even things like on the mac i can do almost all my work if i need to do a power

00:56:11bi well one i can just

00:56:13get on my other laptop that's not the point i can also just run like a virtual machine run it

00:56:18through

00:56:18like parallels or something and i can spin up a microsoft os um and so these barriers are getting

00:56:27lower where the exact operating system that you're on right now is becoming less important um in terms

00:56:35of like accessing tools now it does matter right the operating system that you're using for certain

00:56:43clients for example i only had my mac my microsoft laptop is an hp omen uh hp omen 15 i

00:56:51use that for

00:56:52all my work all my youtube stuff for years and years and years until like a year ago when a

00:56:56client said

00:56:56hey we only we our integration is pure mac we if you don't have a mac it might not work

00:57:02could you get

00:57:03a mac and i was like absolutely i can buy a mac uh so i bought one and i use

00:57:07it for that client

00:57:07specifically now i've used it for other clients who've requested similar things because

00:57:10of how tech stacks um you know sync up and how they work and how they send files and you

00:57:17know

00:57:17how they want to integrate things and you know these things do play a big role um but they are

00:57:24becoming

00:57:24less important for specifically like just getting access to tools i can run power bi on my mac now and

00:57:30i'm actually going to make a video on how to do that um just so other people know how because

00:57:34i myself didn't know how i you know maybe i'm a newbie i don't know still i'm still a fresher

00:57:41sad sad

00:57:46i'm just saying things now all right we got about 15 minutes left um there's something that i do at

00:57:52the end of these live streams by the way is i give away free courses to analyst builder i this

00:57:59is not a

00:58:00promotion i just want to say thank you guys for joining the live stream and i like giving away

00:58:06my courses because i want people to take them and learn from them i really do um there's no i

00:58:11this

00:58:11is not anything other than that the only thing and this is just because of how i have to do

00:58:17this on the

00:58:17back end the only thing in order to get this promo because i'm going to give you a code is

00:58:23you have to

00:58:23have an analyst builder account and um i'll show you what to do once you have your analyst builder

00:58:30account in like 10 minutes and then i'm going to give away five courses to anybody who gets it first

00:58:38right i'm giving away five i'm going to give you a code i'll say the code is uh peanuts whoever

00:58:44gets

00:58:44peanuts and you know redeems it first and buys the course first for zero it's going to be free then

00:58:51they get it and if you don't get it then you know that's i can't control that so all that

00:58:56being said

00:58:56is um i'm gonna i'm gonna set this up just so that i can um give those away but if

00:59:02you want to be part

00:59:03of that giveaway um oh it's lagging now because i think it's because i i'm on my other monitor

00:59:10um if you want to be part of that giveaway then you need to yeah i think that's part of

00:59:16it

00:59:18um you do you i don't know what's going on

00:59:26yeah there's something going on with um when i'm on my other monitor when i'm live streaming this

00:59:31look this is my first time so i'm actually learning a lot um i might just unplug my monitor when

00:59:37i'm

00:59:37live streaming next time interesting um anyways i just want to give you a heads up because in like

00:59:4210 minutes i'll be doing that now i'm going to answer more questions let me go back

00:59:50hey alex this is from venom neo 310 hi alex i'm i thought about making a project revolving stocks

00:59:57what eda related thing would you suggest for it like some things which will help me a lot because

01:00:02i don't have much knowledge in stocks um okay here's a look i want you to do this project but

01:00:09if

01:00:09you don't know anything about it it makes it really hard to actually do exploratory data analysis

01:00:15um because you don't know what to ask you don't know the data if i were you i would start

01:00:19with

01:00:20data you actually know like it could be anything it could be sports it could be horses it could be

01:00:27you know um you like saving money and so you want to look into how people are saving their money

01:00:32i don't know it could be pokemon value of pokemon cards over time i don't know something you actually

01:00:39really know about and do exploratory data analysis on that because that is like you'll know what to

01:00:46ask but if you don't know stocks then i wouldn't do a stock project just yet um that's my opinion

01:00:53but for exploratory data analysis yeah i mean what i would do is i would you know either download a

01:00:58data set on stocks and try to find historical trends and patterns or you know connect that data with you

01:01:05historical events and you know line up the timelines and see what happened at what time like that kind

01:01:11of stuff is all over the internet already but it's interesting to try to build it build replicate and build

01:01:16things yourself um chinta patel 662 how do you feel about a data product owner i don't know how i

01:01:27feel

01:01:27about it i mean do it i've worked with um product managers who own data products and they did great

01:01:36nothing against it

01:01:40yes my stream does have a delay i can't you that's just how youtube streams from obs

01:01:46um and yeah it's like there's a delay of like 30 seconds or something um

01:01:59i'm just a lot of sorry it skipped a lot of these have um i've answered already and so

01:02:08what do you think about learning machine learning machine learning is definitely more on the data

01:02:11science side of things i am not an expert on the data science side of things i worked on a

01:02:16data

01:02:16science team that does not mean that i know it perfect um but machine learning is actually still

01:02:22really useful especially at larger companies most smaller companies i think are actually going to

01:02:28probably move away from a lot of machine learning stuff um you know from a ton of machine learning

01:02:35stuff depending on their use and they'll use some more plug and play ai things but machine learning is

01:02:40absolutely still relevant um and it's going to be sometimes a lot more most times depending on the use

01:02:47a lot more accurate with certain outputs than any ai system is going to be so a lot of companies

01:02:52are

01:02:52definitely going to still learn it i don't know how much it's i don't know how it's changed the landscape

01:02:57has changed

01:03:00all right let me see

01:03:04let me see

01:03:07thank you guys i i need this feedback when i hear like oh it's in sync i'm hearing it right

01:03:13yada yada because i'm not a live streamer like i don't do this i do this every so often

01:03:17um and so i'm trying new things i have a new camera that i got specifically for live streaming

01:03:23um but i'm realizing like my monitor takes a lot of power and so when i'm doing that it's lagging

01:03:29and so i'm going to try not to do that um as much

01:03:34um claude code is best for ai coding i personally have been using claude coding myself i'm coming out with

01:03:40several actually next week i have a video on claude code in excel or claude in excel um i just

01:03:46found

01:03:46claude in excel apparently it's been around for a few months but i was like i didn't know so i

01:03:50made

01:03:50a video on it um and i'm gonna make more videos on some ai tools because i didn't want to

01:03:56make videos

01:03:56on things that i hadn't personally used and didn't feel confident that i should like should be teaching

01:04:01these things um and so claude code claude co-work i've been using now for claude co-work now for

01:04:07like

01:04:07a couple weeks since it came out and i've been using claude code for a little while i've also

01:04:11used codex um i'm gonna come out with videos on this i think that claude code and claude co-work

01:04:18are really good um they're not perfect by any means i actually found a lot of issues with them in

01:04:24my

01:04:24like as i've been using them for my real work um but as you use these tools more you learn

01:04:30the

01:04:30negatives and the positives so i'm i'll come out with some stuff but i like claude co-work i also

01:04:35like

01:04:36codex a lot so if you like codex use codex just depends on what you already kind of have

01:04:41all right i'm going to answer like one or two more questions and then i'm going to give away some

01:04:45courses and then we'll be out of here if you want to get one of those free courses you have

01:04:50to have

01:04:51an analyst builder account and be signed in i'm just giving you a heads up just giving you a heads

01:04:56up

01:04:58all right let me see

01:05:02wish you could play guitar with us with your original song wow that's that is an that's an og

01:05:10follower right there a sarcastic gamer uh i wrote i'm actually in the process of writing another data

01:05:17song um but about like three years ago maybe i put out a song on my youtube channel uh where

01:05:25i sang

01:05:25about um what was what was the title called that's the that's the truth about my job so it's just

01:05:34a

01:05:34funny song you should go listen to it it's funny but that is og and i actually do have my

01:05:38guitar right

01:05:38i'm sure you can see it i have my guitar right here i'm not going to play it right now

01:05:41this mic

01:05:42actually doesn't pick it up well um i need to use a different setting or a different mic for it

01:05:50um all right let me see

01:05:55hi alex which course is the best now to become a data analyst in 2026 i mean genuinely i hate

01:06:00i'm not i hate to be like a self-promoter i'm not i'm not good at self-promoting actually

01:06:05analyst builder which is my platform it's my courses my platform i built it nobody else owns it except

01:06:11you know my team who works with me it is the best platform for like if you're getting into data

01:06:16analytics the best platform in the world at the best price like it's you use the 35 off down below

01:06:2335 off and you get like elite code style questions you get general technical questions to practice for

01:06:28interviews and you get feedback on it and you have all my courses ai is integrated into the whole thing

01:06:33it's pretty awesome um so if i were you that's where i'd go genuinely all right yes matthew's

01:06:42hyping people up get your analyst builder account ready it's true um because i'm gonna do one more

01:06:48question then i'll do the giveaway um with many years in revenue cycle management do you think

01:06:55gaining an epic certification through an epic analyst position may be benefit uh

01:07:00maybe beneficial yeah i do um my company paid for it so i didn't have to pay for it i

01:07:05don't even

01:07:05know the cost if i'm being honest but i had other jobs because uh i was working at america

01:07:11bergen i worked there for many years mckesson tried to like hire me at one point um and they want

01:07:18they

01:07:18the fact that i had that certification was actually useful i ended up taking a job internally at my

01:07:22company for a data analytics manager position within our it department so i didn't go to mckesson

01:07:27um but they were trying to poach me uh back in the day and so it is useful um you

01:07:34know that that was

01:07:35even that was i wasn't even like my youtube channel wasn't even big then so you know they didn't really

01:07:39care about any of that now it's like the first thing that comes up when companies talk to me

01:07:43they're like oh we love your youtube channel i'm like oh that's great but back in the day it didn't

01:07:48and so that those certifications can actually be um and it should be useful now listen i'm about to do

01:07:53the giveaway what i want you to know is that i answered a ton of different questions on the job

01:08:00market on ai on all the tools that you need the best places to find courses um the you know

01:08:07how to

01:08:09apply for jobs the best way to apply for jobs i talked about all that in this live stream if

01:08:12you

01:08:12missed any of it just go back in the live stream and watch it um and you'll be good to

01:08:17go all right

01:08:20here's what we're about to do what i what you need i'm going to do it with you and i

01:08:25might my

01:08:25computer actually i'm going to do it on my phone so i don't lag out the whole live stream goodness

01:08:28gracious i got to get a better setup i'm just not listen some things are not my specialty and live

01:08:33streaming is not my specialty i'm going onto my phone i'm going to analystbuilder.com and also just

01:08:40so you know we optimize for phone usage for analystbuilder.com that is true so you we optimize

01:08:46it so that you can do this on your phone or your ipad or whatever so that you can do

01:08:50it on the go

01:08:51you don't have to be on a laptop so i'm going to come right here i don't even know if

01:08:54you can see

01:08:54this i'm going to go to pricing and i'm going to go down to a course and i'm going to

01:08:59pick my favorite

01:09:00course it can be any course i don't care be any course i'm going to go to i've been talking

01:09:05about

01:09:05cloud computing i have a cloud computing essentials for azure and aws i'm going to buy it uh you have

01:09:10to

01:09:11sign in okay once you sign in at the checkout because i'm not going to sign in right now because

01:09:16that'll take me a second at the checkout there should be an apply code i'm about to give you

01:09:22that code okay and i'm just going to say it and you guys all hear it at the same time

01:09:27you need to

01:09:28type it in redeem it and buy the course at zero dollars it's free you have to be the first

01:09:33one to

01:09:34do that and if you get if you're first you'll get it i'm going to give away five codes okay

01:09:39five codes all right here we go uh i actually gotta go make code

01:09:46oh geez what have i done what have i done

01:09:52all right give me one second because now i gotta like make this code i should have done this earlier

01:09:57i am i'm a fool i am a fool and now it's gonna like lag up my whole live stream

01:10:02for the next like

01:10:03minute or two i'm gonna call this one the ab this is just the name of the coupon it's not

01:10:08the code that

01:10:09you need this is the ab live stream free course all right it's gonna be a hundred percent off

01:10:16but it's only gonna be for the courses not like the lifetime i'm not being good and

01:10:21disgraceous that would be um so give me a second while i select those um and then you need to

01:10:27be the

01:10:28first one to select it so let me see this is the pandas course we've got the python programming course

01:10:34soft skills ai uh getting github that's a oh i didn't even talk about getting github as tools

01:10:41you should learn get in github um i have a full course on it that is like a really great

01:10:48course

01:10:48um or not course but a really great topic to learn um let me see advanced excel for automation i

01:10:56have a lot of give me a second i do apologize this was i should have had this ready i

01:11:01i i feel

01:11:02terrible terrible um tableau i'm almost done almost done uh boom and i think i missed one give me just

01:11:14a second landing a data job course there it is all right so this is gonna be i've created the

01:11:22coupon

01:11:22now i have to give you the code so i hope you're ready now i'm gonna give you this um

01:11:28um this code and you're gonna be good to go so let me create this first code i'm gonna limit

01:11:35the

01:11:35number of times it can be redeemed this one i'm actually gonna make it two people i'm feeling

01:11:39feeling spicy um let me think

01:11:45this is gonna be in all caps the code is azure wow all one word all caps azure wow two

01:11:55people can

01:11:55redeem that um and i'm gonna keep going because it takes like you know there's a delay so i'm gonna

01:12:00add my next one azure wow all one word um

01:12:11the next one can be redeemed it's aws wow

01:12:17i don't know why i'm coming up uh why i'm doing it like that the next code is aws wow

01:12:22all one word all

01:12:23all caps that code will um that code will be redeemed by two people so now we've given away

01:12:31four free courses and then i'm gonna go and let's make another one and you know what i said five

01:12:38total but i'm gonna do seven total uh just because so i'm gonna do three this last one can be

01:12:43redeemed

01:12:43by three people once it's gone it's gone all right this is our last one

01:12:50is our last code the code is and look okay azure wow that one's gone it's been redeemed aws wow

01:12:58that

01:12:58one's been redeemed all right this is our last one this is giving me three free courses total of seven

01:13:03courses for free and this is true i want you to know um that this is 100 true the code

01:13:11is in all

01:13:11caps all together no spaces i love you um it's true i really do i really love you guys you

01:13:20guys

01:13:21have supported me for a long time and this is such a i've done tons of giveaways in the past

01:13:25but this is my way of giving back to you guys um for supporting me in my channel and on

01:13:31these live

01:13:31streams and just you know it really does mean a lot to me and so i know this is a

01:13:37small thing to give

01:13:38back but i hope that whoever you know gets these that they really really use these courses and can

01:13:45learn a lot i also if you get one of these courses if you click the checkout and you get

01:13:49it for free

01:13:50you can go to your um purchases tab and you can see that you got that that's how you'll know

01:13:55for

01:13:55sure you'll go to your purchase tab on analyst builder and you'll show the course down there

01:13:59if you got it please let me know if you got the course i'm going to type in the chat

01:14:03here

01:14:03let me say who won the courses um who won the courses i hope i hope some people who are

01:14:13really

01:14:13active in the chat won the courses i like rewarding people who you know are like engaging in the chat

01:14:19and like working on it and and whatnot um but i hope that that was really cool if you haven't

01:14:25checked

01:14:25out analyst builder this is my last plug just because you guys are already on there just check it out

01:14:29there's a go to the questions page and click on the free questions and you can practice on there

01:14:34for free it's really an awesome platform um and so i hope that you guys use it and if you

01:14:41did win the

01:14:41courses put in the chat because i'm really curious um that's all i got today that's our live stream

01:14:47we did for an hour and 15 minutes or so i think that's true we did for an hour and

01:14:5215 minutes and uh

01:14:55i think it was a good live stream a lot of really great questions today um on tools and and

01:15:00you know

01:15:02kind of a lot on jobs like how to actually get a job how to apply for jobs and things

01:15:07like that

01:15:08um so yes yes this site isn't loading for me oh if it's not loading for you there could be

01:15:15a few

01:15:15we've had issues with specifically with people with using like ad blocker or vpns um those sometimes cause

01:15:21issues um but yeah all right guys i have got to go uh because i do have some work i

01:15:30actually got to

01:15:30get done but thank you guys so much for joining i really do appreciate it that you guys showed up

01:15:36and that you asked questions and you know you participated because i just love seeing that i like

01:15:42seeing people in the enthusiastic and excited about just data analytics and you know who are interested in

01:15:48future and what's going to happen in the next several months and several years so thank you

01:15:52guys for joining um if you guys have any other questions like i said go on linkedin type in alex

01:16:00freeberg or alex analyst i'll come up on either and shoot me a message um send me a connection request

01:16:05with a message that i know you are from the live stream and i will accept it okay so please

01:16:11go and do

01:16:11that and um there you go yes this is a question if you have a if you already have a

01:16:21subscription to

01:16:21analyst builder if you want to buy something and have it forever because you'll get that course for

01:16:26life or the bundle for life you can do that absolutely um yes i'm going to make a 2026 data

01:16:33analyst roadmap that's going to be my i'm literally going to be making this soon it's going to come out

01:16:38soon it's going to be like 31 hours it's going to be called the 2026 data analyst roadmap and it's

01:16:43going to be like all of my videos going back many years as well as new stuff that have come

01:16:47out that

01:16:48was not in my original data analyst boot camp that i put out like two years ago so be on

01:16:52the lookout for

01:16:52that um i hope you guys have a great week

Category

Transcript

Comments

Recommended