- 2 days ago
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'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
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'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
Category
📚
LearningTranscript
00:00:01Hello, hello, hello. What is going on, everybody? Give me just a second. Just gonna make sure
00:00:06that this is on and working and then we will get going. Usually takes just a minute. All
00:00:15right, that sounds good enough for me. So this is our weekly live stream. This is our
00:00:21time to ask questions and just chat and talk. And it's great. I've been doing this for the
00:00:26past several months. I've been really enjoying it because I get so many messages all the time
00:00:32on LinkedIn and Instagram and Twitter or X, emails, and I just can't answer them all. Although
00:00:37I do try, I just can't answer them all. And so this is kind of like my time for you
00:00:44guys
00:00:44just to answer your questions. And there are a lot of questions out there. So I hope that
00:00:49that is helpful. There is a delay between right now what I'm saying and when it actually goes
00:00:55on your screen. It's about a 30 second delay. So don't spam. If you spam stuff, me or one
00:01:01of the moderators will definitely remove you. And that's not what we want. We don't want
00:01:05that. At the very end. So at the very end of the live stream, what we're going to do is
00:01:13we are going to do a giveaway. I do this at the end of every single live stream. And the
00:01:20giveaway is free courses just for you. There's no cost to you at all. And so I hope that it
00:01:26is helpful. And if it is helpful, let me know. What we're going to do is I see there are
00:01:33some
00:01:34people already in here, but usually takes a minute or so for people to join. But what
00:01:39we're going to do is I'm going to start answering questions. And once we get the ball rolling and
00:01:46we start answering some questions, just feel free to, you know, post your questions and
00:01:51I will try to answer them. I'm going to start up here. This is someone who's already been
00:01:56writing in here. This is for Clinton. Clinton, I remember you from a previous one. You already
00:02:04have, you have some good questions. Let me actually skim through these because I, there's
00:02:07a lot of questions. Um, but, um, so you had one on balancing technical skills and business
00:02:16soft skills. Um, more important early on technical or business slash soft skills. What do you think
00:02:21is the biggest mistake? Uh, yeah, there's a lot of, a lot of questions here. So I'm going
00:02:26to say, uh, a good one to answer. I'll, maybe I'll answer two of them, but a good one to
00:02:30answer
00:02:32is, uh, this, sorry, the, uh, uh, biggest mistakes that data analysts make at the beginning
00:02:39of their career. Um, I think one of the biggest mistakes, and this is something I made early
00:02:43on. This is something that, uh, let me scooch over being the more in the middle. This is something
00:02:48that I did very early on, which is I just looked at the basic question of what they were asking
00:02:55and tried to answer it. So I didn't really dive into things. Uh, someone would say, Hey, what is
00:03:02this? And I would just go quickly look it up in a SQL statement and say, and here you go.
00:03:05There's
00:03:05your answer. But I wouldn't ask follow-up questions. And so they actually wanted something
00:03:11slightly different. And so they actually wanted something a little bit more in depth or a little
00:03:16bit more nuanced, but because I didn't ask follow-up questions, I just took them at what they
00:03:20were asking and I went and gave it to them. It usually led to more questions and more issues and
00:03:25more follow-up. And so I could have saved myself a lot of time just looking it up or asking
00:03:30those
00:03:31questions at the beginning. So I think a lot of people make that mistake early on. Um, you're
00:03:37another question that you asked was how can you balance learning technical skills and soft skills?
00:03:42I think learning soft skills without being in a job is very difficult. I, I don't have a great
00:03:50answer on how to even do that besides I'm going to make a series on YouTube, by the way, for
00:03:56soft
00:03:56skills. So it'll be on communication and presentation skills and, you know, a few different
00:04:01things. Um, I think it's going to be really great. I'm going to kind of demonstrate how you might be
00:04:06able to practice this. Although I never did this. I personally just learned on the job. I think
00:04:12technical skills are more concrete. You can absolutely start learning this before you even get a job.
00:04:18So the balance is very weighted on the technical skills at the beginning. But then once you get
00:04:23into a job, you land that first job or you practice for your interviews, you, you get an
00:04:27interview. You can learn from that interview process on what they're looking for, what they're
00:04:32not looking for. But, uh, it's very difficult to learn a lot of those soft skills without being
00:04:39in a job. That's my personal opinion. It's quite difficult. Um, Hey, we have a lot of people
00:04:44joining. If you have questions, let me know, uh, just put in the chat. I will try to get
00:04:48to it. There's a delay. I'm also, um, uh, reading through a lot of different questions.
00:04:54Uh, let's see. So John is, is asking, can I make one portfolio since I'm a data analytics
00:05:07and data into data analytics and data engineering, or should I make two separate portfolios? I'd
00:05:11probably make two separate ones. So if you're like in between, you're not sure what you want
00:05:15to go for data engineering or data analytics, make two, uh, because a data analytics portfolio
00:05:21is not going to be relevant to a data engineering and data engineering won't be related or really
00:05:26useful for data analytics. Um, it just wouldn't make a lot of sense. So I would make two separate
00:05:32portfolios. Uh, this is from mid a chic. It says, I haven't, I haven't been trying to land
00:05:43a job as a fresher and I'm from Sri Lanka. I don't know why it's so hard as a fresher
00:05:48guide
00:05:48me into doing this. Um, so I will just say for landing jobs right now, the market is really tough.
00:05:55Like the market for getting a job, especially remotely, which if I know Sri Lanka, uh, cause I,
00:06:02you know, my team, some of my team members for, uh, for analyst builder are from Sri Lanka. Sri
00:06:06Lanka is a very, uh, uh, they export a lot of things or sorry, they don't export a lot of
00:06:12things.
00:06:13They don't have a lot of business internal. They're, they're importers, uh, uh, for a lot of
00:06:18their goods. So based on that, you're probably looking for a remote job. That's my guess. And if
00:06:25I'm wrong, just let me know. Maybe you're looking for, there is a local company. Um, remote jobs
00:06:30are 20% of the jobs that 80% of the people are trying to get. So it's highly competitive.
00:06:38Um,
00:06:38if it's your first job, it's going to be very, very tough to get one of these remote jobs.
00:06:43I've been telling people, if you have experience, sure, go for the remote jobs. If you were just
00:06:48starting out, getting a remote job is going to be extremely difficult in this market. Extremely
00:06:53difficult. I just think that if you can go local, if you can make a connection, if you can find
00:06:58someone,
00:06:58reach out to someone personally, that's the best way. If you have a good resume, you have the skills,
00:07:02you have some projects, uh, you have a portfolio, like you've done all the things that I've been,
00:07:06I tell people to do, like in my data analyst bootcamp, that's free on YouTube.
00:07:10If you do those things and you have everything set up and you're like, I'm ready, I'm ready for a
00:07:14job.
00:07:15I would recommend reaching out to recruiters, trying to make connections online. Uh, remote jobs are,
00:07:20you know, difficult. So, um, you know, you have to go beyond just applying on like LinkedIn and
00:07:26indeed and whatnot. Hi, Ryan B. Nobody. Good morning, Alex, the mentor. Uh, hello, hello. How's it going?
00:07:37Thanks for joining. I know some of you guys, I've seen many of you guys before
00:07:40and I see you guys, uh, coming in every week, which means a lot. Thank you. I appreciate it.
00:07:45Um, Robert Sorg, I want to learn more about data engineering after your pandas class. Awesome.
00:07:50What's the analyst builder for data engineering? So that is a, uh, the first course that I did not
00:07:56make. I'm not a data engineer, but I got my friend, Ben Rogogen, better known as Seattle data guy,
00:08:01uh, on YouTube. He made that course and he's going to be making some other courses like SQL for data
00:08:06engineering, which goes into more high level, um, some architectural stuff and creating pipelines
00:08:12within SQL. Um, I didn't make that one. So that one goes into using things like airflow, uh, and a
00:08:19few
00:08:19other tools and, and like AWS glue and stuff like that. Um, really great for beginner data engineers.
00:08:26I think it's really, really good. Um, but yeah, beyond, so if you're wanting to get into data
00:08:31engineering, um, you know, I would start looking into, uh, I have one course that's really useful
00:08:38for people who are like wanting to get a little bit more technical like AWS Azure. So I have my
00:08:43cloud
00:08:43computing essentials, uh, course that one goes into some creating pipelines and using databases and
00:08:50things like that, that you'll be doing even in data engineering. Madiha Umar. Good morning, Alex.
00:08:56It's a great pleasure to attend your live stream. Thanks for joining. I appreciate it.
00:09:01Oh, we got someone from Japan, Bill Memni. Hi, Alex. Big hi from Japan. Big hi from the U.S.
00:09:08Thanks for joining. I appreciate it. Let me see. Do you value certifications like the PL 300 or DP 600
00:09:18or 700? No, I don't. Um, never has certifications been a big thing. There was someone back in the day,
00:09:25back when I was hiring, uh, I was on a hiring team and they had, you know, we used Azure.
00:09:31Oops. We used Azure and someone had some Azure certifications, which were useful, but even then,
00:09:37um, you know, they're not needed for most data analysts work. Like 95% of jobs do not care if
00:09:44you
00:09:44have any type of certification. They care if you have the skills. Um, that is just, that is a fact.
00:09:54Uh, Tiku Meister. Oh, geez. It skipped down again. Hey, Taki Patrick dash data analyst. He's one of my
00:10:03mods. Thanks for joining this morning. Thank you. He's already on it. He's already on it. Don't spam.
00:10:09Um, he's going to get you. Don't spam. Um, sorry. I, I was reading what you were saying and then
00:10:14it
00:10:14went down. It says, thanks to your tutorials. I'm a data associate coming from a customer service
00:10:19background. It's a start of a long journey. Cheers to you. That is amazing. I love hearing stories like
00:10:23that because, um, I also don't come from a data background. Uh, my degree is in recreational therapy.
00:10:29It has nothing to do with what I do now. Um, I truly believe that if you put in the
00:10:34work and you
00:10:35study hard and you, you know, follow the path that I've kind of laid out, which very few people do,
00:10:42um, then you have a very good chance of success and you are, that is awesome. You are one of
00:10:47those
00:10:47success stories. I'm so happy to hear that. Dev Aurora. Hi, Alex. Actually, I'm learning Excel
00:10:53so much that after I forgot. Yeah, there's a lot to Excel. Excel is very, it's a
00:10:59simple tool that has a large, large learning, uh, uh, curve at the, like, it's easy, easy,
00:11:07easy. And then it's like, whoa, this is really tough. Um, it does get very advanced.
00:11:23Uh, ZXC09 Ify. I don't know how to pronounce that. Uh, I'm learning SQL through course careers.
00:11:28I'm struggling and it's discouraging me. What are some better ways to practice this? Um,
00:11:33I don't know what course careers is, but SQL is like one of those fundamental skills. I highly
00:11:39recommend starting with SQL. I'm glad you're looking at it, but it can be tough. I will say
00:11:44I struggled for probably a month or two to really understand SQL concepts before I kind of started
00:11:49to learn it better. And then of course I used it for many years and I love SQL. Um, my
00:11:55biggest
00:11:55advice is if you want to do it completely for free, then I highly recommend just getting into a
00:12:02database, getting some data into it there. I have a whole series of beginner, intermediate,
00:12:08and advanced, my SQL tutorials that'll walk you through everything. And if you go through that,
00:12:13like you will learn it. It's, it's a fact you're going to learn it. Um, if you want to practice
00:12:20and
00:12:20more of like a fun way, if you go to analyst builder.com, that's a platform that I created,
00:12:25there's free questions on the questions page and you can practice their easy, medium, hard,
00:12:30and very hard questions. Try out the easy ones. They're meant to be easy. And I have video tutorials
00:12:34on how to solve them. So it's more like a game. And so I think that is a great way
00:12:38to learn.
00:12:39Uh, somebody, uh, Sahil Nike, you gave me 10 bucks. You didn't have to do that. I'm not looking for
00:12:44any donations here. I just, uh, I'm just going to read your questions since you did donate. Thank
00:12:48you. I'll heart it real quick. It says I have data analyst gateway systems, hiring manager
00:12:54interview today. Oh my, uh, that guy isn't super data person, but more of a gateway operations
00:13:00satellite comms. What kind of questions should I expect? Um, I would give me some more information on
00:13:08that. And once I get to it, I'm going to answer, but here's what I'll say. Typically in, you know,
00:13:15if they're like a hiring manager, they're going to make sure you have the skills. So if you're
00:13:18getting an interview, you probably have some of the skills. They're going to ask you about those
00:13:22specific skills, whether it's SQL or Databricks, or maybe they're using some third-party software
00:13:27nobody else has ever heard of. Um, ask about those, that software say, you know, what kind of
00:13:33software do you guys use? And they're going to say, we use Excel, SQL, and Snorfl. And you're like,
00:13:38okay, tell me about Snorfl. How does that work in your, in your systems? You know, what does that
00:13:43do? Is that your BI tools that, you know, what does it do? Then, then you can like show your
00:13:47interest and you can say, oh, okay, so you guys use this and you connect it to this. And that's
00:13:52kind of where I'd be working in that system. I feel very comfortable doing that because I've done this,
00:13:56you know, in, in, you know, previous projects or in previous work or whatever it is.
00:14:01So your goal is to make yourself as, um, optimal for that position as possible, even if you don't
00:14:09know it. And that's going to happen because I, I've gotten jobs or I've applied for jobs or
00:14:14interviewed for jobs where I only knew three of the five skills they wanted. But if you ask questions
00:14:18about those tools, like what they are, how they work, what they're looking for, um, that can kind
00:14:23of open things up for you to then tell them, Hey, okay, yeah, I can do this because I know
00:14:27this. And I,
00:14:28I know how those systems work. So if you give me more information down below in the chat,
00:14:33I will see that. And then I can maybe give you a more informed answer, but, uh, good luck on
00:14:38the
00:14:38interview. Good luck. That is awesome. Uh, Zerab Burkhodzi. Hey Alex, I'm pretty new on this
00:14:48channel and wanted to ask you about my future steps of becoming a data analyst as a 16 year old
00:14:52who's learning Postgres for three months already. What major also? So if you're 16, you're most likely
00:14:57a junior or senior in high school or grade 11 and 12. I think that's what they call it, uh,
00:15:03outside of
00:15:03the U S that is like grade 11 and 12. Maybe I'm wrong. Um, but if you're young, first off,
00:15:12awesome
00:15:12getting into like this space now, because we, the whole market is just crazy right now. We're in this
00:15:20weird, uh, market, but learning the skills now will set you up really well for the future. Tech skills are
00:15:26going to be useful in the future. Um, so learning PostgreSQL, a great thing to learn. I would continue
00:15:33learning that. I would also pick up if you're still, you have time, I would start picking up
00:15:39things like Excel and things like maybe Python, uh, programming. If you start earlier is better in
00:15:46my opinion. I started late. Um, maybe not late. I was like 21, 22 when I started getting into Python,
00:15:53but I wish I had learned it earlier. Um, and so I would start getting into Python. Um, and just
00:15:58find something you enjoy, right? When you're young, don't force yourself to learn something just because
00:16:04you feel like you need to learn it. Um, if you really want to learn Python, then learn it and
00:16:09find it,
00:16:10find a way to do that in a fun way, build a cool project. Uh, but majoring, uh, computer science
00:16:15is
00:16:15always a good one. Um, if I could go back, that's probably what I would major in some type of
00:16:19computer science. Um, but mathematics is also a good, a really good major for analytics, analytics
00:16:27jobs. Um, but good question. Awesome that you're already thinking about this. I was not thinking
00:16:34about, well, I was thinking about my future, but, uh, I didn't know what I wanted to do that much
00:16:39when I
00:16:39was 16 years old. Madi Voli Gerasham. Greetings from Nairobi, Kenya. Your next holiday should be in
00:16:49Kenya. I'd be glad to show you around. Listen, I'd love to come to Kenya. I have a lot of
00:16:53people from,
00:16:54um, Kenya and Uganda, um, and, and different parts of Africa that, uh, a lot of people watch the channel.
00:17:04So I'm very appreciative that, you know, I can help you guys. I hope I could come out one day.
00:17:09Someone was trying to get me to come out for a conference. They wanted me to talk,
00:17:12but the timing didn't work out. Um, otherwise I may have come out there and I do, I hope I
00:17:19do get
00:17:19to at some point cause that'd be awesome. Um, follow Hanmi. Hey Alex, as a beginner, how do I
00:17:27practice my skills on what I've learned? So if you're just getting started and you don't know,
00:17:32you're like a baseline, you're just getting into tools and just getting into learning how to think
00:17:37like a data analyst and learning how to do anything. My biggest advice is to build projects.
00:17:42You can take tutorial after tutorial after tutorial. And of course I have lots of tutorials,
00:17:47but once you actually start building something, that's when like something flips from cognitively
00:17:54understanding to a more in-depth understanding of this is something I can actually do.
00:18:01That's why I focus so much on projects in my YouTube series. I teach you the skills and then
00:18:08we immediately apply it into building something, a project. Building something will help you immensely.
00:18:14And so whatever it is, data visualization, data collection, data cleaning, whatever it is,
00:18:20I highly recommend trying to build something.
00:18:24Bilal Minhas. Hey Alex, voice is much too slow. That's, that's just how I talk.
00:18:30I talk. I talk slowly. Good morning. I like, I like that your name is Taki Patrick dash data analyst.
00:18:39Whenever I see it, I know exactly who it is. I don't have to think about it.
00:18:47Well, good morning. Thanks for joining. He's one of my moderators. You'll see his name in blue.
00:18:52Don't mess with him. He will, he'll block you in a second. Uh, if you start spamming, which I appreciate
00:18:57because that gets too much. Um, Bucci Godwin, how do I transition into health data analysis?
00:19:05So I worked in healthcare for five, six years. I was a manager, uh, at a healthcare company,
00:19:11uh, in data analytics at a healthcare company. Um, my background is in healthcare as well.
00:19:17So I have a degree in recreational therapy. I was going to go and get my master's in occupational
00:19:20therapy. I was going to go be an occupational therapist. My whole life just changed when I
00:19:24found data and fell in love with it. Um, my recommendation. So I have a healthcare data
00:19:30analyst series. It's like four videos on kind of how to get into healthcare analytics. So it covers,
00:19:36here's what you should be looking at. Here's some like topics or things that you should really know
00:19:40about things like insurance, claims data, ICBT codes, ICD codes, LOINC codes. These are things
00:19:46that diagnosis codes. These are things that then you can build and you can learn more about and start
00:19:51creating projects around and learn more about it. So then when you apply and you target healthcare
00:19:56companies, um, you can, you can learn a lot and hopefully get a job. Um, all right, let me look
00:20:04at more questions. This is a, uh, I don't know why MCAP, no offense. I don't know why you're asking
00:20:12me this, but how do you change the background of my SQL workbench to dark mode? My eyes suffer. Look,
00:20:16I feel bad for you, but that's a Google question. That's not a, that's not a me question.
00:20:22That's a chat GPT, Google Gemini, Google question. Uh, let's see. Oh, interesting. Okay. This is kind
00:20:32of a great segue question from healthcare. Uh, Peter Parker, great name. Hey, good morning, Alex. I'm an
00:20:39occupational therapist in New York city or NYC. Uh, what's the best case scenario for me to transition?
00:20:46So I'm guessing transition to some type of data role. Give me one sec. When I talk a lot, I
00:20:51burp a
00:20:51lot. I do apologize. So funny enough, that's what I was going to do. Uh, I had gotten into a
00:20:56master's
00:20:57program. I was going to go and be an occupational therapist. Uh, but I went from recreational therapy,
00:21:03which in my, at my college was like the stepping stone to the masters. Um, I stopped, but my background
00:21:08was really useful. Even at the recreational therapist, you're an occupational therapist. I'm
00:21:15guessing professionally, like you've done this for hopefully several years. That is very valuable.
00:21:20Believe it or not, very valuable. I mean, think of the things that you're most likely doing. If
00:21:24you're doing patient forms, you're using some type of electronic health record system. So EHR system,
00:21:30maybe even a CRM for documenting other things. You're probably submitting for, to insurance. So
00:21:36you're going to know about the insurance process. You're going to know probably about claims data.
00:21:40You're going to know, um, CBT codes because when they come and visit you, you should be using
00:21:45subtype of CBT code. If you don't know what I'm saying, if none of these things are resonating,
00:21:49um, give me more information. It should be making sense. Like these things should be like,
00:21:53you should know a lot of this in my opinion. If you don't, then I don't know. Maybe you're working
00:21:58at some, you know, place that doesn't do that. Some privately, uh, funded thing that they just do
00:22:03it their own way. Uh, it's cash, cash business. They don't file for insurance. Cause if you don't
00:22:08file in for insurance, then you don't need a lot of these, uh, metrics or tracking information.
00:22:13Um, but if you do submit for, uh, nurses, um, and other people in healthcare, cause that's,
00:22:19was my background. And so a lot of people in healthcare, um, and I was able to have a lot
00:22:24of them get jobs. And the, what I always told them was, is you need to figure out what your
00:22:30niche is for you. Maybe it's, you know, um, in the rehabilitation, right? Cause you're in,
00:22:37uh, uh, in occupational therapy, but find out what your niche is. There are companies,
00:22:43guaranteed 100% that fit in that niche. I'll give you a very specific example. When I was,
00:22:50uh, I was under a data science team, but I was a data analyst on a data science team for
00:22:55data
00:22:55collection. We used to hire nurses and doctors. And what we specifically wanted them to know was
00:23:03things about oncology and hematology, very specific fields, right? That's blood and cancer,
00:23:10but that's the data that we worked with. So I learned that just through, uh, other things. But
00:23:17when I got in there, the people who knew that stuff, that's who we hired. And so I got to
00:23:22sit
00:23:22on hiring teams and we would hire, you know, nurses who wanted to be join our team as like a
00:23:27statistician
00:23:28or as a data analyst, but we would hire them. And that made them so valuable. And so we would
00:23:34ask a
00:23:34lot about that kind of information. Tell me what you know about CPT codes and the insurance process
00:23:39and filing claims and all these things. So that's what I would recommend. I really do have a passion
00:23:45for healthcare in general. I'm going to take a sip real quick. Like I think healthcare is one of the
00:23:51best industries for data professionals. I really do. Um, and so I hope that, uh, I hope that was
00:23:58helpful in any way. If you have more information, put it down below because then I can read it and
00:24:02I
00:24:02can give you a better, uh, kind of better instructions or feedback. All right. Let me look
00:24:09at some different questions.
00:24:15Lifestyle with why he, my, I don't know what that means. My eye, um, I have tactical exercise
00:24:22interview next week and I'm so nervous and not sure what to expect. Any advice? My advice is to
00:24:29the way to become confident in these technical interviews is to practice. And genuinely one of
00:24:36the best places to practice on analystbuilder.com, go to the questions page. There are free questions.
00:24:42Go and practice those questions, easy and medium. Those are the ones that you should be focusing on
00:24:46easy and medium. They're free ones. I'm not trying to get anyone to pay for anything. I just think it's
00:24:51a fantastic resource to learn and practice. Those are, I made all those questions. I also have videos
00:24:56to all of those questions and exactly how to solve it. And when you get into technical interviews,
00:25:01they're typically going to ask some type of, um, SQL question. There are also our general technical
00:25:08questions on there. I don't know if we have free ones cause that's still in beta. It's our, uh, but
00:25:13that's those questions give you immediate feedback using AI. So, you know, there are questions like,
00:25:19Hey, how do you use SQL? It helps you figure out how to respond to those questions. So I do
00:25:23recommend
00:25:23people using it to learn, um, how to, how to answer those questions effectively.
00:25:31All right, let me go, let me look, I skipped down again. I'm sorry. Uh, Sahil Naik. Okay. So this
00:25:38is a
00:25:38follow-up from a question earlier. He said he had an interview, but now I, I did, I wanted more
00:25:42information. He said they use Power BI, SQL, AWS. So S3, uh, Kinesis Analytics. Also we'll be dealing
00:25:49with radio frequency data, wireless communication systems data. So I don't know about that type of
00:25:54data. That's not my expertise, but I will say those tools are all tools that I teach on my channel.
00:26:01So I have a lot of experience in Power BI, SQL, and AWS. So familiarize yourself with these tools.
00:26:08You want to know how to use S3 buckets, how to, um, you know, what they're used for,
00:26:14you know, how the data is stored there. You know, I have, again, it's, it's a free video on my
00:26:21channel on, on these things. I don't have one on Kinesis Analytics. In fact, I haven't used that
00:26:25before, but just AWS in general, you can learn a lot by using, you know, trying to use their SQL
00:26:31databases and, you know, create automations and use their S3 buckets, which are like the most common
00:26:37way to store data in AWS. Um, but yeah, I would just, um, I would familiarize yourself with these
00:26:48things. So if you don't know Kinesis Analytics, so I don't know Kinesis Analytics. Let's say I'm
00:26:52going to this interview. I'd be looking up Kinesis Analytics. I would then go in with, uh, one or two
00:26:58questions, ask ChatGPT, say, Hey, I don't know about, here's my interview process. Give me like one
00:27:03or two questions that would be a good question to ask. Um, and so I would be doing research. I
00:27:09try
00:27:09to get a question or two ready and prepared. And then in the interview, I would say, okay, I haven't
00:27:13used Kinesis Analytics yet. I've used S3 buckets, but tell me how you guys use this within your company
00:27:18and, you know, uh, you know, within your workflow, then get, get him to talk about it. So then you
00:27:24can
00:27:24then eventually point it back to, okay, that sounds really good. Uh, you know, this sounds like something
00:27:30I've done before with this tool or with this tool. So this looks, sounds really familiar to me.
00:27:34That's what I would be doing. Uh, let's see.
00:27:45Adowu Aluwabenga. I watched one of your previous live stream sessions. You said, uh, you can't buy
00:27:49courses on analyst builder from Nigeria. That's correct. They blocked our domain provider,
00:27:54which means like they blocked like tens of thousands of websites and ours is one of them.
00:27:58Um, you just have to use a VPN, use a VPN and you can get access.
00:28:04LinkedIn, which industries, finance, health, e-commerce, et cetera, do you think are hiring
00:28:08the most analysts right now and in the future? Right now, genuinely healthcare is hiring some
00:28:13of the most, uh, uh, analysts for different domains. Finance is always up there. Um, and banking
00:28:22is always up there. Besides though, like there are a lot of different industries.
00:28:27So, you know, take this with a grain of salt, but even companies like tech companies aren't
00:28:34hiring as much as things like healthcare. And the reason is because healthcare is like,
00:28:40everybody needs healthcare. Everybody uses healthcare. Healthcare isn't going away.
00:28:44They get so much funding from the government. And if you look at United States as a whole,
00:28:49uh, the government and the government as a entity and healthcare are really propping up the market.
00:28:58They're the only two, uh, positive hiring, uh, industries right now. So every other industry
00:29:07laid off in the United States, laid off workers doesn't mean data related, but just laid off workers
00:29:11in general, whereas healthcare and government agencies hired. So if you go back and you kind of dig into
00:29:18that data, um, it's just interesting. I mean, healthcare is propped up by the government
00:29:23and the government keeps hiring and spending money. And that's not going to stop anytime soon,
00:29:27unless we have some type of government shutdown, which I guess is possible.
00:29:34I only brought, I drank most of my water before the live stream started. Then I didn't get more.
00:29:38So I only have a little bit left. All right, let's see. Um, Emma Woyi Ben. Hey Alex, I just
00:29:48joined
00:29:48your data analyst bootcamp and when installing my SQL, I did not have the default mode like you had
00:29:52and it's making things difficult for in my way forward. In the description, I said, if you don't
00:29:57have the, um, developer edition, then do the full edition. Cause that gives you access to everything
00:30:02in my SQL, um, that they have in the free version.
00:30:05Okay.
00:30:11Um, Hey Alex, currently in the pro this is from sunny D 17 underscore. Hey Alex, currently in the
00:30:17process of learning a stack of SQL, Excel and a BI tool in Python. Great, great stuff to look at.
00:30:22I want to ask you if you can give not a minimum, but a benchmark to be competitive as a
00:30:27entry level
00:30:28data analyst. So if I were starting over today, um, and I wanted to get up and going to at
00:30:34least be
00:30:35competitive in the job market to be able to at least land interviews and potentially get a job,
00:30:41I would one all those skills, all those skills. Python isn't needed. In my opinion, if I were you,
00:30:47I might actually switch Python right now for sorry, burping or AWS and Azure. You know what? I just
00:30:55realized I'm sorry.
00:30:59I have two glasses and I was drinking out of the one with literally no water and I didn't see
00:31:04that
00:31:04I had a full one right here. I don't even know what to say.
00:31:12I'm embarrassed. I'm ashamed. I feel like a fool, but I needed that. I needed that. That was nice.
00:31:20Maybe. No, my wife didn't come in here and fill it up, but maybe she did when I wasn't looking.
00:31:25No, she didn't come in. Maybe I did that. I just remember. Anyways, um, I would be learning
00:31:31SQL Excel, a BI tool, and I would switch Python. I don't think Python is going to give you like
00:31:36five, 10% market share of companies that even want you to know Python. Excuse me. I got an itchy
00:31:42nose.
00:31:43I would replace that with Azure and AWS first. Azure and AWS, so many companies, especially
00:31:51startups and small companies are using these tools. And so let's say 30% of companies use
00:31:58Azure and AWS. Well, Azure and AWS are cloud platform tools. So then if companies use things
00:32:05like Databricks, if they use things like Snowflake, no, you haven't used those tools. And there's a lot of
00:32:11third-party other different tools out there, but you can say, I know Azure and AWS, and I can,
00:32:18I know Snowflake is kind of in that same vein. They have a lot of similar functionality. I'd be
00:32:22able to learn that really quickly. So now instead of the 30%, now it's 40% or 50% of
00:32:25companies out
00:32:26there in the world, in the data world, at least that are using these tools, you'll open yourself
00:32:30up to that instead of the 10% with Python. That's my, that's what I personally would be doing.
00:32:36Um, as a benchmark, if you go through all my data analyst stuff on YouTube, and I mean this
00:32:44sincerely, you will be ready to start applying. It's free. If you want to go even more in depth,
00:32:50I have full courses, but those aren't a hundred percent needed. I promise you can do it for free.
00:32:55And so I recommend doing it. And then if you were like, oh, I want to advance my skills,
00:32:59then take courses, go to Coursera, go to Udemy, go to my platform, wherever you want to go to
00:33:03learn it more in depth, but you can learn all those things for free. That's what I would be doing.
00:33:11Uh, I haven't, I haven't read this whole question. Let me just read it. Divine Godfred. Hi, Alex. I'm a
00:33:16fourth year medical student looking for a side skill that I can use as an income while in school and
00:33:20still remain relevant after. Do you think data analysis is a good option? Um, I don't know. Um,
00:33:27doctors typically aren't doing what I would consider almost any data analysis. They're just on the
00:33:32healthcare side. Um, I get, you know, if you want to get into like the research side of things,
00:33:37I've worked with a lot of doctors, a lot of nurses in my day, but you know, that's a niche
00:33:44thing.
00:33:44It's transitioning from a doctor to the data world. Um, it's, it isn't super common. Um, and so,
00:33:51I mean, it's not a bad thing to learn how to use data because if you get into research or
00:33:57you get
00:33:57into, you know, doing, um, medical testing or anything, or you get into the insurance side of
00:34:03things, then data is going to be really relevant. But I don't know if that's like a moneymaker.
00:34:06I don't know if you're going to be like making good money from it as like a side gig. Like
00:34:13if I
00:34:13were still in college and as a side gig, I'd be like being a moving helper, uh, you know, moving
00:34:19boxes, uh, or I'd get a job at like a supermarket. I don't know. Again, I don't know your position
00:34:26or
00:34:27what you're doing. I'm just thinking like as a college kid, or maybe you're a fourth year medical
00:34:31student. So you're out of college, you're technically like past your master's, I guess.
00:34:36Um, or maybe that's your fourth year, your master's like portion of the, the meta. I don't
00:34:40know. But my guess is that if you don't have any work experience, that maybe you can get something
00:34:46in like a hospital, right? I'm just throwing out random stuff. I just don't think data analytics
00:34:51as like a side gig is going to make much money. It needs to be like a full-time job
00:34:55kind of thing.
00:34:55Um, flash traders. This is a good question. Give me a sec.
00:35:06Oh, Christine's here. That's my wife. It was her birthday recently. We went out, uh,
00:35:13our reserve. We missed our reservation because of traffic had to go to another place, but it was
00:35:17very fun. Uh, happy birthday. I love you, baby. That's Christine. She's in the chat. Thanks for
00:35:23joining. She's working out right now. Um, this question says, uh, hi, Alex, kindly advised. Is
00:35:33it advisable to open a data analytic company as a consultant? So, uh, I have Alex analytics LLC.
00:35:40I've opened a company and I did consulting through that company as a beginner. I don't recommend it.
00:35:47Um, it is very competitive. People expect a certain level of quality when paying consultants.
00:35:57If you can't deliver that, you're gonna have a lot of angry customers, um, who then want to refund and
00:36:02then you get nothing, um, or they don't want to pay you. I, I do recommend, you know, once you
00:36:09get a
00:36:09few years under your belt, then doing it. I just think it's gonna be very difficult. Now, don't let,
00:36:14that's my opinion. Don't let me stop you. If you're like, no, I absolutely want to do it. I can't
00:36:19wait to start this and start doing this and start consulting, do it, but just know that it's gonna
00:36:25be very difficult in my opinion, but it sure could work. All right, let's see.
00:36:39Uh, Mustafa Ahmad, should I spend time solving challenges about SQL on HackerRank or do you have
00:36:45other recommendations? Um, one, HackerRank is good. I've used HackerRank in the past. I've used
00:36:52LeakCode. Uh, they're all good. I have, like, I, on my website, AnalystBuilder, we have a very similar
00:36:56thing, but ours is data analyst focused. I think it's good for practicing. Um, like, it can be very
00:37:04monotonous to put data into a database and query the data and it's just difficult. So places like
00:37:11HackerRank or AnalystBuilder, they have kind of challenging questions that make it more fun.
00:37:18That's what I focus on on our platform. I try to make the questions and interactive interactions fun.
00:37:23Um, but I see that as, you know, a fun game to kind of practice some skills, but that actually
00:37:31is
00:37:31more relevant when you start getting into like the interview process. Um, that kind of stuff is
00:37:36really good for interview process. If you're, if you're wanting to learn it more in depth, you need
00:37:40to take like the full courses or you need to take my, uh, uh, series on YouTube because that'll go
00:37:46a
00:37:46lot more in depth and you'll build projects and building is what really helps you learn a lot of
00:37:51like the core concepts. Then those questions take you into these little niches of if this use case or
00:37:58this use case or this use case, and that's where it's useful for interview process.
00:38:05Clinton, great question. Clinton, I remember you from previous ones. You, you've been asked,
00:38:09you asked great questions. Let's see. Uh, you talked about building projects. If you're hiring manager,
00:38:20what stands out the most in a data analyst portfolio?
00:38:25So I was on a hiring team for several years and I was a hiring manager where I hired several
00:38:30people.
00:38:32Usually the only time I'm looking at a portfolio is when I'm meeting with you like in person. So
00:38:38in the beginning interview stage, the portfolio doesn't really mean a lot. Um, but you should still
00:38:46have projects on your resume because that does make a difference, but having a portfolio, I actually go
00:38:50into your portfolio website and look at it. I was typically only doing that when I was doing an
00:38:54in-person interview with somebody like they'd gotten past that first or second round.
00:38:59What stands out the most to me, uh, is relevance and the, the, uh, skills used or the tools used.
00:39:07So when we were, when I was back at Amerisource Bergen now called, uh, Sencora back when I was at
00:39:14that
00:39:14company, we were hiring, what I would look for is projects that were useful. So, you know, someone
00:39:20would come in and they were from a healthcare background. They had a project on healthcare
00:39:24and they were using similar tools. They were using SQL. They were using power BI. They were using
00:39:29Excel. And I'm like, Oh, these are tools that we are going to be using and you'll be using on
00:39:33the job.
00:39:33I'm so glad you have some experience. And then I would ask them, can you talk to me about this
00:39:38project? Tell me about this project. I would ask that. And then they would tell me about it.
00:39:42They would say, okay, I did this. I did this. I did this. Here's how I, you know, connected
00:39:45these. And I could tell a lot about a person's expertise and how much they actually knew from
00:39:50when they were describing their project. So, um, I think that stands out the most to me when
00:39:56they're youths relevant to the skills needed in that job and also to the domain. Those two things.
00:40:06Uh, Don Rowam, Alex, what are some of the projects to undertake in the financial sector of
00:40:11data analytics? Uh, I personally have never worked in finance, but I love financial things.
00:40:18So I love investments and stocks and savings and, and, you know, banking in general. I find it very
00:40:24fascinating. Um, my recommendation would be, you know, one chat, which he's going to be more
00:40:30knowledgeable on this than I am. But in terms of like the data side of things, you can do a
00:40:35lot of
00:40:36forecasting, a lot of, uh, data modeling, a lot of historical trends and patterns within a lot of
00:40:43financial things. Like take the federal funds rate. You can do projections on that. Um, given,
00:40:50you know, these three or four different independent, uh, factors, like maybe it's GDP or maybe it's,
00:40:56uh, uh, you know, debt levels or whatever it is. And then you can, you can use those to predict
00:41:03where you think the federal funds rate is going to go. That'd be an interesting project.
00:41:06Um, but that's chat GBT. That, that is a question. So like chat GBT is, is good for some things.
00:41:12And that is one that's really good at brainstorming ideas and projects and things like that. That's
00:41:17what I use it for, uh, quite a bit. Can I still be a data analyst in the mechanical engineering
00:41:26industry? Sure. Why not? I don't know much about it, but I don't see why not. I don't know much
00:41:31about mechanical engineering. If I'm being honest, like, I don't know what industries
00:41:35use that a ton.
00:41:41Cool. Brian said, I'm graduating tomorrow. Congratulations. Currently working on one
00:41:44of your old projects that use Tableau, but I chose to challenge myself and use Power BI instead.
00:41:49I love that. That's awesome. That's awesome. I do have Power BI projects too. So you can do the
00:41:56Power BI ones if you like Power BI. Creature requests. I'm 14 year old, 14 years old. Give
00:42:02me the best path to go to because I just started SQL. Learn SQL. So I have a free data
00:42:06analyst
00:42:07bootcamp. Go through that. It teaches you SQL, Excel, uh, Power BI, Tableau, Python, Pandas,
00:42:15AWS, Azure. And soon I'm going to add in my R series and my Git and GitHub series. That's going
00:42:21to add another like three, four hours to the 24 hour long thing. Go through it. Cause there's
00:42:26projects along the way. There is things about how to create a portfolio for free, how to create
00:42:31a portfolio website, how to build, uh, projects, how to do the interview process. It's awesome.
00:42:36It's awesome. You're of Sharma. What kind of stuff gets you shortlisted? So shortlisted in,
00:42:43uh, hiring just means, you know, 300 people applied. Now you're down to like the final 10 candidates.
00:42:48How do you get shortlisted? So one, you have to have a really good resume. I, I can't speak
00:42:54this enough, especially with how hiring is today. You have to have a great resume. Um,
00:42:59one that gets through ATS systems, the automatic, um, systems that scan your resume and see if
00:43:06they fit the criteria needed. You have to have that. That's one. Number two, once you do get
00:43:17quote unquote shortlisted just for your resume, then you have to speak really well in the interview
00:43:23process. I think looking back, my inquisitiveness and my just general, uh, personality helped me
00:43:31get into a lot of in-person and final interviews and landing jobs. The resume and your hard skills
00:43:38get you into interviews, but your soft skills help you land the job. Um, and so that's the kind of
00:43:45things that, you know, you need to work on. If you're bad at interviewing, practice interviewing.
00:43:49I used to practice with my wife, um, practice with somebody.
00:43:57All right, let's see. What's your advice. Oh, it's just skipped down. I was about to read a
00:44:01question. Give me a second. Let me get back up.
00:44:06A curious 24. What is your advice for getting your first client when you're offering a data
00:44:10analytic service? Um, you ha I highly recommend one, either having previous experience and then
00:44:16you can consult for somebody you knew there that I've seen people do that, um, or a company that
00:44:21they knew to, you gotta have some type of online presence. I don't care if you have a million
00:44:28followers or if you have a hundred, if you're, you have some type of audience, you, that's how you,
00:44:34that's how most of the people that I know have gotten consulting gigs and stuff like that.
00:44:39Um, is posting online. Hey, this is a service that I provide. Um, hey, here's some, you know,
00:44:45tips on this or that. Uh, here's a project that I built. Share and build some type of audience,
00:44:51uh, so that they can then see you. Because marketing is half the battle when trying to get customers.
00:45:00Uh, life moon. I'm a primary school teacher. Do you think data analytics is good for me to switch
00:45:05to? I have a bachelor's degree in physics. Um, yes, in the education space, there are a lot of
00:45:11people that will hire data people. Um, I worked with several teachers back when I was doing full
00:45:16mentorship. Um, and they were teachers and they landed data analyst jobs. Finding companies that
00:45:22value your experience is half the battle. Use tools like chat GPT. I really think this is like
00:45:29some of the best use cases for chat GPT is research and figuring things out and brainstorming ideas.
00:45:35Um, because the internet is full of great ideas, but I don't know everything. So use it and say,
00:45:42what kind of companies would be good given my background to transition into data, into data
00:45:47that will give you some headway into here are companies that I can target. I can reach out to them.
00:45:53I can reach out to the recruiters. Um, I can target these companies that would value my teaching
00:45:57experience and you have a degree in physics. So the degree is helpful as well. Um, you could look at
00:46:02companies that value physics as a degree. Mathematics is huge in data analytics. And so, um, you know,
00:46:09physics is heavy math. I, I took physics back in the day, loved it, but it was hard. And so
00:46:15physics
00:46:15is a, is a degree that is relevant and useful in, um, in data analytics. Uh, this is an interesting
00:46:23one. Ali Siam is SSIS, SSAS and SSRS enough for data engineering. Uh, probably not, uh, companies still use
00:46:33those tools, but I would not be focusing my, all of my, that's like, that's like an intro to data
00:46:40engineering. Some companies are still using it, but the, the tools haven't updated a lot for a long
00:46:47time. And it's pretty simple. You can do data engineering work on it, but it's, if you're not,
00:46:53you know, you need to keep up a little bit more. So look at Databricks, look at, um, you know,
00:46:59even alter X, like some simpler tools, look at some coding, right? Maybe learn some Python or Scala,
00:47:07um, look at AWS and Azure, learn how to use AWS glue and things like that. That's what I would
00:47:12recommend.
00:47:16Uh, midfielder, our resume sucks. That's the main problem. Yeah. If your resume is bad, that's tough
00:47:21to get a job. Very tough. Jason Rajan, thanks a lot for the free and great YouTube content. You are
00:47:29welcome. I love making it. I'm, I'm looking back. I wish there was a YouTube that had the content that
00:47:38I put out. That's why I made the content that I made, um, because I wish someone had had that
00:47:42when I
00:47:42was first starting out. Cause I just wasted so much time on random stuff that didn't matter.
00:47:46Um, and I wish I had like a path. And so, um, Clinton, is it preferable? Uh, let me see.
00:47:53No, I'll answer Lee's and then Clinton's, uh, Lee. Hi Alex. What advice do you have for a 50 year
00:47:59old starting from scratch and data? My advice, and I say this with love, you're not too old. I promise
00:48:04you, but you need to utilize your experience at your age. You, you have to, if you don't have any
00:48:11previous experience in any industries, like say you just haven't been working, you've just been,
00:48:15you know, living off a trust fund. You have no experience, nothing. It's going to be very difficult
00:48:21because at your age, entry-level jobs will most likely won't want to hire you. Um, intermediate
00:48:28and senior jobs, uh, they expect either domain knowledge or, you know, in industry knowledge in,
00:48:36in that area. So it's going to be difficult. So I hope you can utilize your previous domain
00:48:40knowledge. So look at what that is and try to do that. Clinton, is it preferable to learn
00:48:46Git and version control concurrently with SQL or after SQL? I don't recommend learning it
00:48:50at the same time. I think it's, I think getting GitHub, um, well, you can use, you, anybody can
00:48:57use GitHub. You just create an account, create a repository, put a file in there. It's super easy.
00:49:01It's not even really even learning it.
00:49:06But version control and Git, I think are a little bit more advanced for most people.
00:49:12Um, I know when I first started learning it, Git and Git, Git, just in general, was so confusing
00:49:17to me. I had to have people continuously be like, no, no, no, no, no, no. Here's how you
00:49:22do it. Here's how you save it. Here's how you merge it. And then I, I figured it out over
00:49:25time. Um, but I, I would just learn SQL first. I would just learn SQL and not learn at the
00:49:31same
00:49:31time.
00:49:38All right. I'm reading through questions.
00:49:48Leonard Zell. Hey, Alex, I'm trying to get into data analysis for three years now and need a tip.
00:49:53How and where did you show your portfolio? What can I possibly be doing wrong?
00:50:00Three years is a long time. Um, that's a long, that's a long time to be trying to break into
00:50:06a
00:50:06field. I admire your persistence. Um, I have a whole series and videos, just specific videos on how to
00:50:15build a portfolio website. And I show you how I did it. So I'm not going to go super in
00:50:19depth,
00:50:20um, into what I did, but create a website, have your contact information, put your projects there,
00:50:27link them out. Um, you can even do the thing, a website like Wix, make it a narrative. That's
00:50:33what I have for my current portfolio. Um, but you can do it easier on just using a GitHub,
00:50:40but I have a lot of resources on this and they're free. You just have to go on YouTube and
00:50:45find them.
00:50:46So my advice would be do those things, create a great resume, not should help immensely.
00:50:54Oh, interesting. Karen. Hello, Alex. I'm in marketing. I marketing is a, I'm just learning
00:51:00about marketing right now with my company. Very difficult. And want to move into data analysis.
00:51:05What is the best way to make this shift? New management skills help in landing such roles.
00:51:10So marketing, actually, there's a bunch of people in data and marketing. There's marketing analysts,
00:51:16uh, and a lot of, a lot of companies because marketing is huge. Getting eyeballs on people,
00:51:22understanding the metrics, knowing where to put marketing funds, um, for advertisements and
00:51:26different things is huge. Um, the shift actually isn't that huge depending on what you've done within
00:51:33marketing. But if you've worked in the data side of marketing, you, I would say you already have
00:51:38some experience with data analysis, right? It just depends on what you're doing. But if you're
00:51:43working with tracking metrics, right? Uh, uh, you're looking at, you know, click through rates,
00:51:49you're looking at conversion rates, and then you're creating things like that is data analysis.
00:51:53You're just in a, you're calling it a marketing lead or whatever. Um, so the transition hopefully
00:52:00wouldn't be that difficult. Just find companies and look and target companies that value that
00:52:05experience. That's been a big thing for today. Um, by the way, we have 10 minutes and then I'll
00:52:09do a giveaway for free courses. That's been a big thing for today. I've noticed a lot of people
00:52:14they're like, and I did this when I first started to, what I did was, is I was in healthcare,
00:52:20but I was applying to any job. It did not matter what job I was applying to. It could have
00:52:25been in oil
00:52:26and gas. It could have been in pharmaceuticals. It could have been in tech. I just applied.
00:52:31But looking back, my healthcare was my superpower. I needed to, I could have gotten a job 10 times
00:52:36faster if I'd focused on that. So that's why I talk about it so much.
00:52:41All right, while I'm reading questions, let me get a sip.
00:52:44Okay. Silas Osei. For storytelling, do you document it after building the project?
00:53:02For storytelling, do you document it after building the project?
00:53:08Um, it depends. So I've done it in a few different ways and that's why I'm kind of thinking about
00:53:13it.
00:53:14So I, when I was presenting at one of my previous jobs, what we used to do is we would
00:53:22try to put,
00:53:22I'm kind of low on my screen. I don't know why, maybe I need to scooch up.
00:53:26What I used to do is, uh, let's say it was a Power BI dashboard. I would just create another,
00:53:34like, uh, I don't even know what it's called. I I'm blanking outside, just another sheet. Right.
00:53:41And what I would do is I would put a lot of this narration that I talked about on from
00:53:45the dashboard
00:53:45in this. I would present the dashboard and then I would just scroll over to this next sheet and I
00:53:51would say, here's kind of everything I've documented, but I did it. I, it's part of the
00:53:55presentation. That's how some previous, you know, execs that I used to present to, that's how they
00:54:00liked it. And so that's what we would do. I've also done it where, you know, I'm building out this
00:54:07project and then presenting to a client. So it's not internal, it's a client. And I would, uh,
00:54:13within the presentation do like tool tips, um, which are just like little boxes or, or things
00:54:19that would explain very simply, here's what happened. Here's why, which adds to the storytelling
00:54:25a little bit, right? Um, storytelling is a skill is 100% of skills. Some people are born with it.
00:54:32Some people aren't, I was not, I had to learn that as a skill. Um, and so what I would
00:54:38do is,
00:54:38is I would build it out first, then I would document it, but I would present it all in one.
00:54:44That's typically what I did. Um, you can do it while you're learning it too.
00:54:50How important is N8N as an aspiring data scientist? Uh, yeah, you can learn it. It's a new technology,
00:54:56a new, new tool. Go ahead and go ahead and learn it. But I, I don't know how important it
00:54:59is.
00:55:03Um, okay, this is a good question. Akhmat Absalam, Akab1999. Hi, Alex. I completed my PL300.
00:55:14Your channel was a cool resource. My question, how long do you need from the time you receive
00:55:20the raw data until you need to complete the report slash dashboard three days? Now,
00:55:26take the timeframe out of this. I've worked on projects where the data was so simple that I
00:55:31got it done like the day of. There were other projects were so complicated. It took me a week
00:55:35just before I even brought the client's questions about the data. And then they sent me a revised data
00:55:43dictionary. And then I would dig into the data and I would ask them about like raw data can be
00:55:49like
00:55:49a big portion of that initial process. It can take, I, I've spent weeks on raw data before I even
00:55:57started cleaning data. Um, I just like one example that came off the top of my head, we were working
00:56:03with this client. They sent us like their whole database because everything was so interconnected and
00:56:10they gave us a data dictionary as well as a diagram that showed how all these tables were connected,
00:56:16which is great. We love when clients do that. They don't always do that, but we like when clients
00:56:20provide us information about the tables, what the data holds. But when I start digging into this data,
00:56:27I start creating the joins from the diagram that I see there were issues. I would go to them and
00:56:32I'd
00:56:32be like, Hey, when I joined these two tables, I'm noticing that we only have like 500 rows over here,
00:56:38but on this other table, we have like 10,000. And so only 500 rows are going across. And then
00:56:46we only just started collecting this data a last week. And I'm like, okay, so this data is basically,
00:56:54I said it in a professional way, but I'm like, this data is basically useless. Why did you send
00:56:57this to me? And, and you know, why, why is this included? So they sent all this useless data with
00:57:04us. And so it took so long just to get into the raw data and understand it. Um, and every
00:57:09company,
00:57:10every client, they collect different data. Um, and so raw data is like, can be very difficult.
00:57:19Also it'd be super easy. So there's no timeframe you need to. So like, if you're talking about like
00:57:24for a client or you need to update your project manager, you need to get in there and say, Hey,
00:57:30I haven't gotten into this raw data yet. Let me scope it out first. And I'm gonna give you an
00:57:34estimate on how long I think it'll take before we can start with our next process. So whether that's,
00:57:39um, you know, cleaning the data or they just want to report or we're building a dashboard or whatever
00:57:44it is, you need to like, not give a timeframe. I've made that mistake. Oh, that'll take just a
00:57:50day. Then it took a week and then they're mad at you. So give it time, start digging into it,
00:57:55start asking questions, then give a timeframe when you feel comfortable.
00:58:01Barasa Fabrice. I'm saying it like that. I don't know if that's how it's pronounced.
00:58:05Power BI versus Tableau. Which one would you go with and why?
00:58:08I personally like Power BI better, but if I were starting out, I would learn Tableau
00:58:15because Tableau has better free features and Tableau has a way you can share your projects
00:58:21for free. It's really great. And so that's why I would learn Tableau, but I personally like Power BI
00:58:26more. It just skipped to the bottom. I was reading a question, skipped to the bottom.
00:58:37We only have like two more minutes. I'm going to give like one or two more questions and then we'll
00:58:42go to the giveaway, which if you want to get one of my courses for free,
00:58:47free. You just have to have an analyst builder account. That's it.
00:58:54My throat is parched today. I'm parched. All right, let me see. How many years to become a master
00:59:02of data analyst? This is from Mustache Din. Great question, Mustache Din.
00:59:09I still don't feel like I'm a master. I've been doing this like eight, nine years. I think that
00:59:14mastering something is pretty relative. I was a master of Excel at a previous job because they
00:59:20use Excel very little. But then when I got into a different job, I was like a newbie, a fresher
00:59:25at Excel. So there are levels to it and it's all perspective and relevance to that job. But I don't
00:59:33think any, I don't, I think it takes a long time, like let's say 15 plus years to really master
00:59:39something. Natalo Moretti found your channel in 2023. You're one of the reasons I have a job
00:59:52today. God bless you. Thank you. I am so glad to hear that. Congratulations. I, there's nothing I
00:59:58love more than hearing people who've bettered themselves through my channel. Like I can't do
01:00:04it for you. I have mil, I have a 1.16 million followers, but very few people actually put in
01:00:13the hard work to learn the skills, to market themselves, to create the resume and follow
01:00:17the steps that I've said. Very few people do it. And so when I see people who really do it,
01:00:22like I'm
01:00:22like that person really put in the work. That is not easy. Even though I have it guided, like it's
01:00:25still
01:00:26a lot of work. You have to believe in yourself and I'm really proud of you because that's awesome.
01:00:29I love that.
01:00:39I'm reading questions. This will be our last question, I believe.
01:00:47Interesting. Gypsy, this will be our last question. Alex, my current role is a database administrator.
01:00:52After three months on the job, my boss got let go. Oh boy. Now I'm feeling like everything is thrown
01:00:58onto me while I have no database experience. What would you do? Oof. I am sorry that's happening. That
01:01:06is terrible. That's not fun. Especially if that person was like a mentor, they were like the senior,
01:01:10the lead, and you were learning from them. They're supposed to like kind of guide you and they got let
01:01:14go.
01:01:15That's tough. My recommendation is for three months, you've been doing a lot of things.
01:01:23I know you have. You've been watching the person who was your boss. You've been seeing what they do.
01:01:29You've been seeing what kind of data they're working with and what systems. I would try to get access to
01:01:37all those systems if you don't have it already. And then I would tell people like, hey, listen,
01:01:41my boss just got let go. It's all on me now. I'm still learning the system. Like set some
01:01:45expectations. I'm learning this. I'm going to do the best I can, but I'm learning this system. So
01:01:50give me time. So I would set expectations because just state the facts. Here's what happened. Here's
01:01:56what I'm doing. I'm going to do the best I can, but just give me some time. And then I
01:02:00would learn it
01:02:01as quickly as possible. That is what I would be doing. Set expectations. It's okay to not take
01:02:09everything on. Or you can be like, hey, I can't, I can't do that right now. All right.
01:02:15Analyst Builder time giveaway. If I'm just going to down below in the description,
01:02:22you can get a free week of Analyst Builder. You can take, I've seen people take a course,
01:02:27two courses in that week for free. It's down below. If you like it, keep using it. If you don't,
01:02:33just cancel your subscription, but it's free. If you want to get a free course today, right now,
01:02:40in like one minute, what you need to do, and I'm going to do it with you. We're going to
01:02:43go to,
01:02:43I'm not going to do it on the screen because if I share my screen, there's so much stuff that
01:02:47could
01:02:47come up. I got emails and contracts and, you know, my social media stuff. So I don't,
01:02:52I don't share my screen. Go to analystbuilder.com. Go to pricing. Go to courses. Now I have all my
01:03:00courses on here. Whichever one you want, click on buy. You don't have to buy it. You don't have
01:03:06to buy it. I prompt, don't buy anything today. Do not. But what I'm going to do, click on it.
01:03:10Let's
01:03:11say I like this cloud computing essentials with AWS and Azure. I want this one. This is the one I
01:03:15want.
01:03:16Now, go to the checkout. All right. Go to add promotion code. I'm about to give you a code.
01:03:24I'm about to give you all the code. And whoever redeems it first, they get the course for free.
01:03:29I'll do five giveaways today. So let's say this isn't a real one, but let's say the code is Alex.
01:03:37Then I apply it. The price will go to zero. Then you click pay. You pay zero, right? If you're
01:03:43getting
01:03:43an error or the code, you know, whatever, whatever, that just means that somebody else got it before
01:03:49you. So that's how we're going to do it. I'm going to go over here to that. This is another
01:03:55reason I
01:03:56can't share my screen. So I'm about to pull up where I create my coupons or the codes. And I
01:04:01don't
01:04:01want people seeing all this too much behind the scenes. I can't share it. All right. Let me get to
01:04:07where I need to go. Next, next, next, next, next. Here we go. My Lanta. Oh, my goodness.
01:04:20Oh, my goodness. Golly gracious. Give me a sec. We have a system that when people click on the.
01:04:32Let me see. Let me see. I got to search for it.
01:04:48Oh, geez. So when somebody gets the here, it is. Got it. When somebody redeems the 100% off,
01:04:56we're generating a code on our backend. And that then kind of clogs up this code area.
01:05:04And so we've had a lot of people, like hundreds. It's like, I think it was like 800 people in
01:05:10the
01:05:10past week sign up for the free week. And because of that, it generates like 800 codes. And then it's
01:05:15all in. It's hard to find. Anyways, I'm going to give you a code. Everyone should be there by now
01:05:19because that took me forever. All right. This one, only one person can redeem. But the next one,
01:05:26two people will be able to redeem. I just added the code. It's all caps, Alex. I was joking earlier.
01:05:32I am going to use that as a code. I lied to you. I'm a liar. I'm not a liar.
01:05:38I'm just I didn't know
01:05:39at the time. All right. If I'm being honest, I didn't know at the time. Now I'm just joking.
01:05:42Um, so. All right. The code is all caps, Alex. Use that code at checkout for a course, a single
01:05:52course. And let me know if you got it. I'm going to give you the next code. Um, this one,
01:06:00you have
01:06:00to know how to spell. Or maybe I have to know how to spell. Um, but this one is experience.
01:06:07We talked
01:06:08a lot today about previous domain experience. Someone already redeemed the Alex code, by
01:06:13the way. Um. Oh, this is a good one. This is a good one. We just got a new dog.
01:06:29The code
01:06:29is whatever kind of dog that is. Um, but you have to know how to spell it. And that's the
01:06:37tough part. All right. I just created the code. The code is Dachshund. But Dachshund is spelled
01:06:44really weird. Um, so if you know how to spell Dachshund, you're going to get this one. No one
01:06:50else knows how to spell Dachshund. But it's spelled D-A-C-H-S-H-U-N-D. Dachshund. That's
01:07:00how they're pronounced. We just got one. Super cute. I think she's asleep out in, um, in our
01:07:04room. Um, but let me know if you were able to get that. If you did, that's great. Oh,
01:07:12the chat disconnected. Oh, I wonder if I get disconnected for a second. I hope I didn't get
01:07:17disconnected. Um, that is our live stream. I hope you guys enjoyed it. Uh, thank you guys
01:07:23for coming. I do this every week. So every Thursday, um, and I really appreciate you guys
01:07:27joining. If you've got a course, let me know down below. If you didn't, uh, there's always
01:07:31next week. So let me say thank you in the chat. Thank you for joining. There we go. If
01:07:41your code is not working, which I just saw in the chat, I said this earlier. If your code
01:07:45isn't working, you didn't get it. You just weren't fast enough. Somebody else got it
01:07:48before you. Um, if you still want to take a course, any of those courses, just get the
01:07:54free week below because that is another way to do it. Hey, Diego Chavez. I got it with
01:08:00the Alex code. Awesome. That was the very first code. It says, thank you. Thank you. You are
01:08:05welcome. Let me know which one you got. Let me know which one you got. All right, guys,
01:08:09I got to get out of here. I hope, uh, that whoever needed that course won it. Um, and if
01:08:16you didn't, you can get the free week down below in the description. Thank you guys for joining.
01:08:19I'll do this next week, next Thursday at 9am. All right, guys, I will see you in the next
01:08:24one. And when I post other things on social media, if you follow me there. All right.
01:08:28All right.