DIY Data Analyst Curriculum using Udemy (Under $75)

[@johnadair4979]

I've done both the SQL courses, both the Excel courses, and the Power BI course. They are all 5 really fantastic!

[@SQLServer101]

Thank you very much. I'm glad that you found our course to be fantastic! Keep learning. Phillip

[@JTD33]

This is exactly what I was looking for when I first started learning data analysis! It will surely be really useful for those starting out and I will recommend it to anyone I know getting into analytics.

[@billshoe22191]

Thank you for putting this together. I love the Udemy courses I've taken, but finding the right course is kind of a nightmare on there. This helped so much

[@whothefcares2687]

I think the best thing about these courses for anyone already in a data analysis role is just learning what everything is called. In job postings and interviews hiring managers like using short hand and buzzwords. Knowing the skills isn't enough, though it should be, you have to be able to convey through buzzwords and acronyms what you can do so hiring managers will pick you. Also, don't underestimate yourselves and your skills. I just had to teach a business analyst with 25 years of experience how to do a vlookup 🤦🏼‍♂️

[@Litentheattic291]

Jose is a good instructor. I took his PostgreSql course

[@traetrae11]

Udemy has some great courses. I ended up taking the 100 days of python course. The first 14 days are the basics and every day has practice exercises. There are a lot of projects throughout that really challenge you to learn the material. It’s not specific to data analytics but it was very helpful.

[@AlexTheAnalyst]

That is a good one! I've taken that also :D

[@marciopineda7818]

Yeah im from Perú came to SF to do my máster degree in Business Analytics in HULT, have awesome teachers but tu pull my skills at least in Python i buy the 100 code program in Python from Ángela and actually it helps me a lot for my Python courses in class.

[@kichaa13]

Nice that you curated these, I have found Udemy to be haphazard and sorting the wheat from the chaff is too much of a chore compared to something like coursera.

[@AlexTheAnalyst]

Haha I hear you on that - yes, these ones are solid

[@pradeepmaji1709]

Hi Alex, I liked the course selection in udemy, which I am following out by first studying the SQL --> Excel --> Tableau --> Work on your projects --> Will create my portfolio referring your video --> later will start with Python However, I need one more suggestion, if you can recommend any good udemy course for 'Excel dashboards and data analysis for business advanced level' from tons of resources, as I have spend over a decade using this tool in my career for about 10 years(its a bread and butter for me now).

[@asn85uk]

IMHO the best sql tutorial ever is Kudvenkats sql tutorial series which available for free on youtube

[@testgroup]

Thanks Alex and others for the effort and guidance. That last time one hour plus video was also amazing.

[@irshadkhan-lq9tp]

Thanks alex for sharing an amazing knowledge for beginners as a analytics

[@galihputroramadhantyo6103]

Thank you, Alex. I just purchased the MySQL from 365careers. So far so good.

[@Squatch_11]

Be careful with some of those Python courses. A lot of them haven't been updated in years and the syntax is way out of date. If you are new to Python, you'll probably have a hard time figuring out why your code isn't working if you are trying to follow along with the instructor. Make sure to read recent reviews of all courses you are interested in buying.

[@s.motwani290]

Then which one do you suggest buddy ?

[@skydexx2940]

Thank you 🙏🏾

[@Litentheattic291]

Jose keeps his updated and you can find the most recent easily

[@iSeries547]

Another one is 100 days of Python by Dr. Angela Yu Which is kept updated.

[@jugalpatel276]

@@iSeries547 I have started it recently and i am on day-7 section. so should i continue with it because it is up-to-date, right?

[@Kaliayad]

Thank you for this list. So helpful esp if you don’t face bootcamp money & not sure where to start. Going to wait & see if the courses go on sale again. It’s funny how they’re all $100 now.

[@dasunpls]

Udemy has sales almost weekly it feels like. You can add courses to your wishlist and be notified when they go on sale!

[@DanDLionX]

Thank you for this video. Now I have a timeline to follow as I have no idea on where to start.

[@satyal235]

Hi Alex, I appreciate you making things simpler for us . Could you please let me know the sequence of the videos to be followed for learning Excel from beginner level to pro including data analysis. There are several videos of yours on it but not understanding where to begin with.

[@hernandezmoises5354]

If you go to his channel you are going to find a reproduction list called "Excel Tutorials for Data Analysis" the videos will be lay out in order so is easier to comprehend :)

[@karenzhou1083]

Jose Portilla's courses have not been updated in at least 3 years. He even said in one course (I think the Python Visualization course) that the course is no longer updated. I don't know why they are still selling the courses.

[@Seftehandle]

This video is one of the most interesting I've seen regarding the topic of learning new skills and which videos will help us with that. It would be nice for you to make a make a video where you will describe your time table of course taking on the job and after, so we can maybe incorporate some of those habits into our own jobs basically if we are in a similar situation where we can learn on the job, it would be nice to see your schedule so maybe we can include that in our dayjob.

[@Seftehandle]

Another interesting idea would be how to transition from watching courses to doing actual projects

[@samsonkiflom5954]

Thank you Alex! This is a Curriculum I am looking for.

[@ngocbui9039]

Thank you for your suggestions so much !

[@Leeon_King]

You're the MVP, Alex!

[@hopeful806]

Thanks a lot for this great guidance, Alex.

[@janej6853]

I am currently doing the MySQL udemy course and so far seems very indepth. Although the content is very good, it moves at a pretty rapid pace for learning. So I am wondering if you did anything to practice what you had learned? I find that just moving onto the next lesson doesn't solidify what I have learned.

[@haitianbrother]

Your the goat Alex Thanks for sharing what made you successful

[@khushbubenpatel2767]

@Alex The Analyst thank you for recommending the courses. can you also suggest some courses people can take on Linkedln learning?

[@vectoralphaSec]

Just discovered your channel. You seem like a cool knowledgeable person on this topic. So im wondering if you can help me with a question i have. So I am a recent graduate in Computer Science and want to instead go into Data Science industry instead of the traditional Software Developer/ Software Engineer career. So as someone like me who eventually one day wants to work in data science industry, is there an entry level job role that one can apply as a starting point and just get promoted/ level up to a data science in time rather than just trying to apply for a data science position from the get go? I dont mind starting at the bottom and working my way up the ladder. If anyone else have any suggestions i would greatly appreciate it?

[@danielpenn7495]

Hi Alex, do you think that Kyle Pew's excel class is a good alternative? I am just curious given it is a much longer course.

[@moatazgoubarah7424]

@AlexTheAnalyst Hi Alex, do you think chat gpt will take away data analysis jobs, particularly at the entry and intermediate levels? I have been earning data analysis for a couple of months and I have been making meteoric progress, and your videos have been focal to my learning, that is why it is important for me to know your opinion on this.

[@StuartGreenley]

You have two videos recommending courses on different platforms (Udemy and Coursera). Which Top ones would you recommend first from either platform for SQL, excel, Visualisation and Python?

[@politicking850]

Great roadmap just know that the current prices are higher.

[@nicholascarlile6934]

Hey Alex, would you say there is a prerequisite amount of excel knowledge needed to taking the Advanced excel functions course?

[@teehi4541]

Hi Alex, awesome video and thank you for all the info but I found out that some of this individual courses are about $100 , how do I get it at this low price? Thank you

[@AlexTheAnalyst]

Wait until it goes on sale, which it does about once a month. Or look for a coupon online :)

[@teehi4541]

@@AlexTheAnalyst okay thank you

[@moxie1189]

Maven Analytics’, Dustin Cabral’s Tableau basic and advanced courses are much better than Krill’s courses. Also, Chris Bruehl’s Python courses, specially Pandas and Numpy, is one of the best Python courses on Udemy.

[@OnceSavedAlwaysSaved7]

Alex, do you have financial connections to any of these courses on Udemy that you’re recommending? Thank you

[@sebastianbhambhani1958]

Hi Alex, thank you so much for this information! Just wanted to ask you in your personal opinion, which platform do you think is better for learning Data Analytics? Coursera or Udemy? I mean, if you would have to recommend this path or the one that's covered in the video you uploaded on Coursera courses 2 weeks ago which one would you choose? (If you forget about money) Thanks!!

[@AlexTheAnalyst]

I think if you have the money, Coursera is worth it, but if money is tight Udemy is 100% the way to go.

[@sebastianbhambhani1958]

@@AlexTheAnalyst Thank you so much Alex! Best regards 🙌

[@TravisSmith-jb8wr]

His list is pretty good as I have taken most of these. Jose is number 1 for Python. Colt wasn’t that good as he has trouble staying focused and 100 days of code was the worst course. If you can’t learn with Jose zero to hero you won’t learn anywhere else. Udemy is much better than Coursera which I wasting 4 to 5 months and didn’t learn or retain much. Udemy got me understanding python and sql within 3 weeks. By month 2. I was completely comfortable with the basics and some advanced coding

[@terencelim9889]

Hey Alex, how about R programming language? Didn't see it being mentioned in your sharing.

[@AlexTheAnalyst]

I usually don't lol but I never took any Udemy courses to learn R, I just learned it in my job

[@terencelim9889]

@@AlexTheAnalyst Understood. Thanks Alex

[@abdulajeesshajahan2565]

Hi Alex!! tahnks for the guidance, Regarding Python course you mentioned in the Video. Can I take the "Learn python for Data Analysis and visualization" without knowing anything in python, do they teach me from scratch...

[@honkymcwhiteboy4084]

Soooooo... how do you feel about Treehouse tech degrees...?

[@soccercastle5357]

Thank you for your excellent video; I aspire to become a data analyst and always follow your videos and suggestions. Unfortunately, the courses you suggested are not discounted in Germany, and it is pretty expensive here to take all the recommended courses.

[@AlexTheAnalyst]

Yeah I don't recommend ever paying full price lol hopefully you can find a coupon or wait for them to go on sale!

[@soccercastle5357]

@@AlexTheAnalyst sure, 100% :)

[@SQLServer101]

Udemy courses are generally discounted every one or two weeks. I would have a look between Tuesday and Thursday. Phillip

[@GobyLinder]

Does this curriculum take you all the way through to getting a data analyst certificate where you can then apply for work?

[@qwertyqart]

do i need to have payed PowerBI or Tableau subscriptions?

[@luckywaddles]

I may have to give Power BI a go because for some reason Tableau simply isn't sticking, even after Kirill's course. I'm chalking it up to self-sabotage and imposter syndrome ...but still.

[@AlexTheAnalyst]

lol it took me several courses to get everything. I learned by forcing myself to learn - some things didn't stick with me right away either.

[@luckywaddles]

@@AlexTheAnalyst I'm sure I'll get there, thanks for everything you do!

[@MegaSpike122]

Do you prefer Udemy more or Coursera?

[@AlexTheAnalyst]

Both are good for different people. Udemy was my go to when I was first starting out. When I could afford it I went to Coursera and loved their content too.

[@talesfromthetiller]

Hi Alex, love the channel. I was lookiing at the SQL course by Careers 365 yesterday and was really interested untill i started to read the reviews, it seems that they do not monitor this or respond to questions. On the other hand, the other hand, I have taken a number of courses from Maven analitics and have been ery happy with the content and the prompt response to questions.

[@AlexTheAnalyst]

Yeah a lot of Udemy instructors don't respond. It's more of a self-service platform as a whole.

[@delta_eps8916]

Hi Keith and Alex, That's false because I subscribed on it and they respond within 24 hours.

[@tanichea327]

Hi there! I noticed that The Complete SQL Bootcamp is no longer of your list of recommended SQL courses. Is it not as helpful as the other two?

[@nemuelpaiva3738]

So which one is better Udemy or cousera curriculum?

[@nemuelpaiva3738]

@alextheanalyst So which one is better Udemy or cousera curriculum?

[@GovindGoel-jy8jt]

Except python second course all are available in my personal plan which cost me around 15$ per month....i know courses in personal plan are different but most are same can you make a video for courses in personal plan? hope you get sponsored from udemy too for promoting personal plan i like it so far

[@missdesireindependance5194]

Are the excel courses good for beginners?

[@26Nick]

Thanks for what you do Alex, you deserve all of the success in the world for your efforts!! Jose Portilla has a "Python for Machine Learning & Data Science Masterclass" course, the first 10-12 hours of which cover NumPy, Pandas, Matplotlib and Seaborn. It looks like this is a newer edition of the second Jose Portilla you talk about in this video. If you have experience with both courses, is there a reason you recommend the one you do over the other one?

[@AlexTheAnalyst]

Yeah that one just covers a lot more Machine Learning than I think is worth learning when you're first learning Python - that's really the only reason.

[@26Nick]

@@AlexTheAnalyst fair enough! I took that particular class up to the data analysis capstone project before moving on to other data analyst skills and projects. If I ever have the desire/need to learn more on the data science side of things, I can pick up where I left off and work through the back ~2/3rds of the course. People like you and Jose make me even more grateful to live in this day and age. What a time to be alive where one can get hours and hours of instruction on extremely marketable skills from experts in their field for $10-15!

[@frankandre_aguilar]

Do something similar with coursera 🙏

[@AlexTheAnalyst]

I did about two weeks ago :) Go check it out!

[@stijndebaere5778]

The paid content you producing is crazyyy

[@SubhaForever21]

Hi Alex, I'm changing my career so last year I completed the google data analytics in coursera and python with data science online course with project... But i like do volunteer first can you please kindly suggest what i have to next? And if any volunteer website if you know please kindly share.... Im in canada saw in google "data for good" website is that good to do volunteers. Please kindly reply and Thank you so much.

[@develop7911]

Can you do an update to this video for 2024. Because that excel pivot tables course is now $200. Would appreciate if you can do a $75 dollar diy curriculum again but for 2024

[@abidmridha7442]

Hi Alex , I have a question to you ! Most people said that data analyst jobs are not entry level jobs . So if anyone wants to aim to build a career in this profession… without degree is it possible ?

[@delta_eps8916]

Hi it 's possible

[@abidmridha7442]

@@delta_eps8916 thanks:)

[@aeterna_victrix]

Would you recommend these courses over the Google Data cert? I've been trying to decide if I should go the Udemy route but the career cert has the job board when you finish. Or would completing the Udemy courses be enough to find a job?

[@AlexTheAnalyst]

Cost wise, yes, but they're fairly different. The Google cert is if you want to learn basic concepts. This udemy curriculum is if you already know some of that and need to expand and grow your skills.

[@nemuelpaiva3738]

Alex I think you should’ve been more precise to say that at the beginning haha

[@Major_Data]

Let's see if I've done any of these...

[@AlexTheAnalyst]

lol I've done them all :)

[@Major_Data]

I haven't finished any of them - I ordered Jose Portillas Python course after I enjoyed his SQL Zero to Hero course. Haven't finished it yet.

[@keepcontinue]

Don't you need some statistics in order to get a job as a data analyst?

[@andreakilin]

Just purchased the Tableau A-Z, hope you get your commission.

[@trinadas364]

Hi Alex, I do not see the prices you showed for these courses on Udemy. How can I get them at those prices.

[@AlexTheAnalyst]

Udemy has a lot of sales, you kind of just have to monitor the site for their deals to go back up. You can also search for Udemy Coupons on Google and can find some good ones.

[@Omar-Asim]

When's the bootcamp coming? 👀

[@AlexTheAnalyst]

Couple weeks :D

[@mohamadchaaban9646]

Still waiting for your course! 💪

[@AlexTheAnalyst]

I'm working on it right now! :D

[@mohamadchaaban9646]

@@AlexTheAnalyst I have a monthly subscription on Udemy. I pay around 17 aud/month but it’s only for the purpose of excel/power query/dashboard purposes. Saying that, I’m not bothering touching anything related to SQL. with learning the SQL skill, I don’t trust anyone other than YOU! So I will wait for your course :D

[@dee2768]

How much do you recommend the data analyst course by 365 careers on udemy?

[@talesfromthetiller]

Best to read the reviews, they do not seem to respond to questions

[@GobyLinder]

or is it just core courses you ill need to then take the actual course?

[@terrancetham171]

HI for those in singapore, our national libary is giving free Udemy Business so you can learn all this for free

[@Dex-dt1br]

Isn't coursera better because you can audit the course and access the content for free?

[@yashsultania1848]

Hi Alex, I have a very important question regarding data analytics. I hope you have the time to read this and reply me solving the query. Is there any particular board for data analytics. Like for example if you want to become a CA there is a separate board for it. So is there is any particular board for data analytics?

[@abcdefghijkl904]

So this video is not about actually for learner who want to be a data analyst instead this video is for sponsor I also have taken one course which is not updated and also the udemy has no check and balance on courses offered by the creators

[@A_Dongle]

Are you able to pull a job with these courses?

[@Kratikajain511]

First one to see this video

[@keshavmaheshwari6232]

sponsered by udemy

[@emmanuelhome9672]

coursera is better to me

[@Canda-fh4xc]

Most of Udemy courses are not worth the money regardless to the high reviews.

[@loveforever5687]

Or I can just watch KZbin to learn

[@ahmednafir2286]

Piecharts, UNFORTUNATELY