ฝัง
- เผยแพร่เมื่อ 4 ก.ค. 2024
- In this video I lay out a step-by-step roadmap to becoming a Data Analyst in 3-6 months.
Walkthrough of my own portfolio: • THIS is How You Stand ...
| Top Courses for Data Analysts |
___________________________________
📑 Excel from Beginner to Advanced → click.linksynergy.com/deeplin...
📊 Power BI for Business Intelligence → click.linksynergy.com/deeplin...
📈 Tableau for Data Analysis and Visualization → click.linksynergy.com/deeplin...
⌨️ SQL for Business Intelligence→ click.linksynergy.com/deeplin...
🐍 Python for Data Analysis & Business Intelligence → click.linksynergy.com/deeplin...
| Additional Resources |
___________________________________
💼 Build a portfolio → try.carrd.co/m8jcb15r
💻 Download Power BI on a Mac → parallels.sjv.io/ankQ6W
🧑💻 Master Data Analytics Interviews → www.dataford.io/?via=matthew
| More Content |
___________________________________
🧔♂️ LinkedIn → / matthewmike
📩 Substack → thdatapoint.substack.com/
As an affiliate with the brands mentioned above, I earn a commission from qualifying purchases in the links provided that help support this channel.
00:44 - Excel
01:31 - SQL
02:33 - BI Tool
03:53 - Projects
04:16 - Portfolio
04:44 - LinkedIn
05:01 - Networking
05:48 - Final Thoughts
Can you make a tutorial on how to look like Ryan Gosling
I liked the way you broke down what to know for each tool. The biggest issues for me are, how to know if my project is good enough, and how to offer useful analytical insights. It's hard to solve a problem with a kaggle data set. All you can really do is show you know how to explore data.
I've done practice data cleaning, some basic sql practice questions, and code along dashboards where you watch someone make a dashboard and do it yourself along each step to learn hands on rather than just watching.
Those are great steps to take! You might consider checking out Maven Analytics and their data sets. Really great stuff along with prompts for an analysis. I’d definitely consider making some of your own projects as a solid next step.
Love the thought and effort you put into this! People will find this very helpful!
Thank you Chris! I certainly hope so!
Great video Mike, I appreciate all the information. I also enjoyed the background decor...can never go wrong with Redbreast 12
Thank you! Glad you noticed 😉
This video is packed with so much value! You definitely deserve more subs
Appreciate that Asa! Thank you!
One of the best videos on the roadmap to data analytics!!
Wow, thank you! I'm glad it's helpful!
Well done, man!
Thanks for that!
Thank you! Glad it was helpful!
This was so helpful. Thank you!!!
Glad to hear that! 🙂
Thank you matt for providing such a great information, for the beginner like me it is really helpful, I am definately going to follow your tips.
I’m glad this was helpful! 🙂
This video is awesome!!! Thanks!!!❤❤
Glad you liked it!
You’re the goat ! Thank you my good sir
Thanks so much! Glad this was helpful.
Very helpful, thanks a lot Matt
Glad to hear it!
Thank you Matt!
You bet!
Your guidelines and ideas are always best. Loved your vedios.
Thank you Inza! I'm glad they've been helpful!
Great Job!
Thanks Stephen!
Hi Matt, this is my first video from you and I'm sure it won't be the last, great video!
My question is: in my Excel portfolio project should I use a lot of functions or just some sheets, sort data, pivot tables and then make a final dashboard? I mean I could use index-match and hlookup/vlookup, 3-4 different if functions, put drop down lists in the sheets (I mean not the basic filters), outlines, sparklines, conditional formatting, etc.
So put EVERYTHING I know in my excel portfolio work OR make it simple, assuming that the hiring managers know that if I know the expert functions, then I know other smaller tricks also.
Thank you! I think you keep the project simple by just presenting the dashboard. However, in your project write-up, I would not the formulas you used and even provide some screenshots of those.
I really appreciate this roadmap! Knowing the foundation on how to kickstart a career as a DA, I’m definitely going to incorporate some of your advice!
Love to hear that! Glad this could help.
@@MattMike What do you recommend is a good way to keep your skills sharp in the various tools (Excel, SQL, Python, PowerBI)?
@@Xaviallin1 DataCamp is a pretty good platform for staying sharp with those tools. Also, for SQL, platforms like DataFord or DataLemur are great resources for practice.
Lots of love from india❤
Thanks 😊
You're welcome! 🙂
Great stuff Mike! What's your opinion on Google Data Analytics Certificate? Should i start with DataCamp or Google certificate? I guess DataCamp is a more hands on practice than Google one but looking forward to your opinion
I think starting with the Google certificate is perfectly fine, but you'll need to go deeper afterwards. The Google cert operates as a good introduction, but it's not enough on its own. I recommend focusing on creating more projects afterwards and perhaps even taking additional courses for upskilling.
Thanks brother, I will be taking the google certificate for data analytics soon!
Awesome stuff! You got this!
Great content Mike!
I have recently done the google analytics course on coursera and I am currently thinking about projects to make in order to improve my portfolio. Besides that I am taking a deeper look into excel, sql, tableau etc. and applying for Jr's positions worldwide.
Am I in the right direction? How long should it take until I get a job?
Thanks for your time and consideration.
Thank you! I think you're definitely heading in the right direction. The Google course is a great introduction and focusing on projects to build out your portfolio is the right next step. It generally takes around 3-6 months. could be more, could be less. Keep it up!
I just started the GA Coursera course as well. So far, I like it and am pacing well ahead of their end date. How did you like the course overall?
Thanks for the great video! I would like to break into this field, but I've been hearing a lot that you need to learn Phyton for Data Analysis, so do you need to know Phyton as well to land a job as a data analysis or can you just learn these skills you mention in your video? Thank you and have a great day!
You're welcome and thank you! I personally don't think Python is necessary for an entry-level data role. I typically see this as a requirement for more advanced roles. It's good to have a basic understanding of it, but I wouldn't invest too much in it when just starting out.
@@MattMike Thank you for the response and have a great day!
Nice video ❤ learned a lot from your video ❤ May I know which one you recommend for data analyst? Windows or Mac?
Thank you! I'm glad to hear that! Most of my experience has been on Windows, but I personally love Mac. Either is great tbh.
What makes a good project for each of these skills? Tableau is kind of obvious but what about Excell and especially SQL? How should I go about creating an Excell or SQL project and how would I share it?
For Excel, I’d create a dashboard that utilizes charts, slicers, and pivot tables as this is very applicable to business analytics.
For SQL, do the analysis and then visualize it with a BI tool.
This video details my own portfolio: maybe it will help provide some inspiration:
th-cam.com/video/Idpxbh0O7Io/w-d-xo.html
What udemy course or TH-cam videos would you recommend for advance SQL concepts like Window Function, CTE?
Definitely the SQL course I have recommended in the description of the video. I’ve taken a lot SQL courses and I still find this one to be one of the most comprehensive that I’ve come across. It covers CTE’s and window functions.
Great video
Thank you!
Where do you find inspiration for your projects? Your portfolio video utilizes projects from your previous employers, but how should I follow the same approach if I'm coming from a different work background?
A few of them are from previous employers, but not all. And before I had my first data job, they were all just personal projects.
I recommend finding a dataset that's genuinely interesting to you. Then put yourself in the shoes of someone personally invested in the data. Come up with a set of questions and then set out on your analysis. Keep it simple and focus on quality over quantity.
If you had to rate the stress level of being a Data Analyst. What would yo rate it? I am leaning towards becoming a Data Analyst but some people make it seem as if you will be in back to back meetings, burnout, stressed out, etc. I’m still going to learn but I’d like your feedback please and thanks.
I can only speak for myself, but I have yet to experience anywhere near the stress I felt when I worked as an operations supervisor (making way less money btw). I don't often hear about burnout from any of my peers either.
While moments of stress are inevitable in any career, I'd say that generally, data is not as stressful compared to other career paths. Though, I'm sure the higher up the ladder you go, the more stressful it could potentially get.
Hope that helps!
Matt, are there any Geographical limitations to this roadmap? Is it applicable across all markets?
This roadmap should generally hold true for most markets, however, I can only speak with certainty for the US.
"Data Analyst" is a loose term for some companies, but a true entry-level Data Analyst role will follow the tech stack I mentioned.
What do you think about IBM Data Science specialist on coursera?
I haven't heard too much about the IBM course but I have seen some who've benefited from it. In general, Coursera hosts some pretty great courses.
Does it mean I should be comfortable enough using Excel before I start learning SQL or should I learn Excel and SQL at the same time?
I would approach Excel first and then SQL after.
The blueprint!!!
Indeed! 👌
Can we get a desk setup vid?
Sure! There are a few things I still need to "complete" it, but once I'm done, I'll do a vid on it.
What demand data analysis job in future wgat impact Ai on thus job
For now, it appears that AI is actually increasing demand for data jobs. There needs to be those who can build and maintain what is built through AI. Analysts will increasingly become "data interpreters" as AI continues it's reach. I wouldn't worry too much about data jobs getting taken over.
Many Thanks for doing this ! I assume python is not necessary ?
In most cases no. At least not for entry level roles. It starts coming in to play for more advanced roles.
@@MattMike why is that? Do the tools you covered not good enough? Thanks
Data preparation tools. ETL ELT
I don’t know if I’d consider those tools necessary for an entry level job but I think they’re definitely great skills to learn to further your career.
tableau ❤❤❤
Love Tableau 🙂
Hi bro learning all the skills is fine but what the job aspects especially fot freshers.
Do you mean like what should someone expect to be doing in an analyst role?
@@MattMike actually i wanted to say that from a fresher's pov even after learning the skills most of the companies ask for experience. What to do in that case
@@MattMikehe mean graduate
do you think without bachelors degree could land a job as data analyst?
I think it's possible if you have a few years of corporate experience to substitute. But you'll need an A-class portfolio too.
Is it necessary to have Python to become a data analyst, sir?
It’s not necessary for an entry level role in my opinion. Early on, it’s a nice to have rather than a need to have. However, as you progress in your career, it’s a good tool to pick up to expand your opportunities for more senior positions.
Hi Matt, Am lewis and have been looking for a mentor as I am changing my career to a Data Analysis. I hereby, ask whether you could mentor me please.
Hi Lewis, appreciate your reaching out. I wouldn't be able to serve as an outright mentor to you, but I do have some additional resources on my LinkedIn page that may be helpful to you.
www.linkedin.com/in/matthewmike/
I don't think they care about portfolio. If you are going through 50 resumes, you not going to waste time on that. You will give some test to applicants and that's it
My portfolio has served me very well. I’ve even reviewed it live during interviews, walking hiring managers through my projects. I’ve never once been given a test. I’ve done live technical interviews, but never a test.