Realistic View While tools like Python and Tableau are highly valuable, SQL, Excel, and Power BI dominate the everyday tasks of most analysts. They are flexible, accessible, and sufficient for 80-90% of workflows. For those in more technical roles, adding Python/R for advanced analytics and cloud tools for large-scale data is essential. But realistically speaking, SQL, Excel, and Power BI/Tableau are indispensable 100% of the time
I got my microsoft software developer certification after working software design for ibm keyboard factory in CA.Now your presentation got me interested in business data analyst.
I've been a graphic designer for 28 years and things have slowed down. I got my BA in Professional and Tech writing in 2020. I did some web development certificates in 2009 and have used some coding skills here and there. I was just advised to check out this field and it's fascinating. I love data. Now I'm going into Excel and learning the functions. Previously, I used it to make visuals for financial advisors in marketing and creative, so I'm halfway there. Thanks for sharing this video. I'm filling in the gaps and going to start up a new search once I have some examples. Still figuring out if I need some case studies, or presentations?
Hi Avery This has been a very insightful video. Especially for someone like me who has no technical background whatsoever but is profusely interested in Data, this comes as a refresher. I have been keen about Data ever since I quit my corporate job as a HR 4 years back to pursue my passion for writing. I did take up couple of courses to familiarise myself with all things Data. But I would always get stuck up when it came to doing projects. Either because of a vast difference in what is taught as theory and what is expected out of you in Projects in these courses or because of my innate fear of not being able to be good at technical stuff, I never went beyond a certain level. Recently, I started working on my Data Skills again and am determined to try harder this time. Will follow your 9 step process and see how it works for me.
Another lazy person checking in lol. Great video. Im not sure if i missed it but, what is the time line for this approach? Also, what are some potential entry level jobs?
I can answer that if you want To me both tools look similar, but the biggest advantage for power bi is that it's free. Tableau if i remember correctly has a fee to pay in order to use it. If you re new in this field or trying to learn the basics i'd say that powerbi is the way to go. If you have the chance to try both, go for it and see what's the best fit for you, but just so you know, it is possible to achieve similar results with both tools and once you start learning one(e.g powerbi), the other one should be easy to get used to. Soo, my advice is to go with powerbi if you're learning the basics (because its free), and you also have some tutorials on microsoft's website that helps with the basics. Lately you can use tools la power automate to ofc get rid of some repetitive tasks etc. Good luck!
Looking into Data Analytics as a new career field after 8 years in Physical Therapy. I've applied to almost 50 jobs that are outside of physical therapy but ive only gotten 2 call backs. Unfortunately with the automated systems you could be a rocket surgeon applying for an admin position and still get nothing but rejections.
@@averysmith unfortunately those interviews were nearly 6 months ago when I was applying for positions which were closer to PT. As I realized that I didn't want to work in those types of positions anymore I started applying outside of my skill set and have gotten zero contacts since. The major drag for me is that I am constantly changing my resume to try to best fit the types of jobs I am applying for. I have nearly 15 different resumes with different points of interest, summaries, etc to try to get past the automation systems but nothing still.
Hey Chris! I’m PT by profession but I did my MBA and I’m in transition phase and recently I started learning Power BI and cleared my CAPM test and started applying basic assistant role to start with.
A milestone and more in this 15minutes watch. This was the Jumpstart I’ve been waiting for. I’m Nigerian though and I have a question. I believe job roles can be remote too, right ?
Great info! I’m very interested in this and looking to pivot into data analytics. Unfortunately, I never did finish my Bachelor’s degree. Is it realistic to think I can get a data analytics role without a Bechelor’s degree? Because, to be blunt, there’s no point in trying to pursue a data analytics career right now if I can’t land such a job without a Bachelor’s degree.
I think coming up as a chef/ cook analyst. Cost of the materials used in making certain food. Like cakes, cookies, stew and the likes. Cost of establishing a food hub
Just keep building sir/ma. You have probably tried all I am about to say or not but diversify, try data entry, data instructor roles, technical roles closely related to data. And then you should also network. BUILD IN PUBLIC. Show your work. If you have a portfolio deal free do send it across to me let me see it. Just keep building.
Great content 👏, best I've seen so far. Im just about to "start" even though i am a BI ananlyst i want to switch over to data analyst. Please recommend a good laptop. Is 4g memory good enough? Again great content 👌
Hello Avery Sir, thank you for your youtube videos. Moreover, I want to ask whether buying M4max apple with 128 gb laptop for machine learning, AI and Data science or buy M4 max with 36 gb and use cloud for higher data computation. It would be our pleasure to have on best laptop idea for these categories.
Is it feasible to land an entry level data analyst job without a bachelor’s degree? (I have a 2-year associates). If one works diligently to learn the required skills and build decent projects for a strong portfolio?
I know that there are multiple "specializations" or different hats within data analytics. But my question is "are there positions on which I have flexible hours? weekends, nighttime work...I guess I'm looking for "you have this deadline to turn this in" type of position.?
I’ve been on/off studying front end web development for 4 years now whilst working an admin job (I use excel and power bi heavily here). I’ve never learned SQL, but I have spent some time in Python.. I’m very demotivated from webdev lately and haven’t studied in a few months.. is data analytics a career that can be entered into purely through self taught? I’d need to learn sql and python I believe for the most part, I’m great with excel and bi.
I have a background in Building Construction and have worked as a builder and site engineer. I am now looking to transition into the data field, particularly as a Data Analyst. Given that I don’t have a degree in Data Analysis or Computer Science, what would be the best way to get started? Or what Data Roles could k jump on? I would appreciate any advice on how to make this career switch
You can literally make more money faster in the construction industry are you kidding? Site engineer, health and safety, operations. Construction is a booming industry. data analyst white collar jobs are scarce and hard to get into
Hi Smith I am from India i want to land data job i liked your course content i want join the program but i cant afford the amount.please help me smith Once i will land job i will clear program fee .
ideally you'd need a degree to show that you're knowledgeable in a particular domain, if you want to be a financial analyst its a must to have a degree in a relevant field
That networking stuff appears to me as some sort of normalized nepotism and corruption. I mean, it’s one thing if you network for some project or idea and maybe indirectly get a job in that way or simply for real merit, and the other thing to get yourself a preferential treatment without real justification. It would be as standing in the line and seeing constantly new people coming ahead of you and the other people waiting. Actually, i see this stuff going on for years now where i live, but I taught this was unthinkable for a developed country.
Github doesn't look like a good place to host portfolios. It looks complicated and not user friendly. Employers want to click your portfolio and see right away projects with easy navigation. Not see a repository that is made for code collaboration etc.
Realistic View
While tools like Python and Tableau are highly valuable, SQL, Excel, and Power BI dominate the everyday tasks of most analysts. They are flexible, accessible, and sufficient for 80-90% of workflows.
For those in more technical roles, adding Python/R for advanced analytics and cloud tools for large-scale data is essential. But realistically speaking, SQL, Excel, and Power BI/Tableau are indispensable 100% of the time
Thanks
I got my microsoft software developer certification after working software design for ibm keyboard factory in CA.Now your presentation got me interested in business data analyst.
BEST VIDEO I EVER WATCHED IN THAT SUBJECT. THANK YOU A MILLION !!!
This comment made my day :)
I've been a graphic designer for 28 years and things have slowed down. I got my BA in Professional and Tech writing in 2020. I did some web development certificates in 2009 and have used some coding skills here and there. I was just advised to check out this field and it's fascinating. I love data. Now I'm going into Excel and learning the functions. Previously, I used it to make visuals for financial advisors in marketing and creative, so I'm halfway there. Thanks for sharing this video. I'm filling in the gaps and going to start up a new search once I have some examples. Still figuring out if I need some case studies, or presentations?
Great content and straight forward. One of the best videos I have seen.
Amazing video!
Music is spot on
I liked your insight how to become a data analyst.
Hi Avery
This has been a very insightful video. Especially for someone like me who has no technical background whatsoever but is profusely interested in Data, this comes as a refresher. I have been keen about Data ever since I quit my corporate job as a HR 4 years back to pursue my passion for writing. I did take up couple of courses to familiarise myself with all things Data. But I would always get stuck up when it came to doing projects. Either because of a vast difference in what is taught as theory and what is expected out of you in Projects in these courses or because of my innate fear of not being able to be good at technical stuff, I never went beyond a certain level.
Recently, I started working on my Data Skills again and am determined to try harder this time. Will follow your 9 step process and see how it works for me.
Awesome wish you the absolute best.
Very nice video. Helpful and to the point. Will subscribe
this is so useful and inspiring too thank you making this video
You're so welcome! Glad it was helpful.
such a cool video! thank you so much for all the advices.
Another lazy person checking in lol. Great video. Im not sure if i missed it but, what is the time line for this approach? Also, what are some potential entry level jobs?
Hi! What are your thoughts on learning Power BI instead of Tableau?
I can answer that if you want
To me both tools look similar, but the biggest advantage for power bi is that it's free. Tableau if i remember correctly has a fee to pay in order to use it. If you re new in this field or trying to learn the basics i'd say that powerbi is the way to go. If you have the chance to try both, go for it and see what's the best fit for you, but just so you know, it is possible to achieve similar results with both tools and once you start learning one(e.g powerbi), the other one should be easy to get used to.
Soo, my advice is to go with powerbi if you're learning the basics (because its free), and you also have some tutorials on microsoft's website that helps with the basics.
Lately you can use tools la power automate to ofc get rid of some repetitive tasks etc.
Good luck!
@@vvs1998Tableau Public is free and doesn’t require a work or school email for use like Power BI.
Thanks
Looking into Data Analytics as a new career field after 8 years in Physical Therapy. I've applied to almost 50 jobs that are outside of physical therapy but ive only gotten 2 call backs. Unfortunately with the automated systems you could be a rocket surgeon applying for an admin position and still get nothing but rejections.
4% is actually pretty average for an applicant rate. I would be happy with those numbers.
@@averysmith unfortunately those interviews were nearly 6 months ago when I was applying for positions which were closer to PT. As I realized that I didn't want to work in those types of positions anymore I started applying outside of my skill set and have gotten zero contacts since.
The major drag for me is that I am constantly changing my resume to try to best fit the types of jobs I am applying for. I have nearly 15 different resumes with different points of interest, summaries, etc to try to get past the automation systems but nothing still.
Hey Chris! I’m PT by profession but I did my MBA and I’m in transition phase and recently I started learning Power BI and cleared my CAPM test and started applying basic assistant role to start with.
What projects should I do if I want to land a job as a technical support engineer?
A milestone and more in this 15minutes watch. This was the Jumpstart I’ve been waiting for. I’m Nigerian though and I have a question. I believe job roles can be remote too, right ?
Yes. It can be
We can also learn grafana for visualization purpous
Tbh never heard of it
Actually I am working as a data analyst intern in intone company sir there for visualizing dashboards they are making me to learn grafana
Great stuff !!
Great info! I’m very interested in this and looking to pivot into data analytics. Unfortunately, I never did finish my Bachelor’s degree. Is it realistic to think I can get a data analytics role without a Bechelor’s degree? Because, to be blunt, there’s no point in trying to pursue a data analytics career right now if I can’t land such a job without a Bachelor’s degree.
Im a professional chef how can I transfer that skill into data analytics? Any ideas?
I think coming up as a chef/ cook analyst. Cost of the materials used in making certain food. Like cakes, cookies, stew and the likes. Cost of establishing a food hub
Very useful information!
Have you got any input for solutions architecture?
I have seen videos how would one become data analyst in 2023, 2024 and 2025. Still haven’t gotten any role yet😂😂😂. Hopefully this year I will make it.
Finger crossed 🤞
Me too but this year i land in an audit data anylst role and i love it
@@holasoynico165 share some tips how you got this
@@holasoynico165which Company bro
Just keep building sir/ma. You have probably tried all I am about to say or not but diversify, try data entry, data instructor roles, technical roles closely related to data. And then you should also network. BUILD IN PUBLIC. Show your work. If you have a portfolio deal free do send it across to me let me see it. Just keep building.
Great content 👏, best I've seen so far. Im just about to "start" even though i am a BI ananlyst i want to switch over to data analyst. Please recommend a good laptop. Is 4g memory good enough? Again great content 👌
Hello Avery Sir, thank you for your youtube videos. Moreover, I want to ask whether buying M4max apple with 128 gb laptop for machine learning, AI and Data science or buy M4 max with 36 gb and use cloud for higher data computation. It would be our pleasure to have on best laptop idea for these categories.
Is it feasible to land an entry level data analyst job without a bachelor’s degree? (I have a 2-year associates). If one works diligently to learn the required skills and build decent projects for a strong portfolio?
I know that there are multiple "specializations" or different hats within data analytics. But my question is "are there positions on which I have flexible hours? weekends, nighttime work...I guess I'm looking for "you have this deadline to turn this in" type of position.?
Not really. Its mostly 9-5
Learn Scala and SAS
I’ve been on/off studying front end web development for 4 years now whilst working an admin job (I use excel and power bi heavily here). I’ve never learned SQL, but I have spent some time in Python.. I’m very demotivated from webdev lately and haven’t studied in a few months.. is data analytics a career that can be entered into purely through self taught? I’d need to learn sql and python I believe for the most part, I’m great with excel and bi.
do i need a bs degree for it or i can just start the process you said
It's a very informative video. thank you.
Is it okay to learn power bi instead of tableu if l want to be in business intelligence
For visualization pick one tool and pick the one that your industry or company uses. If you learn one the other won’t be hard….
Yup. That’s fine.
considering going wgu to get my bachelors in data management would you recommend this or is it better to just learn the programs ?
I have a background in Building Construction and have worked as a builder and site engineer. I am now looking to transition into the data field, particularly as a Data Analyst. Given that I don’t have a degree in Data Analysis or Computer Science, what would be the best way to get started? Or what Data Roles could k jump on? I would appreciate any advice on how to make this career switch
You can literally make more money faster in the construction industry are you kidding? Site engineer, health and safety, operations. Construction is a booming industry. data analyst white collar jobs are scarce and hard to get into
Am currently doing my MBA program in healthcare management, what are the data certification i should do for this
For a healthcare consultant
Would you do projects while you're learning turtle?
I want to be able to do this out of the country
Hi Smith
I am from India i want to land data job i liked your course content i want join the program but i cant afford the amount.please help me smith
Once i will land job i will clear program fee .
Do i need a degree to be a data analyst?
ideally you'd need a degree to show that you're knowledgeable in a particular domain, if you want to be a financial analyst its a must to have a degree in a relevant field
Or if i can show them to my data analyst projects dose that count for not having degree @@mironadiel
That networking stuff appears to me as some sort of normalized nepotism and corruption. I mean, it’s one thing if you network for some project or idea and maybe indirectly get a job in that way or simply for real merit, and the other thing to get yourself a preferential treatment without real justification. It would be as standing in the line and seeing constantly new people coming ahead of you and the other people waiting. Actually, i see this stuff going on for years now where i live, but I taught this was unthinkable for a developed country.
Literally the best video ive ever watched about data analysis
Github doesn't look like a good place to host portfolios. It looks complicated and not user friendly.
Employers want to click your portfolio and see right away projects with easy navigation. Not see a repository that is made for code collaboration etc.
Couldn't have said it better myself
I could not disagree with you any more.
Make a website
Bro with all these content , trust me you’re not lazy 😅😂
I’m going to be that guy in the comments pointing out that not every turtle swims. 😅
HAHAHAHA fair point! Most turtles.
💫👑🎙️🧔✨