Alex The Analyst Q/A Livestream | Come Ask Me Anything - video Dailymotion

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.  Never Tried Analyst Before? Get 1 Month of Free Courses on Analyst Builder with code: 1MONTHFREE Select Monthly Subscription here: https://www.analystbuilder.com/pricing  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 fo

Transcript

00:00:02hello hello hello uh i'm just getting set up i want to make sure everything looks good

00:00:08making sure everything looks good before we get officially started but hello everybody in the

00:00:16chat i see a lot of people here i am um there we go making sure everything was working right

00:00:24it's working it's coming through checking my phone

00:00:31yeah this looks good all right sweet so here's what we're going to do uh i've been doing a weekly

00:00:36live stream for one week now this is our second one so it's two weeks i guess but i'm very

00:00:43excited

00:00:44to see everybody how these work is i just read through the chat and that's it uh it's pretty

00:00:52simple wait give me one second i was gonna make uh taki a moderator there we go

00:01:05he reached out to me on linkedin and was like hey i like the live stream i'd like to be

00:01:09a moderator

00:01:10i was like sure but wait a second matthew's already here uh that's okay we'll have a few moderators

00:01:16and that's all right uh because it doesn't hurt to have backups not a big deal glad i have extra

00:01:24people though uh thank you guys for joining uh shout out to the moderators they're gonna be there

00:01:29to help people not spam the chat uh which people don't like nobody likes that so don't do that

00:01:36if you do that i don't answer your questions i really don't um so all right uh let me see

00:01:44here

00:01:45let me get let me get everything finished and set up and good to go all right i think we're

00:01:54i think

00:01:54we're rocking and rolling um let me say hi to everybody first uh music max what's going on

00:02:00tanver tanvir hey tanvir watching from argentina ezekiel thanks for joining uh let's see who else we got

00:02:10in here yeah no spammy spam no spammy spam pavin or pavan from india uh very nice to meet you

00:02:18guys

00:02:19very very nice thanks for joining uh this is a somewhat new thing i'm doing i'm gonna be doing a

00:02:25weekly live stream every thursday at 9 a.m uh just to give back i heard from a ton of

00:02:31people saying they

00:02:32missed my live streams they had a lot of questions to ask and i try to be as available as

00:02:37i can on

00:02:38places like linkedin and other places but of course i have a lot of work to do and i don't

00:02:43have as much

00:02:43time so i'm i just try to carve out an hour or so of time um on thursday mornings so

00:02:49that you guys

00:02:50can ask me questions and so i'm going to answer questions as best as i possibly can you can ask

00:02:56any question it doesn't mean i'm going to answer it uh it could be a really bad question or it

00:03:01could

00:03:01be a fantastic question that everybody else in the chat is like i wish somebody had asked that um

00:03:06and that might be you you might ask that great question so i hope um i hope that is i'm

00:03:11gonna

00:03:12start um i'm gonna start higher up for the people who kind of got here early and uh then we'll

00:03:21be good

00:03:21to go so let's see let's see all right i'm just reading through the chat give me a second i'm

00:03:31gonna

00:03:31answer some uh answer some questions excited for the live stream me too i do get excited for the

00:03:37live stream they're fun um how can i this is just a i don't know if it's a generic question

00:03:44it's kind

00:03:45of a vague question precious no watch who said how can i create insights i butcher that name but how

00:03:52can

00:03:52i create insights um insights into data is usually a lot more nuanced than it seems um i i don't

00:04:03know

00:04:04if i talked about this in the last live stream but when you no i didn't you know what it

00:04:08was i created

00:04:09a i'm trying to do more tiktoks believe it or not i don't like tiktoks as much but i tried

00:04:13to make

00:04:14some and i made one uh the other day and it basically said that when i was first getting into

00:04:19analytics

00:04:20when i first got into data presenting information was basically all i did i just said here's what

00:04:25the data is the data shows this it's not super insightful um insights is where you turn data

00:04:33kind of into action it's where you say hey here's what the data is here's how we got the data

00:04:38and

00:04:38here's what this means and here's what we need to do because of that right it's kind of like the

00:04:42different stages and for the first year of my career i was just at the here's what the data is

00:04:47it was not very helpful um i wouldn't have said i was like the best analyst in the world

00:04:54but as i went along i was like oh the clients need more context they need more information

00:05:01um and when i was working with decision makers i was like hey here's what i'm seeing here's what i

00:05:06suggest you guys do with this information and you don't have to i'm sitting kind of low i just realized

00:05:12all right but that's kind of how you get insight you you go beyond just here's what the data says

00:05:21music max says have you thought about a business analytics degree um i won't be going back to get

00:05:28any degree i don't plan i i actually uh the only higher education besides my recreational therapy

00:05:36degree i was going to go back and get a master's in occupational therapy that my whole life changed and

00:05:41i'm not doing that anymore i did think maybe about four or five years ago oh maybe i should go

00:05:46back

00:05:47and get my mba and like business analytics or go back and get a computer science degree or you know

00:05:51something i honestly realized i was like i don't think that's needed anymore i don't i think i'm you

00:05:58know my experience is probably more useful than a degree is and my life has kind of went in a

00:06:04direction

00:06:04where i just didn't really need a degree so i'm not personally looking about it i've thought about it

00:06:10and for a lot of people it could be a great degree um but i personally know i'm not looking

00:06:15at getting a degree hot uh haritha jagadish hey do i need to learn looker looker is a visualization

00:06:27tool no you don't need to learn it it's like these other tools it's like power bi it's like tableau

00:06:34but

00:06:34looker i believe is purely cloud-based which is different than like a desktop-based version at

00:06:39least that's when i was using looker that it was just web-based um and so no you don't need

00:06:44to learn

00:06:44it but if you want to if your job is wanting you to learn it then learn it other than

00:06:49that i would

00:06:49just stick with like the fundamentals but it's a tool you can learn it for sure um i don't know

00:06:57what

00:06:57that means um garden exhibitor in the age of ai is it beneficial to learn data analytics and earn

00:07:05five to ten thousand usd in a month um in the age of ai knowing data and understanding data i

00:07:13think is

00:07:14and not just understanding data it's understanding like the business side of things the domain

00:07:19knowledge but the skills of a data analyst aren't going away i don't see a future where we are gone

00:07:26so i think learning data in general is a very good idea um i just in my opinion i really

00:07:33do earning five

00:07:34to ten thousand dollars a month um with inflation i mean we'll be there any we'll be there any day

00:07:41like in two years like the median salary would be like a hundred thousand um but today no i don't

00:07:47see earning ten thousand dollars very realistic especially when you're first starting out five

00:07:52thousand very realistic right sixty to seventy five thousand you're first starting out perfectly

00:07:57reasonable in most metropolitan areas if you're a small town company in the middle of nowhere you

00:08:04know maybe it's like 40 but that might be a good salary for the cost of living in that area

00:08:07but ten is kind of pushing it unless you're living like los angeles all right let's keep going

00:08:15nana i shot says hi alex thank you so much for your videos i'm watching your youtube when the

00:08:21live stream notification came up very cool thanks for watching my videos i hope they're helpful i would

00:08:26like to know how to secure an internship role so internships are tricky um internships every company

00:08:32does internships differently every company um gets their interns in a different way i never got an

00:08:39internship so i can't give you personal experience but here's what i've heard from other people is

00:08:43that a lot of people kind of got an internship via knowing somebody so networking a lot of people get

00:08:49internships through their college so you know they go and they get a data analytics degree they have a

00:08:55career uh part of their college that helps them secure internships from alumni right so through your

00:09:03college network even if you don't know them personally you both went to uh smj or whatever

00:09:09acronym you school you went to every hey my this guy went to smj and he has an internship at

00:09:14his company

00:09:15or his business where he works um let's connect you with s the this smj alumni that's i that's how

00:09:22i've

00:09:22heard it works for the most part you also can apply online um oh oh give me one second christine

00:09:33my wife thank you my love she said i don't she wants to see my face more not the uh

00:09:38microphone i'm

00:09:39adjusting this real quick because i take my wife's feedback very uh seriously i think this is better

00:09:47you can see my mouth now before it was like this now you can see it a little bit better

00:09:51um but that's how i've heard i'm not a i'm not an expert in that area i'm just gonna give

00:09:56her a

00:09:57heart back real quick thanks babe i appreciate it all right let's keep going oh geez it did that

00:10:04thing where it jumps down it did that thing where it jumps down not cool all right let me see

00:10:14so max sterner said can i learn data analysis myself or do i have to go to local courses it's

00:10:20100

00:10:20available to learn by yourself so he i taught myself through courses back in the day uh this

00:10:26is 2017 era things have changed a little bit um and i'll i kind of want to go into a

00:10:31few of the

00:10:31nuances just a little bit about that um which is uh back in 2017 the job market was a little

00:10:39bit

00:10:39easier honestly it wasn't that much better um but it was better right companies were hiring a little

00:10:45more but uh applying to jobs was just as terrible you i applied to thousands of jobs like i think

00:10:51it was like 2 000 jobs and i didn't hear back and then i worked with a recruiter i started

00:10:55getting

00:10:56lots of interviews it was great um you can teach yourself you can there's i have honestly i believe

00:11:03over the past five years i've created one of the best catalogs and repositories of data analysis content

00:11:09in the world and so you can learn that for free on my channel but you can also pay for

00:11:14courses if

00:11:14you want to you don't have to though um courses just streamline things maybe have more advanced

00:11:19stuff i know my courses do but um honestly i have heard from a lot of people who learn purely

00:11:26for free

00:11:26uh that's all across the world just from my youtube channel and got a job so it's very possible

00:11:33um you don't have to do courses if you can't afford it don't just use my youtube stuff and

00:11:40there's lots of other creators who create great content that cover things that i don't even cover

00:11:44or haven't covered yet so no you don't have to pay for it um but if you do then find

00:11:51good courses

00:11:51that you like i have some in the description i have my own courses on analyst builder but there's

00:11:56also udemy and coursera courses that i have taken and i really like um so you know that's what i

00:12:00would do

00:12:01it mohit jengam being a fresher where to apply for data analyst role um i i always recommend

00:12:11several different things one you got to do the traditional just applying through linkedin and

00:12:17uh whatnot all right give me a second my wife's texting me she said so good all right it's better

00:12:22my wife approved so we're good um so i always just cold applying right that's through linkedin

00:12:31uh indeed these other job websites just apply through them you should um to kind of get a feel

00:12:38for the job descriptions what they're looking for and whatnot the other thing is that that for me was

00:12:44not successful and there's so much there's so many uh automatic systems now that just filter out

00:12:50resumes if you don't have great resume it's really tough i recommend reaching out to recruiters now

00:12:55others are recruiters are primarily in uh metropolitan areas so you know that doesn't

00:13:01necessarily help everybody who doesn't live in a metropolitan area but there are online recruiters

00:13:07who work directly for companies you can reach out to them on linkedin i have a whole uh i have

00:13:11several

00:13:11videos in the boot camp on how to do that uh it's free right you can just reach out to

00:13:16people

00:13:17um so i do recommend uh doing that i recommend reaching out to people and then uh that actually

00:13:24that is the third method so working with a recruiter or then cold reaching out to recruiters who work

00:13:29for companies and sending them your resume so i do recommend that matthew uh said says hi to christine

00:13:36i'll let her know i'll be sure to let her know but that's where i would be applying and i'd

00:13:41work

00:13:42heavily with recruiters if you can watching from liberia saeed bari awesome awesome awesome let me

00:13:51see can i like no but christine's there i see her thank you i'm glad she's watching she really she

00:14:00really needs to learn more about data analytics that's that's for sure um boosted tofu cool name

00:14:09how does one spin their resume to fit a quant investment role i don't know i know what quant is

00:14:15uh i know what a quant is i know what that job i have met people i've talked to people

00:14:19who do that

00:14:20it's a really neat job um but it's heavily statistics heavily mathematics based and i've never done it

00:14:26so i don't know um you there's quant channels on youtube that you should follow and uh look them up

00:14:33for sure um let's see

00:14:40let's see let's see let's see what do you say about zapier i don't know if that's you pronounce it

00:14:45zapier zapier and hubspot data analytics i know companies and i've worked with companies in the

00:14:51past uh that use those in fact uh i know people right now who are using uh those for automation

00:14:58and for collecting data and whatnot and and it can be very good depending on the size of your company

00:15:04can be a very good combination it also could be overkill for some companies um for smaller companies

00:15:10that don't really need it so they're good tools to learn in fact you know that those would be to

00:15:15hubspot specifically is a very big tool a lot of people will use it so if you're keen on uh

00:15:21doing that

00:15:22if you're keen on learning those tools do it they're they're good tools kevin moreno hello alex

00:15:29first of all kevin from new york hey from new york i'm in south carolina right now what's going on

00:15:33thankful for your content i'm currently pivoting into data analytics i got a certificate from springboard

00:15:38from a non-stem background any advice i feel lost so springboard i believe is a uh i don't know

00:15:44if they

00:15:45do courses i know they do boot camps um they're like one of the big boot camps not just for

00:15:51data

00:15:51analytics but for data engineering and software engineering and data science and all those things

00:15:56um and i don't know how much you paid kevin but from what i saw springboard was somewhat expensive

00:16:03um once you get these degrees once your certificates or whatever they want to call them and you go

00:16:09through these boot camps typically they're gonna have some kind of program to help you find a job

00:16:15or you get your money back if you didn't if they don't have that i don't like when companies do

00:16:20that

00:16:20first off you pay a lot of money to learn these skills and they don't help you land a job

00:16:26it's not

00:16:26cool um but i would reach out to them say hey i'm having trouble finding a job do you guys

00:16:33have

00:16:33resources to help with that because that would be the first thing i would ask first thing i'd be

00:16:37looking for the next thing is that you know a lot of that is going to be on you uh

00:16:42unfortunately

00:16:44you're coming from a non-stem background and you're like me and you're trying to land a job

00:16:49and your experience is this so if i were you i'd be looking what other experience do you have can

00:16:55you

00:16:55kind of uh put that into use like mine was a healthcare background so i got into a healthcare

00:17:02analytics company it's just an example and so um that feeling of being lost is it makes sense because

00:17:09when you're on that path and springboard there you're teaching things you're meeting with your

00:17:13mentor once a month or whatever it is and so you have a path to follow then afterwards you kind

00:17:18of drop

00:17:18off and you're like okay what do i do next i know the skills so i'd be applying to jobs

00:17:22i'd be

00:17:22reaching out to recruiters um i would be updating my resume um you know advancing your skills a little

00:17:28more that's what i would be doing okay it's skipped down i hate when it does this i'm sorry yeah

00:17:34matthew tell him how it is tell him to stop spamming matthew's on it um all right i can't i

00:17:41went back up

00:17:43i saw talking in there too i saw talking in there too he's my new mod i got two mods

00:17:47now

00:17:48i'm gonna be doing more live streams i might need to get three who knows all right let me keep

00:17:54going

00:17:57ashwin suresh as a non-tech professional with five years of work experience and having completed data

00:18:02science boot camp i'm unable to get data related roles due to lack of relevant work experience how can

00:18:08i work around this same thing as i was just saying before you have to if you don't have a

00:18:13background

00:18:13in it then you need to really hustle to work hard to get noticed by recruiters reach out to recruiters

00:18:20um you know see how you can take your previous experience on your resume and change and apply

00:18:25and target this is something i started doing later on in my career but i wish i would have done

00:18:29earlier

00:18:29which is targeting specific companies that would value my experience because i didn't really know

00:18:35about that beforehand but my experience in healthcare was valuable to some companies not all

00:18:40excuse me and so if i would have reached out specifically to like mckesson and uh cardinal

00:18:45health and uh the one i eventually worked for which is america's bergen now cancera

00:18:50i would have had more luck um because they would have valued that experience a lot more

00:18:55that's what i'd be doing

00:19:01uh chucks ava asked this i'm just going to read it but i don't know says any advice if i

00:19:06go ahead

00:19:06writing aws exam i don't know i don't know you maybe someone in the chat can help you but i

00:19:12don't

00:19:12know that um ghost star with a star in the name that's a cool that's a cool name hi i'm

00:19:20a data

00:19:21analyst looking for a new job i'm going to be taking some classes to work on skills i don't get

00:19:25in my job like sequel but other than projects how do i look like a competent candidate well first off

00:19:32having any experience whether it's early on like i when i first started my career all my company did

00:19:37was excel it was only excel it's pretty simple um and that was my experience but i upskilled just

00:19:43like what you're wanting to do into sequel and tableau and python and r and all these other things

00:19:49um and then how do you look competent one create a good portfolio website if you haven't already i

00:19:54have a whole thing on how to create a portfolio website on my youtube channel i also have a course

00:19:58and um people remind me at the end of this i'm going to give away some courses free courses whatever

00:20:04course you want i'll just give you some codes and you just got to plug it in i'm going to

00:20:07do this

00:20:08every single live stream but i have a landing a data job course on analyst builder and that one goes

00:20:14more in depth on creating a portfolio portfolio projects portfolio website um i recommend doing

00:20:20that and putting those projects in your resume as well is great because it shows this person in you

00:20:26know if they're in if you have a certain industry that you're targeting making projects in that

00:20:30industry is really good and so having more skills having that previous experience and having projects

00:20:35and a portfolio website and a good linkedin profile those are the things that i would be focusing on

00:20:40um because you already have some experience and they don't these other companies don't know what

00:20:45you've done in that job right and so you can write it to make it sound good even if you're

00:20:51just using

00:20:51excel like what i was doing i in my in my uh skills section i still put sequel and excel

00:20:59and tableau

00:20:59because i was learning those things on the side and as you're learning you can add them to your resume

00:21:03so that's what i would do um and uh for real guys remind me at the end uh about the

00:21:11the free giveaway

00:21:12because i will do a giveaway i'll give like five or six free courses away you don't have to buy

00:21:17them

00:21:17they're completely free let's keep going

00:21:23peace casa hey alex peace here cool name great name quick question i live in benin republic in west

00:21:31africa is it possible for me to get remote job or internship and data analysis from an african

00:21:36company and if yes how can i now again i don't have personal experience of this but here's my

00:21:42experience of working with other people and um you know back when i was uh a manager we did i'm

00:21:49getting

00:21:50lower in my chair i don't know if that's a good thing or not um we would take in not

00:21:56interns we would

00:21:57take uh um yeah not interns what's the uh word i'm looking for um where they weren't full-time

00:22:07employees they were if i'm thinking of the word i'm thinking of the word i'll think of it in a

00:22:16second um but they weren't full-time hires we took them for six months a year contractors is what i

00:22:22was

00:22:22thinking of thank you i couldn't think of it um so here's how they typically worked usually we would

00:22:29work through a company like accenture um there's a bunch of other consulting companies and they would

00:22:35be from lithuania or mexico or uh different parts of the world and we would hire from them um the

00:22:43upside for our company was that it was cheaper right but it was a good wage for where they were

00:22:48living

00:22:48but it was cheaper for us um and so uh typically we would do that oh my mom was texting

00:22:55me uh she

00:22:56called it a temp but no we didn't hire temps although that is maybe what some people use but

00:23:01we we call them contractors at least but it could be called a temp too um but if you can

00:23:06get in with

00:23:06one of those companies typically you have to interview um and then those companies will kind of

00:23:11kind of uh lease you out to companies as a consultant and you make money the company makes money and

00:23:16everybody wins um other ways to do it is one you can create uh uh you know an account on

00:23:24like fiverr

00:23:24upwork and try to get experience through that it's you know a little bit tougher in my opinion to get

00:23:30started on those websites without any experience but uh those can be very helpful so uh but that's my

00:23:37experience that's my experience i worked with them mostly through consulting companies like accenture so

00:23:41if you want a c c e n t u r e uh something really close to that mohan said

00:23:48we want a special video

00:23:49with your family i have videos from the past with uh uh christine i know i don't know if my

00:23:57mom ever

00:23:57made it on a video i don't think my dad ever has maybe i should bring up one for a

00:24:01live stream one of

00:24:01these days why not uh our business analysts and data analysts the same this is from ascaline red

00:24:09ascaline red are business analysts and data analysts the same no they're not the same but

00:24:14they're similar business analysts tend to be more business focused where they're interfacing more with

00:24:20the client side um whereas data analysts will do that but on larger teams you're gonna you sometimes

00:24:27have one of both on smaller teams you'll just have one a business analyst or a data analyst and

00:24:32will typically do the work of both positions um but at larger companies the business analyst is going

00:24:38to interface what means they're going to talk to the client they're going to receive the requirements

00:24:43of a project or whatever and then they'll go and relate that to the team and then they may take

00:24:48on

00:24:48some small tasks in excel and sql but they won't typically do a ton of technical work but maybe a

00:24:53little bit um kind of the baseline stuff a data analyst is typically going to work in internal teams

00:24:59unless it's a small company and you're going to work do everything but details typically will do a

00:25:03little bit more the technical side of things they'll interface more with the data engineers

00:25:07with the data scientists with the uh with the managers with uh the uh what's it called

00:25:14database developers right to understand the data better help with the data collection process help

00:25:19with the data cleaning things like that they know the data a little bit more in depth

00:25:25taha nafal i remember you from last uh last stream what's going on how to get out of tutorial hell

00:25:33uh that is this bottom that people call it tutorial purgatory as well it's this bottomless

00:25:39place where you just take tutorial after tutorial and you feel like you're looking at the same stuff

00:25:43and you don't know what you don't know my biggest advice to this is to start building you're doing

00:25:49small little queries on small little tables and it's very simple stuff my biggest advice to that

00:25:56is to build a project and make it your own get your own data source your own data create your

00:26:02own

00:26:02data get data from data.gov which i love um and try to build out your own project because you're

00:26:07going

00:26:07to advance your skills a lot faster because you're going to ask questions and then about the data you're

00:26:14going to say i wonder how many people fit this criteria and this thing and then you have to write

00:26:20the query but the query doesn't make perfect sense and you have to kind of use some ai use some

00:26:25googling figure it out and you advance your skills a lot faster that's what i would do all right who's

00:26:31this from uh matthew thanks for the donation matthew gave me five bucks uh i don't know why he does

00:26:36this

00:26:37matthew gives me five dollars for a five for five well i do know you know many years ago this

00:26:42is a long

00:26:42time ago uh i mentioned i when i was very broke moved to dallas with no money no no job

00:26:49no nothing

00:26:50um i used to just eat five for fives a lot to feed myself and so now he gives me

00:26:56five bucks to

00:26:56feed myself for five for five i'll do that i'll have to get one for you although now i think

00:27:00they

00:27:00only have the six dollar biggie bag which is preposterous um not a fan i like that i liked my

00:27:06five for five anyways i'm getting off topic um all right precious no watchaku i i butchered that name

00:27:17but i i read your name i'm just gonna call you precious that's a cool name where can we find

00:27:21sites that teach us real life data sets thank you for explaining the questions on insights um so

00:27:28finding data sets is a different thing than uh websites that teach you with real life data sets

00:27:33my website i think uses fantastic real life data sets that i've used in the real world

00:27:38and i use those in my courses um and so i would look there first right analystbuilder.com highly

00:27:45recommend looking at it i that's what i use in my courses i use real data sets and teach real

00:27:50projects

00:27:50um but if you're looking just for raw data sets kaggle is a good spot although sometimes it can be

00:27:56a

00:27:56little bit uh more curated data.gov is a great one and then google data set search not just google

00:28:02it's called google data set search and you can search for data sets and they'll give you

00:28:07it's basically an index of data sets of all these different locations and so i would recommend that

00:28:14off main lati how how can a data analyst work remotely um you can definitely work remote

00:28:22because uh it's all internet based and you can do zoom meetings and that's how a lot of companies did

00:28:26it and that's how i did it for the last two years of my like full-time data analyst career

00:28:30now when i do

00:28:31consulting or do anything else i just do it remote i don't really go to anybody but you have a

00:28:35computer

00:28:35they'll usually send you a computer um and then they'll set it up for you you get all the software

00:28:40you need and then you can you know talk to people message people in teams or slack or whatever chat

00:28:46they

00:28:46use give me one second i get some water

00:28:53war daddy

00:28:55interesting name uh do you play the guitar yes i do play the guitar

00:28:59um i actually have a song on my youtube channel somewhere

00:29:04i think it's called the truth about my job

00:29:08song you can look that up it's a cool song i like it i still

00:29:12like that tune i play that tune every so often

00:29:16let me keep going

00:29:20sd i love the courses on cloud aws and azure and etl those are uh yeah those are great courses

00:29:27i i enjoyed

00:29:29making them but are there any plans for dbt um maybe in the future maybe in the future

00:29:38that's not a top priority of mine i have other courses already lined up

00:29:41so no probably not in the near future maybe next year

00:29:47let's see

00:29:52hi kiteswa michael good day and thanks for your video i'm new to tech and data analysis i'm in

00:29:58your second video on excel formulas in excel how do i get the data there should be a link in

00:30:02the

00:30:02description either in that video or the one previous to it i can't remember but there should

00:30:06be a link in that video to a github and you're going to go to github you're going to

00:30:09download the raw file that's how you do it download the raw file

00:30:14let's see

00:30:18what is the easiest cloud service to learn off main lottie i remember that name

00:30:23what's the easiest cloud service to learn that's a great question i've used all of them

00:30:27i've used well not okay let me hear you i've used the big three google cloud platform aws and

00:30:32azure i've used them all um in workplace environments so it's not just like personal

00:30:36testing i personally think azure is the easiest to learn i actually think azure or sorry aws is the

00:30:44hardest to learn aws is so confusing it took me a while to kind of get the hang of it

00:30:48azure came

00:30:49pretty naturally i feel like it has a better ui better flow a better way to get access to things

00:30:54um it doesn't mean that azure is the best i think they genuinely they both have their trade-offs

00:31:01some things azure excels in something aws excels in i don't like google cloud platform for anything

00:31:07it's garbage uh they do people still use it and i'm sure there's use cases for it but i never

00:31:13found

00:31:13any i never liked google cloud platform and people get mad at me for that but i'm telling you i

00:31:17just

00:31:18nothing vibe with me with google cloud platform i didn't like i didn't like anything it's just gonna

00:31:23become a gcp bashing session for me um yeah didn't like it won't use it again um ghost daddy what's

00:31:34up bro what's up bro uh hamza rayad your website is really useful thank you thank you i'm gonna be

00:31:41giving out some free courses at the end so stick around if you want a free course um precious said

00:31:48your uh precious we're just chatting your channel has really helped me date now so far i got to know

00:31:53about it two weeks ago and it's been very helpful i'm really glad to hear that emil

00:32:01kajkus kajkus hi how to deal with complex sql query with multiple joins and conditions what is

00:32:06your approach all right um back in the day i was working on a team with data engineers and data

00:32:12scientists and they were making some of the most complex system it was it was it was in store

00:32:19procedures it'd be etls it'd be temp tables it'd be creating views it would be data cleaning all in one

00:32:26long script it was really impressive but i was very intimidated um as i got along i talked to some

00:32:33people there's a guy named jd on my team who i worked with a lot he helped me a lot

00:32:37with kind of

00:32:37the more complex stuff um what i learned to do is to break it down you have to take this

00:32:45really

00:32:45complex query and sometimes ai will do that too they'll give you this really complex query and it

00:32:50works but then you try to adjust it for this other use case and it doesn't work and then ai

00:32:55can't

00:32:55really refactor and change the code how you're wanting it to do so you have to do yourself we're

00:32:59living in a world where you still have to do things yourself after you so often emil i'm glad you're

00:33:04asking this question what i used to do is i used to comment out things that i knew i could

00:33:08comment

00:33:09out and then run it and see what breaks so then in this in the you know you can see

00:33:14when you start

00:33:14making these joins you're going to use some type of you know uh the table name dot the the field

00:33:20name

00:33:21and i would start commenting those out and then i would break it down from okay now let's see what

00:33:26we're grouping on and then i would break it into the group by and so i would break it down

00:33:29by the query

00:33:30to to start seeing how it's working why it's working this way and and really understand it

00:33:36and so then you start adjusting the kind of the conditions that you're putting in there maybe in

00:33:42your where statement you're having statement and you're adjusting and you kind of see how it's getting

00:33:47to it because i'll tell you one of the biggest things i've seen especially with you know i'm just

00:33:54going to say in general but i've used in editors that do english to sequel is that they don't get

00:34:01the nuances of the data correct is you'll say hey i want it from july 1st through july 31st i

00:34:08want

00:34:08that range in my dates and they'll do that but then your date has a time stamp so they try

00:34:14to create a

00:34:14time stamp but the time stamp is off right or it's not formatted correctly or your data is formatted in

00:34:19a

00:34:20specific way and then you have to reform so it's all these little nuances of the data that the ai

00:34:24just right now just doesn't under won't get and won't understand you understand it so you have to

00:34:28really break that down it's it's just um you really have to break it down derrick hodgson gave me five

00:34:36bucks you didn't have to do that i appreciate it thank you for all you do you didn't even ask

00:34:40a

00:34:40question thank you derrick i appreciate you don't have to do that no you don't nobody has to donate

00:34:44anything this is you know but i do appreciate when you do maybe i'll go buy two big five for

00:34:50fives

00:34:51or six dollar biggie bags at wendy's wendy needs to sponsor the channel at this point i talk about

00:34:56them a lot um all right this is an interesting question i haven't read the whole thing yet but

00:35:02i saw olap and olap and olap so i'm going to read it live derrick arnold i remember you from

00:35:08earlier

00:35:09my company struggles to uh prioritize creating an olap system we currently generate analytics

00:35:16from oltp system and it regularly impacts production how would you approach solving this challenge um

00:35:24that's a good question um honestly there's so many factors that i can think of off the top of my

00:35:33head

00:35:33that would impact that uh so i'm not i i this is one that this is one that i could

00:35:39probably talk i

00:35:39could make a whole video on um oltp versus olap but how to solve that specific problem if your company

00:35:46doesn't do it i don't know i don't know off the top of my head i'd have to think about

00:35:51that i i could

00:35:52definitely yeah that's a just an interesting question on how how the data is collected um

00:36:02it just depends on how much data you have where you're storing the data if uh down below how much

00:36:07time do we have oh it's almost 9 30 so we have halfway down below give me some more details

00:36:12on

00:36:12that i might be able to give you an answer for that but right now just off the top of

00:36:15my head i

00:36:15can't because there's too many factors going on in my head um maduri chan don botway i'm sorry i

00:36:26can't pronounce your guys's name i'm just that's not my forte but um she or he said hi alex five

00:36:32types of analysis can you make a video on it like descriptive and diagnosis diagnostic and all those

00:36:37different types yes i should make a video on that that'd be really good

00:36:43all right matthew asked a good question i've gone from an individual contributor to managing a small

00:36:49team i still struggle with zooming out and not living in the weeds any tips on working from a

00:36:55zoomed out perspective all right so this is something that um i've had to do more and more

00:37:02as my career went along when i was an individual contributor like yourself um you're in the weeds

00:37:08you're figuring out all the tiny details and everything like that and it's really um tough

00:37:13when you go to managing you cannot be in that same headspace as i have to be in the weeds

00:37:19and know

00:37:20the details of everything we're doing with every project it's impossible you'll get overwhelmed you'll

00:37:24get burnt out that's somewhat what happened to me um i just was two in the weeds and i got

00:37:30kind of

00:37:30burnt out being a people manager people managing is very tough and now i run a business where

00:37:38we have like 10 employees or maybe it's like 10 to 11 12 employees depending on the time of the

00:37:43year

00:37:43when we pull in an extra i can't be involved that much i have too much on my plate and

00:37:49so what you have

00:37:49to do is you have to delegate and delegation is very difficult for someone like me who really enjoys

00:37:56the coding and i enjoy uh building i enjoy those things and i don't want to not be able to

00:38:02do that

00:38:03and so it's really tough for me but what i would say is delegation has been the number one thing

00:38:07that i've done with delegation though you have to have a good team you have to people you trust

00:38:14people who understand your vision people who know what they're doing if you don't you have to get rid

00:38:18of them and that is so tough for my first fire when i first fired somebody i i really had

00:38:25to i did not

00:38:26want to um but it was a very good decision because we brought someone in who had a lot more

00:38:31experience

00:38:31and who did their job better and that took so much pressure off of me so that is kind of

00:38:38what

00:38:38you need to do you need to see are these people i can work with are these people that can

00:38:42get the job

00:38:43done if they're not you have to get rid of them it's a business decision it's not a personal decision

00:38:47that's the toughest thing um ma do you think ai agents will end junior data analysis um give me one

00:38:58second i'm gonna get some water i don't so i don't think the term junior data analyst is going to

00:39:07leave but requirements will change as they have for the past 10 15 years um i think personally that

00:39:18junior data analysts will always be around because from a business perspective they want a lower title

00:39:23they weren't going to get rid of the title and go straight to a senior for example you're not

00:39:27going to have everyone on your team be a senior because then you have to pay everyone more that's

00:39:30just how it would work so the junior title will stick around and they will hire junior data analysts

00:39:37what i think will change is and it has 10 years ago a junior data analyst just needed sql now

00:39:45you need

00:39:45sql and excel on the cloud platform now the the things change and so ai is going to be something

00:39:50that

00:39:50i don't think replaces junior data analysts they're just going to be interfacing more with ai in the

00:39:55future um it's not happening now like if you look at most companies uh most small medium-sized

00:40:02companies not a lot of them are using ai um a lot of big tech companies are using them because

00:40:08they're

00:40:08creating them they're you they're you know trying to keep up with everything and they're trying to

00:40:13stay ahead of their competitors small medium-sized companies aren't using a lot of ai some are but not

00:40:19a lot and uh i saw someone donate give me a second i'll i'll get that just after this one

00:40:24so i think

00:40:25the the the requirements will change for due to data analysts so you'll just need to know more

00:40:31in my opinion and i think that's been a trend for a long time right is in 2008 if you

00:40:37knew the basics of

00:40:38like excel and sql you could get a job as a data analyst you know when i started it was

00:40:42like excel

00:40:43sql tableau and that's about it and now i think adding a cloud platform and some ai skills is kind

00:40:49of like you know becoming a requirement as well so it's just you know it changes things

00:40:57matthew matthew stop i will see you in the chat you don't have to donate thank you i appreciate them

00:41:04something i've also found is that i'm no longer doing the cool stuff and just doing more admin type

00:41:09work removing blockers getting clarification etc is this something you experienced also

00:41:13yes if you i don't know if you maybe you have watched this video but i made a whole video

00:41:17on

00:41:18why i quit being quit my manager job and that was the number one thing that i said

00:41:24is that i went from this individual contributor where i was a i would consider myself pretty a

00:41:28great person on the team for technical skills and expertise and i was like i was well i was like

00:41:35the

00:41:36team lead for data analysis on my team and then i went to a manager and i don't didn't

00:41:43get to dig into things anymore i didn't get to build things anymore i didn't get to talk to my

00:41:48data engineers and figure out complex stuff anymore and i realized very quickly management

00:41:52was not my thing now that's me maybe it's not you but i love building and that's what i get

00:41:58to do

00:41:58all the time with my work now and i i missed it for like that year and a little bit

00:42:02of change

00:42:02i missed building so much i was building in a different way but it wasn't i didn't enjoy it that

00:42:08much and what i was doing was more people work right i was figuring out contracts i was figuring

00:42:13out payroll i was figuring out our budget for the next quarter and these things were extremely boring

00:42:19to me i did not enjoy it um and so i don't know if that's what you're exactly experiencing but

00:42:26you

00:42:27know maybe if you're like me and you just really want to build being a manager is not really the

00:42:33best

00:42:33place for us um it just isn't so you know take that with a grain of salt apply it to

00:42:41your own

00:42:41scenario don't quit your job because i told you so or i don't just don't don't do that but um

00:42:49animals life is your data analyst boot oh sorry oh wait no i got to matthew's thing i thought i

00:42:54was

00:42:54i thought i forgot i missed it wormhole really quick said love your content i love you

00:43:01animals life is your data analyst boot camp 2022 still worth doing in 2025 100 not much has changed

00:43:10not much has changed um i need to add like an ai section in there that i might re-release

00:43:17and i

00:43:17have an r series coming out i have a git and github series coming i'm in the middle of the

00:43:22r and r

00:43:23um series now but then my git and github series will come out after that i'm going to add those

00:43:29things to the uh another video make a longer one it'll be like 28 29 hours um but yes all

00:43:35that

00:43:35content that's in there is still good oh matthew just said animals life stop spamming uh-oh and then

00:43:42i answered his question i'm not doing that again not happening animals life you're cut off i'm just

00:43:49kidding unless matthew blocks you and then you really are cut off taki blocking people over here

00:43:55appreciate it thank you that's and i i don't know what that person was spamming but i believe

00:43:59that ab kumar was spamming itaki is blocking them all right let's keep going we got about

00:44:0725 more minutes and then we're going to do a giveaway for um my platform for learning data

00:44:13analysis which is analyst builder by the way this is a shameless plug if you go into the description

00:44:18right now you can get one month for free you could probably take a course or maybe two if you

00:44:24really

00:44:24really focus for free and if you like it keep using it if you don't stop your subscription it's

00:44:29as easy as that but you can use it for free go in the description if you that's only for

00:44:34new users

00:44:35though i am sorry that's only for new people who've never bought anything on the platform

00:44:39if you have there's a code for 35 off anything on the platform even the lifetime subscription 35 off

00:44:46so just a little plug shameless plug

00:44:49does not impact by the way me having that does not impact my views on anything i'll tell you straight

00:44:55up if i don't have something or if i think something's better somewhere else

00:44:59all right i'm reading through questions give me a sec

00:45:09elizabeth nalule nalule hi alex i have a master's in statistics and would like to be a healthcare

00:45:16analyst i don't have any experience in healthcare so i've been difficult to even get an entry-level

00:45:21job what should i do statistics is a really interesting background so this is heavily used

00:45:27in data analysis um i actually worked with a lot of statistician statisticians back when i worked

00:45:34at amerisource bergen we have a whole i was under a data science umbrella but it was under the healthcare

00:45:39so we were specifically oncology hematology it was um a specialty pharmacy solutions that's what the

00:45:46the uh business part of the company i was in we had a data science team we had data scientists

00:45:52data engineers data analysts business analysts statisticians um we had nurses and doctors on our team

00:45:59very unique um if you apply to a company a larger company that has a lot of different

00:46:08uh a lot of employees let's just say even 500 employees or more there are gonna be different

00:46:14business parts of that company so in healthcare for example um when i was working in the it's

00:46:21consera now but it used to be amerisource bergen amerisource bergen i could have worked at like

00:46:25six different departments within that company because they all were focused on healthcare but

00:46:29a different niche and a different business side of things and i didn't realize that until i got in it

00:46:33and so for a statistician a statistician like you trying to get into healthcare there are going to be

00:46:37business departments within that business that really value statistics for example my um my data

00:46:45science team really valued statistics we had statisticians on the team but there were other

00:46:49departments where they were very low level just healthcare focused only no no statistics almost

00:46:54you know very little statistics it was like claims data not things that needs as much statistics so what

00:47:01i would say is

00:47:06even if you're applying to jobs i would actually look in those companies and find specific departments

00:47:12within that company to try to reach out to those people specifically so i was getting distracted with the

00:47:17now i got an itchy nose i'm just all over the place my mind's going very quickly that's what i

00:47:22would

00:47:22recommend but a master's in statistics is very valuable uh so you just need to find something that

00:47:29values it and if in order to find it you kind of have to dig in this is the difficult

00:47:34part um is is

00:47:36finding a department within a company that you like and then finding out how to reach out to them

00:47:41but it would be worth it also work with a recruiter recruiters love people with master's degree

00:47:45because they're easier to place at companies so recruiters peace casa can a data analyst be a data

00:47:52engineer and is that an advancement in his career uh it could be depends on what you mean by

00:47:58advancement so data data engineers typically make a little bit more money maybe about 10 percent

00:48:0320 to 20 percent more um especially it's the the gap widens a little bit or sorry the gap is

00:48:11wider at

00:48:11the beginning whereas later on it usually kind of closes that gap a little bit maybe it's only like

00:48:17a 10 percent difference um but data engineering is much more technical you're going to be doing a lot

00:48:24more technical work and that's usually why um it demands a little bit of higher pay data analysts can go

00:48:30as far as a data engineer can go career advancement wise you can do junior in both mid-level um

00:48:37senior

00:48:38lead or tech lead or whatever you'd want and then management if you'd like to go that way

00:48:44engineering just typically makes a little bit more money is it an isn't an advancement for some it will

00:48:50be for others it won't um you know i've known people who just love analytics and they hate engineering

00:48:57and that's not going to be an advancement to them they love the the figuring things out and decision

00:49:02making and all these different things whereas data engineers typically aren't making as many decisions

00:49:06they're just building a lot of things that people who tell them what to build do for the most part

00:49:12not always depends on the team but uh yeah i would just look at it as like is that something

00:49:16you really

00:49:16enjoy you really want to do um you have the skills for and then go from there

00:49:25oku richard owusu hi alex i'm richard a chemical engineering graduate uh congratulations currently

00:49:33learning data analytics how can this skill benefit my career and what steps should i take to enter the

00:49:38field with my background i i didn't read that question before i don't know much about chemical

00:49:43engineering honestly um so i don't have a ton of advice for you i'm sorry i if i knew more

00:49:50about

00:49:50chemical engineering i would definitely let you know i just don't so i'm sorry all right oh i'm oh

00:49:57jeez i thought i was nearing the bottom and then it skipped down and i wasn't nearing the bottom at

00:50:00all

00:50:04um geez let me go uh let me go back up

00:50:14um

00:50:17let's see i scooched down in my chair actually scooch

00:50:20up oh man sitting is tough sitting is tough i i kid um all right we got about 20 more

00:50:28minutes

00:50:28then we'll do a giveaway joe sarah said what is the most important skills for an entry-level data

00:50:35analyst job i only know excel and beginner level sql so i would say you have the very very basics

00:50:41very basics and there may even so i look at it as like percentages i've always looked at it like

00:50:46this

00:50:47so if you look at the whole of data analysis and you look at what jobs would you be able

00:50:53to apply for

00:50:54with just excel and sql it's going to be like like 10 5 10 of jobs because there are jobs

00:51:00out there that

00:51:01only require excel and sql that's it and they want some domain knowledge that's all they are looking

00:51:04for maybe 15 let's say then you're going to learn some more skills you're going to learn the

00:51:11learn more sql first off you're going to need to learn more sort of like intermediate level but then

00:51:16you're going to learn some tableau power bi poop poop python poop r poop aws and azure poop a little

00:51:24bit of ai skills poop now you're now you've opened yourself up to like 50 of jobs those are the

00:51:30core

00:51:30skills for most like the majority so let's say 55 to get a majority those are the core skills in

00:51:37every

00:51:37company though there's so there's thousands of tiny little tools out there third-party software

00:51:45startup tools that company just took on that you're never going to learn you don't know what

00:51:51chimmy is chimmy is this new tool i just made it up chimmy is this new tool that this company

00:51:56is using

00:51:56and they understand that nobody knows that tool so they're looking for someone with the basics who

00:52:01can learn chimmy quickly right so look at it like that so i would learn those skills in the data

00:52:06analyst boot camp or go on analyst builder learn those skills and then put that on your resume you're

00:52:11going to give yourself a higher percentage chance of jobs you can apply for a larger area of jobs

00:52:16you can apply for and actually potentially get an interview so if you just have excel and sql you're

00:52:21only going to get an interview for very little or have an ability to even get an interview but as

00:52:26you

00:52:26open yourself up to more then that's that's really good um and let's keep going

00:52:39is dsa important for data analysts what is dsa i'm data data science i can't remember what dsa is

00:52:47i i need i need words acronyms i can sometimes forget i can sometimes forget oh yeah taki said erica

00:52:56what is dsa thanks taki i appreciate it that was a good question if i read it down below then

00:53:04i will

00:53:05answer that

00:53:09derek it's complicated here we go so this is a question from earlier he's asking about ltp versus

00:53:15olap uh it's complicated for one example we have a massive sequel table tens of billions of rows oh that's

00:53:23interesting that can cause rollback segment length growth aws when queried we work around by querying

00:53:30hourly intervals what data okay now i have even more questions what data are you working with where

00:53:37you have one sequel table that is tens of billions of rows that is not some someone is messing up

00:53:44there

00:53:45um database some type of data architect data engineer is severely causing a bloated table you

00:53:54need to segment that table by anything you and if that's if it's that big you need to be indexing

00:54:02it

00:54:02there's so many things you can be doing to optimize that just actually that probably isn't even an

00:54:07oltp issue or an olap issue that sounds like a database issue a genuinely you need to you

00:54:14so here's the issue here's what happens when you let's take transactional data or maybe you're

00:54:19you're uh putting in log data which is thousands a day hundreds of thousands a day if you try to

00:54:26store that log data you try to store those transaction data and you're storing all these things

00:54:30tables get bloated and then if you don't index them correctly if you don't store it correctly

00:54:34it gets bogged down by the heaps and billions of rows of data that's too much

00:54:40it's too much so you need to do several things one is you can segment that data and yes you're

00:54:47going to have more tables but you can put that it you can store that 10 times more a hundred

00:54:54times

00:54:55more efficiently so look at uh this could be something that you could do that could really

00:54:59impress whoever is in charge of that look into this issue um dig into the little bit because i

00:55:05don't know again i don't know everything of where you're storing it how you're storing it what the

00:55:08data is but give me more information later on because i am interested i may have more insight

00:55:13but that seems like a database management issue storing the data inefficiently will cause so many

00:55:20issues so look into that or or give me more information down below and i'll give you more

00:55:27some because the more i know now the more curious i am i really am all right we got about

00:55:3115 13 more

00:55:33minutes or so so i'll keep going until then uh matthew said i still get to trial new tech

00:55:41but i really do like managing people okay that's good getting them to have the light bulb moments

00:55:45are super rewarding so that you know that may be something that you enjoy i would just try to get

00:55:51out of the weeds try to enable your your people more and even maybe stop helping them and say hey

00:55:59listen i would love to help you but this is something that i know you can figure out

00:56:03if you need a brain you know during our weekly and you can't something figure something out but

00:56:07during our weekly call then during our weekly call bring that up and we'll brainstorm it but

00:56:12this needs to be a less frequent thing for you

00:56:17um ved patel how much important python various library like numpy panda seaborne and metplotlib

00:56:25to data analytics all right uh hey great your english is getting there you're doing really

00:56:32good i totally understood what you were saying how important are these different things within

00:56:37python to learn for data analytics um they're very important if you're going to learn use python

00:56:42for a data analysis you don't want to use base python that would be rewriting it's like starting

00:56:49building a a car from wood and stone uh rocks for the wheels

00:56:59numpy matplotlib seaborne uh pandas polars were designed and built by very smart people some of whom

00:57:08i've met i met the guy who made pandas um shout out to posit for that creator meetup um posit

00:57:15they hire the guy who literally built pandas these libraries were designed and built for speed

00:57:22and efficiency and to simplify these things so highly recommend learning them

00:57:30oh black tempo hi alex i'm working on standardizing our plumbing company's operations and we're using

00:57:38epic core solar eclipse pdw never heard of it any advice on how to start implementing standard

00:57:44procedures across workflows and data oh that's a big question that's a big question so i'm just

00:57:53going to give you some generic stuff there's a lot more that could go into this a lot more

00:58:00so if you are starting maybe it maybe and again there's more to this i don't know all the

00:58:06information but let's say you're starting up a new data collection data workflow uh procedural

00:58:13stuff across your company who's never done it before in this scenario they've never done that

00:58:17stuff before you are going to need to create and i'm not just i'm not just saying this you need

00:58:24to create some type of processes and procedures processes and procedures you have to outline

00:58:32here's what needs to happen once you you figure it out first then you you write it because what's

00:58:37going to happen is is other people are going to come in maybe you hire someone else other teams

00:58:42are going to start using this and they're not going to follow the processes and procedures and then

00:58:46their stuff is going to be completely messed up and you're like did you follow the processes and

00:58:50procedures here's how to store the data here's where the data goes here's how you need to do your

00:58:55nightly runs here's how the workflows need to flow so that you have clean data it's very complex

00:59:00very complicated but create process and procedures um you know you need to figure the the process or

00:59:07the uh work flows out first though in my opinion um xyz thank you for the donation you didn't have

00:59:15to do that but i'll read yours because you did uh hi alex i'm a third year bba student in

00:59:20india

00:59:21i want to be a business analyst what skills should i focus on um i would focus the and and

00:59:27i say this

00:59:28all the time and i really do mean this is that i think you should focus on the basics focus

00:59:36on the

00:59:36basis of excel sql tableau or power bi a cloud platform i recommend azure and aws you can choose

00:59:44one but i like both um learn a little bit of python maybe if you're feeling up to it or

00:59:52r if you're

00:59:52feeling up to you don't have to um but then learn some ai how to interface with you know using

00:59:58these

00:59:59tools how to you know create some prompts to to help it do basic things um that's what i would

01:00:06be

01:00:06doing that's what i would be doing those are the skills that i'd be focusing on how do you handle

01:00:11data cleaning this is a m a a manual how do you handle data cleaning data cleaning is like my

01:00:16specialty

01:00:17i love data i actually really do enjoy data cleaning um i used to be on a data cleaning team

01:00:22that's what i did i was a data analyst on a data cleaning team and data cleaning is a process

01:00:29it's

01:00:29a never-ending cycle even when you clean something you come back to it and i actually have lots of

01:00:34videos on data cleaning on my youtube channel so go and check it out how i handle data cleaning though

01:00:41is we would get the raw data from the clients they would hopefully send a data dictionary or some type

01:00:46of uh outline of what the data looks like and then i go back to them with initial questions

01:00:53i would say okay i see this data in this column how do you guys collect that uh sorry i

01:01:00said that

01:01:00wrong earlier i was on a data collection team we collected data from a bunch of ehrs hospitals all

01:01:05this stuff and then i what we cleaned the data but we were a data collection team not data cleaning

01:01:09team data collection team um and then i was sort of asking questions how did this data get collected

01:01:15what is you know i would start querying the data and find inconsistencies and i would say hey

01:01:20why does the data look like this and they would say oh that's because you know in that column we

01:01:25actually in our database we have or when somebody inputs the data we actually have two options i would

01:01:30say why do you have two options they would say oh well it's a legacy system and so we took

01:01:34that over

01:01:34from a previous system so there's historical data from this date backward and i would say oh that's good

01:01:39to know right nuances tiny nuances but maybe they wanted to keep that maybe historically they want

01:01:46to keep that like that so they know when they used to do that instead of standardizing it maybe i

01:01:51don't

01:01:51know that's how you go about data cleaning and then you process it and you try to figure out how

01:01:55are we

01:01:56going to use this data and then you transform it and you create automations around that it's a lot of

01:02:01work i love data cleaning it's a lot of work excuse me

01:02:12rachid bahami just started your boot camp any tips first off that's fantastic that boot camp is

01:02:20genuinely if i had to put a price tag on it from like five years ago five years ago there

01:02:25were

01:02:25companies that would charge a thousand dollars for that boot camp today um because of channels

01:02:32like mine and other channels who have helped make it more possible to get free education

01:02:37and there's a lot more right it's not just me i'm not trying to pat myself on the back but

01:02:41channels who do that kind of stuff they've driven the price down which has been great i'm very happy

01:02:46about that now i put it like a value of like a couple hundred bucks 200 bucks um but my

01:02:52anyways that

01:02:53was a just a side note i just thought of it i don't know why tips my tips are

01:03:01try different things as you're doing it you're going to follow along with me exactly and get my

01:03:06exact output and that's fine that's great but then think what if i wrote this let me try that out

01:03:13and

01:03:13you try to write it maybe it'll work and that's great and you learn something or maybe it didn't work

01:03:17and you have to go and google it or ai it if that's a verb and then you figure it

01:03:24out and you've learned

01:03:25more than what my boot camp had to offer and that is where you need to what you need to

01:03:29do then let's

01:03:30say you get through the whole my sequel portion beginner intermediate and advanced you get through

01:03:34that my sequel portion at the end there's going to be projects and you build those projects and then

01:03:38try to build your own projects when you build your own you have your own questions that really makes

01:03:43forces you to use those skills and you learn them 10 times better i assure you that's my it's my

01:03:48advice

01:03:55just reading through some questions some of these i've already uh i've already answered so i'm skipping

01:03:59some all right let's see joe saris where should i start learning beginner ai and cloud for an entry-level

01:04:10data analyst job um so i mean honestly for ai i don't think the bar is very high for using

01:04:20ai for

01:04:20most companies the bar is very low i would just mess around with claude and gemini and chat gbt

01:04:26plug in some data ask it questions ask it follow-up questions see where it fails plug in the plug

01:04:32in

01:04:32the queries into your database that's the kind of stuff that i'd be doing not anything crazy for cloud

01:04:37platforms i have a full series on aws and azure for free on my youtube channel honestly that's all

01:04:44you need if you want to go more advanced oops sorry i hit my mic if you want to go

01:04:49more advanced i have

01:04:50a full course on azure and aws on analystbuilder.com that's genuinely i would recommend it goes more in

01:04:56depth more automations and more advanced things i've looked at other tools out there other courses

01:05:02out there they're pretty good um so if you find one that you like better you vibe with better then

01:05:05go

01:05:05take that one but i didn't find one where i was like i would recommend it or man i really

01:05:11need to

01:05:11make my course a lot better because this one's way better i haven't found that yet there weren't a lot

01:05:14on aws and azure that i could find um let's see

01:05:25all right i've i've ever answered some of these questions before if i didn't answer your question

01:05:30i'm kind of skipping it you wouldn't know but go back and watch the live stream um because the live

01:05:34stream will have other you know we'll have other things in it by the way we have about

01:05:38three minutes i'm gonna answer just a few more questions then i'll do the giveaway

01:05:42and then we'll get out of here and then we'll have our live stream next thursday

01:05:47y'all like i'm starting your data analyst course what are you saying to me i don't know i don't

01:05:52know

01:05:52what that means i don't know what i'm saying to you oh i almost got to the bottom this is

01:05:56great

01:05:58um

01:06:01what's a data life cycle that's a good question town of promise what's a data life cycle in a

01:06:08sequential manner so typically it's data ingestion so you're connecting creating some type of connector

01:06:14to a data source whether it's an ehr system financial system database uh a spreadsheet excel file

01:06:21doesn't matter or csv file you're gonna connect to that data source you're gonna pull that data in

01:06:26when that data gets pulled in you have to then process that data because maybe how it's sitting

01:06:32or how it's formatted how it gets pulled in how it was sitting in the source table or how it

01:06:36got

01:06:36you know there's so many factors but you need to format that correctly then you want to uh uh so

01:06:43that's just a small part of data cleaning then you need to transform that data you have to have an

01:06:46end goal in mind what am i doing with this data is it a report is it a dashboard is

01:06:53it a live stream

01:06:54is it an api access for a client who knows you need to transform it to what it fits what

01:06:59what makes

01:07:00sense for that data then once you do all of that you need to go back you need to validate

01:07:07your data

01:07:07then you need to um create automations to do that whole process and then once it's done and it's

01:07:15working you need to have some type of monitoring system that checks the output and the data pipeline

01:07:23or the process that you created to make sure that that data is streaming flowing being brought in

01:07:28whatever process you have correctly because it's going to break and then a client is going to say hey

01:07:34for three weeks it's been broken why didn't you fix this and you're going to say whoops i didn't

01:07:38know didn't know it was broken until a client brings it up and that's not what you want so that's

01:07:43what i

01:07:43would do matthew lay down the hammer he's like guys please don't spam he's asking nice don't make

01:07:52matthew angry taki's over here deleting people left and right no spamming no spamming um if i get to your

01:08:00question good but wait like a few minutes because there's a delay and then i'm up in the chat and

01:08:04so

01:08:05you know don't spam spam guys i'll answer one last question and then we'll go into a giveaway and i'm

01:08:11just gonna i'm just gonna give away courses um real quick for the giveaways you do need to go into

01:08:18analystboulder.com and have an account you're gonna need to go to the pricing page select a course to

01:08:23buy you don't have to buy it i don't want anyone to buy a course i genuinely don't want anyone

01:08:27to buy

01:08:27any course but then there's an apply coupon code i'm gonna create a coupon code and you're gonna

01:08:33input it so i'm doing that in a few minutes so if you want to go ahead and um go

01:08:39ahead and create

01:08:39your account now if you want to i'm looking at questions i'm gonna do one more what i use snow

01:08:48i'll answer two more this is the easy one would you use snowflake or bigquery snowflake don't like

01:08:53bigquery all right this is our last question um

01:09:05niche or nick hi alex what is a typical day of a junior data analyst in work

01:09:12so there are levels right you have your junior you have your mid you have your senior your tech

01:09:17oh give me a second okay my wife's texting me i'm going to read it once she i'm gonna say

01:09:25i'm

01:09:25just gonna tell her go for it um but um oh i think i know what she's gonna do i

01:09:34think i know what she's

01:09:34gonna do anyways um be be prepared i have i have a feeling she's gonna come in here in a

01:09:39second that's

01:09:40my guess but a junior day analyst is going to you're there mostly to learn and do small low level

01:09:47tasks and understand the business better and learn that's what you're genuinely there for for the most

01:09:52part so what's going to happen is you're going to go in and your manager your mid-level analyst

01:09:57senior level analyst they're going to start handing small tasks to you they're going to say hey here's

01:10:03what uh you need to be working on here's what the client needs and you're going to go and do

01:10:06that

01:10:07you're not going to ask a ton of questions you're not going to be able to really understand it crazy

01:10:11in depth in order to get to that next level what you're going to do is you're going to have

01:10:14to start

01:10:15asking more questions learn the business more understand what the clients need what they don't

01:10:19need these are things that you'll need to start thinking and doing to get to the next level but

01:10:25junior day analyst you know the walk-in sequel excel maybe make a dashboard but then they'll have to

01:10:29get most things approved by someone higher up first before you can bring it to a client or show it

01:10:34to

01:10:34somebody now i one second baby i think my wife's coming up here uh i'm i'm gonna ask her something

01:10:56i think she's uh i think she's gonna do something

01:11:01i don't know if she's hearing that all right um so now we're gonna do the giveaway

01:11:07the giveaway is very simple i'm going to create a code i haven't created it yet i learned my lesson

01:11:13people were guessing the codes that i was creating before the live stream started or during the live

01:11:21stream they were guessing it because they know me they watch too many of my videos

01:11:25oh my goodness so here's what you need to do go to analystbuilder.com create an account if you

01:11:32don't have one go to the pricing page and go to the courses let me make sure i'm i'm saying

01:11:37everything

01:11:38accurately go to the no no don't go to the courses go to pricing

01:11:46go to courses all of my courses are there click on one to buy you don't have to buy it

01:11:52i don't want

01:11:53you to buy it if you buy it go to your purchases and just get a refund but go to

01:11:57the one you want

01:11:57say i want microsoft power bi i'm going to click buy it's going to take you to a checkout where

01:12:02there

01:12:03can be an apply code i'm going to give you a code if you were the first person to redeem

01:12:08that code

01:12:09you'll get it for free if not it'll just give you an error then don't have to buy it just

01:12:12click

01:12:13apply coupon and then you'd have to use the coupon before anyone else i'm just all right

01:12:18give me a second um

01:12:30give me one sec

01:12:38um

01:12:39i thought she was talking about something totally different

01:12:44um but anyways that gave us time for you guys to do that to get set up

01:12:48all right you should be on

01:12:51you should be on it

01:12:54all right here's what we're going to do i'm going to create a code right now live

01:12:58it's only going to be redeemed by one person

01:13:01then i'll make two other ones that two people can redeem

01:13:03so you have more chances to win so here we go

01:13:07are we ready are we are we

01:13:09am i i don't know

01:13:14um

01:13:14oh oh sad

01:13:18um we got a new dog her name's penny she's a mini dachshund she's like that big

01:13:24um and i wanted my wife to bring her in

01:13:27and she said she couldn't right now she was busy she was doing something

01:13:30so sorry you guys won't get to see penny all right guys

01:13:33you guys i'm about to give you a code i haven't created the code i know you're already trying

01:13:37them some of you guys are like trying things like asparagus and pepper and whatnot it's not correct

01:13:44all right um

01:13:48i wonder if i can do numbers give me a sec

01:13:53all right the code is 175 175 no spaces no letters 175 because there was 175 people watching

01:14:03at the time um if you just joined i'm doing a free giveaway on analyst builder.com

01:14:09you can apply the code 175 only one person is getting this one i'm going to give

01:14:14two more codes away they have two redemptions so two more codes coming true

01:14:20are coming true two more codes coming soon let me see if someone

01:14:27has redeemed it already someone got it like i get to see i can see on the back end who

01:14:33redeems

01:14:33it by the way very nice very nice

01:14:39i think it's someone yep i'm not gonna say the name i'm not gonna say your name but congratulations

01:14:45if you got it put in the chat that you got it and tell me what course you got because

01:14:48i am just from

01:14:50like a whole perspective um yeah yeah i didn't want to say it but nick got it he's in the

01:14:58chat i

01:14:58see him he has i asked one of his questions earlier awesome awesome awesome um but congrats

01:15:05on the course let me know what course you uh what course you got i'm about to give two more

01:15:10codes out

01:15:11these next two codes are each going to have two winners right or two people who can redeem them

01:15:16so i'm gonna add a code i'm gonna say two people can redeem this one

01:15:25there we go now i just need to create the code create the code oh maybe someone else uh

01:15:34maybe someone else got it pandas for data analysis that's what i chose awesome

01:15:38pandas for data analysis that's a great course that's a very that was probably one of my favorite

01:15:44projects of courses like at the end we build these really cool projects with really

01:15:49great data visualization um that i just loved i love the projects at the end of that

01:15:57all right i'm about to give out a code here's the next code be sure to just you have to

01:16:01click

01:16:02on the course you don't have to buy it it just says buy but get ready to apply the code

01:16:06and then you will get it okay so apply the code so here we go um

01:16:17all right this next code i just added it the code is christine christine was texting me a lot during

01:16:24this live stream just being helpful she's doing great i'm proud of her i love her i hope she's

01:16:30listening the code is christine two people you have to spell christine correctly it's all caps

01:16:37christine um if you type in christine as the code you apply and you it says good and you buy

01:16:46then you will get it fantastic if you act this has happened once or twice if you accidentally buy a

01:16:53course just go to your purchases click refund there's it's no questions asked you don't even

01:16:59have to ask me just go refund it if you accidentally buy it i'm sorry i don't i don't

01:17:03want you to i don't want you to buy it if you try to redeem it and you get some

01:17:07error message it

01:17:08means someone else already got it that's just what it means someone else already got it all right

01:17:14two people got that one if you want it let me know what you got i see uh two people

01:17:22in here

01:17:23who are redeeming i see the names i won't say it unless you put your you put it down below

01:17:29but i got

01:17:30two people all right i'm giving out if you already won one by the way don't try to get another

01:17:35one let

01:17:36someone else win that's not cool let someone else win so if you won congratulations let me know what

01:17:40course you chose um if ovo oxo said they won and chose a cloud computing essentials course that's my aws

01:17:51and azure course great course great choice uh thanks alex i got the tableau for data viz awesome

01:17:58and the tableau course great work those are great courses really highly recommend them all right this

01:18:04next one this is our last giveaway for the evening i am going to give you this code i haven't

01:18:11created

01:18:11it yet so don't even try i'm going to give you this code two people will win i want to

01:18:16know what

01:18:16they won and then we're going to be out of here all right so here's the code you have to

01:18:20be at the

01:18:20checkout on whatever course you want look listen rokib hassan i want to win too i want everyone to be

01:18:28winners but i can't i it's not practical to give 172 people every course for free so two more people

01:18:37it's a giveaway right i'm going to do this every live stream so come back to the next live stream

01:18:40if

01:18:41you don't win so here we go the next code i gotta write it out um here we go that's

01:18:49the one the next

01:18:50code is git g-i-t that's because my next series on youtube and my next course coming out in

01:18:57like

01:18:57on probably on monday is git and github that's my next course uh it's my next full course as well

01:19:03and then the series on youtube will also be getting github so the code is git two people can win

01:19:09that

01:19:09one i hope you do i hope you win i want you to win excuse me i was drinking water

01:19:19if you do win

01:19:20please tell me what you won that's all i ask i don't ask a lot i don't ask for a

01:19:26lot i just want

01:19:27to know what you chose is that too much all right they've been redeemed actually maybe i can go in

01:19:33here and see what they got no it's like some weird hash code that our api understands but doesn't say

01:19:40out

01:19:40loud what it is excited for the git course a lot you know what i've had really great feedback um

01:19:45from a lot of people saying they're really excited about the git and github course it's a great course

01:19:50too because getting github is not something that most data analysts even think about but a lot of

01:19:56teams use and so you want to know it um let's say oh towela kayira said i won chose the

01:20:03aws course

01:20:04fantastic i love that course and then derek hodgson who was asking lots of questions earlier oh there's

01:20:10a few people who say they got it who's telling the truth who's telling the truth but derek said he

01:20:16got

01:20:17it derek hodgson is a trustworthy individual i trust him with my life so if he's saying he got it

01:20:24i

01:20:26believe him cloud computing essentials wow a lot of people got the azure and aws one that's great

01:20:31genuinely there's not a lot of great resources for learning azure and aws and that is probably

01:20:36one of the best courses you're going to see out there and so um yeah azure and aws great course

01:20:41to

01:20:42choose really but when is the getting github course launching i think next monday i think i'll have that

01:20:49up and ready by next monday and i'll probably do some you know promotion on it or whatnot but then

01:20:54the getting github series on youtube um will be after my r series so my r series is right now

01:21:02and

01:21:03that ends like next month so maybe after next month then i'll start my r um am i getting github

01:21:10series

01:21:12so um i don't know if this is blurry or not i can't tell um so that is the end

01:21:17of our live stream

01:21:18for july 17th i will be doing another live stream july 24th so next thursday 9 a.m we'll do

01:21:27more

01:21:27questions more q a more giveaways this is like this this is almost like open hours for like a professor

01:21:34right it's coming it's if you want to you can come in you can hang out you can ask questions

01:21:39and then

01:21:39i'm going to give away free courses at the end um if you stick around and so that's all this

01:21:43is it's

01:21:44nothing more um just hope it's helpful to people i hope that you guys have been enjoying it um

01:21:51and i will see you guys next week trying to think if there's anything else uh anything interesting

01:21:56think of questions to ask if you have questions throughout the week just jot it down come in and

01:22:02ask those questions i'll try to i'll try to help out uh kapil sharma saying give 50 off no i

01:22:08down below

01:22:08have 35 off um the 50 off uh i do those for very special promotions because i'm doing this every

01:22:16single week i'm doing 35 off and then for larger promotions later on i'll do 50 but just uh not

01:22:23not during the weekly live streams but hope that helps thank you guys everybody have a good one i love

01:22:29you all i'm writing that in the chat right now love you all there we go um take it easy

01:22:34get out of here

01:22:35have a great day it's thursday we're over hump day you're almost at the end of the week i live

01:22:41for

01:22:41the weekend i don't i'm just kidding but um all right guys take it easy i love you all and

01:22:48i'll see

Alex The Analyst Q/A Livestream | Come Ask Me Anything

Category

Transcript

Comments

Recommended